Skip to Content Skip to Menu

[SOLVED] CD Subs Problems????

10 years 1 month ago #253038 by zingerdigital
Replied by zingerdigital on topic CD Subs Problems????
We just changed servers for our site, for performance reasons.

And by doing that...surprisingly it started working! The transactions were going through, and the proper messages are displaying.


Now, the State pulldown issue/bug for the invoice address is still there. And doesn't look good for our clients to see that error at the top. Any idea when the fix will be available for this?

In the meantime, its not preventing the transactions to be processed, so how can I bypass it so the message doesn't show?

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48674
  • Thanks: 8313
  • Karma: 1446
10 years 1 month ago #253039 by krileon
Replied by krileon on topic CD Subs Problems????
By state pulldown error I assume you're meaning the following?

Code:
1267 - An error has occurred. Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=SELECT a.`id` AS `value`, a.`name` AS `text` FROM `igb_cbsubs_geo_zones` AS a LEFT JOIN `igb_cbsubs_geo_zones_entries` AS b ON b.`geo_zone_id` = a.`id` LEFT JOIN `igb_comprofiler_countries` AS c ON c.`country_iso_code2` = b.`country_iso_code2` GROUP BY value ORDER BY a.`ordering`

That's fixed by editing your database and making sure all your tables have the same collaction. Generally they should all be "utf8_general_ci".

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.

10 years 1 month ago #253041 by zingerdigital
Replied by zingerdigital on topic CD Subs Problems????
I'll try that,

Which tables need to be checked?

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48674
  • Thanks: 8313
  • Karma: 1446
10 years 1 month ago #253043 by krileon
Replied by krileon on topic CD Subs Problems????
All of them. They should all have the same collation otherwise anytime you join 2 tables with different collations you get that error.

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.

10 years 1 month ago #253046 by zingerdigital
Replied by zingerdigital on topic CD Subs Problems????
all of them, you mean... all the cbsubs tables?

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

  • beat
  • beat
  • ONLINE
  • Posts: 2174
  • Thanks: 463
  • Karma: 352
10 years 1 month ago #253050 by beat
Replied by beat on topic CD Subs Problems????

zingerdigital wrote: all of them, you mean... all the cbsubs tables?


I think to have read that Kyle wrote "all".

That means check all tables of your Joomla installation to have same collations. That will help your site function and performance.

A tool like phpMyAdmin or "Akeeba Admin Tools" (not sure if Free or Pro, but I think i saw that in that function in that tool, google search is a helpful friend, can maybe help you to do that. And your hoster too for sure.
Beat - Community Builder Team Member

Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks :)
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info

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

Moderators: beat, nant, krileon
Powered by Kunena Forum