SQL errorDB function failed with error number 1267
Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' SQL=INSERT INTO jos_core_acl_aro (section_value,value,order_value,name,hidden) SELECT 'users' AS section_value, u.id AS value, 0 AS order_value, u.name as name, 0 AS hidden FROM jos_users u LEFT JOIN jos_core_acl_aro a ON a.section_value = 'users' AND a.value = CAST( u.id AS CHAR ) WHERE a.value IS NULL
SQL =

INSERT INTO jos_core_acl_aro (section_value,value,order_value,name,hidden) SELECT 'users' AS section_value, u.id AS value, 0 AS order_value, u.name as name, 0 AS hidden FROM jos_users u LEFT JOIN jos_core_acl_aro a ON a.section_value = 'users' AND a.value = CAST( u.id AS CHAR ) WHERE a.value IS NULL


Joomla! is Free Software released under the GNU/GPL License.

Hi guys I upgragraded my CB v1.1 to CB v1.2 using the expert method. All went well except when I tried to synchronize the the User Database, I've got the above error.

Does anyone encounter the same problem too? Please share the solution.

Thanks.

Post edited by: alvinzar, at: 2009/02/15 08:57