[Use v3.0.14+] 1267 Illegal mix of collations

More
8 years 6 months ago - 8 years 6 months ago #61230 by flodariege
Hello,
After updating Joomla from 3.4.8 to 3.5.1, I get this error each time I try to access items or categories on the back-end :
1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '<>' SQL=SELECT COUNT(*) FROM #__content as i JOIN #__flexicontent_items_ext as ie ON i.id=ie.item_id WHERE i.language<>ie.language LIMIT 1

What am I supposed to do to solve this?

Thanks for any help.
Flo

Dare to dream, believe the unbelievable, never take no for an answer
Last edit: 8 years 6 months ago by ggppdk.

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

More
8 years 6 months ago #61231 by ggppdk
Hello

have you searched the forum ?

there are 6 other threads on this, you could have posted in 1 of them

also you do not mention the FLEXIcontent version that you are using, since this is supposed to have been fixed with v3.0.14-rc2a or later


-- 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 6 months ago - 8 years 6 months ago #61233 by flodariege
I'm sorry, I should have look in the forum before posting!
I did... after... ooops!
So now I'm trying to find out which version of flexicontent I use, but... I cannot access to components/flexicontent, so I dont know how to find out which FC version I use...

EDIT: I checked in my notes (I write down everything I do when I change something important), and I found out : I'm still under v3.0.13 :blush:
So I'm gonna upgrade to 3.0.14 right now. Sorry..

Dare to dream, believe the unbelievable, never take no for an answer
Last edit: 8 years 6 months ago by flodariege.

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

More
8 years 6 months ago #61234 by ggppdk
Hello

you do well to report bugs

only please search forum first
and also mention Joomla / PHP / Mysql / FLEXIcontent versions


-- 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 6 months ago #61236 by flodariege
Yes, I understand. I was a little in panic when I saw this appear, so I forgot to check first, I was so convinced it was going to be difficult and unique ...
I just updated FC to 3.0.14-rc2a, and everything seems to work perfectly. Thank you :)

Dare to dream, believe the unbelievable, never take no for an answer

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

More
8 years 6 months ago #61237 by ggppdk
Hello

v3.0.14-rc2a:
if you are using sharedmedia field make sure you get API keys
you cannot save old values in item form without them

v3.0.14 fixes this, so that you can save existing values without yet adding an API key

also since you had reported this :
navigation buttons when coming from module now works, please confirm it


-- 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.

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