Page 1 of 2 12 LastLast
Results 1 to 10 of 15
  1. #1

    Default Attribute management error after upgrade to 1.3.0.2

    Hi,

    I"ve upgraded a 1.3.0.1 installation to 1.3.0.2.

    I'm now seeing this error when I try to add a new option (currently there are none) to my test installation.

    1264 Out of range value adjusted for column 'products_options_images_per_row' at row 1
    in:
    [insert into hbgz_products_options (products_options_id, products_options_name, language_id, products_options_sort_order, products_options_type, products_options_images_per_row, products_options_images_style, products_options_rows) values ('1', 'To', '1', '10', '1', '', '', '1' )]
    If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

    Any idea where the problem might be?

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Attribute management error after upgrade to 1.3.0.2

    Check the structure of the products_options table:

    It should match:
    PHP Code:
    DROP TABLE IF EXISTS products_options;
    CREATE TABLE products_options (
      
    products_options_id int(11NOT NULL default '0',
      
    language_id int(11NOT NULL default '1',
      
    products_options_name varchar(32NOT NULL default '',
      
    products_options_sort_order int(11NOT NULL default '0',
      
    products_options_type int(5NOT NULL default '0',
      
    products_options_length smallint(2NOT NULL default '32',
      
    products_options_comment varchar(64) default NULL,
      
    products_options_size smallint(2NOT NULL default '32',
      
    products_options_images_per_row int(2) default '5',
      
    products_options_images_style int(1) default '0',
      
    products_options_rows smallint(2NOT NULL default '1',
      
    PRIMARY KEY  (products_options_id,language_id),
      
    KEY idx_lang_id_zen (language_id)
    TYPE=MyISAM
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  3. #3

    Default Re: Attribute management error after upgrade to 1.3.0.2

    Hi,

    Only difference I found is that products_options_sort_order is type integer and not int(11).

  4. #4
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Attribute management error after upgrade to 1.3.0.2

    Do you have any records in the products_options table?

    Do you have any records in the products_options_types table?

    Do you have any records in the products_options_values table?
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  5. #5

    Default Re: Attribute management error after upgrade to 1.3.0.2

    Hi,

    No it's completely empty. This is the first time I am trying to add attributes to my test system so it's possible that there was a problem after the 1.3.0.1 installation which was a fresh install.

  6. #6
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Attribute management error after upgrade to 1.3.0.2

    I asked about 3 tables ... are all 3 empty?
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  7. #7

    Default Re: Attribute management error after upgrade to 1.3.0.2

    Hi,

    Sorry for the inexact answer.

    Here's the info out of MySqlAdministrator for the tables.
    product_options: 0 rows (Data Length: 0 B, Index Length: 1 KB)
    product_options_types: 6 rows (Data Length: 120 B, Index Length: 2 KB)
    product_options_values: 1 rows (Data Length: 20 B, Index Length: 2 KB)

  8. #8

    Default Re: Attribute management error after upgrade to 1.3.0.2

    Here's the extracts from each table:

    [FONT="Courier New"]
    mysql> select * from hbgz_products_options;
    Empty set (0.00 sec)

    mysql> select * from hbgz_products_options_types;
    +---------------------------+-----------------------------+
    | products_options_types_id | products_options_types_name |
    +---------------------------+-----------------------------+
    | 0 | Dropdown |
    | 1 | Text |
    | 2 | Radio |
    | 3 | Checkbox |
    | 4 | File |
    | 5 | Read Only |
    +---------------------------+-----------------------------+
    6 rows in set (0.00 sec)

    mysql> select * from hbgz_products_options_values;
    +----------------------------+-------------+------------------------------+------------------------------------+
    | products_options_values_id | language_id | products_options_values_name | products_options_values_sort_order |
    +----------------------------+-------------+------------------------------+------------------------------------+
    | 0 | 1 | TEXT | 0 |
    +----------------------------+-------------+------------------------------+------------------------------------+
    1 row in set (0.00 sec)
    [/SIZE][/SIZE][/FONT]

  9. #9
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Attribute management error after upgrade to 1.3.0.2

    Okay this is good ...

    Backup your database ...

    Then run:
    PHP Code:
    DROP TABLE IF EXISTS hbgz_products_options;
    CREATE TABLE hbgz_products_options (
      
    products_options_id int(11NOT NULL default '0',
      
    language_id int(11NOT NULL default '1',
      
    products_options_name varchar(32NOT NULL default '',
      
    products_options_sort_order int(11NOT NULL default '0',
      
    products_options_type int(5NOT NULL default '0',
      
    products_options_length smallint(2NOT NULL default '32',
      
    products_options_comment varchar(64) default NULL,
      
    products_options_size smallint(2NOT NULL default '32',
      
    products_options_images_per_row int(2) default '5',
      
    products_options_images_style int(1) default '0',
      
    products_options_rows smallint(2NOT NULL default '1',
      
    PRIMARY KEY  (products_options_id,language_id),
      
    KEY idx_lang_id_zen (language_id)
    TYPE=MyISAM
    Let's see if this corrects the issues or not ...

    Also check the ID of the file ... on your server ... /admin/options_name_manager.php

    Does it match:
    PHP Code:
    //  $Id: options_name_manager.php 3297 2006-03-28 08:35:01Z drbyte $ 
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  10. #10

    Default Re: Attribute management error after upgrade to 1.3.0.2

    Hi,

    Okay, confirmed the file versions of /admin/options_name_manager.php match.
    Database table has been dropped and recreated with the sql you sent.
    I tried to add an new option name and the same error came up.

    Should I expect to find one row in hbgz_products_options_values table?

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. Adding Attribute to product Problem after upgrade
    By Darkmuncan in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 19 Nov 2007, 05:30 PM
  2. Error after upgrade
    By bfwdesigns in forum Upgrading from 1.3.x to 1.3.9
    Replies: 2
    Last Post: 7 Sep 2006, 02:17 AM
  3. Error after upgrade to 1.3.5
    By camay123 in forum Upgrading from 1.3.x to 1.3.9
    Replies: 7
    Last Post: 5 Sep 2006, 03:05 AM

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