I have downloaded Storez 9.2.3 (updated on August 4, 2008). I am using MySQL 4.0.12. I got message error from MySQL. It said that there was DUPLICATE KEY when I tried to add a new record for each table on this scripts (located at root\modules\Storez\admin):
- currencies.php,
- locations.php,
- payments.php,
- products.php,
- products_availability.php,
- products_media.php,
- products_options.php,
- products_reviews.php,
- shipping.php,
- taxes.php,
- cart.php.
I saw at "INSERT INTO ..." statement in those files. They used DEFAULT value instead of NULL. This bug happened because the value for ID field number which had field type "AutoIncrement" was: DEFAULT.
When I replace DEFAULT value with NULL value at INSERT INTO statement in those files, then the scripts work good again.
Initiated by Bugger (Original Entry) - Comments Here Please.