How to resolve the Zen Cart Illegal mix of collations error

We had deployed a Zen Cart website and we came up with the following error in the Zen Cart admin panel when clicking on the Tools -> Send Email link. Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation ‘locate’ After checking the table collation in PHPmyAdmin I found that the subscribers table (created when … Read more

How to offer discounts and coupons to customers using Facebook Like

I have come across some businesses offering discounts, offers, video downloads, documents etc. to users on Facebook and in return they ask them to simply Like their page. This is quite a good idea as it helps them to attract leads/sales from Facebook and it serves as an additional revenue generation model apart from search … Read more

List of test credit card numbers for Sage Pay

If you are using Sage Pay Form and wish to test whether the integration is working correctly or not you can use the following test credit card numbers for placing orders. Visa (VISA) 4929000000006 MasterCard (MC) 5404000000000001 Visa Debit / Delta (DELTA) 4462000000000003 Solo (SOLO) 6334900000000005 Issue 1 UK Maestro / International Maestro (MAESTRO) 5641820000000005 … Read more