Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Large Store Setup Causing Admin Catalog Not to Load


saltandl

Recommended Posts

Posted

I have installed using the unzip and ftp method. I created a store at http://www.saltandlightlearning.com/catalog with only about 10,000 items out of our total 17,000 because of my problems. Useing EasyPopulate I imported the data

 

The website loads ok, but Admin catalog/products will not. I get 30 second timeout errors and can't find an answer on how to increase it. I've been troubleshooting this over a month or so with some progress and really need help if I'm going to use osCommerce.

 

I fixed problems with catagories and sub-catagories being named the same. I had some products with no subcatagories thinking that might be the problem but didn't seem to help. I know that there are people with many thousands of products that are using this product, but as I approach 10,000 items, it croaks.

 

My store is setup like this:

 

Category (e.g. Math, Science)

Sub-category (e.g. Curriculum, Supplies)

Publisher/Author A ->

...

Publisher/Author Z - >

Publisher/Author names

Grade Level

 

Do you see a problem with my setup and have suggestions on how to change it?

Are there any mods I can install that may help?

Any help or suggestions would be greatly appreciated.

Mike

Posted

Since you're using easy populate, you may have to split your file and upload that way.

 

Note: there is a support thread for the EasyPopulate. There would be your best place for an answer relating to that contrib. As a matter of fact, mostly all the contribs have their own support thread going.

 

 

Kevin

"What I didn't know yesterday, I know today & will remember tomorrow"

(By Kwalker)

 

What do you see when you open up the tep_database-pr2.2-CVS.pdf file that came with your osCommerce download?

Posted

My problem isn't using EasyPopulate.

 

If you read the post, my problem is that after I load the data, Admin/Catalog won't display. I get the "30 seconds exceeded" error message.

Mike

Posted

If you have access to a local copy of php.ini you can increase the PHP Maximum Execution Time from 30 to 45 or 60 - but I wouldn't go any higher than that.

 

If you don't have access to that file then you can put this in a .htaccess file (Apache Servers only) in the root of your web:

 

php_value max_execution_time 60

 

However, I don't think that is your problem.

 

Vger

Posted
If you have access to a local copy of php.ini you can increase the PHP Maximum Execution Time from 30 to 45 or 60 - but I wouldn't go any higher than that.

 

If you don't have access to that file then you can put this in a .htaccess file (Apache Servers only) in the root of your web:

 

php_value max_execution_time 60

 

However, I don't think that is your problem.

 

Vger

 

I saw a post about this change in the php.ini, however I'm unable to find a php.ini file, and I've looked for one without success. Where would it be? Or can I create one and where would it go?

 

On the htaccess file, I have a htaccess01 in my public_html directory, but it's empty. Suggestions?

Thanks,

Mike

Posted
If you have access to a local copy of php.ini you can increase the PHP Maximum Execution Time from 30 to 45 or 60 - but I wouldn't go any higher than that.

 

If you don't have access to that file then you can put this in a .htaccess file (Apache Servers only) in the root of your web:

 

php_value max_execution_time 60

 

However, I don't think that is your problem.

 

Vger

 

I changed the htaccess file to add this value. It helped to display the catagories, but it's slow to load. And it only helped some. Other areas have problems.

 

Any other ideas? I'm afraid that if I increase the database size, osCommerce won't be able to handle it. I thought we weren't limited on categories, sub-categories or products?

Mike

Posted
I changed the htaccess file to add this value. It helped to display the catagories, but it's slow to load. And it only helped some. Other areas have problems.

 

Any other ideas? I'm afraid that if I increase the database size, osCommerce won't be able to handle it. I thought we weren't limited on categories, sub-categories or products?

Mike

You're not limited on any of those by osC but a wimpy server can still let you down.

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Posted

Hi,

 

Not sure if this will help you any but I had to have my host server make changes between my Disk Usage and Disk Space available. The first question he asked me when I told him the problem was how many items did I have. But I was also getting messages from my server that I had a problem. Check with your server provider and see if they can do something there. Otherwise I suggest you find a new one that can handle your store size.

 

Dukesgrl

Posted
Hi,

 

Not sure if this will help you any but I had to have my host server make changes between my Disk Usage and Disk Space available. The first question he asked me when I told him the problem was how many items did I have. But I was also getting messages from my server that I had a problem. Check with your server provider and see if they can do something there. Otherwise I suggest you find a new one that can handle your store size.

 

Dukesgrl

 

My database is only using 4mb and I have plenty of disk space.

Posted
My database is only using 4mb and I have plenty of disk space.

 

It is not really a matter of disk space but of resources. 10k + products will need a good server especially if you get any amount of traffic.

 

Are you on a dedicated or shared server? You should be able to look at the resources being used on the server when you are trying to open up your catalog. I would do so and see what is going on. If your cpu or memory usage spikes when you are doing so then you will really need to move to a better server or upgrade the one you are on. Your hosting company should be able to help you with checking this out if needed.

The Knowledge Base is a wonderful thing.

Do you have a problem? Have you checked out Common Problems?

There are many very useful osC Contributions

Are you having trouble with a installed contribution? Have you checked out the support thread found Here

BACKUP BACKUP BACKUP!!! You did backup, right??

Archived

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

×
×
  • Create New...