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:



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------


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.