Fatal Error

[Crin]

Hi,

I have a client who has been using this excellent product sucessfully for over a year, there database is massive and contains over 20'000 items!

Today for no apprarent reason they started reciving this error when trying to add new featured products...

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 2955142 bytes) in /home/sites/wallofsound-records.com/public_html/admin/featured.php on line 267

Does anybody know what might have caused this?

Crin :)

[DrByte]

What version of Zen Cart?
What version of PHP?
What version of MySQL?

[Crin]

MYSQL 5.0.45

Zen Cart 1.3.7

PHP 4.4.7

[DrByte]

Is this what that line says? ...

[font="courier"] <td class="main"><?php echo (isset($fInfo->products_name)) ? $fInfo->products_name . ' <small>(' . $currencies->format($fInfo->products_price) . ')</small>' : zen_draw_products_pull_down('products_id', 'size="5" style="font-size:10px"', $featured_array, true, $_GET['add_products_id'], true); echo zen_draw_hidden_field('products_price', (isset($fInfo->products_price) ? $fInfo->products_price : '')); ?></td>[/font]

[Crin]

Yup that's it.

<td class="main"><?php echo (isset($fInfo->products_name)) ? $fInfo->products_name . ' <small>(' . $currencies->format($fInfo->products_price) . ')</small>' : zen_draw_products_pull_down('products_id', 'size="5" style="font-size:10px"', $featured_array, true, $_GET['add_products_id'], true); echo zen_draw_hidden_field('products_price', (isset($fInfo->products_price) ? $fInfo->products_price : '')); ?></td>

[DrByte]

What addons/contributions do you have installed?

[Crin]

None really but there's a lot of custom mods to the product related pages to allow for the sale of records.

[DrByte]

Your database is running rather slow for its retrieval of the 37,000 records.
I tested the same database on my own PC running XAMPP, just to check for bottlenecks (rather than messing with your live site), and found that I got results back from my PC's MySQL in about 350 milliseconds. But yours took 50,194 milliseconds ... to bring back the same data. Granted, a large portion of that time will be the transfer of the actual data ... so, maybe it's not "that" bad.

The only way to work around both the slowdown and your server's very low memory_limit in PHP was to tell it to ignore the memory_limit when drawing the Featured and Specials pulldowns. On my test server, using 64M seemed to be just fine.

Recommendation:
Get your host to change their PHP "memory_limit" configuration from the default of 8M to 32M or 64M instead. (64 would be better, esp with your large database).

[Crin]

Thanks! I just PM'd you but i'l reply here anyways.

The database is VERY slow, i've been trying to work out why, could this be the memory limit too? if not what could i do to speed things up?

Crin

[DrByte]

Thanks! I just PM'd you but i'l reply here anyways.

The database is VERY slow, i've been trying to work out why, could this be the memory limit too? if not what could i do to speed things up?

It's not the PHP memory_limit setting. It's likely MySQL memory issues though.

You'll have to work with your hosting company about that. I suspect they've got insufficient RAM assigned to the MySQL processes, including its own built-in caching settings.