[SOLVED] Illegal mix of collations with J3.5, Unable to load any FC Administration screen

ok, i will do that and write again.

PM sent

Hello,

i have the same problem :

DB-Version: 5.1.73
Datenbankzeichensatz: utf8_general_ci
PHP-Version: 5.6.19
Joomla!-Version: Joomla! 3.5.0 Stable
Flexicontent: 3.0.14-rc2

Hello,
This morning I had the same concern after the update joomla, but after the update FLEXIcontent I have a longer error message

*******
Une erreur s'est produite
1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT COUNT(*) AS total1, ( SELECT COUNT(*) FROM `#__flexicontent_items_ext` AS ie JOIN `#__content` AS i ON ie.item_id=i.id WHERE 1 ) AS total2 FROM `#__content` AS i JOIN `#__flexicontent_items_tmp` AS ca ON i.id=ca.id JOIN `#__flexicontent_items_ext` AS ie ON ie.item_id=i.id WHERE 1 AND i.`title`=ca.`title` AND i.`state`=ca.`state` AND i.`catid`=ca.`catid` AND i.`created`=ca.`created` AND i.`created_by`=ca.`created_by` AND i.`modified`=ca.`modified` AND i.`modified_by`=ca.`modified_by` AND i.`publish_up`=ca.`publish_up` AND i.`publish_down`=ca.`publish_down` AND i.`version`=ca.`version` AND i.`ordering`=ca.`ordering` AND i.`access`=ca.`access` AND i.`featured`=ca.`featured` AND i.`language`=ca.`language` AND ie.`type_id`=ca.`type_id` AND ie.`lang_parent_id`=ca.`lang_parent_id`
*******

I found this
stackoverflow.com/questions/3029321/trou...tions-error-in-mysql

but I don't now how to do modification

@aghi

you don't need to fix something, we will fix this,
see here:
www.flexicontent.org/forum/20-general-su...l?limitstart=0#60736

Hello

i have made package:
v3.014-rc2a that should fix this:

www.flexicontent.org/downloads/latest-version.html

also you may click to subscribe to the above to get early updates of new versions (before new version appears in backend version checks)

Problem solved for me (mysql 5.5.46 - J3.5 - 3.0.14.rc2a) !
Once again, thanks for your quick support ggppdk

thanks, for the quick solution! it works now: joomla 3.5 / php 7.0 / mysql 5.5.47-0

yeah, works here, too! Thanks, and glad that old box helped