Forums / Upgrading from 1.2 to 1.3.x / Attribute management error after upgrade to 1.3.0.2

Attribute management error after upgrade to 1.3.0.2

Locked

Started by brownrv on 25 Jun 2006, 4:58 PM · Views: 3,534

Results 1 to 15 of 15
This thread is locked. New replies are disabled.
25 Jun 2006, 4:58 PM
#1
brownrv avatar

brownrv

New Zenner

Join Date:
May 2006
Posts:
21
Plugin Contributions:
0

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?

25 Jun 2006, 5:10 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Attribute management error after upgrade to 1.3.0.2

Check the structure of the products_options table:

It should match:

DROP TABLE IF EXISTS products_options;
CREATE TABLE products_options (
  products_options_id int(11) NOT NULL default '0',
  language_id int(11) NOT NULL default '1',
  products_options_name varchar(32) NOT NULL default '',
  products_options_sort_order int(11) NOT NULL default '0',
  products_options_type int(5) NOT NULL default '0',
  products_options_length smallint(2) NOT NULL default '32',
  products_options_comment varchar(64) default NULL,
  products_options_size smallint(2) NOT NULL default '32',
  products_options_images_per_row int(2) default '5',
  products_options_images_style int(1) default '0',
  products_options_rows smallint(2) NOT 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!]
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!

25 Jun 2006, 5:46 PM
#3
brownrv avatar

brownrv

New Zenner

Join Date:
May 2006
Posts:
21
Plugin Contributions:
0

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).

25 Jun 2006, 5:58 PM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

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!]
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!

25 Jun 2006, 6:29 PM
#5
brownrv avatar

brownrv

New Zenner

Join Date:
May 2006
Posts:
21
Plugin Contributions:
0

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.

25 Jun 2006, 6:41 PM
#6
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

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!]
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!

25 Jun 2006, 7:58 PM
#7
brownrv avatar

brownrv

New Zenner

Join Date:
May 2006
Posts:
21
Plugin Contributions:
0

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)

25 Jun 2006, 8:14 PM
#8
brownrv avatar

brownrv

New Zenner

Join Date:
May 2006
Posts:
21
Plugin Contributions:
0

Re: Attribute management error after upgrade to 1.3.0.2

Here's the extracts from each table:


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]

25 Jun 2006, 8:45 PM
#9
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Attribute management error after upgrade to 1.3.0.2

Okay this is good ...

Backup your database ...

Then run:

DROP TABLE IF EXISTS hbgz_products_options;
CREATE TABLE hbgz_products_options (
  products_options_id int(11) NOT NULL default '0',
  language_id int(11) NOT NULL default '1',
  products_options_name varchar(32) NOT NULL default '',
  products_options_sort_order int(11) NOT NULL default '0',
  products_options_type int(5) NOT NULL default '0',
  products_options_length smallint(2) NOT NULL default '32',
  products_options_comment varchar(64) default NULL,
  products_options_size smallint(2) NOT NULL default '32',
  products_options_images_per_row int(2) default '5',
  products_options_images_style int(1) default '0',
  products_options_rows smallint(2) NOT 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:

//  $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!]
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!

26 Jun 2006, 12:47 AM
#10
brownrv avatar

brownrv

New Zenner

Join Date:
May 2006
Posts:
21
Plugin Contributions:
0

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?

26 Jun 2006, 2:01 AM
#11
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Attribute management error after upgrade to 1.3.0.2

Not if you are getting the error ...

Do you have Products right now or not in your shop?

I am trying to reproduce the error ... and having a little trouble doing so ...

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!]
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!

26 Jun 2006, 2:51 AM
#12
brownrv avatar

brownrv

New Zenner

Join Date:
May 2006
Posts:
21
Plugin Contributions:
0

Re: Attribute management error after upgrade to 1.3.0.2

Hi,

Only one product. It is a test product so I can run through the sale process.

This is a test system that I have been using to develop a customized template, so I can pretty much do what is needed to figure out what is going on.

26 Jun 2006, 4:12 AM
#13
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Attribute management error after upgrade to 1.3.0.2

Start with a reload of all the files to /admin

It isn't making a lot of sense that this is happening ...

I am guessing you installed without the demo products?

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!]
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!

27 Jun 2006, 2:56 AM
#14
brownrv avatar

brownrv

New Zenner

Join Date:
May 2006
Posts:
21
Plugin Contributions:
0

Re: Attribute management error after upgrade to 1.3.0.2

Hi,
Okay, I'll work on that.
Yes, I didn't install the demo.
I'll get back to you soon.
Thanks.

27 Jun 2006, 3:48 AM
#15
brownrv avatar

brownrv

New Zenner

Join Date:
May 2006
Posts:
21
Plugin Contributions:
0

Re: Attribute management error after upgrade to 1.3.0.2

Hi,

Okay, after replacing the admin directory (renamed it out of the way) with the admin directory from the full 1.3.0.2 fileset and putting the configure.php file back into admin/includes. The admin panel comes up, but when I log in, I'm now getting this error:

[Mon Jun 26 20:28:10 2006] [error] [client 192.168.1.101] Premature end of script headers: php.exe, referer: http://192.168.1.101/zencart/admin/login.php?zenAdminID=a044f0952156137c75813b1798963e1a
[Mon Jun 26 20:40:15 2006] [error] [client 192.168.1.101] Premature end of script headers: php.exe, referer: http://192.168.1.101/zencart/admin/login.php?zenAdminID=be372e9a9de7fea2a2de6b2550083802
[Mon Jun 26 20:40:45 2006] [error] [client 192.168.1.101] Premature end of script headers: php.exe, referer: http://192.168.1.101/zencart/admin/login.php

Any ideas? I'm baffled :no:
Appears to me the php interpreter blows up after accepting the admin account and password.

I've put back the old admin directory and it still works (gives me the index page).

Now something else is busted in the new admin folder.