Post by Lembo » Tue Apr 30, 2019 7:51 am

Hello,
I was wondering why when i edit order it duplicate in the order table in mysql Database
It's weird that same order has more than order id because it's duplicated after editing
how to avoid duplicating orders?

Newbie

Posts

Joined
Wed Oct 17, 2018 9:56 am

Post by rjcalifornia » Tue Apr 30, 2019 12:17 pm

Lembo wrote:
Tue Apr 30, 2019 7:51 am
Hello,
I was wondering why when i edit order it duplicate in the order table in mysql Database
It's weird that same order has more than order id because it's duplicated after editing
how to avoid duplicating orders?
How did you edit the order and how did you notice it duplicated?

Image


Active Member

Posts

Joined
Fri Sep 02, 2011 1:19 pm
Location - Worldwide

Post by Lembo » Wed May 01, 2019 3:40 pm

rjcalifornia wrote:
Tue Apr 30, 2019 12:17 pm
Lembo wrote:
Tue Apr 30, 2019 7:51 am
Hello,
I was wondering why when i edit order it duplicate in the order table in mysql Database
It's weird that same order has more than order id because it's duplicated after editing
how to avoid duplicating orders?
How did you edit the order and how did you notice it duplicated?
Edited Order using the admin panel
Sales tab -> Orders -> Edit " Next to view button "

I've noticed duplicated lines when i tried to export orders to xls file
it returned more than 10 orders while it's shown i have only 8 orders
so i checked the order table at mysql and it had 10 lines of orders
6 lines and 2 duplicated orders which i've edited

Newbie

Posts

Joined
Wed Oct 17, 2018 9:56 am

Post by Lembo » Fri May 03, 2019 11:29 am

Is there is anybody can help?

Newbie

Posts

Joined
Wed Oct 17, 2018 9:56 am

Post by OSWorX » Sun May 05, 2019 6:21 pm

Lembo wrote:
Fri May 03, 2019 11:29 am
Is there is anybody can help?
Not really.
Because when editing orders, they are not duplicated - in a default installation.
Maybe you have additional extensions installed?

It would be also helpfully, if you post the used OpenCart version (see Forum rules!).

Custom Development | Individuelle Entwicklung | Support & Bugfixes

Image Image Image


User avatar
Guru Member

Posts

Joined
Mon Jan 11, 2010 10:52 pm
Location - Austria

Post by rjcalifornia » Tue May 07, 2019 11:17 am

Lembo wrote:
Wed May 01, 2019 3:40 pm
rjcalifornia wrote:
Tue Apr 30, 2019 12:17 pm
Lembo wrote:
Tue Apr 30, 2019 7:51 am
Hello,
I was wondering why when i edit order it duplicate in the order table in mysql Database
It's weird that same order has more than order id because it's duplicated after editing
how to avoid duplicating orders?
How did you edit the order and how did you notice it duplicated?
Edited Order using the admin panel
Sales tab -> Orders -> Edit " Next to view button "

I've noticed duplicated lines when i tried to export orders to xls file
it returned more than 10 orders while it's shown i have only 8 orders
so i checked the order table at mysql and it had 10 lines of orders
6 lines and 2 duplicated orders which i've edited
That's not normal, usually doesn't happen. Which extensions you have in your store?

Image


Active Member

Posts

Joined
Fri Sep 02, 2011 1:19 pm
Location - Worldwide
Who is online

Users browsing this forum: No registered users and 2 guests