Salemake won't load

Ok I have searched the forum ect and can't find the answer. I am trying to set up a sale for my entire store, I go to salemaker and hit the new sale button to start to create the sale, it takes forever to load but when done I get the page not found stuff. How do I fix this. It seems that the page to create the new sale just isn't there?
Zen Cart 1.3.7
Database Patch Level: 1.3.7

Check that the files in the /admin are all loaded correctly ...

If you have no admin changes you can just reload that directory to see if this corrects the problem with a bad or corrupt file that may be affecting Sale Maker ...

Are you using any Add-ons?

Has this ever worked for you?

NOTE: upgrading to v1.3.8 is always a good plan ...
http://www.zen-cart.com/forum/showthread.php?t=81696

Hi Linda,

this is weird,
its like its timing out, but there is NO way with the amount of resources I have thrown at this,

the only thing I can think of is it has to do with the attirbutes there are a few million attributes

How many products and categories are on sale?

about 20,000 total products

The issue is that it wont even go beyond the add a sale button

How many Categories are there all together?

45 categories and 24,500 products 1.62 Million attributes

I think I would have to peek at this as I am not seeing anything that would address a long delay just pushing the Add button ...

The slowest process would be on the update of the products_price_sorter for these products ...

Ok have a new problem just started at the same time as this. I just got off the phone with Tina on it. We had specials prices up on the site but needed to change the whole site pricing so I uploaded with EZ Populate all the new prices, changed the start & stop date but it did not end the old specials so Tina went into the data base and got rid of the specials there,she said to be sure to say she did not erase the database for specials, now for some reason the prices showing on the site are 7% below the list price we put in that would be the exact amount of the taxes. Tina & I can not figure out why. She said if u need to call her. Could this be part of the trouble?

Look in phpMyAdmin and browse the products table ...

Do you have master_categories_id values set on all of the products?

I did not know so I called Tina she set all that up. She went in and redid it just to be sure and it still does the same thing. Would you like a log in so you can look at it?

Go ahead and PM me ... and when I have time I will peek and see if I can see anything loopy here ...

Such a user moment I had ...

20,000+ categories ...

Sale Maker has to load a line on the screen for each of those categories so that you can check mark which ones get the sale ...

20,000 lines of information, at a minimum, must draw on your screen ... must come across the internet, thru your connection, to send all the little bites until all 20,000+ lines are drawn ...

So ... yowser ... 20,000+ lines both sent and recieved must happen ... :eek:

This means your monster file must transmit to you ... and, in addition, it has to processes on the server for all those categories and subcategories and most likely, this will help locate a lot of inefficiencies in the Category structure if things are not 100% perfect ... :unsure:

So ... Sale Maker is not going to be your friend and you will just blow up when you hit that key for Insert Sale ... :lamo:

If you do hit the button and finally get the white page, and if you did a View Source and waited long enough for the View Source to draw all of what it couldn't draw on the white page, you may end up seeing some things ...

This would have to be majorly customized for you to add Sales to utilize Sale Maker ...

Same with adding Specials ... you would need to use the extra feature where you can add a special by products_id vs scroll through the products due to the size ...

I would like to see this in v1.3.8 to see what all the upgrades to that have managed to do to optimize your site/database as v1.3.7 was not as efficient ...

I would not attempt to upgrade a Live site or even a semi-working existing site until you have done it successfully a few times on a test site in a test database ...

But this is the mystery here ...

Too many lines of data that is attempting to draw inside a <table> and <tables> require that the last byte be drawn before showing anything ...

Got your coder hat on and ready to do your upgrade? Oh and it would be a good idea to customize your Admin to manage such a large gang of categories and products more efficiently ... but for that, I would have to fool with your site for several hours to tweak here and there to make things much more efficient ...