Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
We're getting an internal server error while accessing the tea commerce backend store in Umbraco.Not every time but can see sometimes.
Any idea on why this is happening. Please do let me know
Can you please provide details of the actual error? Stack trace etc? Otherwise we have nothing to go off.
This the screenshot from client. Any license issue?
It looks like your SQL connection is timing out. It may be worth profiling the database to see if you have any long running queries and whether any new DB index's might be required to optimize queries.
How many orders do you have in your database? If it's a lot, it could be worth deleting old orders that were never completed (TC creates and keeps orders for all cart sessions).
Hope this helps
Upon checking the TC order table. We had 348880 orders :(
Yea, that's quite a lot of orders.
You could run a SQL script like
DELETE FROM TeaCommerce_Order WHERE DateFinalized IS NULL AND DateModified < DATEADD(y, -1, GETDATE())
Which should delete all non finalized orders that we not modified in the last year.
Of course, always take a backup before performing such a task.
Thanks a lot, Matt appreciates the support
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted