dculley Posted December 21, 2019 Share Posted December 21, 2019 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 More sharing options...
kgtee Posted December 22, 2019 Share Posted December 22, 2019 I have done this using phpmyadmin. Execute this SQL command line: ALTER TABLE orders AUTO_INCREMENT=19001; assuming the order id will start with 19001. Link to comment Share on other sites More sharing options...
dculley Posted December 22, 2019 Author Share Posted December 22, 2019 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 Link to comment Share on other sites More sharing options...
kgtee Posted December 22, 2019 Share Posted December 22, 2019 You miss typing a semicolon at the end of the statement. Link to comment Share on other sites More sharing options...
dculley Posted December 22, 2019 Author Share Posted December 22, 2019 I copied passed your line in and changed the 19001 to 20001 I left the semicolon at the end. I even tried typing it in. Link to comment Share on other sites More sharing options...
kgtee Posted December 22, 2019 Share Posted December 22, 2019 Check if your orders_id field is indexed? Link to comment Share on other sites More sharing options...
dculley Posted December 22, 2019 Author Share Posted December 22, 2019 it appears to be. Link to comment Share on other sites More sharing options...
♥ecartz Posted December 22, 2019 Share Posted December 22, 2019 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 More sharing options...
♥Moxamint Posted December 22, 2019 Share Posted December 22, 2019 When you are at the "orders" table, go to the "Operations" tab, enter the desired number in the "AUTO_INCREMENT" field, and then press "Go" button Link to comment Share on other sites More sharing options...
kgtee Posted December 22, 2019 Share Posted December 22, 2019 As @ecartz said it has worked, the green tick confirms that. We miss reading between the lines 😆 Link to comment Share on other sites More sharing options...
dculley Posted December 22, 2019 Author Share Posted December 22, 2019 Moxanint OMG that was easier. That should be under the notes in the start up reference manual. Thank you Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.