Skip to Content Skip to Menu

Russian letters in group or folder names marks as question signs

  • evgentret
  • evgentret
  • OFFLINE
  • Posts: 7
  • Thanks: 1
  • Karma: 0
9 years 6 months ago #263363 by evgentret
When I try to add new group in groupJive or new folder in cb gallery or any new item in add-ons I see a question signs instead of letters. If I try to add new record in profileBlog or profileWall it shows an error "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' SQL=SELECT COUNT(*) FROM poster_comprofiler_plug_profilebook WHERE postername = 'poster' AND posteremail = 'poster@mail.ru' AND postertitle = 'аыпаыпаы' AND postercomment = 'ыапаы' AND posterid = 459 AND userid = 459"

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

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
9 years 6 months ago #263365 by nant

evgentret wrote: When I try to add new group in groupJive or new folder in cb gallery or any new item in add-ons I see a question signs instead of letters. If I try to add new record in profileBlog or profileWall it shows an error "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' SQL=SELECT COUNT(*) FROM poster_comprofiler_plug_profilebook WHERE postername = 'poster' AND posteremail = 'poster@mail.ru' AND postertitle = 'аыпаыпаы' AND postercomment = 'ыапаы' AND posterid = 459 AND userid = 459"


The message is pretty clear to me.

Some of your database tables appear to have wrong collation (latin1_swedish_ci !).

Please use phpmyadmin to inspect and make changes to all such latin1_swedish_ci collations to the correct for your use case utf_8_general_ci setting.

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

  • evgentret
  • evgentret
  • OFFLINE
  • Posts: 7
  • Thanks: 1
  • Karma: 0
9 years 6 months ago #263367 by evgentret
Well... and a lot of TEXT and VARCHAR in every table that also has a latin1_swedish_ci collation. An hour of work. I'll try to fix it, but one more question: what about updates? Will this collation returns?

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48478
  • Thanks: 8282
  • Karma: 1443
9 years 6 months ago #263387 by krileon
Table and column collation is based entirely off your database configuration. Contact your host and have them change the default collation (you maybe able to do this from phpmyadmin or your host panel). Joomla and CB don't set the collation (unless it's missing entirely).


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

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

Moderators: beatnantkrileon
Powered by Kunena Forum