www.mashupmb.com , the only error i can think of is i installed zoints local and it asked for VB's mysql info
i check the mysql in the cpanel and its 'OK' apart from one error
The storage engine for the table doesn't support r...
any ideas much appriciated?
many thanks,
joe. :)
In order to get the full error, you need to view the source code on the error page. Doing that shows me this error:
<!--
Database error in vBulletin 3.6.9:
Invalid SQL:
SELECT * FROM mashupmb_user FORCE INDEX (lastactivity)
WHERE lastactivity > 1209168000 ORDER BY username;
MySQL Error : Key 'lastactivity' doesn't exist in table 'mashupmb_user'
Error Number : 1176
Date : Saturday, April 26th 2008 @ 05:08:09 PM
Script : http://www.mashupmb.com/
Referrer : http://www.vbulletin.org/forum/showthread.php?t=177244
IP Address :
Username : Unregistered
Classname : vB_Database
-->
If you look at your user table, do you see lastactivity as an index?
Unfortunately i'm a tad confused, any ideas how to fix it?
Many thanks,
Joe. :)
ps. Im only pretty new to VB lol
EDIT// My host says that error isn't there. :S confused lol
Well, the first thing I would do is use a database tool like phpMyAdmin and look at the table and see if lastactivity is listed under the Indexes table like this:
http://www.vbulletin.org/forum/attachment.php?attachmentid=79297&d=1209248782
Ah, I cant find the lastactivity index. Am i to reload it, but how?
Many thanks,
Joe. :)
'lastactivity' is not a default vBulletin index. It is probably added and used by a modification. Contact the author of the modification.