Previous Thread
Next Thread
Print Thread
Hop To
Joined: May 2006
Posts: 137
FREAK Offline OP
Member
OP Offline
Member
Joined: May 2006
Posts: 137
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,822
Likes: 105
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,822
Likes: 105
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
Code
<select name="stylesheet" class=formboxes>
<option value="usedefault" selected="selected">{$ubbt_lang['DEFAULT']}</option>

REPLACE WITH
Code
<select name="stylesheet" class="formboxes">
<option value="0" selected="selected">{$ubbt_lang['DEFAULT']}</option>


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Work In Progress: soon
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Apr 2004
Posts: 1,822
Likes: 105
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,822
Likes: 105
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.


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Work In Progress: soon
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: May 2006
Posts: 137
FREAK Offline OP
Member
OP Offline
Member
Joined: May 2006
Posts: 137
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,014
Likes: 58
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,014
Likes: 58
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:
SQL Query
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:
Quote
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


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Apr 2004
Posts: 1,822
Likes: 105
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,822
Likes: 105
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
Code
		delete from {$config['TABLE_PREFIX']}FORUM_PERMISSIONS
		where FORUM_ID = ?

REPLACE WITH
Code
		delete from {$config['TABLE_PREFIX']}FORUM_PERMISSIONS
		where FORUM_ID = '?'


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Work In Progress: soon
isaac @ id242.com // my forum @ CelicaHobby.com
1 member likes this: Gizmo
Joined: May 2006
Posts: 137
FREAK Offline OP
Member
OP Offline
Member
Joined: May 2006
Posts: 137
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,278
Likes: 45
Online Yawn
Joined: Dec 2003
Posts: 6,278
Likes: 45
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

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
v7.7.5 Active Topics Display Name Incorrect
by Jake - 11/17/2020 4:46 PM
custom islands in forums tool
by Ruben - 11/17/2020 3:21 PM
Captcha bug maybe?
by Morgan - 11/16/2020 8:34 AM
Facebook thumbnail issue
by DBryce - 11/08/2020 7:43 PM
No hop to menu in the category pages
by Morgan - 11/05/2020 4:19 PM
Who's Online Now
1 members (Ruben), 56 guests, and 52 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
gallery test
gallery test
by Mors, September 23
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Powered by UBB.threads™ PHP Forum Software 7.7.5