|
Joined: May 2006
Posts: 169
Member
|
Member
Joined: May 2006
Posts: 169 |
When trying to create a new topic for this upcoming football season if there is one I am running into issues.
I go to CP click on add new forum, the screen pops up as it always does. I type in the forum name Bad Man 2020 and list it with the parent of contests and then click on add new forum.
I get this error
Script: /home/freaksfo/public_html/admin/docreateforum.php Line: 129 SQL Error: Incorrect integer value: 'usedefault' for column 'FORUM_STYLE' at row 1 SQL Error: 1366
Query: INSERT INTO ubbt_FORUMS (FORUM_TITLE, FORUM_DESCRIPTION, FORUM_DEFAULT_TOPIC_AGE, FORUM_CUSTOM_HEADER, FORUM_STYLE, FORUM_IMAGE, FORUM_IS_ACTIVE, CATEGORY_ID, FORUM_POSTS, FORUM_TOPICS, FORUM_CREATED_ON, FORUM_LAST_POST_TIME, FORUM_LAST_POSTER_ID, FORUM_LAST_POST_ID, FORUM_PARENT, FORUM_ISLAND_INSERT, FORUM_IS_RSS, FORUM_RSS_TITLE, FORUM_SHOW_INTRO, FORUM_INTRO_TITLE, FORUM_IS_TEASER, FORUM_IS_GALLERY, FORUM_POSTS_COUNT, FORUM_ACTIVE_POSTS, FORUM_SORT_FIELD, FORUM_SORT_DIR) VALUES ('Bad Man 2020', '', '0', 0, 'usedefault', '', 1, 41, 0, 0, 1594685980, 0, 0, 0, '0', 0, 0, 'RSS Feed for Bad Man 2020', 0, '', 0, 0, 1, '0', 'last', 'desc')
When trying to remove an old forum such as NHL Expert, I go through the normal steps and get this error. It's the same for any forum I try to delete but a different forum Id.
Script: /home/freaksfo/public_html/admin/dodeleteforum.php Line: 38 SQL Error: Truncated incorrect DOUBLE value: 'New Forum Template' SQL Error: 1292
Query: delete from ubbt_FORUM_PERMISSIONS where FORUM_ID = 181
I did check with my hosting company thinking there was an issue with the SDQL and they stated the issue is with the coding.
Appreciate insight into this.
|
|
|
|
Joined: Apr 2004
Posts: 1,945 Likes: 145
|
Joined: Apr 2004
Posts: 1,945 Likes: 145 |
Thank you for reporting this. This has been fixed for the upcoming UBB.threads 7.7.5. While waiting for 7.7.5 to be released, the fix is rather simple to correct on your own forum. FIND IN templates/default/admin/createforum.tmpl AROUND LINE 158 <select name="stylesheet" class=formboxes>
<option value="usedefault" selected="selected">{$ubbt_lang['DEFAULT']}</option> REPLACE WITH <select name="stylesheet" class="formboxes">
<option value="0" selected="selected">{$ubbt_lang['DEFAULT']}</option>
|
|
|
|
Joined: Apr 2004
Posts: 1,945 Likes: 145
|
Joined: Apr 2004
Posts: 1,945 Likes: 145 |
As for the second item you've reported regarding deleting the old forum.
This may be related to a UBB.threads 7.3.0 Alpha 2 (VERSION-7.3a2) bug from 2008. I am guessing that this only affected forums that ran that version at one time (???)
What happens when you do... 1. go to "Control Panel > Forums" 2. click on "Permissions" for the forum you want to delete. 3. at the permissions page without changing anything, confirm that "Currently Editing Permissions For" is the correct forum, then click the "Update Permissions For Selected Forum" button at the bottom. 4. now go back to "Control Panel > Forums" 5. click on "Details" for the forum you want to delete. 6. click "Delete Forum" in the footer.
Hopefully deleting the unwanted forum works for you now.
|
|
|
|
Joined: May 2006
Posts: 169
Member
|
Member
Joined: May 2006
Posts: 169 |
Followed directions to a tee, tried on two separate ones with the same result. Here is the second attempt error.
Script: /home/freaksfo/public_html/admin/dodeleteforum.php Line: 38 SQL Error: Truncated incorrect DOUBLE value: 'New Forum Template' SQL Error: 1292
Query: delete from ubbt_FORUM_PERMISSIONS where FORUM_ID = 74
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
What version of UBB.threads are you running? When you run the below MySQL code (CP -> Tools & Information -> Database Tools -> SQL Command) could you copy the output? It sounds like there could be a duplicate entry in the table for one of your groups: SELECT `GROUP_ID`, `FORUM_ID` FROM `ubbt_FORUM_PERMISSIONS` WHERE `FORUM_ID` LIKE '%New Forum Template%' ORDER BY `GROUP_ID` ASC You should get a kludge similar to: GROUP_ID FORUM_ID 1 New Forum Template 2 New Forum Template 3 New Forum Template 4 New Forum Template 5 New Forum Template 7 New Forum Template 10 New Forum Template 11 New Forum Template 12 New Forum Template
|
|
|
|
Joined: Apr 2004
Posts: 1,945 Likes: 145
|
Joined: Apr 2004
Posts: 1,945 Likes: 145 |
This looks like the columns being searched are int vs char. ubbt_FORUMS FORUM_ID is int(9)ubbt_FORUM_PERMISSIONS FORUM_ID is varchar(100)If you turn off SQL strict mode, the error you have now should turn into just a warning, and you will be able to proceed. But i believe this may be easily fixed at the code level by just adding single quotes around the string. Give this a shot FIND IN admin/dodeleteforum.php AROUND LINE 35 delete from {$config['TABLE_PREFIX']}FORUM_PERMISSIONS
where FORUM_ID = ? REPLACE WITH delete from {$config['TABLE_PREFIX']}FORUM_PERMISSIONS
where FORUM_ID = '?'
|
1 member likes this:
Gizmo |
|
|
|
Joined: May 2006
Posts: 169
Member
|
Member
Joined: May 2006
Posts: 169 |
Software 7.7.4 Release (build 20200307)
GROUP_ID FORUM_ID 1 New Forum Template 2 New Forum Template 3 New Forum Template 4 New Forum Template 5 New Forum Template 6 New Forum Template 7 New Forum Template 8 New Forum Template 9 New Forum Template
|
|
|
|
Joined: Dec 2003
Posts: 6,562 Likes: 78
|
Joined: Dec 2003
Posts: 6,562 Likes: 78 |
Isaac, Freak asked me to implement your suggestions, as usual they are spot on. And yes strict mode is enabled.
After doing so I checked the cp and had like 50+ forums. Then I checked the forums table had 146 rows.. All the rows that were not displayed in the control panel had null values for forum_title and parent forum_id. Plus the forum permissions and post tables had remaining rows with the bad forums. So I edited the forums table to to add a forum-title and parent forum_id. Then deleted them the normal way . This cleaned them completely.
This was probably due to failed deletions over the years.
So I attempted to run the re builders and now have a error on rebuild posts. I will post a new topic on that subject. with all the details.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
1 member likes this:
isaac |
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
1 members (Nightcrawler),
1,165
guests, and
234
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|