PDA

View Full Version : Database Error.


exel
12-08-2009, 03:40 PM
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

ChopSuey
12-08-2009, 11:16 PM
I think we solved this somewhere else. Hehe.

vbplusme
12-09-2009, 12:21 AM
Check this thread out, it gives instructions on how to fix that problem.

https://vborg.vbsupport.ru/showthread.php?t=186628