Database error-we are under attack

[bkm_mahdi]

every couple of hours, somebody attack to our data base, and then we just have "data base error" alert. what's the problem and what can we do?

Database Error Database error
The P 3 0 L O R D S.COM 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.

[terracore]

Originally Posted by bkm_mahdi

every couple of hours, somebody attack to our data base, and then we just have "data base error" alert. what's the problem and what can we do?





Database Error Database error
The P 3 0 L O R D S.COM 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.

I'm having the same problem! This has never happened before.

[Lynne]

It would help to see the actual database error. When you get that screen, go to View Source and on the bottom of that page is the actual database error. Copy/Paste the whole error here.

[terracore]

MySQL Error : Table './aviannat_vb3/user' is marked as crashed and should be repaired
Error Number : 145
Request Date : Thursday, September 11th 2008 @ 09:05:02 AM
Error Date : Thursday, September 11th 2008 @ 09:05:02 AM
Script : http://www.aviannation.com/
Referrer : http://www.aviannation.com/
IP Address : 209.193.18.149
Username :
Classname : vb_database
MySQL Version :

How can I repair it without having access to the cpanel?

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

Incidentally, google vbulletin "database error" and look at the results... a zillion of them are down as of 9/11/08 morning.

OK I was able to fix it through my web host but how did this happen? We just upgraded to 3.7.3. over the weekend and never had problems before.

[Quarterbore]

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

Incidentally, google vbulletin "database error" and look at the results... a zillion of them are down as of 9/11/08 morning.

OK I was able to fix it through my web host but how did this happen? We just upgraded to 3.7.3. over the weekend and never had problems before.

Wow, and google mars made of cheese and you will discover 4,540,000 pages so obvioulsy Mars is made of cheese!

Sorry for your misfortune, but the sky is not falling!

I think you should go to vBulletin.com and ask for help there. I would put a support ticket in and send them the error notice. I think you can likely run one of the utilities they have to repair the database. If not, do you have a recent backup of the database downloaded?

If not, you should have been doing so and here is a tutorial I wrote years ago that will help you start!

http://www.vbclassified.com/showthread.php?t=241

[Lynne]

A crashed table is easily fixed by doing a repair/optimize in the Admin CP or through phpMyAdmin (or any number of other ways). As for why, who knows, it's a server thing and they sometimes have a mind of their own. If you want more info on why tables crash, you could google it or do a search on both of the vb sites and see if their is a thread about it.

I'm laughing about the google thing though. Crashed tables do not signal the end of the world.

[Eikinskjaldi]

Originally Posted by Lynne

I'm laughing about the google thing though. Crashed tables do not signal the end of the world.

No, that's the job of the large hadron collider.

A crashed table usually means your DB went through some kind of crisis.

[Paul M]

Originally Posted by Lynne

A crashed table is easily fixed by doing a repair/optimize in the Admin CP or through phpMyAdmin (or any number of other ways).

Sadly, he cannot do it via the ACP as its his user table thats crashed - no user table means no ACP access.

[Opserty]

Extract tools.php, from the "do_not_upload" folder of the vBulletin archive you downloaded from vbulletin.com, upload this file to your /admincp/ directory. There is an option to "[Repair Tables]", you may need to run it a few times, for it to work.

[bkm_mahdi]

thanks to all of you I'll have to test all of these works that you tell and I will tell you the news after that ...