Tried to run the SQL Query stated in the knowledgebase (http://xrl.in/2utl) but it's not working.
Can anyone confirm that this query works in 5.0.5 and try to ascertain what I am doing wrong if it does?
Also, if there is any guidance where the script should be run in phpmyadmin then I can check if I am doing it right.
Thanks all.
Changing the start number for order ID's...
-
- Posts: 337
- Joined: Thu Jun 18, 2009 9:38 am
-
- Site Admin
- Posts: 1854
- Joined: Wed Jun 17, 2009 6:30 pm
- Location: South Yorkshire UK
- Contact:
Re: Changing the start number for order ID's...
What the script does is change the autoincrement start point... I'm guessing you've already passed the point where the orderID is past 1000 so that might explain why it's not working.babyREFLUX wrote:Tried to run the SQL Query stated in the knowledgebase (http://xrl.in/2utl) but it's not working.
Can anyone confirm that this query works in 5.0.5 and try to ascertain what I am doing wrong if it does?
Also, if there is any guidance where the script should be run in phpmyadmin then I can check if I am doing it right.
Failing that what's your table prefix in your ISC installation? and/or what error are you getting?
There's no reason to expect the version to cause the problem though as the table name hasn't changed..
Re: Changing the start number for order ID's...
If you can't get phpmyadmin change autoincrement value for you, you can get demo of EMS MySQL Manager 2010, register your DB in it, connect DB and then open the table where you need to alter AUTOINCREMENT VALUE. In right pane under Properties tab (of opened table) there's a field Auto increment value with corresponding selector. Change it to anything you want but greater than biggest ID value (not amount of records) in whole table.
It took less than a minute for me. Also check the table name as pointed by Martin.
It took less than a minute for me. Also check the table name as pointed by Martin.