[SOLVED] CD Subs Problems????
- zingerdigital
- OFFLINE
-
Elite Member
- Posts: 195
- Thanks: 1
- Karma: 0
9 years 5 months 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?
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 to join the conversation.
krileon
Team Member- OFFLINE
- Posts: 68602
- Thanks: 9108
- Karma: 1434
9 years 5 months ago #253039
by krileon
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.
Replied by krileon on topic CD Subs Problems????
By state pulldown error I assume you're meaning the following?
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".
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 to join the conversation.
- zingerdigital
- OFFLINE
-
Elite Member
- Posts: 195
- Thanks: 1
- Karma: 0
9 years 5 months ago #253041
by zingerdigital
Replied by zingerdigital on topic CD Subs Problems????
I'll try that,
Which tables need to be checked?
Which tables need to be checked?
Please Log in to join the conversation.
- krileon
- Team Member
- OFFLINE
- Posts: 68602
- Thanks: 9108
- Karma: 1434
9 years 5 months ago #253043
by krileon
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.
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 to join the conversation.
- zingerdigital
- OFFLINE
-
Elite Member
- Posts: 195
- Thanks: 1
- Karma: 0
9 years 5 months ago #253046
by zingerdigital
Replied by zingerdigital on topic CD Subs Problems????
all of them, you mean... all the cbsubs tables?
Please Log in to join the conversation.
- beat
Team Member- ONLINE
- Posts: 8175
- Thanks: 528
- Karma: 352
9 years 5 months ago #253050
by beat
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
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 to join the conversation.
Moderators: beat, nant, krileon
Time to create page: 0.213 seconds
-
You are here:
- Home
- Forums
- Support and Presales
- Developer Members Support
- [SOLVED] CD Subs Problems????