Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Hybrid View

  1. #1
    Join Date
    Nov 2006
    Posts
    4
    Plugin Contributions
    0

    Idea or Suggestion BLOB/TEXT column 'products_options_values' can't have a default value ??

    Hi there , thank you for making such a great software avaliable for free . however, i encountered an error during database installation.
    i am using iis6 , mysql 5

    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;]
    any solution ? Thanks in advance

  2. #2
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: BLOB/TEXT column 'products_options_values' can't have a default value ??

    Hmmm ... hadn't ran into that one yet.

    You'll have to edit the /zc_install/sql/mysql_zencart.sql file and search for "BLOB " and remove the default '' following it (leaving the , )

    There are 2 BLOB references with default values, and 3 TEXT references with default values.
    - customers_basket_attributes (BLOB)
    - orders_products_attributes (BLOB)
    - query_builder (TEXT x 3)

    These will be remedied in the next release.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    Nov 2006
    Posts
    4
    Plugin Contributions
    0

    Default Re: BLOB/TEXT column 'products_options_values' can't have a default value ??

    1101 BLOB/TEXT column 'query_description' can't have a default value
    in:
    [CREATE TABLE query_builder ( query_id int(11) NOT NULL auto_increment, query_category varchar(40) NOT NULL default '', query_name varchar(80) NOT NULL default '', query_description TEXT NOT NULL default '', query_string TEXT NOT NULL default '', query_keys_list TEXT NOT NULL default '', PRIMARY KEY (query_id), UNIQUE KEY query_name (query_name) ) TYPE=MyISAM COMMENT='Stores queries for re-use in Admin email and report modules';]


    Hmm new error ?
    i would appreciate if u could send me all the fixed sql files

  4. #4
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: BLOB/TEXT column 'products_options_values' can't have a default value ??

    Updated SQL file attached.
    Attached Files Attached Files
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  5. #5
    Join Date
    Nov 2006
    Posts
    4
    Plugin Contributions
    0

    Default Re: BLOB/TEXT column 'products_options_values' can't have a default value ??

    Hey thanks ! after using ur attached sql files
    i am still getting
    1364 Field 'query_keys_list' doesn't have a default value
    in:
    [INSERT INTO query_builder ( query_id , query_category , query_name , query_description , query_string ) VALUES ( '1', 'email', 'All Customers', 'Returns all customers name and email address for sending mass emails (ie: for newsletters, coupons, GV\'s, messages, etc).', 'select customers_email_address, customers_firstname, customers_lastname from TABLE_CUSTOMERS order by customers_lastname, customers_firstname, customers_email_address');]

    hmm is it because of mysql5 version lol ?

  6. #6
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: BLOB/TEXT column 'products_options_values' can't have a default value ??

    I've updated the attachment in my previous post.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  7. #7
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: BLOB/TEXT column 'products_options_values' can't have a default value ??

    Quote Originally Posted by quantumfusion View Post

    hmm is it because of mysql5 version lol ?
    Yes, the initial problem you reported is related to MySQL5.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  8. #8
    Join Date
    Dec 2006
    Posts
    6
    Plugin Contributions
    0

    Default Re: BLOB/TEXT column 'products_options_values' can't have a default value ??

    Quote Originally Posted by DrByte View Post
    Hmmm ... hadn't ran into that one yet.

    You'll have to edit the /zc_install/sql/mysql_zencart.sql file and search for "BLOB " and remove the default '' following it (leaving the , )

    There are 2 BLOB references with default values, and 3 TEXT references with default values.
    - customers_basket_attributes (BLOB)
    - orders_products_attributes (BLOB)
    - query_builder (TEXT x 3)

    These will be remedied in the next release.
    This issue still exists in the 1302-to-135.sql file for the query_builder fields.

    Mark

  9. #9
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: BLOB/TEXT column 'products_options_values' can't have a default value ??

    Quote Originally Posted by mriffey View Post
    This issue still exists in the 1302-to-135.sql file for the query_builder fields.

    Mark
    Correct - it's fixed in the upcoming v1.3.8 fileset.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  10. #10
    Join Date
    May 2006
    Posts
    41
    Plugin Contributions
    0

    Default Re: BLOB/TEXT column 'products_options_values' can't have a default value ??

    Updating 1.37 to 1.38 (mysql_upgrade_zencart_137_to_138.sql) getting the same error.

    Code:
    ERROR 1364 (HY000) at line 62: Field 'query_keys_list' doesn't have a default value

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. Replies: 2
    Last Post: 2 Aug 2011, 03:57 PM
  2. Is it possible to have a default value in text attributes?
    By rbobzin in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 12 Sep 2008, 09:20 PM
  3. problem with products_options_values as a BLOB
    By audleman in forum Setting Up Categories, Products, Attributes
    Replies: 2
    Last Post: 8 Oct 2007, 10:55 PM
  4. 1101 BLOB/TEXT column can't have a default value
    By tkroh in forum Installing on a Windows Server
    Replies: 3
    Last Post: 27 Dec 2006, 10:28 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR