Need some help with Database Errors and how to fix

[TimBrown]

Hi, my vB has some kind of database error and i dont know how to fix it. Heres the error

<!--
Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_holiday AS phrasegroup_holiday,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep

FROM vb_user AS user
LEFT JOIN vb_userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN vb_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN vb_language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))

WHERE user.userid = 6;

MySQL Error : Table './x4wrest_forum/vb_user' is marked as crashed and should be repaired
Error Number : 145
Request Date : Monday, April 6th 2009 @ 02:03:18 PM
Error Date : Monday, April 6th 2009 @ 02:03:18 PM
Script : http://24forums.com/
Referrer : http://24forums.com/
IP Address : 216.138.1.10
Username :
Classname : vB_Database
MySQL Version :
-->


Any idea on what to do?
Please and thank you!

[Lynne]

Go to admin cp > maintenance > repair/optimize tables > select the user table > repair/optimize You may have to do this a couple of times until it says the table is OK and up-to-date.

[TimBrown]

When i try to go to the Admin cp, it also gives me the database error.
as seen here
http://img300.imageshack.us/img300/4048/scr9549451.jpg

[BSMedia]

you'll have to hit View -> Source to get the database error from your AdminCP.

I suggest running repair table from SSH if its available to you, as doing it from AdminCP can actually cause more problems, especially on a large site or over loaded server.

[snakes1100]

As your using cpanel, log into your cpanel and use phpmyadmin to repair your crashed db table.

[TimBrown]

heres the one from the admin cp
<!--
Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT administrator.*,
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_cphome AS phrasegroup_cphome,
language.phrasegroup_cpglobal AS phrasegroup_cpglobal,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep

FROM vb_user AS user
LEFT JOIN vb_userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN vb_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN vb_administrator AS administrator ON (administrator.userid = user.userid) LEFT JOIN vb_language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))

WHERE user.userid = 6;

MySQL Error : Table './x4wrest_forum/vb_user' is marked as crashed and should be repaired
Error Number : 145
Request Date : Monday, April 6th 2009 @ 03:36:03 PM
Error Date : Monday, April 6th 2009 @ 03:36:06 PM
Script : http://24forums.com/admincp/index.php
Referrer :
IP Address : 216.138.1.10
Username :
Classname : vB_Database
MySQL Version :
-->


looks the same

[Lynne]

As already mentioned, use phpMyAdmin to select the table and run repair on it.

[TimBrown]

Ok gotcha. Ill try it out and report back. Thanks!