Announcement

Collapse
No announcement yet.

VB2.2.9 & MySQL 4.x

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

  • VB2.2.9 & MySQL 4.x

    Ventures Online upgraded their MySQL software from 3.x to 4.x 6 days ago. And my forum experienced database errors 8 times in those 6 days. Most error messages goes like this:

    Database error in vBulletin 2.2.9:

    Invalid SQL: SELECT COUNT(*) AS users,MAX(userid) AS max FROM user
    mysql error: Can't open file: 'user.MYI'. (errno: 145)

    mysql error number: 1016

    Date: Sunday 13th of April 2003 02:24:23 PM
    Script: http://www.z-comics.com/forum/forum/
    Referer: http://www.z-comics.com/

    Are there any known compatibility problems with VB2.2.9 & MySQL 4.x?

  • #2
    Well, you should upgrade to vBulletin Version 2.3.0.

    Try uploading repair.php from your 'extras' folder in your vBulletin Download and run the following in your browser:

    http://your.domain/vb/admin/repair.php?html=1&check=1

    Comment


    • #3
      The user table often can't be repaired with repair.php. You may need to run this query in phpMyAdmin:

      REPAIR TABLE user;
      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


      • #4
        Thanks both.
        Originally posted by Steve Machol
        The user table often can't be repaired with repair.php. You may need to run this query in phpMyAdmin:
        REPAIR TABLE user;
        How do I do that?

        So there are no known compatibility problems with VB2.2.9 & MySQL 4.x?

        Comment


        • #5
          You run that query in the SQL tab in 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


          • #6
            Originally posted by Steve Machol
            You run that query in the SQL tab in phpMyAdmin.
            Is this in VB2.2.9? I can't find it.

            Comment


            • #7
              PhpMyAdmin is a MySQL database management tool. Most web hosts provide this as part of the web site management tools such as CPanel, Plesk or Ensim. Look for a link to SQL or MySQL Databases. If you can't find it I suggest you ask your host about this.

              If for some reason they do not provide phpMyAdmin or an equivalent MySQL manager, then you can download and install phpMyAdmin yourself from this location:

              http://www.phpmyadmin.net/
              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