2008:MySQL client ran out of memory

[mespe]

Getting this error many times, what to do? I recently installed a responsive template (sheffield blue) so I'm sure it has to do with that install


[18-May-2016 22:29:02 America/Phoenix] PHP Fatal error: 2008:MySQL client ran out of memory :: select products_description from zen_products_description where products_id = '1578'
and language_id = '1' in /includes/classes/db/mysql/query_factory.php on line 120


19-May-2016 01:15:55 America/Phoenix] PHP Fatal error: 0: :: select products_tax_class_id, products_price, products_priced_by_attribute, product_is_free, product_is_call, products_type from zen_products where products_id = '141' limit 1 in /includes/classes/db/mysql/query_factory.php on line 120


18-May-2016 22:29:02 America/Phoenix] PHP Fatal error: 2008:MySQL client ran out of memory :: select products_description from zen_products_description where products_id = '1578' and language_id = '1' in /includes/classes/db/mysql/query_factory.php on line 120

[mespe]

A few more errors

[21-May-2016 10:13:50 America/Phoenix] PHP Fatal error: 2008:MySQL client ran out of memory :: select products_id, products_quantity_order_units from zen_products where products_id = '786' in /includes/classes/db/mysql/query_factory.php on line 120

[21-May-2016 10:14:06 America/Phoenix] PHP Fatal error: 2008:MySQL client ran out of memory :: select products_tax_class_id, products_price, products_priced_by_attribute, product_is_free, product_is_call, products_type from zen_products where products_id = '1690' limit 1 in /includes/classes/db/mysql/query_factory.php on line 120

[21-May-2016 10:19:31 America/Phoenix] PHP Fatal error: 2008:MySQL client ran out of memory :: select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zen_products_attributes where products_id = '1742' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value in /includes/classes/db/mysql/query_factory.php on line 120

[mespe]

Here's my query_factory.php

//line 109
function show_error() {
if ($this->error_number == 0 && $this->error_text == DB_ERROR_NOT_CONNECTED && !headers_sent() && file_exists('nddbc.html') ) include('nddbc.html');
echo '<div class="systemError">';
if (defined('STRICT_ERROR_REPORTING') && STRICT_ERROR_REPORTING == true)
{
echo $this->error_number . ' ' . $this->error_text;
echo '<br />in:<br />[' . (strstr($this->zf_sql, 'db_cache') ? 'db_cache table' : $this->zf_sql) . ']<br />';
} else {
echo 'WARNING: An Error occurred, please refresh the page and try again.';
}
trigger_error($this->error_number . ':' . $this->error_text . ' :: ' . $this->zf_sql, E_USER_ERROR);
if (defined('IS_ADMIN_FLAG') && IS_ADMIN_FLAG==true) echo 'If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.<br />';
echo '</div>';
}
//line 124

[mespe]

I have no idea what that is telling me, any help is appreciated

[kobra]

What about your server details??
In the posting tips at the top when you reply

[mespe]

decided to forego these issues, so I installed 1.55a now I get a warning
Your database appears to need patching to a higher level. See Tools->Server Information to review patch levels.

[kobra]

I get a warning
Your database appears to need patching to a higher level.

Re run zc_install and select upgrade Database only

[DrByte]

PHP Fatal error: 2008: MySQL client ran out of memory

That's MySQL complaining that it doesn't have enough memory to run the query submitted to it.
(What's particularly odd is that the query quoted is extremely simple.)
Only your hosting company has access to tweak the tuning of the MySQL database engine to allow for bigger caches and connections.

Your database appears to need patching to a higher level.

As kobra said, you need to finish the upgrade by running zc_install to update the database. Or your data is in tables denoted by a different DB_PREFIX than what you've configured the new site to use.

[DrByte]

Seems you've resolved it by setting the DB_PREFIX to match properly, per: https://www.zen-cart.com/showthread....82#post1311482