The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
MySQL errors
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. |
#2
|
||||
|
||||
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:
<!-- 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 : https://vborg.vbsupport.ru/showthread.php?t=177244 IP Address : Username : Unregistered Classname : vB_Database --> |
#3
|
|||
|
|||
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 |
#4
|
||||
|
||||
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:
|
#5
|
|||
|
|||
Ah, I cant find the lastactivity index. Am i to reload it, but how?
Many thanks, Joe. |
#6
|
|||
|
|||
'lastactivity' is not a default vBulletin index. It is probably added and used by a modification. Contact the author of the modification.
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|