geekgirl Posted August 14, 2010 Posted August 14, 2010 Hey there! So basically I had a "fatal error" problem on the top_application.php page but fixed it with your posts! Thanks!! However, i still have another problem! When i log into admin on the right side is the customers and the left is the orders. Where the orders are supposed to be it says: 5 - Out of memory (Needed 1042720 bytes) select o.orders_id, o.customers_name, greatest(o.date_purchased, ifnull(o.last_modified, 0)) as date_last_modified, s.orders_status_name, ot.text as order_total from orders o, orders_total ot, orders_status s where o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '1' order by date_last_modified desc limit 6 Also, when you go into the store on the left side where it has the top products purchased instead of that list it says: 5 - Out of memory (Needed 1042492 bytes) select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 10 [TEP STOP] Please please please help!!!!!
Jan Zonjee Posted August 14, 2010 Posted August 14, 2010 Also, when you go into the store on the left side where it has the top products purchased instead of that list it says: 5 - Out of memory (Needed 1042492 bytes) It sounds as if you have a lot of orders. For the top products purchased you could try the Faster also purchased module.
Jan Zonjee Posted August 14, 2010 Posted August 14, 2010 select o.orders_id, o.customers_name, greatest(o.date_purchased, ifnull(o.last_modified, 0)) as date_last_modified, s.orders_status_name, ot.text as order_total from orders o, orders_total ot, orders_status s where o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '1' order by date_last_modified desc limit 6 I think that if you change that query to order by o.orders_id desc instead of order by date_last_modified desc (would that be a big difference for who deals with that info - guess not) the difference could be measurable.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.