Guest Posted November 13, 2007 Share Posted November 13, 2007 I get the following error when trying to run. catalog path: /home/xxxxx/public_html/ languages array built currencies array built taxes array built countries array built categories array built Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/xxxxx/public_html/includes/functions/database.php on line 44 2008 - MySQL client ran out of memory SELECT s.*, cd.*, c.*, ptc.*, mi.*, m.*, pd.*, p.*, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id LEFT JOIN manufacturers_info mi ON m.manufacturers_id = mi.manufacturers_id AND pd.language_id = mi.languages_id LEFT JOIN products_to_categories ptc ON pd.products_id = ptc.products_id LEFT JOIN specials s ON ptc.products_id = s.products_id LEFT JOIN categories c ON ptc.categories_id = c.categories_id LEFT JOIN categories_description cd ON c.categories_id = cd.categories_id AND pd.language_id = cd.language_id WHERE pd.language_id IN(1) AND p.products_status = 1 ORDER BY p.products_id [TEP STOP] Quote Link to comment Share on other sites More sharing options...
Guest Posted November 14, 2007 Share Posted November 14, 2007 I get the following error when trying to run. catalog path: /home/xxxxx/public_html/ languages array built currencies array built taxes array built countries array built categories array built Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/xxxxx/public_html/includes/functions/database.php on line 44 2008 - MySQL client ran out of memory SELECT s.*, cd.*, c.*, ptc.*, mi.*, m.*, pd.*, p.*, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id LEFT JOIN manufacturers_info mi ON m.manufacturers_id = mi.manufacturers_id AND pd.language_id = mi.languages_id LEFT JOIN products_to_categories ptc ON pd.products_id = ptc.products_id LEFT JOIN specials s ON ptc.products_id = s.products_id LEFT JOIN categories c ON ptc.categories_id = c.categories_id LEFT JOIN categories_description cd ON c.categories_id = cd.categories_id AND pd.language_id = cd.language_id WHERE pd.language_id IN(1) AND p.products_status = 1 ORDER BY p.products_id [TEP STOP] THIS IS WHEN SUING FEEDMACHINE.......... I KNOW THE PROBLEM IS memory. Any wah tto modify so it writes directly to disk? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.