MyBB Community Forums

Full Version: SQL Error when trying to post a thread.
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I keep getting this error message when I try to publish a thread. And idea how to fix it?
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    1267 - Illegal mix of collations (latin1_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
Query:
    SELECT p.pid FROM mybb_posts p WHERE p.uid='1' AND p.fid='13' AND p.subject='Testing' AND p.message='testing\r\n' AND p.posthash='1e074ca7e94dd76277700180f9b3c43a'

Please contact the MyBB Group for support.
Open ./inc/init.php file and find;
if(!isset($config['database']))
{
	$mybb->trigger_generic_error("board_not_installed");
}
and add the following code just after that;
mysql_query("SET CHARACTER SET utf8");
(2011-04-17, 06:17 AM)Yaldaram Wrote: [ -> ]Open ./inc/init.php file and find;
if(!isset($config['database']))
{
	$mybb->trigger_generic_error("board_not_installed");
}
and add the following code just after that;
mysql_query("SET CHARACTER SET utf8");

I am sorry but it doesnt fix it. I still get the same error message. Confused
Changes the tables that are latin1_general_ci to utf8_general_ci.
Tool & Maintenance >> System Health >> UTF-8 Conversion
(2011-04-17, 08:40 AM)Malcolm. Wrote: [ -> ]Changes the tables that are latin1_general_ci to utf8_general_ci.

(2011-04-17, 08:42 AM)pyridine Wrote: [ -> ]Tool & Maintenance >> System Health >> UTF-8 Conversion

That fixed it. Thanks for helping me out.