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!