Improper Collation Virtuemart Conflict


  • Default avatar
    simon82    
     a month ago
    0

    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.
  • Your avatar
    seyi    
     a month ago
    0

    Hello,

    Unfortunately it is impossible to determine what the issue is without debugging it directly.  I can do this if you can send a private message with temp admin and ftp access.
  • Default avatar
    simon82    
     a month ago
    0

    That's not really doable. The program is currently uninstalled. The error messages pretty much says that you're awoaffiliate seems to have a set utf8 that is opposite ours.
  • Your avatar
    seyi    
     a month ago
    0

    Hello,

    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:
    www/administrator/components/com_awoaffiliate/helpers/estore/virtuemart/commissionhandler.php
    function commissions_retrieve

    There is a utf8 conflict within the tables in the sql query.  So you can compare tables/columns to determine where the issue is.
  • Default avatar
    simon82    
     a month ago  last edited a month ago
    0

    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?
    Okay,

    We resolved the issue.

  • Your avatar
    seyi    
     a month ago
    0

    Ok great.  Just to stress, AwoAffiliate does not set the character set, it allows the system to choose the default.
  • Default avatar
    simon82    
     a month ago
    0

    Yes, We understand. It was just an odd quirk of our database system. Thank you for your help resolving the issue.