Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Reset the order ID in Pheonix 1.0.4.1


dculley

Recommended Posts

It has been a long time since I had to do this. I'm not a programmer but can work my way around a few things. 

Can anyone show me how to reset the order ID in terms that I can understand?  I'm coming from OSC 2.3.4 to Phoenix 1.0.4.1.  I want to update the order ID number in Phoenix so that when I ready to go live with PHX I will be at the correct order number. 

Thanks

Dean

Link to comment
Share on other sites

I seem to not know where the command line is.  I clicked on SQL button, copied in the line and click 'go'.  Then I got the below. 

Can you point me in the right direction? 

Thanks

 

image.thumb.png.a13948324023055d04653e1ea9fbf2b1.png

 

Link to comment
Share on other sites

What does

SHOW TABLE STATUS LIKE 'orders'

show?  Or just

SELECT AUTO_INCREMENT
FROM information_schema.tables
WHERE table_name = 'orders'
AND table_schema = DATABASE( ) ;

The command may have worked.  I'm not sure that it says anything when used. 

Always back up before making changes.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...