Page 1 of 2 12 LastLast
Results 1 to 10 of 17
  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
    59,807
    Blog Entries
    4
    Plugin Contributions
    133

    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!
    Donations always welcome: www.zen-cart.com/donate

    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
    59,807
    Blog Entries
    4
    Plugin Contributions
    133

    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!
    Donations always welcome: www.zen-cart.com/donate

    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
    59,807
    Blog Entries
    4
    Plugin Contributions
    133

    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!
    Donations always welcome: www.zen-cart.com/donate

    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
    59,807
    Blog Entries
    4
    Plugin Contributions
    133

    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!
    Donations always welcome: www.zen-cart.com/donate

    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
    Nov 2006
    Posts
    4
    Plugin Contributions
    0

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

    Woot thanks a lot !! still a newbie to this software lol

  9. #9
    Join Date
    Jul 2006
    Posts
    14
    Plugin Contributions
    0

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

    I was also facing same problem.

    thanx for the help.
    zencart is working now.

  10. #10
    Join Date
    Mar 2004
    Location
    Calgary, Alberta
    Posts
    290
    Plugin Contributions
    1

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

    Good work! I was going to pass on my SQL alterations but that has already been done.

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. Replies: 37
    Last Post: 7 Jul 2008, 07:17 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
  •