[DONE v1.3.9d] Featured Products in Admin Area Timeout

[jdw1979]

I have 30,000 products in the inventory on my site. When I try to add featured products, the area times out and I am left looking at the nav-bar and a big blank white area. Help!

Dale

[jdw1979]

My best guess as to how to deal with this is to actually go into phpMyAdmin and make the changes to the "featured" table in the database. Is there any other tables in the database that deals with these features?

Dale

[Ajeh]

Because the Featured and Specials generate a dropdown of all products so that they can be added and this can be overwhelming in size on sites with large numbers of Products ... there is an input box for manually entering the products_id ...

Also, see if you can access the Catalog ... Products Price Manager ... or is that timing out too?

[jdw1979]

The Catalog isn't timing out, but the Products Price Manager is. Where is that input box for the products_id? I didn't see it in the featured products area, or any of the other areas. Thanks for your help, by the way.

Dale

[Ajeh]

What version of Zen Cart are you running?

When you go to Catalog ... Specials ... you should see on the right panel:

Select
Product ID to be Manually Added as a Special

Hit the button and enter your products_id that you want to add a Special to ... the same is on Featured Products ...

Without actually seeing your site, it is hard to say if the time outs are due to the 30,000 products or a slow server ...

Many of these dropdowns with all of your products listed are timing out because while they can grab the list very quickly, that list of 30,000 products has to download via the browser to you and that is the part that is timing out ...

[jdw1979]

Attached is a screenshot of what I'm looking at in the Admin on the specials page. I'm using Zen Cart version 1.3.8a, and I'm hosted by Godaddy...with what is supposed to be the best hosting package they offer.

Dale

[Ajeh]

Aha! A clue ...

With 0 Specials, the side panel does not show ...

To get around this, the first time, go to Tools ... Install SQL Patches ... and run this command:

INSERT INTO specials (products_id) VALUES ('1');

Now go to your Zen Cart Admin and go to Catalog ... Specials ... and you should see the one we added as well as the side panel ...

Add your first special ...

Now, delete the one we added ...

You can do the same with Featured if you need it with:

INSERT INTO featured (products_id) VALUES ('1');

[jdw1979]

Sweet! It worked beautifully! Thank you so much!

Dale

[jtlswan]

I need to bump on this...I'm using 1.3.9c (upgraded from fresh install of 1.3.9a) and am having the exact problem (Same issue as Dale, to many products and explorer is timing out, also using GoDaddy). I tried doing the SQL patches Linda mentioned and it still is not working...any ideas? Please? Thanks in advance for any help!

JTLS

[Ajeh]

How many Products do you have?