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 1024 times
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
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.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
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 974 times
Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer
Attachments
whataboutthis.png (46.48 KiB) Viewed 910 times
Code: Select all
ALTER TABLE `oc_order` AUTO_INCREMENT = 1;
And you can delete that test orders.
Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer
@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.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
@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.
Attachments
autoincr.png (21.3 KiB) Viewed 882 times
Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer
it is not working. error received. 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 851 times
Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer
I imagine you are getting close to getting NO help at all here :-)ideep13 wrote: ↑Thu Jan 21, 2021 7:43 pmfrom 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
You want help but you don't want to explain the reason for your problem?
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.
Again you're speaking gibberish.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Correct.mikeinterserv wrote: ↑Thu Jan 21, 2021 10:18 pmI imagine you are getting close to getting NO help at all here :-)
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
You're right it's easier to understand now the title has been edited to might slightly more sense.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Users browsing this forum: No registered users and 140 guests