cannot create new gallery in the Forums

Print Thread

Hop To

#227742 07/21/2009 11:09 AM

Joined: Jan 2008

Posts: 13

ckelpin

stranger

ckelpin

stranger

Joined: Jan 2008

Posts: 13

I get the following error when adding a new Forum to existing Gallery, but can create new Gallery without errors. Anyone familiar with this, or know how to fix?

The table for 'FORUM_SORT_DIR' is varchar(3).

Code

Script: E:\Inetpub\wwwroot\devbb\forums\admin\docreateforum.php
Line#: 140
SQL Error: Data too long for column 'FORUM_SORT_DIR' at row 1
SQL Error #: 1406
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_SORT_FIELD,FORUM_SORT_DIR) VALUES ( 1 , '' , 93 , 0 , 0 , '' , 1 , 10 , 0 , 0 , 1248188539 , 0 , 0 , 0 , 0 , 0 , 0 , 'RSS Feed for 1' , 0 , '' , 0 , 0 , 1 , 'last' , 'desc') 

» Return

Last edited by Gizmo; 07/21/2009 12:28 PM. Reason: [code] tags

Re: cannot create new gallery in the Forums ckelpin #227743 07/21/2009 12:27 PM
Joined: Jun 2006 Posts: 16,301 Likes: 116 Portland, OR; USA Gizmo
Gizmo Joined: Jun 2006 Posts: 16,301 Likes: 116 Portland, OR; USA	Change forum_sort_dir to a varchar4; it's trying to put "desc" (4 chars) in a 3 char field... Your "new" gallery forums must be ascending (asc) 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!

Re: cannot create new gallery in the Forums Gizmo #227745 07/21/2009 1:15 PM
Joined: Dec 2003 Posts: 6,566 Likes: 78 Lutz,FL Ruben
Ruben Joined: Dec 2003 Posts: 6,566 Likes: 78 Lutz,FL	Maybe I missed something here. Why would they need to change any table properties Giz? From what I see they are using ubb7.5 Blue Man Group There is no such thing as stupid questions. Just stupid answers

Re: cannot create new gallery in the Forums Gizmo #227747 07/21/2009 2:22 PM
Joined: Jan 2008 Posts: 13 ckelpin stranger
ckelpin stranger Joined: Jan 2008 Posts: 13	I made the change and received the following error: ALTER TABLE `ubb`.`ubbt_forums` MODIFY COLUMN `FORUM_SORT_DIR` VARCHAR(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL; I'm on 7.5 - ran the upgrade some time back but almost looks like the upgrade changed the DB charset to something other than English? Thoughts?

Re: cannot create new gallery in the Forums ckelpin #227748 07/21/2009 2:32 PM
Joined: Jun 2006 Posts: 9,242 Likes: 1 Aberdeen, WA R Rick Former Developer
Rick Former Developer R Joined: Jun 2006 Posts: 9,242 Likes: 1 Aberdeen, WA	This was a bug in 7.5 where the column was only 3 characters in length when it should have been 4. As for the error you're getting now, you should just be able to run this: ALTER TABLE `ubb`.`ubbt_forums` MODIFY COLUMN `FORUM_SORT_DIR` VARCHAR(4)

Re: cannot create new gallery in the Forums ckelpin #227749 07/21/2009 2:32 PM
Joined: Jan 2008 Posts: 13 ckelpin stranger
ckelpin stranger Joined: Jan 2008 Posts: 13	OK - I changed the Default order from Descending to Ascending and was able to create the new forum needed. thanks.

Link Copied to Clipboard

UBB.threads PHP Forum Software Community Forums Resources and Customizing How Do I? cannot create new gallery in the Forums