upgraded to MySQL 4.0.16

[tariqalali]

Greetings,

I upgraded my MySQL 3.23 to 4.0.16 and got the following error message as soon as accessing the forum.

----------------------------
There seems to have been a slight problem with the Forum_name database.

Please try again by pressing the refresh (javascript:window.location=window.location;) button in your browser.
An E-Mail has been dispatched to our Technical Staff (webmaster@alazraq.com), who you can also contact if the problem persists.


We apologise for any inconvenience.

----------------------------

I went through the threads here and couldn't find the answer. It could probably be old.

I thank you in advance for your support.

Regards

Tariq AlAli
ALAZRAQ.com

[eva2000]

on the error page right click and view source code and copy and paste the

<!-- --> mysql error message you get

[tariqalali]

HI Eva

Thank you for your reply. Please find below the source code of the error:

<!-- Database error in vBulletin 2.2.9:
Invalid SQL: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='4'
mysql error: Can't open file: 'user.MYI'. (errno: 145)
mysql error number: 1016
Date: Saturday 01st of November 2003 03:06:48 PM
Script: http://alazraq.com/diwania/diwania/
Referer:
-->

the VB database folder permission is 700 and the data is 660.


Thank you.

-Tariq

[eva2000]

that error means your USER table was corrupted and needs repairing

do you have root server access ?

if you do log into ssh telnet and type

mysqlcheck -r -q -u mysqlusername -p vbdatabasename user

you'd be prompted for your mysqlusername's password

if you don't have ssh telnet access you need to repair

1. via phpmyadmin run this query on your vbdatabasename

REPAIR TABLE user;

OR

2. you need to upload repair.php from your vB zip file to your /admin directory and run this url

yourdomain.com/admin/repair.php?html=1&check=1

[tariqalali]

Dear Eva

Yes, i did repaired it and it's working fine now.

THank you for your continuous support.


-Tariq