Trying to fix mysql error number: 1033.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Novadream
    Senior Member
    • Oct 2002
    • 447

    Trying to fix mysql error number: 1033.

    I am trying to Empty the Search Index from Repair/OptimizeTables to fix a mysql error number: 1033...and when trying to empty the search index i get the exact same mysql error so i cant do anything.



    then I need to know what this means......



    DROP TABLE IF EXISTS `postindex`;
    CREATE TABLE postindex (

    wordid INT UNSIGNED NOT NULL DEFAULT '0',
    postid INT UNSIGNED NOT NULL DEFAULT '0',
    intitle SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    score SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    UNIQUE KEY wordid (wordid, postid)""
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    As I mentioned in your other post, please provide the complete error message so we can see exacctly what the problem is.
    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

    • Novadream
      Senior Member
      • Oct 2002
      • 447

      #3
      Oh sorry about that...didn't realise I was explaining it wrong...


      here we go.....


      Database error in vBulletin 3.0.1:
      Invalid SQL:
      REPLACE INTO postindex
      (wordid, postid, score, intitle)
      VALUES
      (68100, 48272, 1, 0)

      mysql error: Incorrect information in file: './boardmysql/postindex.frm'
      mysql error number: 1033





      thanx!

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #4
        Have you tried repairing the postidex table?
        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

        • Novadream
          Senior Member
          • Oct 2002
          • 447

          #5
          postindexCheckError: Incorrect information in file: './boardmysql/postindex.frm'


          I ran it many times and i always got this error

          Comment

          • George L
            Former vBulletin Support
            • May 2000
            • 32996
            • 3.8.x

            #6
            Originally posted by Novadream
            Oh sorry about that...didn't realise I was explaining it wrong...


            here we go.....


            Database error in vBulletin 3.0.1:
            Invalid SQL:
            REPLACE INTO postindex
            (wordid, postid, score, intitle)
            VALUES
            (68100, 48272, 1, 0)

            mysql error: Incorrect information in file: './boardmysql/postindex.frm'
            mysql error number: 1033





            thanx!
            Your table definition file seems to be corrupted and needs rebuilding/repair along with your index file for postindex table. REPAIR or vbadmincp repair options or mysqlcheck won't work to repair this. You need to close your forum and shut down mysql server and us myisamchk to recreate the *.frm and *.myi files for postindex table.

            This is decribed in Stage 4, step 2 at http://dev.mysql.com/doc/mysql/en/repair.html

            Or since postindex isn't that important, you can just delete the postindex table and recreate it, and then reindex the forums via admincp update counter page

            What version of mysql are you using and do you have ssh telnet/root server 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

            • Novadream
              Senior Member
              • Oct 2002
              • 447

              #7
              what do you mean by shutting down the mysql server? how do i do that?


              thnx

              Comment

              • George L
                Former vBulletin Support
                • May 2000
                • 32996
                • 3.8.x

                #8
                to shut down mysql server you need ssh telnet and root server access - usually if you have a dedicated server you would have root server access

                mysql stop and start command would be something like this

                /etc/rc.d/init.d/mysql stop
                /etc/rc.d/init.d/mysql start

                path may vary depending on how your server and mysql was installed (ask your web host if not sure)
                :: 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

                • Novadream
                  Senior Member
                  • Oct 2002
                  • 447

                  #9
                  what does this mean? And how do I do it?


                  "Or since postindex isn't that important, you can just delete the postindex table and recreate it, and then reindex the forums via admincp update counter page"

                  Comment

                  • George L
                    Former vBulletin Support
                    • May 2000
                    • 32996
                    • 3.8.x

                    #10
                    Originally posted by Novadream
                    what does this mean? And how do I do it?


                    "Or since postindex isn't that important, you can just delete the postindex table and recreate it, and then reindex the forums via admincp update counter page"
                    you use phpmyadmin or ssh telnet and from mysql command line, drop or delete the postindex table and then find your vB 3.01 zip file and in /install/mysql-schema.php find the line that is used to create postindex table

                    in txt editor search in mysql-schema.php for postindex and you will come to a line similar to this, this is what vB 3.0.0 had, may have changed slightly in vB 3.0.1

                    CREATE TABLE " . TABLE_PREFIX . "postindex (
                    wordid INT UNSIGNED NOT NULL DEFAULT '0',
                    postid INT UNSIGNED NOT NULL DEFAULT '0',
                    intitle SMALLINT UNSIGNED NOT NULL DEFAULT '0',
                    score SMALLINT UNSIGNED NOT NULL DEFAULT '0',
                    UNIQUE KEY wordid (wordid, postid)
                    )
                    You use phpmyadmin to run this command replacing

                    " . TABLE_PREFIX . "

                    with your prefix name if you set on in config.php if not delete this line

                    " . TABLE_PREFIX . "

                    If you are unsure, you can submit a support ticket at http://www.vbulletin.com/members/mem...ontactform.php and one our vB staff will see what they can 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 ]

                    Comment

                    • Novadream
                      Senior Member
                      • Oct 2002
                      • 447

                      #11
                      I'm very unsure. But I might as well give it a shot myself.


                      As for the Vb 3.01 zip file.. I don't think I have that package on my harddrive anymore. Is there somewhere to download it from on this site?



                      thanks for your help!

                      Comment

                      • Steve Machol
                        Former Customer Support Manager
                        • Jul 2000
                        • 154488

                        #12
                        If you had an active license when 3.0.1 was released, you should be able to download it from the Members Area.
                        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

                        • Novadream
                          Senior Member
                          • Oct 2002
                          • 447

                          #13
                          I downloaded VB3.1 onto my harddrive and found this part in the mysql-schema.php



                          CREATE TABLE " . TABLE_PREFIX . "postindex (
                          wordid INT UNSIGNED NOT NULL DEFAULT '0',
                          postid INT UNSIGNED NOT NULL DEFAULT '0',
                          intitle SMALLINT UNSIGNED NOT NULL DEFAULT '0',
                          score SMALLINT UNSIGNED NOT NULL DEFAULT '0',
                          UNIQUE KEY wordid (wordid, postid)
                          )


                          Im not sure what you're asking me to do at this step though.

                          Comment

                          • George L
                            Former vBulletin Support
                            • May 2000
                            • 32996
                            • 3.8.x

                            #14
                            Originally posted by Novadream
                            I downloaded VB3.1 onto my harddrive and found this part in the mysql-schema.php



                            CREATE TABLE " . TABLE_PREFIX . "postindex (
                            wordid INT UNSIGNED NOT NULL DEFAULT '0',
                            postid INT UNSIGNED NOT NULL DEFAULT '0',
                            intitle SMALLINT UNSIGNED NOT NULL DEFAULT '0',
                            score SMALLINT UNSIGNED NOT NULL DEFAULT '0',
                            UNIQUE KEY wordid (wordid, postid)
                            )


                            Im not sure what you're asking me to do at this step though.
                            do you have phpmyadmin installed ? if not you can edit your vB config.php to set your admin userid in

                            $canrunqueries = 'userid';

                            where userid = your admin userid

                            also do you have a table_prefix set in config.php ? what is it ?
                            :: 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

                            • Novadream
                              Senior Member
                              • Oct 2002
                              • 447

                              #15
                              yes i was waiting in phpmyadmin that day...so i was asking what do i do now from within phpmyadmin with all that code????

                              Comment

                              Related Topics

                              Collapse

                              Working...