I have an issue with me Opencart admin.
I have a server with a couple of websites on including a forum also. I had issues with too many sql connections so asked the provider to look into it. They said them made some changes and used PHP-FPM .
See below quote
Code: Select all
Ultimately it seems since Sam made that change the server has been more stable and doesn't seem to have MySQL connection issues. With that in mind what happened earlier is likely that PHP-CGI processes were hanging (for some reason) and this caused the MySQL connections they had to be kept open. So eventually the MySQL max connection limit is hit and the sites start having issues. With PHP-FPM in place these stuck PHP-CGI processes cannot happen any more so the issue shouldn't come up for these sites anymore.
Afterwards I tried to add a sale manually on my opencart store in my admin panel, selecting the customer was fine in step 1, but on step 2 when I try to add a product I do the search and auto complete brings up a list of products, when I select a product and click the add option, nothing happens no product is added no matter how I try, also I noticed if upload an image, it uploads but then its not visible to add, if I later go back to it, I can then add the image.
There was also an issue with the journal theme when I added a different product to the carousel , the full journal control disappeared from the admin panel, and through an error on the store how page, I had to go back to my admin modifications option and refresh cache and the journal control re-appeared.
I'm not sure what has happened but everything was fine before the server change, on reverting it back to the previous settings via the server support , I'm still getting the same issue in opencart...
Can anyone shed any help or advice on this, is it some type of Java issue? How can I check or is it an easy fix or something I'm overlooking.
Any help would be appreciated failing that I'm going to have to look at a server restore and manually add any customers/orders back on from before the date.
Many Thanks