Store Manager processes and Memory Time outs - Any workaround?

[Jeffey]

1.3.8a all security updates.

I’m on a shared server on Dreamhost and sometime back I was getting server errors when trying to run the Reset Master Category ID in Store Manager. After a lot of back and forth and noting that my store was not a big one (about 5,000 items) they adjusted for that one process so I can run it again.

However, I still could not run things like Google sitemap and when I noticed ( for the first time!) that the price sort wasn’t working for new items I tried to run the Update Price Sorter and got similar time out related errors. The process was killed by the server essentially as it was for the master ID.

My question is, is there anyway to do any/all of the Store Manager procedures via the SQL database itself or some other method?

Thanks for reading!

[Jeffey]

Mmm, seems to only be a couple of categories I recently added to and looking at past, but recent, updates most of those seem ok so maybe it will sort itself out?

Still interested in what can be done outside of the Admin. if anyone knows.

[Ajeh]

Edit the file:
/admin/store_manager.php

around line 25 is:
zen_set_time_limit(600);

Set that to 900 ... does it work? If not, how about 1200?

How many categories do you have?

Do you use Specials? Sales? Attributes? Price by Attributes?

[Jeffey]

Thanks!

I got/get different responses with each try but these are typical (along with page not found).

900:

Fatal error: Out of memory (allocated 16777216) (tried to allocate 75 bytes) in /home/SITE/includes/classes/db/mysql/query_factory.php on line 246

1200:

0
in:
[select products_tax_class_id, products_price, products_priced_by_attribute, product_is_free, product_is_call from products where products_id = '11790' limit 1]
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.

1500:

Fatal error: Out of memory (allocated 16777216) (tried to allocate 512 bytes) in /home/SITE/includes/classes/db/mysql/query_factory.php on line 248

About 285 Categories/subcategories.

All items have a sale price. Product price update works from Store Manager though I think the host may have made an exception with that particular process. It was a back and forth discussion and frankly all I can remember is it started to work again (could also have been a DB issue with restart to fix).

Very few attributes. Only a handful.

[Jeffey]

Another 1500 resulted in:

2008 MySQL client ran out of memory
in:
[select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included from products_attributes where products_id = '11787' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, price_prefix, options_values_price]
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.

[Ajeh]

You really appear to be on a server with memory limitations ...

Sale Maker does add a lot to what has to be done on the calculations, but I would not think it would be that sever ...

Without actually trying your database on another server ...

What happens if you turn off the Sales?

[Jeffey]

Thanks for the help.

Yeah, silly too for a host that provides a one click install of Zen and this store is not large by any means. Things work on a smaller store on the same host but ridiculous to break on 6,000 items. Used to work until they "upgraded".

Turning off sales isn't an option.

I already do my metas via SQL query and trying the same with price sorter but must have the update command wrong.

Could you suggest the query to simply update the price sorter based on the product_id?

Sorry for the newbie one, I usually just update and insert and not sure why update isn't working - just get "failed" with no information. I've tried a couple of formats already.

[Jeffey]

Got it, must have typed wrong:

UPDATE products
SET products_price_sorter=65
WHERE products_id=15017

Will that work or do I need to do something else?

[Jeffey]

Ooops, only one at a time?

Scratch that and "Duh!", needed to end each with ; and not ,

[Jeffey]

Thanks again for the time, always appreciate it.

Ok, seems to work but do let me know if anything else needs to be done/updated.

My updates are getting pretty intensive!
I'm lucky to have an legacy offline database but had to do similar steps to create scripts for metas, google maps & base and now price sorting! Of course easy populate too (thanks for that at least! though I have to stop that one but it populates before it craps out).

Dread the idea but have to move eventually, kind of waiting on the new version as it sounds like it might help.