Hi

As soon as I click on the save database setting, under the database setup step installation, I can see the zencart application try to create table under my database. Please see the blue color error message. The zencart is not allow me continuous the next step.

Please advise me the solution, I am using MYSQL5.0

http://localhost/shop/zc%5Finstall/i...se_phpbb=false




Installation In Progress...

~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
1101 BLOB/TEXT column 'products_options_values' can't have a default value
in:
[CREATE TABLE orders_products_attributes ( orders_products_attributes_id int(11) NOT NULL auto_increment, orders_id int(11) NOT NULL default '0', orders_products_id int(11) NOT NULL default '0', products_options varchar(32) NOT NULL default '', products_options_values BLOB NOT NULL default '', options_values_price decimal(15,4) NOT NULL default '0.0000', price_prefix char(1) NOT NULL default '', product_attribute_is_free tinyint(1) NOT NULL default '0', products_attributes_weight float NOT NULL default '0', products_attributes_weight_prefix char(1) NOT NULL default '', attributes_discounted tinyint(1) NOT NULL default '1', attributes_price_base_included tinyint(1) NOT NULL default '1', attributes_price_onetime decimal(15,4) NOT NULL default '0.0000', attributes_price_factor decimal(15,4) NOT NULL default '0.0000', attributes_price_factor_offset decimal(15,4) NOT NULL default '0.0000', attributes_price_factor_onetime decimal(15,4) NOT NULL default '0.0000', attributes_price_factor_onetime_offset decimal(15,4) NOT NULL default '0.0000', attributes_qty_prices text, attributes_qty_prices_onetime text, attributes_price_words decimal(15,4) NOT NULL default '0.0000', attributes_price_words_free int(4) NOT NULL default '0', attributes_price_letters decimal(15,4) NOT NULL default '0.0000', attributes_price_letters_free int(4) NOT NULL default '0', products_options_id int(11) NOT NULL default '0', products_options_values_id int(11) NOT NULL default '0', products_prid tinytext NOT NULL, PRIMARY KEY (orders_products_attributes_id), KEY idx_orders_id_prod_id_zen (orders_id,orders_products_id) ) TYPE=MyISAM;]


I logon to MYSQL Server and I can see some of the table has been created by zencart application. See details below:

mysql> use zencart
Database changed
mysql> show tables;
+----------------------------------+
| Tables_in_zencart |
+----------------------------------+
| address_book |
| address_format |
| admin |
| admin_activity_log |
| authorizenet |
| banners |
| banners_history |
| categories |
| categories_description |
| configuration |
| configuration_group |
| counter |
| counter_history |
| countries |
| coupon_email_track |
| coupon_gv_customer |
| coupon_gv_queue |
| coupon_redeem_track |
| coupon_restrict |
| coupons |
| coupons_description |
| currencies |
| customers |
| customers_basket |
| customers_basket_attributes |
| customers_info |
| db_cache |
| email_archive |
| ezpages |
| featured |
| files_uploaded |
| geo_zones |
| get_terms_to_filter |
| group_pricing |
| languages |
| layout_boxes |
| manufacturers |
| manufacturers_info |
| media_clips |
| media_manager |
| media_to_products |
| media_types |
| meta_tags_categories_description |
| meta_tags_products_description |
| music_genre |
| newsletters |
| orders |
| orders_products |
| upgrade_exceptions |
+----------------------------------+
49 rows in set (0.00 sec)

mysql>