My SQL went down twice tonight and after restarting it the 2nd time all of my forum titles and descriptions have been cut down to 5 characters. Anyone know what to do?
Announcement
Collapse
No announcement yet.
SQL issue, forum titles being cut off
Collapse
X
-
Originally posted by Glock21
My SQL went down twice tonight and after restarting it the 2nd time all of my forum titles and descriptions have been cut down to 5 characters. Anyone know what to do?:: Always Back Up Forum Database + Attachments BEFORE upgrading !
:: Nginx SPDY SSL - World Flags Demo [video results]
:: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]
-
We also ran through myisachk and all, and it looks like the data is there. When I go to modify the forum names it lets me change them but still only displays the first few letters so I think the data is there, it's just not being displayed correctly.
Comment
-
I figured that part out and it was because the char limits were 1 and 5 respectively. Problem is all of my 60+ forum titles and descriptions are now gone. I have a complete SQL backup from a few days ago, how do I go about just re-importing the titles and descriptions?
Comment
-
Database error in vBulletin 2.2.9:
Invalid SQL: SELECT maxlength,profilefieldid,required,title
FROM profilefield
WHERE editable = 1
ORDER BY displayorder
mysql error: Unknown column 'title' in 'field list'
mysql error number: 1054
I'm still getting this mailed to me also.
Comment
-
What is the complete error message (including the script being run)?
Upload the phpinfo.php file from the 'extras' directory of the zip file to your forums directory. Then post the URL here. This will help us troubleshoot the problem.Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
-
Originally posted by Steve Machol
What is the complete error message (including the script being run)?
Upload the phpinfo.php file from the 'extras' directory of the zip file to your forums directory. Then post the URL here. This will help us troubleshoot the problem.
Database error in vBulletin Control Panel 2.2.9:
Invalid SQL: SELECT profilefieldid,title FROM profilefield
mysql error: Unknown column 'title' in 'field list'
mysql error number: 1054
Date: Friday 10th of January 2003 03:12:35 PM
Script: http://www.racialistforums.com/admin/user.php
Referer: http://www.racialistforums.com/admin...s=&action=home
Well it's happening in the CP now also, in addition to seeing 70 of these in my email this morning.
Comment
-
Database error in vBulletin 2.2.9:
Invalid SQL: SELECT maxlength,profilefieldid,required,title
FROM profilefield
WHERE editable = 1
ORDER BY displayorder
mysql error: Unknown column 'title' in 'field list'
mysql error number: 1054
Date: Friday 10th of January 2003 04:02:42 PM
Script: http://www.racialistforums.com/register.php
Referer: http://www.racialistforums.com/register.php
Comment
-
Something has happened to your database which deleted the title field from the profilefield table. Fill out a support ticket at:
http://www.vbulletin.com/members/support_form.php
Be sure to include the login info to your Admin CP and phpMyAdmin.Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
-
Are you able to provide instructions as to how to recreate it? I did it myself and just want to confirm that everything is correct in the settings as it seems to be working. I would prefer to not have to create logins for vBulletin and all, so this would be the easiest way.
Comment
-
I don't have specific instructions on doing this, but you can find and use the appropriate query in the install.php file.Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment