database error
 

Hello . after a long time working on our forum , we have another database error again

we also work on our security sistem.but we still have database errors
anyone know a Way to help me ? I am really tired of this errors

Database Error Database error
The database has encountered a problem.
Please try the following:

* Load the page again by clicking the Refresh button in your web browser.
* Open the p30lords.com home page, then try to open another page.
* Click the Back button to try another link.

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

We apologise for any inconvenience.

You will need to post the entire error message. You can find this either in your webmaster email or by viewing the page source.

I put the page source at VB support before . you told me to have conections and change config . O change config and also I've got a VPS . but I still have problems ...

--------------- Added [DATE]1233152711[/DATE] at [TIME]1233152711[/TIME] ---------------

at online users list , I saw a lot of guests there that viewing user control panel ! why it was like that ?

--------------- Added [DATE]1233152743[/DATE] at [TIME]1233152743[/TIME] ---------------

Database error in vBulletin 3.7.5:

Invalid SQL:
SELECT p.threadid, t.forumid FROM post p LEFT JOIN thread t ON(t.threadid = p.threadid) WHERE p.userid = ;

MySQL Error : Table './p30lords_vb2/post' is marked as crashed and last (automatic?) repair failed
Error Number : 144
Request Date : Wednesday, January 28th 2009 @ 09:13:20 AM
Error Date : Wednesday, January 28th 2009 @ 09:14:19 AM
Script : http://www.p30lords.com/forum/
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.67-community

MySQL Error : Table './p30lords_vb2/post' is marked as crashed and last (automatic?) repair failed


To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

If you can not access your AdminCP, then you can upload the tools.php file from the vbulletin .zip file do_not_upload/ folder into your forumdir/admincp/ directory and run it through the browser, there's a switch there to run optimize and repair. Run it a few times for best result.

If you cannot access either the Admin CP or tools.php you can also use a tool like phpMyAdmin to repair tables.

thank marco
I do so but is there any way to take care of this problems ?

I just posted how you can take care of this issue. :confused:

thanks a lot ... sorry If I tell my sentece in bad words . It works for now ... but I have this problem a lot of times ... what should I do to never have this problem again ?

If it is the same problem (corrupted table) then the solution is the same. If this happens a lot, you should contact your host to review his server configuration.