Jump to content
Sign in to follow this  
polowrx

can someone help?

Recommended Posts

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]

Share this post


Link to post
Share on other sites
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?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×