UK web developer

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 …

How to resolve the Zen Cart Illegal mix of collations error 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 …

How to offer discounts and coupons to customers using Facebook Like 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 …

List of test credit card numbers for Sage Pay Read More »

How to remove the Fatal error: SOAP-ERROR: Parsing Schema: unexpected in sequence error?

If you use the eBay API in any way on your website related to your products or orders then you may have come across an issue which happened last week probably around Jan 26 2012. If you call any eBay API method you will encounter the following error message: Fatal error: SOAP-ERROR: Parsing Schema: unexpected …

How to remove the Fatal error: SOAP-ERROR: Parsing Schema: unexpected in sequence error? Read More »