how to RESET order_id in DB

Post by ideep13 » Thu Jan 21, 2021 4:53 pm

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.

Attachments

Orders-DB-OC.png (108.14 KiB) Viewed 1418 times

Post by thekrotek » Thu Jan 21, 2021 5:26 pm

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com

Post by ideep13 » Thu Jan 21, 2021 5:48 pm

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.

Post by thekrotek » Thu Jan 21, 2021 5:52 pm

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com

Post by xxvirusxx » Thu Jan 21, 2021 6:01 pm

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...

Attachments

autoincrement.png (54.89 KiB) Viewed 1368 times

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer

Post by ideep13 » Thu Jan 21, 2021 6:28 pm

Attachments

whataboutthis.png (46.48 KiB) Viewed 1304 times

Post by xxvirusxx » Thu Jan 21, 2021 7:20 pm

 ALTER TABLE `oc_order` AUTO_INCREMENT = 1;

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer

Post by ideep13 » Thu Jan 21, 2021 7:29 pm

Attachments

cannottickthebox.png (85.09 KiB) Viewed 1288 times

privileges.png (88.24 KiB) Viewed 1288 times

Post by paulfeakins » Thu Jan 21, 2021 7:32 pm

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk

Post by xxvirusxx » Thu Jan 21, 2021 7:33 pm

Attachments

autoincr.png (21.3 KiB) Viewed 1276 times

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer

Post by ideep13 » 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

Post by xxvirusxx » Thu Jan 21, 2021 7:46 pm

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

Attachments

last_draw.png (43.44 KiB) Viewed 1245 times

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer

Post by mikeinterserv » Thu Jan 21, 2021 10:18 pm

Post by paulfeakins » Fri Jan 22, 2021 7:51 pm

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk

Post by paulfeakins » Fri Jan 22, 2021 7:51 pm

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk

Post by paulfeakins » Fri Jan 22, 2021 7:53 pm

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk