Announcement

Collapse
No announcement yet.

SQL issue, forum titles being cut off

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

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

  • #2
    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 ?
    :: 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 ]

    Comment


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

      Comment


      • #4
        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


        • #5
          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?

          Comment


          • #6
            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


            • #7
              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


              • #8
                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


                • #9
                  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.

                  Comment


                  • #10
                    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


                    • #11
                      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


                      • #12
                        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


                        • #13
                          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

                          Loading...
                          Working...
                          X