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

[Guest]

Hello, I am new to osCommerce. This is a great product so far and easy to use and setup. I am very greatful for all the help.

 

My webhost has osCommerce installled. I am creating a production server. I installed the latest Apache 2.2.3, MySQL5 and PHP5 versions on windowsXPPro. I also installed the latest OSCommerce.

 

All went well during install. Had a few bugs but I figured them out. I did some test transactions. Teh only issue so far is that I go through the whole checkout process with no problems.

 

At the very end When it says "Your Order Has been Processed" I then click "Continue" I then get the following error

 

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 have searched for over an hour trying to find anything on this forum about this with no luck.

 

Any ideas?

 

Thanks in advance for any help

 

PS! Here are some additional questions. They dont need to be anwered as I will probably just have to figure it out myself but if there are simple answers it may save me some looking around. Thanks again.

 

Question one. I have several domains. Can I do more than one install of osComm on the same machine. Is there a tool to manage more than one shop?

 

Question 2. My Host company uses some PHP4 version and some MySQL 4 version. Will I have any issues when I FTP my site to my Host?

[Guest]

After further investigation, I figured out this error comes from not checking any boxes at the end on product notifications. I cant figure out how to turn this off or adjust it for NULL.

 

When I go into MySQL and try to change it to allow to accept Null value it does not allow me to change it. I have tried a few things. Any Help would be great.

 

Thanks

 

Robert

[Guest]

Found My Own answer: Here is what I found I will post it incase anyone else could not find this:

 

I changed the code in application_top.php as the following:

 

from:

 

if ($check['count'] < 1) {

tep_db_query("insert into " . TABLE_PRODUCTS_NOTIFICATIONS . " (products_id, customers_id, date_added) values ('" . $notify[$i] . "', '" . $customer_id . "', now())");

}

 

to:

 

if ($check['count'] < 1 && $notify[$i] != null) {

tep_db_query("insert into " . TABLE_PRODUCTS_NOTIFICATIONS . " (products_id, customers_id, date_added) values ('" . $notify[$i] . "', '" . $customer_id . "', now())");

}

 

Thanks to alvinspau

[maxxxie]

rfenn, you're a champ! That fixed it for me :)

 

Max.

[gueiros]

It really solved my problem too.Thank you

[peterbra]

You ARE THE MAN !! THANKS A LOT !!!!!!!!!!!

[EuroTimmy]

Found My Own answer: Here is what I found I will post it incase anyone else could not find this:

 

Legend!

Fixed my install for me too!

 

I appreciate you posting the problem and solution for me to use.

 

Cheers

[Guest]

Found My Own answer: Here is what I found I will post it incase anyone else could not find this:

 

I changed the code in application_top.php as the following:

 

from:

 

if ($check['count'] < 1) {

tep_db_query("insert into " . TABLE_PRODUCTS_NOTIFICATIONS . " (products_id, customers_id, date_added) values ('" . $notify[$i] . "', '" . $customer_id . "', now())");

}

 

to:

 

if ($check['count'] < 1 && $notify[$i] != null) {

tep_db_query("insert into " . TABLE_PRODUCTS_NOTIFICATIONS . " (products_id, customers_id, date_added) values ('" . $notify[$i] . "', '" . $customer_id . "', now())");

}

 

Thanks to alvinspau

 

Thanks much! This fixed me too!

[edmoore1]

I am having the same issue on the categories.php page. I have tried similar modifications, with no luck. Has anyone had any experience with this page as well?

 

Thanks,

 

emoore.

 

Found My Own answer: Here is what I found I will post it incase anyone else could not find this:

 

I changed the code in application_top.php as the following:

 

from:

 

if ($check['count'] < 1) {

tep_db_query("insert into " . TABLE_PRODUCTS_NOTIFICATIONS . " (products_id, customers_id, date_added) values ('" . $notify[$i] . "', '" . $customer_id . "', now())");

}

 

to:

 

if ($check['count'] < 1 && $notify[$i] != null) {

tep_db_query("insert into " . TABLE_PRODUCTS_NOTIFICATIONS . " (products_id, customers_id, date_added) values ('" . $notify[$i] . "', '" . $customer_id . "', now())");

}

 

Thanks to alvinspau

[offordscott]

Thank you so much for posting this fix. It most likely saved me hours of headache. How long has this been an issue, why hasn't it been addressed in the latest release?

 

Scott

 

 

 

I changed the code in application_top.php as the following:

 

from:

 

if ($check['count'] < 1) {

tep_db_query("insert into " . TABLE_PRODUCTS_NOTIFICATIONS . " (products_id, customers_id, date_added) values ('" . $notify[$i] . "', '" . $customer_id . "', now())");

}

 

to:

 

if ($check['count'] < 1 && $notify[$i] != null) {

tep_db_query("insert into " . TABLE_PRODUCTS_NOTIFICATIONS . " (products_id, customers_id, date_added) values ('" . $notify[$i] . "', '" . $customer_id . "', now())");

}

[sumaiya]

Thanks.... helped me too.

 

I have noticed the same knda problem at other places too....... gonna find them debug em. There is no permanent solution for this right? We have to find each error and debug it outselves yeh?