Config Panel Problem CB1.1

11 years 2 months ago #43752 by Wiktor
Hi,

i already searched on the whole forum the answser to this question, but didn't found anything

When I click on "go to the config panel" stuff, I get this message :

SQL errorDB function failed with error number 1267
Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' SQL=SELECT count(*) as total FROM (jos_users as j INNER JOIN jos_comprofiler as cb ON j.id = cb.id) INNER JOIN phpbb_users as p ON cb.cb_phpbbid = p.user_id WHERE cb.approved='1' AND p.user_active='1' AND j.block='0' AND (j.username = p.username) AND (j.password = p.user_password) ORDER by j.id
SQL =

SELECT count(*) as total
FROM (jos_users as j INNER JOIN jos_comprofiler as cb ON j.id = cb.id)
INNER JOIN phpbb_users as p ON cb.cb_phpbbid = p.user_id
WHERE cb.approved='1' AND p.user_active='1' AND j.block='0' AND (j.username = p.username) AND (j.password = p.user_password)
ORDER by j.id


Could you please tell me what to do... I'm a newb then please tell me also how to do it..thanks
11 years 2 months ago #43871 by geeffland
What this error message is saying is that your databases for phpbb and Joomla have different collations (character encodings)

One table is using
latin1_general_ci
and the other is using
latin1_swedish_ci

So basically the MySQL database doesn't know how to compare those different values. You will need to make each of those tables

phpbb_users and jos_users have the same collation using phpMyAdmin or a similar tool...

For the exact steps needed to fix the error I would need to research... try checking google or phpMyAdmin for MySQL collations.

When you find the answer post a quick note indicating you have found the answer otherwise when I get a chance I will see what URLs might be helpful.

Greg

CB3PD Developer - CB Connector (formerly phpBB Connector) plugin
Moderators: beatnantgeefflandmartijn189krileon
Time to create page: 0.353 seconds
Facebook Twitter Google LinkedIn