PDA

View Full Version : MySQL errors


jmellors
26 Apr 2008, 21:58
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. :)

Lynne
26 Apr 2008, 22:11
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 &gt; 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?

jmellors
26 Apr 2008, 22:36
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

Lynne
26 Apr 2008, 23:26
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

jmellors
27 Apr 2008, 10:54
Ah, I cant find the lastactivity index. Am i to reload it, but how?

Many thanks,
Joe. :)

Marco van Herwaarden
28 Apr 2008, 12:55
'lastactivity' is not a default vBulletin index. It is probably added and used by a modification. Contact the author of the modification.