Jump to content

Allowed memory size of 67108864 bytes exhausted


Recommended Posts

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

 

post-484012-0-80572300-1368551131_thumb.jpg

 

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 by Mystikal (see edit history)
Link to comment
Share on other sites

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 by Mystikal (see edit history)
Link to comment
Share on other sites

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

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 by Mystikal (see edit history)
Link to comment
Share on other sites

  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

  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

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

×
×
  • Create New...