Status
Not open for further replies.

xwarlordx

Active Member
152
2008
0
0
hello

few days back i have restored my site to older version of vbulletin that is 3.7.3 and the restore is sucess . After 2 days im getting an error
Code:
Invalid SQL:

SELECT thread.lastposter, thread.lastpost, thread.views, thread.open, thread.forumid, thread.replycount, thread.threadid, thread.pollid, thread.title, user.username, user.userid, user.usergroupid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid FROM thread as thread
LEFT JOIN user AS user ON (user.username = thread.lastposter) ORDER BY lastpost DESC LIMIT 0, 5;

MySQL Error   : Table 'xtremesh_te56d2.user' doesn't exist


where did the user table go ?..

i tried for past weeks to over come this error ..i tried on vb 3.8.4 i got the same error after 1 day or after couple of hours

Please help me :(
 
1 comment
Go into your forum.com/admincp and choose Maintenance > Repair/Optimize Tables

Then click Continue at the bottom of the page.

When you get to the next page you may see things such as 'Corrupt Data' or other errors. Choose to do the repair again on that page and normally the process goes well the second time, if not the first.

All fixed!


Also, Have you tried disabling the products from the config.php file?

Just below "<?php"
Enter:define('DISABLE_HOOKS', true);

<3
:D
 
Status
Not open for further replies.
Back
Top