Database Errors

[Dj Smuggla]

Hi i just tried going on my site, but it's showing a database error. It's not showing any info for the error.

I went to my email account and saw a lot of emails saying database error.

This was the first one:

Database error in vBulletin 3.8.6:

Invalid SQL:
SELECT count(*) as num,floor((1315353599-post.dateline)/86400) as  day FROM post AS post LEFT JOIN thread AS thread on  post.threadid=thread.threadid LEFT JOIN forum AS forum on  thread.forumid=forum.forumid WHERE ((forum.options&4096))AND(post.userid=13484)AND(post.dateline>=1312934400) GROUP BY day ORDER BY day;

MySQL Error   : Lost connection to MySQL server during query
Error Number  : 2013
Request Date  : Tuesday, September 6th 2011 @ 05:15:51 PM
Error Date    : Tuesday, September 6th 2011 @ 05:15:53 PM
Script        :
Referrer      :
IP Address    : 180.76.5.91
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

A few like this:

Database error in vBulletin 3.8.6:

Invalid SQL:

                        SELECT * FROM user FORCE INDEX (lastactivity)
                        WHERE lastactivity > 1315353600 ORDER BY username;

MySQL Error   : Table './hhd_ddforum/user' is marked as crashed and should be repaired
Error Number  : 145
Request Date  : Tuesday, September 6th 2011 @ 05:33:11 PM
Error Date    : Tuesday, September 6th 2011 @ 05:33:11 PM
Script        : 
Referrer      :
IP Address    : 220.181.108.176
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

And this:

Database error in vBulletin 3.8.6:

Invalid SQL:
SELECT userid, usergroupid, membergroupids, infractiongroupids, username, password, salt FROM user WHERE username = 'framinoky';

MySQL Error   : Table './hhd_ddforum/user' is marked as crashed and should be repaired
Error Number  : 145
Request Date  : Tuesday, September 6th 2011 @ 05:33:45 PM
Error Date    : Tuesday, September 6th 2011 @ 05:33:45 PM
Script        : 
com/login.php
Referrer      :
IP Address    : 74.53.190.130
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

When i go to the acp to repair the table again it just says database error.

Does anyone know how i can fix this issue? It was working fine earlyer.

[Lynne]

Your user table needs to be repaired. Since you won't be able to do this from the admincp, you will need to either ask your host, or do it via phpMyAdmin.

[Dj Smuggla]

Thanks for your quick reply Lynne

How do i repair a table in phpMyAdmin?

I logged in to phpMyAdmin, clicked the database, then clicked on the user table & clicked the Operations tab but i cant see a option for Repair Table.

Is it the same as Flush the table (FLUSH), because thats all i see under "Table maintenance"

[Wayne Luke]

http://php.about.com/od/mysqladminis...pair_mysql.htm

[TheNewOne]

1. Login to phpMyAdmin
2. Choose the affected database. If you only have one database, it should choose it by default so you don't need to do anything.
3. In the main panel, you should see a list of your database tables. Check the boxes by the tables that need repair.
4. At the bottom of the window just below the list of tables, there is a drop down menu. Choose "Repair Table"

This should fix your table, and let you access it again.

[Dj Smuggla]

Thanks a lot guys for your fast replys, i was pulling my hair out trying to fix this...

Now that it is fixed... it's a good idea to make that database backup!

Your not wrong there m8...