Hypothesis:
- OP had bad dates in his coupon table.
- zero_dates_cleanup.sql script was not run
- ALTER TABLE failed for that reason.
To test, in phpMyAdmin, run
ALTER TABLE orders_products ADD products_quantity_mixed tinyint(1) default NULL;
verify that it fails. The run
zc_install/sql/install/zero_dates_cleanup.sql
Then you can re-run that ALTER TABLE and it will work. But you'll have to figure out what worked and what didn't - it would be easier to restore your pre-upgrade database, run zero_dates_cleanup, then run zc_install so you'd be sure to get all the schema changes for 1.5.6.
Bookmarks