Forum Ran an SQL query, killed the forum
 

Hey there,
Before I start I would like to say that I used digitalpoint's vB Optimizing guide right here and I am aware that it clearly states that anything can break at any moment when applying these changes, but it was actually a mistake on my part.

The thing is that I ran the following query:
PHP Code:
ALTER TABLE post DROP INDEX userid, ADD INDEX userid (userid, parentid)

And although my database uses a prefix, the query still ran somehow.

So I ran it a second time with the appropriate prefix, and it worked... until a few hours ago.


I am now getting e-mails from the vBulletin Database Error System similar to this;

Code:
Database error in vBulletin 4.0.3:

Invalid SQL:
SELECT userid from post where threadid='222' AND userid=12;

MySQL Error : Table 'forums.post' doesn't exist
Error Number : 1146
Request Date : Friday, June 11th 2010 @ 02:55:04 AM
Error Date : Friday, June 11th 2010 @ 02:55:04 AM
Script : ****
Referrer : ****
My forums now point to a non-existent table and I cannot come up with a solution.

I was hoping somebody here experienced enough in MySQL would be able to help me.

Appreciate the help and much success,
Thanks a lot!