|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
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! __DEFINE_LIKE_SHARE__ |
مواقع النشر (المفضلة) |
| |