We updated our shopping cart to version 7.
The cart.php page is failing with the error:
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
Fatal error: Uncaught Error: Call to a member function free_result() on boolean in C:\Inetpub\vhosts\vrmca.com\httpdocs\vsadmin\inc\incfunctions.php:1810 Stack trace: #0 C:\Inetpub\vhosts\vrmca.com\httpdocs\vsadmin\inc\inccart.php(6372): ect_free_result(false) #1 C:\Inetpub\vhosts\vrmca.com\httpdocs\cart.php(42): require_once('C:\\Inetpub\\vhos...') #2 {main} thrown in C:\Inetpub\vhosts\vrmca.com\httpdocs\vsadmin\inc\incfunctions.php on line 1810

This did not happen with our development/test site, but it is happening with vrmca.com.
If you go to https://www.vrmca.com/products.php and put something into your shopping cart, you will see the error.

We did try to reload the vsadmin directory in case that was bad, but that did not make a difference.
What should we try?

BTW - Nothing to do with this - I tried putting the extcart.js include at the bottom of the page. It did not work. I included it in the header and it worked fine. Thought that was odd enough to mention.

Hi Kevin

In the control panel go to Store Admin > Database Utility > Set Database Collation and select utf8_general_ci from the drop down. I believe that should fix it.

Andy

Please feel free to review / rate our software

That is an elegant solution.
Thank you!