[Forum] Forum database error

[-martin-]

Hello,

suddenly I realized there is some kind of database error in my vbulletin 4.2.1 forum it's happening on all pages, including forum index.

I didn't changed anything that could cause the error and i doubt that hosting did changed something without sending some notification.

How can I get more information about the sql error because all I see is just

The XXXXXX FORUM database has encountered a problem.

Please try the following: Load the page again by clicking the refresh button in your web browser. Open the XXXXXX home page, then try to open another page. Click the Back button to try another link.

The XXXXXX forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

[-martin-]

database login works, I downloaded whole base to sql file and set it on my localhost but still I get the error an all pages, after typing login data on admincp index page , action login also causing the same error

[Zachery]

Enable debug mode in the config file, and also make sure the techemail is set to a valid email address.

[-martin-]

Thanks Zachery, I edited includes/config.php and added the following line under <?php

$config['Misc']['debug'] = true;

I also put my gmail email address to

$config['Database']['technicalemail'] =' ' ;

line.

Still I get no additional info about the error.

[Zachery]

Right click and view the source of the page. Also make sure debug mode isn't being shut off further down the page.

[-martin-]

In the source it says:

 
 <!-- Database error in vBulletin 4.2.1:  Invalid SQL:  		SELECT username, userid, birthday, showbirthday 		FROM user 		WHERE (birthday LIKE '10-21-%' OR birthday LIKE '10-22-%') 		AND usergroupid IN (0, 22, 25, 5, 27, 30, 28, 23, 7, 2, 6, 21) 		AND showbirthday IN (2, 3) 		AND lastactivity &gt;= 1408715612;  MySQL Error   : Table './xxx_forum/user' is marked as crashed and should be repaired Error Number  : 145 Request Date  : Tuesday, October 21st 2014 @ 01:53:32 PM Error Date    : Tuesday, October 21st 2014 @ 01:53:32 PM Script        : http://www.com/forum/forum.php Referrer      :  IP Address    : XX.XXX.XX.XXX Username      : Unregistered Classname     : vB_Database MySQL Version :   Stack Trace:  #0 vB_Database-&gt;halt() called in [path]/includes/class_core.php on line 426 #1 vB_Database-&gt;execute_query() called in [path]/includes/class_core.php on line 473 #2 vB_Database-&gt;query_read_slave() called in [path]/includes/functions_databuild.php on line 1726 #3 build_birthdays() called in [path]/forum.php on line 149   -->

[Sqυιd]

If you read the error message you'll note that your user table has been marked by mysql as crashed. Here's a link to mysql's page for repairing a crashed myisam table.

[Lynne]

If you have access to your database via phpMySQL, then select the table (the "user" table) and run Repair database on the table. If it runs and says it is OK, then you should be fine. If it's doesn't say "OK" after running it once, then try running it again.

[-martin-]

acctually I don't see user table in the database! It looks like somehow got erased! In the last backup I can clearly see that existed.

[Lynne]

If you are missing your user table, then you have major problems. I would suggest uploading your database backup and using that for your site.

[-martin-]

I see now. When i did sql restore to localhost it was without user table, but on my main host there is still user table, after doing check with phpmyadmin those are the results:

XX_forum.user	check	warning	Table is marked as crashed
XX_forum.user	check	warning	1 client is using or hasn't closed the table prope...
XX_forum.user	check	error	Checksum for key: 10 doesn't match checksum for re...
XX_forum.user	check	error	Corrupt

[-martin-]

repair table user;

sql query solved the thing. Thanks for help.