rallygt
User
Fresh Boarder
| Posts: 1 |   |
Karma: 0
|
Strange error when installed - 2007/12/14 02:21
I have sucsessfully installed, and the language in the component is Norwegian, as in my Joomla installation.
I testet the registration, but i got several "confirmation-request". And if i choosed only registrered users, the login window dissapeared...
Here is the error showing in Joomla admin:
Illegal mix of collations (latin1_danish_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' SQL=SELECT M.* FROM `jos_users` AS M LEFT JOIN `jos_acajoom_subscribers` AS N ON M.id = N.user_id OR M.email = N.email WHERE M.registerDate > '2007-12-11 17:22:04' AND N.id IS NULL AND M.block=0database Object ( [_sql] => SELECT M.* FROM `jos_users` AS M LEFT JOIN `jos_acajoom_subscribers` AS N ON M.id = N.user_id OR M.email = N.email WHERE M.registerDate > '2007-12-11 17:22:04' AND N.id IS NULL AND M.block=0 [_errorNum] => 1267 [_errorMsg] => Illegal mix of collations (latin1_danish_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' SQL=SELECT M.* FROM `jos_users` AS M LEFT JOIN `jos_acajoom_subscribers` AS N ON M.id = N.user_id OR M.email = N.email WHERE M.registerDate > '2007-12-11 17:22:04' AND N.id IS NULL AND M.block=0 [_table_prefix] => jos_ [_resource] => Resource id #15 [_cursor] => [_debug] => 0 [_limit] => 0 [_offset] => 0 [_ticker] => 0 [_log] => Array ( ) [_nullDate] => 0000-00-00 00:00:00 [_nameQuote] => ` ) Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_danish_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 > '2007-12-11 17:22:04' AND M.subscribe_date > '2007-12-11 17:22:04' AND M.name != N.name OR M.email != N.email OR N.block = M.confirmeddatabase Object ( [_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 > '2007-12-11 17:22:04' AND M.subscribe_date > '2007-12-11 17:22:04' AND M.name != N.name OR M.email != N.email OR N.block = M.confirmed [_errorNum] => 1267 [_errorMsg] => Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_danish_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 > '2007-12-11 17:22:04' AND M.subscribe_date > '2007-12-11 17:22:04' AND M.name != N.name OR M.email != N.email OR N.block = M.confirmed [_table_prefix] => jos_ [_resource] => Resource id #15 [_cursor] => [_debug] => 0 [_limit] => 0 [_offset] => 0 [_ticker] => 0 [_log] => Array ( ) [_nullDate] => 0000-00-00 00:00:00 [_nameQuote] => ` ) Illegal mix of collations (latin1_danish_ci,IMPLICIT) and (latin1_swedish_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 > '2007-12-11 17:22:04' AND M.subscribe_date > '2007-12-11 17:22:04' AND M.user_id = 0 AND N.block = 0database Object ( [_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 > '2007-12-11 17:22:04' AND M.subscribe_date > '2007-12-11 17:22:04' AND M.user_id = 0 AND N.block = 0 [_errorNum] => 1267 [_errorMsg] => Illegal mix of collations (latin1_danish_ci,IMPLICIT) and (latin1_swedish_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 > '2007-12-11 17:22:04' AND M.subscribe_date > '2007-12-11 17:22:04' AND M.user_id = 0 AND N.block = 0 [_table_prefix] => jos_ [_resource] => Resource id #15 [_cursor] => [_debug] => 0 [_limit] => 0 [_offset] => 0 [_ticker] => 0 [_log] => Array ( ) [_nullDate] => 0000-00-00 00:00:00 [_nameQuote] => ` )
|
|
|
| | To post on the forum you need to sign in. |
Acajoom
