Hi, I'm running a fresh install of opencart 3.0.3.8. The reason I'm running a fresh install is because the last opencart I was working on started to show some weird behaviour, which was as follows: when I placed a new order this was being saved in the oc_order table but not being saved in the oc_order_history table, hence it was not showing up on the front- nor back-end. So I thought to myself, let me do a fresh install of opencart as the behaviour may be due to some mods I had running.
I have now a fresh install of opencart and I could place an order successfully. However when I went to make a new order, I got the order successful screen but the same thing has happened i.e. the order is being saved in the oc_order table but not in the oc_order_history table.
To try and debug I then deleted the first order, to see if this had anything to do with the customer not being to place a new order whilst there was an existing order pending, but this didn't solve the problem.
To debug even more I then decided to create a new user account, but the same thing has happened, i.e. the new user can place a successful order but this is not being saved in the oc_order_history table.
Has anyone heard of this before? I have come to a complete standstill now. A fresh install of oc allows me to make one order and one order only.
When I write that I am running a fresh install of oc, I mean that it's a complete new download of oc on a new directory with new database tables, i.e. a completely fresh install with no mods, nothing!
Impossible.
From where you have downloaded oc 3.0.3.8?
Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer
I agree, it's impossible, but the impossible has become possible. I downloaded the file from https://www.opencart.com/index.php?rout ... ad/history.
The order is written just after the payment method is confirmed and just prior to the order confirmation page is send.
The order history is written by the payment method itself after the order is confimed.
Just before the order history is written though, the order confirmation emails and alerts are send out by events.
So if the order is written but the order history is not, chances are that you have an issue with the payment method and/or the email events.
The order history is written by the payment method itself after the order is confimed.
Just before the order history is written though, the order confirmation emails and alerts are send out by events.
So if the order is written but the order history is not, chances are that you have an issue with the payment method and/or the email events.
DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.
Spinning Social : Links : Menus : Payments : Socials : Ads : Screen Backgrounds : Galleries : Headers : Banners : Promos
Why are you looking directly at database tables?
Isn't the order history table only populated when you view an order and add order history?
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Thanks for the help so far with this. I have found the solution, but I have no idea what the solution is and wonder if you can help with this?
My server guy suggested that I clear the cache between orders, so I tried this today and it worked like a charm. So when I place an order, I then clear my browser cache, then I can successfully make a new order which is then saved in the order_history table, with the admin being notified via email, and with the customer being able to view the order in their order history.
So the question is, why is this happening? As I've said originally, this is happening with e fresh oscommerce install.
Thanks / Luke
My server guy suggested that I clear the cache between orders, so I tried this today and it worked like a charm. So when I place an order, I then clear my browser cache, then I can successfully make a new order which is then saved in the order_history table, with the admin being notified via email, and with the customer being able to view the order in their order history.
So the question is, why is this happening? As I've said originally, this is happening with e fresh oscommerce install.
Thanks / Luke
It looks like this hit the nail on the head, thank you! I'll continue reading up about this, for now the fix works and I'm happy for this. I read on github that this may also be due to cloudflare so I'll do some more digging and chat with my server guys.xxvirusxx wrote: ↑Sun Jan 29, 2023 3:19 amAdd this fix, and try again
viewtopic.php?t=206449#p786660
Once again, thank you very much, this has plagued me for a week!!!
/ Luke
Who is online
Users browsing this forum: No registered users and 19 guests
