Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

bombs after finished paying.......


junioratv.com

Recommended Posts

Posted

Just after completing the payment (i'm using auth.net), at the "finish" part of the transaction, there is a screen for Notify of updates and the opportunity to put in a checkmark. If you do check off one of the items, it is fine (returns to the store home page). if you don't chek any of the items, you get this error:

 

1366 - Incorrect integer value: '' for column 'products_id' at row 1

 

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

 

[TEP STOP]

 

Driving me nuts!!

Posted
Just after completing the payment (i'm using auth.net), at the "finish" part of the transaction, there is a screen for Notify of updates and the opportunity to put in a checkmark. If you do check off one of the items, it is fine (returns to the store home page). if you don't chek any of the items, you get this error:

 

1366 - Incorrect integer value: '' for column 'products_id' at row 1

 

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

 

[TEP STOP]

 

Driving me nuts!!

My guess is that you are using an older version and have not patched for mysql 5.

 

If that is the case, you probably havn't done the other patches as well.

Posted
My guess is that you are using an older version and have not patched for mysql 5.

 

If that is the case, you probably havn't done the other patches as well.

 

Still using php4 on the server.

Posted
Still using php4 on the server.

OK, then I guess the mysql5 is not a problem.

 

Sorry, can't help you.

Posted
:(

Well, what does php4 have to do with mysql5?

 

If you cannot be bothered to read what is posted, why should I bother to post. Good luck.

Posted
Well, what does php4 have to do with mysql5?

 

If you cannot be bothered to read what is posted, why should I bother to post. Good luck.

 

Sorry for being a noobie, and not understanding.

Posted
Thanks jan, I guess I should replace my checkout_success with what is in there?

Or simply download RC2a and use checkout_success.php in there. Easiest way.

Posted
ok, I will do that.. a related question, if I download the latest OSC, will that undo all the contribs that I have installed?

If you install it yes. But if you unpack the zip on your computer you will find folders and files in the unzipped archive. Look in the folder catalog and you will find that file.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...