Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Problem, it's saying "5 - Out of memory" in admin and on cart


geekgirl

Recommended Posts

Posted

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!!!!!

Posted

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.

Posted

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...