Ok, so we purchased awoaffiliate. When we installed it began to conflict with our virtuemart one page checkout as seen below when users would attempt to complete a purchase: We have used your products before and have not run in to this issue before. Is there anything that can be done on your end to resolve this collation issue involving utf8 unicode and general utf8. It only appears once we have installed your product, awoaffiliate. We have used your awocoupon and aworewards with no issue in the past.
Improper Collation Virtuemart Conflict
The installation does not choose what utf8 to set, it uses the system default.
On order complete the commissions section is called, the sql code can be found in:
There is a utf8 conflict within the tables in the sql query. So you can compare tables/columns to determine where the issue is.
- Okay, Thanks. I'll let you know what we find
Turns out that when installed the awoaffiliate becomes active with the wrong charset. Is there anyway to make sure that the right charset is used when the tables are installed or will it need to be done in the database after the fact?
We resolved the issue.