Failed to create tables under database setup step.

[samcyh]

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>

[spazashop]

I get exactly the same problem - also using mySQL 5.0 and zen cart 1.3.5; php 4.4.4

[cjloong]

Hi
I am facing the same thing. It seems that the line that is giving problems is
products_options_values BLOB NOT NULL default ''

Looking at http://www.zen-cart.com/forum/showth...highlight=BLOB, it seems that the line should be written as
products_options_value_text BLOB NULL default NULL,

How should this problem be fixed? (I would not want to simply replace to avoid future schema problems.)

[cjloong]

Seems that the problem happens to TEXT type field as well in query_builder table.

[vinadir]

I have this exact same problem as well. It's kind of surprising how little info there is on this error, as it seems like it would be pretty prevalent.

I didn't want to make any changes to the schema in the sql file for the same reasons as the OP, I don't want to break anything else later on.

[Pixxi]

Zen 1.3.5 isn't supported for MySQL 5.x.x yet - it may work, or you may get errors. It works fine with MySQL 4.4.x

[lchoate]

Well, I think I got it to work in with MYSQL 5...

What I had to do was start the install with MYSQL in compatibility mode: (in the MYSQL Console)


[FONT=monospace]SET @@global.sql_mode='MYSQL40'

[FONT=Verdana]Then I got past one error, to the next:[/FONT]

[FONT=monospace]SET @@global.sql_mode='TRADITIONAL'

[FONT=Verdana]That did it. FYI, I am on XP/IIS/PHP5/MYSQL5[/FONT]
[/FONT]

[/FONT]

[DrByte]

This may help too:
http://www.zen-cart.com/forum/showth...highlight=BLOB