Technote Details :: My MX Kart or MX Shop site errors on checkout

After selecting the items I want to purchase from the online shop, when I try to checkout the billing and shipping details are not saved in the database. I am using PHP and MySQL 5 for the database.

 This happens because one field in the MX Kart and MX Shop tables  - details_ord - is set to have the NOT NULL property. When the cart contents are saved to the database on checkout, this field is left empty. This causes MySQL 5 not to create the record at all. This results in the billing and shipping details not being saved into the database.

 To fix this problem you have to edit the order_ord database table and set the details_ord field to the NULL property. You can do this using your preferred MySQL management software (like phpMyAdmin, MySQL Control Center, etc.). Instructions on how to change this property are supplied in the management software manual.