I've had a problem with my eshop for several months. I still couldn't solve it. I have a 500 error several times a day. Too many queries to the database.
Today I accidentally logged in to the shop under my account from the front. And I found out that I have 136 products in my cart. Can't the problem be somewhere in the settings? in cache? Something wrong? I have always logged into administration only.
I have a new, really good hosting.
Joomla 3.9.5
VirtueMart 3.4.2
php 7.1
memory_limit 2048M
max_execution_time 300
Forcibly terminating processes due to lack of memory.
Date Process
05.05.2019 17:16 php-cgi
have you turned off VM404 error handling!
Quote from: AH on May 07, 2019, 00:23:43 AM
have you turned off VM404 error handling!
yes
Please check where those visits come from and block the bots.
I have the same problem in my site, which turned out to be bots calling my site.
Have a look here:
https://www.seoblog.com/2018/03/block-bots-spiders-htaccess/
Perhaps also check if you do have a 'huge' session table in your database or a 'huge' session folder on the server?
Some time ago I had memory problem because I did hit the maximum allowed webspace on the server (too many subfolders for testing).
Quote from: jjk on May 07, 2019, 17:01:17 PM
Perhaps also check if you do have a 'huge' session table in your database or a 'huge' session folder on the server?
Some time ago I had memory problem because I did hit the maximum allowed webspace on the server (too many subfolders for testing).
(https://i.postimg.cc/JDrtvbk8/db.png) (https://postimg.cc/JDrtvbk8)
I think the problem is that you have 136 products in the cart.
Remove the entry in XXX_virtuemart_carts for your virtuemart_user_id
Quote from: Studio 42 on May 07, 2019, 18:44:38 PM
I think the problem is that you have 136 products in the cart.
Remove the entry in XXX_virtuemart_carts for your virtuemart_user_id
I deleted items manually. But I don't understand how they got there. I suspect there's a mistake somewhere. Which may be related to speed problems.
The screenshot doesn't include the size column. I would also look into the sh404sef cache folder. Almost 24000 urls in the table and maybe a huge amount of megabytes in the cache folder.
QuoteBut I don't understand how they got there
multiple test 'add to carts' over time? You said this was the account u use for testing...
Quote from: GJC Web Design on May 07, 2019, 22:17:44 PM
QuoteBut I don't understand how they got there
multiple test 'add to carts' over time? You said this was the account u use for testing...
Yes. but I haven't been on the site for months. I perform tests on e-shop as anonymous.