Products Attributes

[rosemary]

Hello, can someone help me with this problem, pleeeease!?

 

I cannot insert products into the Products Attributes section of the Administration -> Catalog -> Products Attributes. I have no problem with adding Product Options and Option Values, but when I have done these and go on to Products Attributes (at the bottom of the page) to associate the various attributes with my products, I get an error message like this:

 

1264 - Out of range value adjusted for column 'products_attributes_id' at row 1

insert into products_attributes values (' ', '8', '5', '13', '35.9900', '+')

[TEP STOP]

 

Trying this task with the default OSC products still yield this error message. I've been stucked for several days reading and searching for answers to no avail. I am grateful for any help or suggestions.

 

 

Stucked and stumped :'(

Rose

[jasonabc]

A simple Google search on this error brought back these three - they should solve your problem.

 

http://www.oscommerce.com/forums/lofiversion/i...hp/t199007.html

http://www.oscommerce.com/forums/index.php?showtopic=189550

http://www.oscommerce.com/community/bugs,3757/category,Other

[rosemary]

Thanks, Jason. Just got back home . . . I will take a look at the resources you suggested.

 

Thanks again!

Rose

 

 

 

 

 

A simple Google search on this error brought back these three - they should solve your problem.

 

http://www.oscommerce.com/forums/lofiversion/i...hp/t199007.html

http://www.oscommerce.com/forums/index.php?showtopic=189550

http://www.oscommerce.com/community/bugs,3757/category,Other

[rosemary]

Hi, Jason.

 

Okay, results report . . . for the benefits of future others who also encounter this problem (as many other had encountered the same) . . .

 

There was indeed a bug in the original osC catalog/admin/product_attribute.php file.

 

All 3 links you had provided essentially has the same solution. I went with the "alternate" fix posted by Jimmy_D, namely, I replaced this line (around line 63):

 

tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " values ('','" . (int)$products_id . "', '" . (int)$options_id . "', '" . (int)$values_id . "', '" . tep_db_input($value_price) . "', '" . tep_db_input($price_prefix) . "')");

 

 

with this line:

 

tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " values (NULL,'" . (int)$products_id . "', '" . (int)$options_id . "', '" . (int)$values_id . "', '" . tep_db_input($value_price) . "', '" . tep_db_input($price_prefix) . "')");

 

 

because it offers the most logical and minimal change (it fixes only the offending part of the line). With this fix, I have not encountered further "yowza" as the poor dude in the 3rd link.

 

 

All is working fine for me now. Thanks again, Jason! :thumbsup:

 

Rose

 

 

 

 

 

 

Thanks, Jason. Just got back home . . . I will take a look at the resources you suggested.

 

Thanks again!

Rose

[djrino]

Hi

only for info

nothinf of this hava worked for me..

 

im running on my localhost anreceive this error

 

1264 - Out of range value adjusted for column 'products_quantity' at row 1

 

insert into products (products_quantity, products_model, products_price, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_date_added) values ('', '', '', null, '', '1', '0', '0', now())

 

[TEP STOP]