[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