Out Of Range error trying to apply attributes

[orasca]

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

 

insert into products_attributes values ('', '28', '1', '2', '', '+')

 

[TEP STOP]

 

 

I have searched and found several unanswer topics and a few with replies.

This is one of them

 

My producte_attributes.php file shows the following;

tep_db_query("insert into " . TABLE_PRODUCTS_OPTIONS . " (products_options_id, products_options_name, language_id) values ('" . (int)$products_options_id . "', '" . tep_db_input($option_name) . "', '" . (int)$languages[$i]['id'] . "')");

}

 

Now from the linked topic the files look the same. I do have additional information befor the -values-statement, but the rest appears to be the same code.

(products_options_id, products_options_name, language_id)

 

Why am I getting this error and what options do I have to fix it.

 

Thanks

ORA

[Guest]

Check the products_attributes table make sure the extra field is set to auto-increment. Then check what's the next autoindex value. If you see a huge number like 2G may indicate somehow the table got corrupted.