Announcement

Collapse
No announcement yet.

VB2.2.9 & MySQL 4.x

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

  • Steve Machol
    replied
    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/

    Leave a comment:


  • mystara
    replied
    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.

    Leave a comment:


  • Steve Machol
    replied
    You run that query in the SQL tab in phpMyAdmin.

    Leave a comment:


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

    Leave a comment:


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

    REPAIR TABLE user;

    Leave a comment:


  • Guest's Avatar
    Guest replied
    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

    Leave a comment:


  • mystara
    started a topic VB2.2.9 & MySQL 4.x

    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?
Loading...
Working...
X