Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Cancellation/ Update Error


Guest

Recommended Posts

Posted

Hi

 

i would appreciate any help or advice

 

when using the checkout process below, i have this error message:

 

'******_*****.orders_products_download' doesn't exist

delete from orders_products_download where orders_id = "1873

[TEP STOP]

 

the order process is

 

customer cancels an order from the payment screen i.e paypal >> then remove the product from the basket >> then update the basket >> then place new product in basket >> then confirm order with new product

 

the url is /checkout_confirmation.php

 

how would i go about fixing this problem?

 

Your help or advice would be appreciated

 

Kind Regards,

PW

Posted
customer cancels an order from the payment screen i.e paypal >> then remove the product from the basket >> then update the basket >> then place new product in basket >> then confirm order with new product

looking on your sql you trying to remove the order which hasn't been created on the firths place!

 

'******_*****.orders_products_download' doesn't exist

delete from orders_products_download where orders_id = "1873

 

you need simly add the verification before you can erase the order details and normally this is not right way to "remove the product from the basket", as the oscommerce multi user system and you can delete someone else order...

Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here!

8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself.

Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues.

Any issues with oscommerce, I am here to help you.

Archived

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

×
×
  • Create New...