SQL issue, forum titles being cut off

[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?

[George L]

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?

what version of php, vB and mysql ?

[Glock21]

Originally posted by eva2000
what version of php, vB and mysql ?

PHP 4.2.2
vB 2.2.9
MySQL 3.23.41

[Glock21]

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.

[Glock21]

it's the table layout in the sql program the field definition "title" has to be fixed or re-created.

I just had someone tell me that, how do I go about doing such a thing and what is the default limit if I understand this correctly?

[Glock21]

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?

[Glock21]

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.

[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.

[Glock21]

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.

http://www.racialistforums.com/phpinfo.php

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.

[Glock21]

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

[Steve Machol]

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.

[Glock21]

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.

[Steve Machol]

I don't have specific instructions on doing this, but you can find and use the appropriate query in the install.php file.