Database Error.
Hey, I've recently got this error, any idea how to fix it?
Database error in vBulletin 3.8.4:
Invalid SQL:
DELETE FROM xboxisoh_faq WHERE product = 'hidelinksfromguest' AND volatile = 1;
MySQL Error : Unknown column 'product' in 'where clause'
Error Number : 1054
Request Date : Tuesday, December 8th 2009 @ 07:20:19 PM
Error Date : Tuesday, December 8th 2009 @ 07:20:19 PM
Script : xxxxxxx
Referrer : xxxxxxx
IP Address : xxxxxxx
Username : xxxxxxx
Classname : vB_Database
MySQL Version : 5.0.85-community
and
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT prefix.*, prefixpermission.usergroupid AS restriction
FROM xboxisoh_prefix AS prefix
LEFT JOIN xboxisoh_prefixpermission AS prefixpermission ON (prefix.prefixid = prefixpermission.prefixid)
ORDER BY prefix.displayorder;
MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Tuesday, December 8th 2009 @ 08:01:56 PM
Error Date : Tuesday, December 8th 2009 @ 08:01:56 PM
Script : xxxxxx
Referrer : xxxxxx
IP Address : xxxxxx
Username : xxxxxx
Classname : vB_Database
MySQL Version : 5.0.85-community
|