allowed memory size error

[tautou]

i've searched around here and through google and still haven't been able to come up with an answer. i've tried optimizing and repairing my tables and still can't quite figure out what's going on. heres the error:

[25-Feb-2013 23:26:33 UTC] PHP Fatal error:  Allowed memory size of 94371840 bytes exhausted (tried to allocate 4137290 bytes) in /home/SITE/includes/classes/cache.php on line 127

and the relevant code:

$result_serialize = $db->prepare_input(base64_encode(serialize($zf_result_array))); 

  function sql_cache_store($zf_query, $zf_result_array) {
    global $db;
    $zp_cache_name = $this->cache_generate_cache_name($zf_query);
    switch (SQL_CACHE_METHOD) {
      case 'file':
      $OUTPUT = serialize($zf_result_array);
      $fp = fopen(DIR_FS_SQL_CACHE . '/' . $zp_cache_name . '.sql',"w");
      fputs($fp, $OUTPUT);
      fclose($fp);
      return true;
      break;
      case 'database':
      $sql = "select * from " . TABLE_DB_CACHE . " where cache_entry_name = '" . $zp_cache_name . "'";
      $zp_cache_exists = $db->Execute($sql);
      if ($zp_cache_exists->RecordCount() > 0) {
        return true;
      }
      $result_serialize = $db->prepare_input(base64_encode(serialize($zf_result_array)));
      $sql = "insert into " . TABLE_DB_CACHE . " set cache_entry_name = '" . $zp_cache_name . "',
                                                 cache_data = '" . $result_serialize . "',
                   cache_entry_created = '" . time() . "'";
      $db->Execute($sql);
      return true;
      break;
      case 'memory':
      return true;
      break;
      case 'none':
      default:
      return true;
      break;
    }
  } 

[DrByte]

That's a PHP error, and thus repairing or optimizing tables won't solve the problem.

The problem is rooted in what you're trying to make your site do beyond original Zen Cart core code. So, as a start to knowing how exactly your site differs from original Zen Cart code, please click Reply below and answer the first 10 questions in the Posting Tips section, as we need to know those details about your site.

[gilby]

Some mods such as user tracking can chew up memory
One site I have this on had to have the memory upped to 128mb before it would work reliably
What mods do you have installed?

[tautou]

What version of Zen Cart are you using? v 1.5.1
Has your site been upgraded? When? From what version(s)? No
What plugins/addons have you installed? When? Easy Populate 4, Ultimate SEO
HOW did you install Zen Cart? (upload via FTP and run zc_install, or a one-click install from your hosting company? One click install, then zc-install
What version of PHP and MySQL is your server using? (See Admin->Tools->Server Info) MySQL -> 5.1.66; PHP -> 5.3.13
WHEN did the problem "start"? How does that compare with other events of your hosting company, changes you've made to your site files/addons, or your admin settings, etc? The problem started after I attempted to add a category, using the ZenCart method, not importing anything
If this is your first store, have you tested all aspects of transactions before going live? I do not believe this applies
In what ways is your site customized or different from a brand new uncustomized install? Installed plugins, using abagon theme
If you're encountering problems that could be related to your server or hosting company, include the name of your hosting company (not their URL). using DreamHost

[tautou]

does anyone have any thoughts? i really don't want to have to reinstall the whole program again.

[terraGirl]

90MB is not a lot for memory allowance. A quick fix would be to ask your host to increase memory allowance, or to switch host to someone with higher settings.

For your site to work you should look for 128MB memory_limit which is very reasonable and should be supported by hosts specialising in eCom sites. Or to future proof, look for 256MB.