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

[kapilza]

Hi Guys

 

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

 

insert into products_notifications (products_id, customers_id, date_added) values ('', '2', now())

 

[TEP STOP]

 

I am always getting the above error when I click CONTINUE after my order has been processed. Any suggestions would help.

 

Thanks in advance.

[aheisey]

Found reference for a fix in another thread:

 

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

 

Outside OsCommerce:

 

http://webomania.wordpress.com/2006/10/01/...r-column-error/

[magis16]

Found reference for a fix in another thread:

 

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

 

Outside OsCommerce:

 

http://webomania.wordpress.com/2006/10/01/...r-column-error/

Perhaps I'm just not understanding what the issue is, but I've read both of the afore-mentioned posts and I can't seem to fix my problem either. If I check the "Notify me" box, then everything goes off without a hitch. Its when its left blank that I get the same error. I've gone to the "Product Notification" php file, but cannot find anywhere to add the "1"...

 

If anyone has any ideas on how to fix this other than adding text to the notification process instructing people that they HAVE to check the boxes.

 

Thanks!