saltandl Posted December 20, 2005 Posted December 20, 2005 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
kwalker Posted December 20, 2005 Posted December 20, 2005 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?
saltandl Posted December 20, 2005 Author Posted December 20, 2005 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
♥Vger Posted December 21, 2005 Posted December 21, 2005 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
saltandl Posted December 21, 2005 Author Posted December 21, 2005 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
saltandl Posted December 23, 2005 Author Posted December 23, 2005 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
AlanR Posted December 23, 2005 Posted December 23, 2005 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)
dukesgrl Posted December 24, 2005 Posted December 24, 2005 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
saltandl Posted December 30, 2005 Author Posted December 30, 2005 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.
ozcsys Posted December 30, 2005 Posted December 30, 2005 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??
Recommended Posts
Archived
This topic is now archived and is closed to further replies.