makol
20-05-2010, 09:15
W menu "Subskrybenci" mam taki komunikat:
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=SELECT M.* FROM `jos_users` AS M LEFT JOIN `jos_acajoom_subscribers` AS N ON M.email = N.email WHERE M.registerDate > '2010-05-18 06:35:07' AND N.id IS NULL AND M.block=0JDatabaseMySQL Object ( [name] => mysql [_nullDate] => 0000-00-00 00:00:00 [_nameQuote] => ` [_sql] => SELECT M.* FROM `jos_users` AS M LEFT JOIN `jos_acajoom_subscribers` AS N ON M.email = N.email WHERE M.registerDate > '2010-05-18 06:35:07' AND N.id IS NULL AND M.block=0 [_errorNum] => 1267 [_errorMsg] => Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=SELECT M.* FROM `jos_users` AS M LEFT JOIN `jos_acajoom_subscribers` AS N ON M.email = N.email WHERE M.registerDate > '2010-05-18 06:35:07' AND N.id IS NULL AND M.block=0 [_table_prefix] => jos_ [_resource] => Resource id #25 [_cursor] => [_debug] => 0 [_limit] => 0 [_offset] => 0 [_ticker] => 0 [_log] => Array ( ) [_utf] => 1 [_quoted] => Array ( ) [_hasQuoted] => [_errors] => Array ( ) ) Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '<>' SQL=SELECT N.id, N.name , N.email , N.block FROM `jos_users` AS N LEFT JOIN `jos_acajoom_subscribers` AS M ON N.id = M.user_id WHERE N.registerDate > '2010-05-18 06:35:07' AND M.subscribe_date > '2010-05-18 06:35:07' AND M.name != N.name OR M.email != N.email OR N.block = M.confirmedJDatabaseMySQL Object ( [name] => mysql [_nullDate] => 0000-00-00 00:00:00 [_nameQuote] => ` [_sql] => SELECT N.id, N.name , N.email , N.block FROM `jos_users` AS N LEFT JOIN `jos_acajoom_subscribers` AS M ON N.id = M.user_id WHERE N.registerDate > '2010-05-18 06:35:07' AND M.subscribe_date > '2010-05-18 06:35:07' AND M.name != N.name OR M.email != N.email OR N.block = M.confirmed [_errorNum] => 1267 [_errorMsg] => Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '<>' SQL=SELECT N.id, N.name , N.email , N.block FROM `jos_users` AS N LEFT JOIN `jos_acajoom_subscribers` AS M ON N.id = M.user_id WHERE N.registerDate > '2010-05-18 06:35:07' AND M.subscribe_date > '2010-05-18 06:35:07' AND M.name != N.name OR M.email != N.email OR N.block = M.confirmed [_table_prefix] => jos_ [_resource] => Resource id #25 [_cursor] => [_debug] => 0 [_limit] => 0 [_offset] => 0 [_ticker] => 0 [_log] => Array ( ) [_utf] => 1 [_quoted] => Array ( ) [_hasQuoted] => [_errors] => Array ( ) ) Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=SELECT N.id , N.email FROM `jos_users` AS N LEFT JOIN `jos_acajoom_subscribers` AS M ON N.email = M.email WHERE N.registerDate > '2010-05-18 06:35:07' AND M.subscribe_date > '2010-05-18 06:35:07' AND M.user_id = 0 AND N.block = 0JDatabaseMySQL Object ( [name] => mysql [_nullDate] => 0000-00-00 00:00:00 [_nameQuote] => ` [_sql] => SELECT N.id , N.email FROM `jos_users` AS N LEFT JOIN `jos_acajoom_subscribers` AS M ON N.email = M.email WHERE N.registerDate > '2010-05-18 06:35:07' AND M.subscribe_date > '2010-05-18 06:35:07' AND M.user_id = 0 AND N.block = 0 [_errorNum] => 1267 [_errorMsg] => Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=SELECT N.id , N.email FROM `jos_users` AS N LEFT JOIN `jos_acajoom_subscribers` AS M ON N.email = M.email WHERE N.registerDate > '2010-05-18 06:35:07' AND M.subscribe_date > '2010-05-18 06:35:07' AND M.user_id = 0 AND N.block = 0 [_table_prefix] => jos_ [_resource] => Resource id #25 [_cursor] => [_debug] => 0 [_limit] => 0 [_offset] => 0 [_ticker] => 0 [_log] => Array ( ) [_utf] => 1 [_quoted] => Array ( ) [_hasQuoted] => [_errors] => Array ( ) )
i nie wiem, co z tym zrobić.
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=SELECT M.* FROM `jos_users` AS M LEFT JOIN `jos_acajoom_subscribers` AS N ON M.email = N.email WHERE M.registerDate > '2010-05-18 06:35:07' AND N.id IS NULL AND M.block=0JDatabaseMySQL Object ( [name] => mysql [_nullDate] => 0000-00-00 00:00:00 [_nameQuote] => ` [_sql] => SELECT M.* FROM `jos_users` AS M LEFT JOIN `jos_acajoom_subscribers` AS N ON M.email = N.email WHERE M.registerDate > '2010-05-18 06:35:07' AND N.id IS NULL AND M.block=0 [_errorNum] => 1267 [_errorMsg] => Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=SELECT M.* FROM `jos_users` AS M LEFT JOIN `jos_acajoom_subscribers` AS N ON M.email = N.email WHERE M.registerDate > '2010-05-18 06:35:07' AND N.id IS NULL AND M.block=0 [_table_prefix] => jos_ [_resource] => Resource id #25 [_cursor] => [_debug] => 0 [_limit] => 0 [_offset] => 0 [_ticker] => 0 [_log] => Array ( ) [_utf] => 1 [_quoted] => Array ( ) [_hasQuoted] => [_errors] => Array ( ) ) Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '<>' SQL=SELECT N.id, N.name , N.email , N.block FROM `jos_users` AS N LEFT JOIN `jos_acajoom_subscribers` AS M ON N.id = M.user_id WHERE N.registerDate > '2010-05-18 06:35:07' AND M.subscribe_date > '2010-05-18 06:35:07' AND M.name != N.name OR M.email != N.email OR N.block = M.confirmedJDatabaseMySQL Object ( [name] => mysql [_nullDate] => 0000-00-00 00:00:00 [_nameQuote] => ` [_sql] => SELECT N.id, N.name , N.email , N.block FROM `jos_users` AS N LEFT JOIN `jos_acajoom_subscribers` AS M ON N.id = M.user_id WHERE N.registerDate > '2010-05-18 06:35:07' AND M.subscribe_date > '2010-05-18 06:35:07' AND M.name != N.name OR M.email != N.email OR N.block = M.confirmed [_errorNum] => 1267 [_errorMsg] => Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '<>' SQL=SELECT N.id, N.name , N.email , N.block FROM `jos_users` AS N LEFT JOIN `jos_acajoom_subscribers` AS M ON N.id = M.user_id WHERE N.registerDate > '2010-05-18 06:35:07' AND M.subscribe_date > '2010-05-18 06:35:07' AND M.name != N.name OR M.email != N.email OR N.block = M.confirmed [_table_prefix] => jos_ [_resource] => Resource id #25 [_cursor] => [_debug] => 0 [_limit] => 0 [_offset] => 0 [_ticker] => 0 [_log] => Array ( ) [_utf] => 1 [_quoted] => Array ( ) [_hasQuoted] => [_errors] => Array ( ) ) Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=SELECT N.id , N.email FROM `jos_users` AS N LEFT JOIN `jos_acajoom_subscribers` AS M ON N.email = M.email WHERE N.registerDate > '2010-05-18 06:35:07' AND M.subscribe_date > '2010-05-18 06:35:07' AND M.user_id = 0 AND N.block = 0JDatabaseMySQL Object ( [name] => mysql [_nullDate] => 0000-00-00 00:00:00 [_nameQuote] => ` [_sql] => SELECT N.id , N.email FROM `jos_users` AS N LEFT JOIN `jos_acajoom_subscribers` AS M ON N.email = M.email WHERE N.registerDate > '2010-05-18 06:35:07' AND M.subscribe_date > '2010-05-18 06:35:07' AND M.user_id = 0 AND N.block = 0 [_errorNum] => 1267 [_errorMsg] => Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=SELECT N.id , N.email FROM `jos_users` AS N LEFT JOIN `jos_acajoom_subscribers` AS M ON N.email = M.email WHERE N.registerDate > '2010-05-18 06:35:07' AND M.subscribe_date > '2010-05-18 06:35:07' AND M.user_id = 0 AND N.block = 0 [_table_prefix] => jos_ [_resource] => Resource id #25 [_cursor] => [_debug] => 0 [_limit] => 0 [_offset] => 0 [_ticker] => 0 [_log] => Array ( ) [_utf] => 1 [_quoted] => Array ( ) [_hasQuoted] => [_errors] => Array ( ) )
i nie wiem, co z tym zrobić.