Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

reset Order# in DB...


virose_pt

Recommended Posts

Can someone please help me with this??

 

I reset orders_id in DB, but when anyone puts a new orders, I dont know why, along with the product that they brought, the DB keeps adding products that doesnt exist already in the shop!

 

In the confirmation email me and the client receive everithing is ok, but in the "My Account" and admin area everithing is wrong, and i keep receiving 2 orders for each purchase.

 

I know that the DB is messing with the old orders.

 

I know that if I reset again the order_id (I can do it, no problem) and had a SQL statement meybe everithing works fine. Its something like CHANGE TABLE "order_id" .... I did it in another DB and worked fine, but now I dont remember the SQL statement...

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...