Mystikal Posted May 14, 2013 Share Posted May 14, 2013 (edited) Hello, recently my site is generating a error 500 when I try to view the front office (the back office works perfectly). Activating the display of errors is returned me the error: Quote Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 92 bytes) in /web/htdocs/www.gioielleriacunsolo.com/home/classes/db/DbPDO.php on line 90 By setting the memory limit to -1 I see the page in the attached files I have already tried many of the solutions I've found online for this problem (clean the cache of smarty, restore a backup ...) but the problem is not solved. Can anyone help me? The link of the site is www.gioielleriacunsolo.com Edited May 14, 2013 by Mystikal (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted May 14, 2013 Share Posted May 14, 2013 You're on shared hosting or on dedicated/VPS ? it looks like the mysql server doesn't work well, this may be related to the memory issues Link to comment Share on other sites More sharing options...
Mystikal Posted May 14, 2013 Author Share Posted May 14, 2013 (edited) It's a shared hosting, so it's a problem of the database? EDIT: I've checked my database. It is 744 MB large and the space I purchased is only 100MB. It seems strange that the problem occurred only now though (I suppose) I have long ago exceeded the limit. It is normal that the database is so large (I have 2719 products)? Is this the problem? Edited May 14, 2013 by Mystikal (see edit history) Link to comment Share on other sites More sharing options...
tomerg3 Posted May 14, 2013 Share Posted May 14, 2013 DB size has very little to do with memory size. 744MB is a bit large, but if you have a lot of traffic, most likely the majority of it is in the connections table, which stores history of every page visit. Most likely you installed a new module, or something else that is taking a bit more ram, you should really have 128MB as the minimum. Link to comment Share on other sites More sharing options...
vekia Posted May 14, 2013 Share Posted May 14, 2013 But mysql and innoDB consume a lot of ram, i think that this might be the problem (huge database + queries + high traffic) Can you check in your database which tables take up the most space? Link to comment Share on other sites More sharing options...
Mystikal Posted May 14, 2013 Author Share Posted May 14, 2013 (edited) The biggest table is ps_specific_price (3,840,282 rows and 713.2 MiB). I do not know specifically what it's for, but it seems a bit too big because the other does not exceed 5MB. I forgot a thing. The problem started when I try to install a new theme. However, in an attempt to solve the problem, I deleted everything and loaded a backup made before installing the new theme EDIT: I checked now what contains the table and I may have figured out the problem. I apply a discount on each piece for sale online and I wanted to display the Regular Price, the discount and the final price. I applied, therefore, a cart rule on all the items for sale. Could this be the cause of the huge table? Edited May 14, 2013 by Mystikal (see edit history) Link to comment Share on other sites More sharing options...
tomerg3 Posted May 14, 2013 Share Posted May 14, 2013 This has nothing to do with the DB size. Increase your ram to 128 Link to comment Share on other sites More sharing options...
benjamin utterback Posted May 14, 2013 Share Posted May 14, 2013 On 5/14/2013 at 9:17 PM, Mystikal said: I applied, therefore, a cart rule on all the items for sale. Could this be the cause of the huge table? That is the reason for a large database (not overly huge) but your ram is a little low. Try what tomerg3 suggested that 128 mb should fix it. Ask your hosting provider to increase it temporarily to see if it solves the problem. Link to comment Share on other sites More sharing options...
Mystikal Posted May 14, 2013 Author Share Posted May 14, 2013 On 5/14/2013 at 10:06 PM, Benjamin Utterback said: That is the reason for a large database (not overly huge) but your ram is a little low. Try what tomerg3 suggested that 128 mb should fix it. Ask your hosting provider to increase it temporarily to see if it solves the problem. You mean setting the memory limit in config.inc.php? I try, and I get the screen attached in the first post Link to comment Share on other sites More sharing options...
vekia Posted May 15, 2013 Share Posted May 15, 2013 what's your memory limit? Can you use phpinfo ? You will get information about your memory limit there Link to comment Share on other sites More sharing options...
tomerg3 Posted May 15, 2013 Share Posted May 15, 2013 The current memory is in the error message "Allowed memory size of 67108864 bytes exhausted" Just because you increase it in php.ini, does not mean your server will use that limit, as it's a shared host. Link to comment Share on other sites More sharing options...
Recommended Posts