Log in

View Full Version : Help Me ASAP. Error Database Make New Thread


kawe
02-06-2009, 02:33 PM
Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT prefix.*, prefixpermission.usergroupid AS restriction
FROM forumprefixset AS forumprefixset
INNER JOIN prefixset AS prefixset ON (prefixset.prefixsetid = forumprefixset.prefixsetid)
INNER JOIN prefix AS prefix ON (prefix.prefixsetid = prefixset.prefixsetid)
LEFT JOIN prefixpermission AS prefixpermission ON (prefix.prefixid = prefixpermission.prefixid)
WHERE forumprefixset.forumid = 7
ORDER BY prefixset.displayorder, prefix.displayorder;

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Friday, February 6th 2009 @ 11:31:23 PM
Error Date : Friday, February 6th 2009 @ 11:31:23 PM
Script : ______________________
Referrer : ______________________________
IP Address : 0000000000
Username : Admin
Classname : vB_Database
MySQL Version : 5.0.67-community

show this error if im make new thread
how to fix it please help me :( :( :( :(

Lynne
02-06-2009, 02:41 PM
Try disabling your plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

Marco van Herwaarden
02-06-2009, 02:43 PM
If the above does not solve your problem, please open a support ticket.