Announcement

Collapse
No announcement yet.

Database error in vBulletin 2.2.6:

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

  • Database error in vBulletin 2.2.6:

    What does this meen, and how do I get it to go away?

    Database error in vBulletin 2.2.6:

    Invalid SQL: SELECT title FROM usertitle WHERE minposts<=5+1 ORDER BY minposts DESC LIMIT 1
    mysql error: Incorrect information in file: './max/usertitle.frm'

    mysql error number: 1033


    Thankx,
    244

  • #2
    looks like you have a corrupted table definition file

    first things first is

    1. close your forum
    2. backup your forum and put aside the backup sql file for safe keeping

    once that is done i can guide you through the repair process

    what version of mysql are you using?
    do you have shell/ssh/telnet access ?
    :: 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

      1. close your forum
      2. backup your forum and put aside the backup sql file for safe keeping


      O.K.

      what version of mysql are you using?

      3.23.49 on FreeBSD

      do you have shell/ssh/telnet access ?

      Yes, SSH, TCSH and I have root access..

      Thanks,
      244

      Comment


      • #4
        that's great.. may i ask how you backed up your forum database ? via telnet/ssh -> http://www.webmasterbase.com/article/678

        or via vB's admin panel

        it's best to use telnet/ssh guide at http://www.webmasterbase.com/article/678
        :: 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


        • #5
          that's great.. may i ask how you backed up your forum database


          VB Admin panel, but I will try the other way also.


          Thankx,
          244

          NOTE: tried to dump via ssh got this error message..
          mysqldump: Can't get CREATE TABLE for table 'useractivation' (Incorrect information in file: './max/useractivation.frm')
          Last edited by 244; Tue 2 Jul '02, 2:14am.

          Comment


          • #6
            what you'll need to do is make a copy of the actual database files

            to do this

            1. shutdown mysql

            2. check to make sure mysql is shut down by typing as root user in telnet/ssh

            ps aux | grep mysql

            you should see no or only 1 mysql process running

            3. now create a backup mysql data directory in /home in you can

            mkdir /home/mysqldatabackup

            4. copy over the forum database's data files i.e. if they're located at

            /var/lib/mysql/forumdatabasename

            type:

            Code:
            cp /var/lib/mysql/[b]forumdatabasename[/b] /home/mysqldatabackup
            reason for this procedure is that repair process can cut out corrupted entries and you would be best to have a copy of the original database in case you need to try other repair options...
            :: 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


            • #7
              O.K.,
              Done, I also tared the directory but I got this error message while doing it.. Aslo mysql was not running while I was taring.

              tar: read error at byte 0, reading 4096 bytes, in file max/usertitle.frm : Input/output error
              Also got this

              cp: /home/mysqlbackup/usertitle.frm: Bad address



              Thankx,
              244

              Comment


              • #8
                hmm i think it's best if i had a look for myself...

                you can submit a support ticket at http://vbulletin.com/members/support.php and provide your server's root password, and mysql root password and telnet/ssh log in details
                :: 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


                • #9
                  O.K.
                  Message was sent..

                  Thankx again,
                  244

                  Comment

                  widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                  Working...
                  X