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

More
8 years 1 month ago #60741 by coerter
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

with regards

coweb

Please Log in or Create an account to join the conversation.

More
8 years 1 month ago #60742 by aghi
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`
*******

Please Log in or Create an account to join the conversation.

More
8 years 1 month ago #60743 by aghi

Please Log in or Create an account to join the conversation.

More
8 years 1 month ago #60746 by ggppdk
@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


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
8 years 1 month ago - 8 years 1 month ago #60748 by ggppdk
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)


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...
Last edit: 8 years 1 month ago by ggppdk.
The following user(s) said Thank You: kath, yasarts, weCombine, Natwork

Please Log in or Create an account to join the conversation.

More
8 years 1 month ago - 8 years 1 month ago #60780 by Natwork
Problem solved for me (mysql 5.5.46 - J3.5 - 3.0.14.rc2a) !
Once again, thanks for your quick support ggppdk :cheer:
Last edit: 8 years 1 month ago by Natwork.

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.328 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline