Skip to Content Skip to Menu

🎃 Happy Halloween! Treat yourself with an awesome discount on memberships! Get 20% off now with code SPOOKY-2024!

Greek language wall post

  • sfitsoula
  • sfitsoula
  • OFFLINE
  • Posts: 1
  • Thanks: 0
  • Karma: 0
8 years 9 months ago #276142 by sfitsoula
Greek language wall post was created by sfitsoula
Hi
Someone can tell me How can i resolve this problem :(
"1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' SQL=SELECT COUNT(*) FROM jos_comprofiler_plug_profilebook WHERE postername = 'someone' AND posteremail = 'user@gmail.com' AND postertitle = '' AND postercomment = 'Δεν' AND posterid = 42 AND userid = 42"
trying to post in Greek language at the wall. I have install cb on xampp

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

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
8 years 9 months ago - 8 years 9 months ago #276143 by nant
Replied by nant on topic Greek language wall post

sfitsoula wrote: Hi
Someone can tell me How can i resolve this problem :(
"1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' SQL=SELECT COUNT(*) FROM jos_comprofiler_plug_profilebook WHERE postername = 'someone' AND posteremail = 'user@gmail.com' AND postertitle = '' AND postercomment = 'Δεν' AND posterid = 42 AND userid = 42"
trying to post in Greek language at the wall. I have install cb on xampp


(Γεια σου!)
Your database collations are mixed - everything should be utf8_general_ci.

Check your database tables and also all your text columns and change where needed using phpmyadmin.
Last edit: 8 years 9 months ago by nant.
The following user(s) said Thank You: sfitsoula

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

Moderators: beatnantkrileon
Powered by Kunena Forum