[SOLVED] Error after update to J3.5.0, illegal collation error in FLEXIcontent backend

More
8 years 9 months ago - 8 years 9 months ago #60744 by nexteo
Hello !
I use the 3.0.13 version of Flexicontent
I just updated my website in Joomla from version 3.48 to 3.5 and I can not do anything in the administration because I have the following message:

"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` "

Do you have an idea of the problem ?
Thanks
Last edit: 8 years 9 months ago by ggppdk.

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

More
8 years 9 months ago - 8 years 9 months ago #60745 by ggppdk
Ok

but you can look / search at the forum, there is a "sticky" topic already with an answer about this

also the topic has a good descriptive title ;)

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...
Last edit: 8 years 9 months ago by ggppdk.

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

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.377 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