Previous Thread
Next Thread
Print Thread
Hop To
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
UBB.threads Developer
UBB.threads Developer
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
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 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
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.


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
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,289
Likes: 115
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,289
Likes: 115
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,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
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
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 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
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,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
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

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Forum Privacy Policy
by ECNet - 02/26/2024 11:58 AM
Who's Online Now
2 members (Nightcrawler, Ruben), 322 guests, and 160 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)