Page 1 of 1
how to RESET order_id in DB
Posted: Thu Jan 21, 2021 4:53 pm
by ideep13
Hi,
I know this probably been asked, but I can not find the resolution anywhere. I am trying to figure it out how to fix order_IDs in DB. Why are some fictitious orders created in DB and why don't they start with 0? Can you please provide me with resolution, how to fix that, so I won&t be having those empty spaces in between order ID numbers and so the next order will start with 1? Thank you.
Please find attached a screenshot.
Re: how to fix order_id in DB
Posted: Thu Jan 21, 2021 5:26 pm
by thekrotek
To fix something it has to be broken. Nothing is broken here, so nothing to fix. Topic can be closed.
Re: how to fix order_id in DB
Posted: Thu Jan 21, 2021 5:48 pm
by ideep13
Well for me this is not normal, if you make a fresh clean install of 3.0.3.6. and waiting your clients to make some order, and than you find out you have all this in your DB for unknown reason? If everything would be ok, than the order_id would start with 1, and another order with 2. And now I have empty spaces with order Id's and two testing orders..
so the thing does not goes as smooth as I want, pure, flawless. For me this is broken value. And I want to know why this happened and how to fix it to not happen again.
So we are not here to debate, but to find resolutions. If this is not the matter, than this place should not be called forum.
Re: how to fix order_id in DB
Posted: Thu Jan 21, 2021 5:52 pm
by thekrotek
Sorry, but there's nothing to fix here. Topic can be closed.
Re: how to fix order_id in DB
Posted: Thu Jan 21, 2021 6:01 pm
by xxvirusxx
thekrotek wrote: ↑Thu Jan 21, 2021 5:52 pm
Sorry, but there's nothing to fix here. Topic can be closed.
When you start a store you make some tests.
Orders and sh*t to see if everything is ok.
After that when you open the store you want orders to start from 1 so you will need to change AUTO_INCREMENT to 1 for order_id from oc_order table.
@ideep13
You can filter in admin for Missing orders...
Re: how to fix order_id in DB
Posted: Thu Jan 21, 2021 6:28 pm
by ideep13
Thank you xxVirusxx for your continuous help. It is impossible to tick the box - Adjust privileges. The box is grey. Should I proceed with not ticking the box and just change auto_increment to 1? What about data below ? See picture.
Re: how to fix order_id in DB
Posted: Thu Jan 21, 2021 7:20 pm
by xxvirusxx
On
table options....
Code: Select all
ALTER TABLE `oc_order` AUTO_INCREMENT = 1;
And you can delete that test orders.
Re: how to fix order_id in DB
Posted: Thu Jan 21, 2021 7:29 pm
by ideep13
It is not possible to tick the box.
I tried to set privileges, access denied.
Re: how to fix order_id in DB
Posted: Thu Jan 21, 2021 7:32 pm
by paulfeakins
thekrotek wrote: ↑Thu Jan 21, 2021 5:52 pm
Sorry, but there's nothing to fix here. Topic can be closed.
@thekrotek is perfectly correct, this is just how OpenCart works.
If you have a specific reason for this, please explain, otherwise I will lock the topic.
Re: how to fix order_id in DB
Posted: Thu Jan 21, 2021 7:33 pm
by xxvirusxx
xxvirusxx wrote: ↑Thu Jan 21, 2021 6:01 pm
you will need to change AUTO_INCREMENT
@paulfeakins
Title correct should be how to reset....
What is hard to understand? He made some test orders or are missing orders. He want to open the store for customers....and when first customer make an order, ID for that order to be 1.
Re: how to fix order_id in DB
Posted: Thu Jan 21, 2021 7:43 pm
by ideep13
from when do we need to explain ourselves?
I think this should be reported to the opencart directly. Forum is runned by bunch of sensitive guys, who wants to have control over their users. Unbelievable.
it is not working. error received. you can not move the table to the same one
Re: how to fix order_id in DB
Posted: Thu Jan 21, 2021 7:46 pm
by xxvirusxx
ideep13 wrote: ↑Thu Jan 21, 2021 7:43 pm
you can not move the table to the same one
To move what?
Run that command and if doesn't work...contact hosting provider...
Last draw...
time break for water
Re: how to fix order_id in DB
Posted: Thu Jan 21, 2021 10:18 pm
by mikeinterserv
ideep13 wrote: ↑Thu Jan 21, 2021 7:43 pm
from when do we need to explain ourselves?
I think this should be reported to the opencart directly. Forum is runned by bunch of sensitive guys, who wants to have control over their users. Unbelievable.
it is not working. error received. you can not move the table to the same one
I imagine you are getting close to getting NO help at all here :-)
Re: how to fix order_id in DB
Posted: Fri Jan 22, 2021 7:51 pm
by paulfeakins
ideep13 wrote: ↑Thu Jan 21, 2021 7:43 pm
from when do we need to explain ourselves?
You want help but you don't want to explain the reason for your problem?
ideep13 wrote: ↑Thu Jan 21, 2021 7:43 pm
I think this should be reported to the opencart directly. Forum is runned by bunch of sensitive guys, who wants to have control over their users. Unbelievable.
We're trying to help you with our experience, for free, and you want to criticise us? Continue like this and you will be banned.
ideep13 wrote: ↑Thu Jan 21, 2021 7:43 pm
it is not working. error received. you can not move the table to the same one
Again you're speaking gibberish.
Re: how to fix order_id in DB
Posted: Fri Jan 22, 2021 7:51 pm
by paulfeakins
mikeinterserv wrote: ↑Thu Jan 21, 2021 10:18 pm
I imagine you are getting close to getting NO help at all here :-)
Correct.
Re: how to fix order_id in DB
Posted: Fri Jan 22, 2021 7:53 pm
by paulfeakins
xxvirusxx wrote: ↑Thu Jan 21, 2021 7:33 pm
Title correct should be how to reset....
What is hard to understand?
You're right it's easier to understand now the title has been edited to might
slightly more sense.