Ran an SQL query, killed the forum

[MadK]

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;

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

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!