hi at all, i have an error on the plugin's panel:
[code:1]Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT).....[/code:1]
but i don't have any latin1_swedish_ci tables in my database, they are all in UTF8_unicode_ci
my root folder of phpbb is in:
mysite.com/CMS/frm/
where CMS is the root of joomla, and declared as
CMS/frm/ in the plugin 1rst panel.
when i would go to advanced feature i have this error.
for informations the complete one is:
[code:1]SQL errorDB function failed with error number 1267
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_unicode_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[/code:1]
then i could not impotrt/export anything, and could not syncrhonise then.
All ideas are welcome
(i don't know very weel joomla, but i know phpbb if it could help
)