Open menu

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

weCombine
Offline
Premium Member

8 years 8 months ago #60787 by weCombine

Replied by weCombine on topic Illegal mix of collations with J3.5, Unable to load any FC Administration screen

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

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

kath
Offline
Platinum Member

8 years 8 months ago #60788 by kath

Replied by kath on topic Illegal mix of collations with J3.5, Unable to load any FC Administration screen

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

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

coerter
Offline
Premium Member

8 years 8 months ago #60791 by coerter

Replied by coerter on topic Illegal mix of collations with J3.5, Unable to load any FC Administration screen

hello,

works fine. Thank you so much. Great support. Thank you

PHP 5.6.1.9
MySQL 5.1.79
Joomla 3.5

with regards

coweb

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

aghi
Offline
New Member

8 years 8 months ago #60795 by aghi

Replied by aghi on topic Illegal mix of collations with J3.5, Unable to load any FC Administration screen

Hello,

with v3.014-rc2a , I have no problem now

Thank you

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

yopyop001
Topic Author
Offline
Moderator

8 years 8 months ago #60828 by yopyop001

Replied by yopyop001 on topic [SOLVED] Illegal mix of collations with J3.5, Unable to load any FC Administration screen

Hi,

It works nice with :
Joomla 3.5.0
Mysql 5.1.31
PHP 7.0.2

Thanks a lot

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

thatch10
Offline
Senior Member

8 years 3 months ago #63855 by thatch10

Replied by thatch10 on topic [SOLVED] Illegal mix of collations with J3.5, Unable to load any FC Administration screen

George,

I am getting this message on a site I manage,

Mysql 5.1.73
PHP 5.6.24
Joomla 3.6.2
Flexicontent 3.1.0-rc2

Only admin flexi menu option which doesn't give this issue is Configuration.

Reinstalled Joomla and flexi same error

Code:

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.`alias`=ca.`alias` 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`

Thatch

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