Hi
I have tried to create a 10% discount coupon. It seemed to work OK but on the cart page I get the following:

Illegal mix of collations (latin1_general_cs,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on boolean in /homepages/5/d87640952/htdocs/vsadmin/inc/incfunctions.php:2168 Stack trace: #0 /homepages/5/d87640952/htdocs/vsadmin/inc/inccart.php(563): ect_fetch_assoc(false) #1 /homepages/5/d87640952/htdocs/vsadmin/inc/inccart.php(6051): calculatediscounts(3.25, false, '') #2 /homepages/5/d87640952/htdocs/cart.php(107): include('/homepages/5/d8...') #3 {main} thrown in /homepages/5/d87640952/htdocs/vsadmin/inc/incfunctions.php on line 2168

The collation of the database and all the tables is latin1_general_cs so I don't understand why the first bit of that error is created, and I have no idea at all about the second bit.

The cart version is 6.7 and everything else, including a free shipping discount seems to work just fine.

Any ideas?

Eric Lewis

Hi Eric

Just to be sure can you go to the admin database utility page and set the collation there.

Andy

Please feel free to review / rate our software

Wow! Thanks Andy

That seems to have fixed it. Excellent support as ever.

Eric