Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17
  1. #11
    Join Date
    Nov 2006
    Posts
    296
    Plugin Contributions
    2

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

    Quote Originally Posted by xplorer View Post
    I was also facing same problem.

    thanx for the help.
    zencart is working now.
    And another soul rescued here, thanks!

  2. #12
    Join Date
    Apr 2006
    Location
    Göteborg
    Posts
    126
    Plugin Contributions
    0

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

    Just want to share, I had the same going from 1.3.0.2 --> 1.3.5 in the route to 1.3.7

    It started with
    1101 BLOB/TEXT column 'query_description' can't have a default value
    in:
    [ALTER TABLE zen_dog_query_builder CHANGE COLUMN query_description query_description TEXT NOT NULL default '';]

    when upgrading dB from 1.3.0.2 to 1.3.5.

    After a number of delete database and reimport, I found that removing default '' in the following lines worked.

    ALTER TABLE query_builder CHANGE COLUMN query_description query_description TEXT NOT NULL default '';

    ALTER TABLE query_builder CHANGE COLUMN query_string query_string TEXT NOT NULL default '';

    ALTER TABLE query_builder CHANGE COLUMN query_keys_list query_keys_list TEXT NOT NULL default '';

  3. #13
    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

  4. #14
    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.

  5. #15
    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

  6. #16
    Join Date
    May 2006
    Posts
    41
    Plugin Contributions
    0

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

    Quote Originally Posted by smap View Post
    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
    Hmm, sorry upon 2nd look I'm not sure this is related.

  7. #17
    Join Date
    May 2006
    Posts
    41
    Plugin Contributions
    0

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

    My live/server version of MySQL is 4.1.22. My dev/local version of MySQL is 5.0.27 (where the upgrade/error was occurring). I reconfigured the dev instance and unchecked 'strict mode' and this error went away.

 

 
Page 2 of 2 FirstFirst 12

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