Skip to Content Skip to Menu

[SOLVED] cb promotions

8 years 9 months ago - 8 years 9 months ago #280104 by globalgridfree
[SOLVED] cb promotions was created by globalgridfree
joomla 3.4.8 cb all updated,

I am getting this error in promotions/promotion stats

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=SELECT COUNT(*) AS `paid_quantity`, SUM( ( a.`order_amount` * ( b.`rate` / c.`rate` ) ) ) AS `paid_mc_gross_total` FROM `pvwmc_cbsubs_promotions_uses` AS a LEFT JOIN `pvwmc_cbsubs_currencies` AS b ON b.`currency` = 'USD' LEFT JOIN `pvwmc_cbsubs_currencies` AS c ON c.`currency` = a.`currency` WHERE ( a.`state` = 'A' )
Last edit: 8 years 9 months ago by krileon.

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

  • beat
  • beat
  • ONLINE
  • Posts: 2174
  • Thanks: 463
  • Karma: 352
8 years 9 months ago - 8 years 9 months ago #280108 by beat
Replied by beat on topic cb promotions
utf8_unicode_ci sounds more like Joomla 3.5...Maybe you have tables coming from Joomla 3.5 ?

I think Akeeba Admin Tools latest version has a tool (on joomla 3.5, not sure if also on 3.4.8) to fix such collation mismatches.
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
Last edit: 8 years 9 months ago by beat.

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

8 years 9 months ago #280113 by globalgridfree
Replied by globalgridfree on topic cb promotions
yes i also have akeeba, would you suggest updating joomla to 3.5? i did update everything else

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 #280120 by nant
Replied by nant on topic cb promotions

globalgridfree wrote: yes i also have akeeba, would you suggest updating joomla to 3.5? i did update everything else


All your tables should really be using the same collation otherwise the joining of 2 tables with different collations would give you the error you are seeing.
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting

Visit my CB Profile - Send me a Private Message (PM)

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

8 years 9 months ago #280268 by globalgridfree
Replied by globalgridfree on topic cb promotions
could this be why there is no link in the email validation email? I am currently having an issue with email validation link not in the email sent to user to validate!

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

8 years 9 months ago #280272 by globalgridfree
Replied by globalgridfree on topic cb promotions
all tables are now fixed, email verification link is fixed, all cb is up to date, joomla 3.4.8

I still have an issue with promotions, when a new member signs up and enters the promo code and click redeem, they get sent back to fist page of tabbed registration page, the registration page is empty, the user is added in back end but no package was selected?

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

Moderators: beat, nant, krileon
Powered by Kunena Forum