Announcement

Collapse
No announcement yet.

SQL issue, forum titles being cut off

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    Leave a comment:


  • Glock21
    replied
    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.

    Leave a comment:


  • Steve Machol
    replied
    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.

    Leave a comment:


  • Glock21
    replied
    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

    Leave a comment:


  • Glock21
    replied
    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.

    Leave a comment:


  • Steve Machol
    replied
    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.

    Leave a comment:


  • Glock21
    replied
    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.

    Leave a comment:


  • Glock21
    replied
    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?

    Leave a comment:


  • Glock21
    replied
    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?

    Leave a comment:


  • Glock21
    replied
    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.

    Leave a comment:


  • Glock21
    replied
    Originally posted by eva2000
    what version of php, vB and mysql ?
    PHP 4.2.2
    vB 2.2.9
    MySQL 3.23.41

    Leave a comment:


  • George L
    replied
    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 ?

    Leave a comment:


  • Glock21
    started a topic SQL issue, forum titles being cut off

    SQL issue, forum titles being cut off

    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?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X