mysql 5 upgrade problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • 2cv
    Member
    • Dec 2005
    • 60
    • 3.8.x

    [Forum] mysql 5 upgrade problem

    I have big problem after i upgrade my server from mysql 4 on mysql 5.
    I solve most of tham but still have one record corrupted in my vbulletin sql base.
    that is errror i get

    DELETE FROM vb_blog_usercss
    WHERE userid = 5590;

    MySQL Error : Incorrect key file for table 'vb_blog_usercss'; try to repair it
    Error Number : 1034
    Request Date : Friday, July 15th 2011 @ 03:28:23 AM
    Error Date : Friday, July 15th 2011 @ 03:28:23 AM
    Script : http://www.cxxcom/forum/admincp/user.php?do=kill
    Referrer : http://www.cxx.com/forum/admincp/use...=remove&u=5590
    IP Address : 88.200.92.236
    Username : 2cv
    Classname : vB_Database
    MySQL Version : 5.1.56

    MySQL Error : Incorrect key file for table 'vb_blog_usercss'; try to repair it

    vb_blog_usercss is corupted so i wond drop that record and crete new that works in mysql 5 so if any body could give me drop of that reccord.
    Web Hosting www.bilte.net - Citroen Info www.citroenbilten.com
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    Just repair it.
    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

    • 2cv
      Member
      • Dec 2005
      • 60
      • 3.8.x

      #3
      i cant every time get that record is corrupted and in use.
      Web Hosting www.bilte.net - Citroen Info www.citroenbilten.com

      Comment

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

        #4
        If this is happening frequently then this is a server issue. There is no reason for any table to crash that often. You should contact your host.
        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

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

          #5
          Originally posted by 2cv
          I have big problem after i upgrade my server from mysql 4 on mysql 5.
          I solve most of tham but still have one record corrupted in my vbulletin sql base.
          that is errror i get

          DELETE FROM vb_blog_usercss
          WHERE userid = 5590;

          MySQL Error : Incorrect key file for table 'vb_blog_usercss'; try to repair it
          Error Number : 1034
          Request Date : Friday, July 15th 2011 @ 03:28:23 AM
          Error Date : Friday, July 15th 2011 @ 03:28:23 AM
          Script : http://www.cxxcom/forum/admincp/user.php?do=kill
          Referrer : http://www.cxx.com/forum/admincp/use...=remove&u=5590
          IP Address : 88.200.92.236
          Username : 2cv
          Classname : vB_Database
          MySQL Version : 5.1.56

          MySQL Error : Incorrect key file for table 'vb_blog_usercss'; try to repair it

          vb_blog_usercss is corupted so i wond drop that record and crete new that works in mysql 5 so if any body could give me drop of that reccord.
          Prior to performing any MySQL upgrades, did you read the official instructions at http://dev.mysql.com/doc/refman/5.1/...us-series.html for MySQL 5.1.x upgrades or http://dev.mysql.com/doc/refman/5.5/...wngrading.html for MySQL 5.5.x upgrades. Also official recommendations for mysql upgrades is NOT to skip major versions. So if upgrading from MySQL 4.0.x, you upgrade to MySQL 5.0.x, then upgrade to MySQL 5.1.x, then to MySQL 5.5.x. Or do a mysqldump sql backup on MySQL 4.0.x, and after upgrading, restore that sql backup to a newly created MySQL database name on the upgraded server.

          Make sure you had done a full mysqldump sql backup of all databases on your server prior to upgrading and after upgrade run mysql_upgrade to ensure all existing database tables are compatible with new mysql version. If not compatible you will need to reload and restore those databases after upgrade using the full mysqldump sql backups you made just prior to upgrading mysql.

          Trying running the command mysql_upgrade in ssh2 telnet if you didn't run it when you did the upgrade and save a copy of that output for your own reference.
          :: 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

          • 2cv
            Member
            • Dec 2005
            • 60
            • 3.8.x

            #6
            All that do my support and i am sure that is be done.

            Now i have problem wit only one record that is vb_blog_usercss
            I think i could live wit out that but get errer when some user wont delete. Registratin works i see all other things works.
            Also hav eproblem with some durpale users.

            So i need just repair that record or wait to some new upgade which is gonana updarte that record. All other record works fine.
            Web Hosting www.bilte.net - Citroen Info www.citroenbilten.com

            Comment

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

              #7
              Have you tried using mysqlcheck to repair database in ssh2 telnet do the following

              step 1. backup database using mysqldump to sql file using ssh2 telnet and mysqldump as outlined here http://www.vbulletin.com/docs/html/m...nce_ssh_backup

              step 2. To repair such corruption log into server using ssh telnet as root user preferably try using mysqlcheck http://dev.mysql.com/doc/refman/5.1/en/mysqlcheck.html

              1. check database tables

              mysqlcheck -s -u mysqlusername -p vbforumdbname

              ignore session and cp session table messages and on mysql 5.1.x, ignore errors related to mysql.general_log and mysql.slow_log they don't support mysqlcheck.

              2. repair table

              mysqlcheck -r -q -u mysqlusername -p vbforumdbname


              3. recheck database tables

              mysqlcheck -s -u mysqlusername -p vbforumdbname

              if still get corruption errors that aren't related to vB session tables, then run

              mysqlcheck -r -u mysqlusername -p vbforumdbname

              if you want to do one table at a time then add tablename(s) to end of commandline

              i.e.

              mysqlcheck -s -u mysqlusername -p vbforumdbname tablename1 tablename2 tablename3




              So for that one particular table type in ssh2 telnet

              to check table
              mysqlcheck -s -u mysqlusername -p vbforumdbname vb_blog_usercss

              to repair table
              mysqlcheck -q -r -u mysqlusername -p vbforumdbname vb_blog_usercss

              to recheck table

              mysqlcheck -s -u mysqlusername -p vbforumdbname vb_blog_usercss

              if still got errors repair with

              mysqlcheck -r -u mysqlusername -p vbforumdbname vb_blog_usercss

              while you're at you can run mysql_upgrade via mysqlcheck command using -g option

              mysqlcheck -gA -r -u mysqlusername -p
              Last edited by George L; Sat 16 Jul '11, 2:26am.
              :: 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

              • 2cv
                Member
                • Dec 2005
                • 60
                • 3.8.x

                #8
                no way .. i fix and more then hundred mysql base works fine (wordpress,phpBB,store, etc etc)
                Only problem is with that my vbulletin one tabel and with durpal cms there is same porblem with system tabel and portal not work.
                So i must live with out this i hope vbulletin coild work with that borken.
                Web Hosting www.bilte.net - Citroen Info www.citroenbilten.com

                Comment

                • cerberuz
                  Senior Member
                  • May 2009
                  • 147
                  • 3.8.x

                  #9
                  I've just got about 50 email notifications from the server with this error aswell, I updated to vB 4.1.5 PL1 this morning and so far today ive had getting on for 240 to 250 db errors emails telling me that ive had either one of these errors

                  Code:
                  Database error in vBulletin 4.1.5:
                  
                  Invalid SQL:
                  
                  UPDATE cron
                  SET nextrun = 1312395900
                  WHERE cronid = 13 AND nextrun = 1312392300;
                  
                  MySQL Error   : Incorrect key file for table './game/cron.MYI'; try to repair it
                  Error Number  : 126
                  Request Date  : Wednesday, August 3rd 2011 @ 06:56:53 PM
                  Error Date    : Wednesday, August 3rd 2011 @ 06:56:54 PM
                  Script        : [URL="wlmailhtml:{F90A64FD-FDF1-4F02-99AC-728FCDBA914C}mid://00000303/!x-usc:http://experienced-gamers.com/cron.php?rand=1312394211"]http://[COLOR=#222222]mysite.com/c[/COLOR]ron.php?rand=1312394211[/URL]
                  Referrer      : [URL="wlmailhtml:{F90A64FD-FDF1-4F02-99AC-728FCDBA914C}mid://00000303/!x-usc:http://experienced-gamers.com/f246/battlefield-bad-company-2-digital-deluxe-edition-80127.html"]http://[COLOR=#222222]mysite.com/f[/COLOR]246/battlefield-bad-company-2-digital-deluxe-edition-80127.html[/URL]
                  IP Address    : 79.1xx.1xx.1x
                  Username      : Unregistered
                  Classname     : vB_Database
                  MySQL Version :

                  or one of these

                  Code:
                  Database error in vBulletin :
                  
                  mysql_connect(): Lost connection to MySQL server at 'reading initial communication packet', system error: 111
                  /var/www/vhosts/mysite.com/httpdocs/includes/class_core.php on line 314
                  
                  MySQL Error   : 
                  Error Number  : 
                  Request Date  : Wednesday, August 3rd 2011 @ 06:14:39 PM
                  Error Date    : Wednesday, August 3rd 2011 @ 06:14:39 PM
                  Script        : [URL]http://mysite.com/media.php?do=tag&tid=x360[/URL]
                  Referrer      : 
                  IP Address    : 174.129.228.67
                  Username      : 
                  Classname     : vB_Database
                  MySQL Version :

                  or a "Mysql has gone away error" I can't post one of those notifications as I deleted those emails as I got fed up with seeing them.. any ideas what may be causing this as my hosts say its a vBulletin issue

                  EDIT: Forgot to ask, how do i update mysql, as when i goto myphpadmin i see this

                  Code:
                  Your PHP MySQL library version 5.0.90 differs from your MySQL server version 5.1.57. This may cause unpredictable behavior.
                  could this be causing the issues?
                  Last edited by cerberuz; Wed 3 Aug '11, 10:55am.

                  Comment

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

                    #10
                    1. To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

                    Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

                    If you cannot access the Admin CP you can also use phpMyAdmin to repair tables.

                    If that doesn't work then this may be too damaged to fix with the normal methods. Please check out this thread for other ways to repair a db, particularly items #2 and 3:



                    You may have to ask your host to try and repair this for you.


                    2. This is a server issue. You need to contact your host about this. See this post for the possible causes of a lost connection error:



                    3. Yes, that mismatch library issue could be contributing to #2.
                    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

                    • cerberuz
                      Senior Member
                      • May 2009
                      • 147
                      • 3.8.x

                      #11
                      Cheers Steve, I tried all of the above, Im now going to chuck it back at the hosts to resolve..

                      Thanks Steve

                      Comment

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