Kryptronic Software Support Forum

It is 99% likely that you are editing your CSV's in the wrong type of editor, and it is saving them as ASCII documents.  CSV's need to be both saved and uploaded in BINARY only, or they will crash and burn.

Lisa

Thanks for the replies

Lisaweb, i'm opening the files in Excel and saving them as CSV in Excel, uploading them in Binary mode via FTP, chmod to 777.

Also, through much testing and assistance with this from Terry at hosttec.net, he has uploaded my databases on another clean install and they worked perfectly. So we've 99.9% ruled out that it's the database.

Currently the whole thing works like this:

The home page loads fine. In fact, click on Store Home and all the category placeholders, etc. all go perfectly. The category list is pefect, yada yada. Now, click on a category and it explodes. But, do a search for say, Charlie Brown. The results show up perfectly, no explosion in the category list, click on a product in the results and it takes you to the description page, etc. But click on a category and it comes unglued.

We've gone through the database and taken out any duplicates, i've stripped any HTML tags from any product descriptions and category descriptions. I've designed this layout page twice since I thought the same thing..that it was a broken tag. BUT, if I use the exact same page and upload the default CCP5 database files for product, category, and prodxcat then the page works perfectly and there's no problems. But upload mine and there's a problem. BUT, keep in mind that on another install my databases worked perfectly on a default site layout!

Something is happening in the category function that is either not parsing all the HTML, or gives up, or is looking for something. What I can't understand is, if the category area is going to 'break' then it should be broken no matter what page or link you hit. So on the home page of the cart it should be broken if there's tag missing. It would be broken on any page.

So, i'm lost!

Greg..if you could do that it would be MUCH appreciated! I have spent DAYS on this and am totally baffled. Terry, the guy that is helping me (and is a reseller) is totally baffled.

I think there's a cosmic vortex hanging over this install!

Greg/Nick:
I have avoided editing the CSV files so far, as I am running Office 97, and am unsure if Excel 97 is compatible with CCP5. Any thoughts/tips on this, or do I have to upgrade to 2000?
Thanks in advance!

I have a feeling this is a server resource limitation issue and the category names are just red herrings.  Are the categories that you're failing on holding more items that the ones that you're not failing on?
___________________________

Nick Hendler
Webmaster, Kryptronic, Inc.

Have you tried to perl the script on the command line:

perl cp-app.cgi pg=cat ref=powerpuffgirls

Have you checked the server error logs?

If the program is bombing on your layout and not the default, I still think it's an httpd issue.  It may be choking on a bit too much HTML or something.  If your perl command using the shell outputs the entire HTML page, you know you have a webserver issue.  Your logs may be able to tell you what that issue is.

___________________________

Nick Hendler
Webmaster, Kryptronic, Inc.

Nick, it appears as though you're on track with the server issue. Terry set up yet another store using my HTML and my databases and it works fine. Looks a little funky...but works

So the question is, is there a specific module that we would need to make this work?

I'll send you a personal email with a link to a view of the current server config and modules installed.

Hi Nick:

I had a short conversation with the tech people at the host. Apparently there ARE some limitations based upon how long a script takes to run it's functions and the problem is most likely that it's timing out.

I haven't gotten confirmation of this but here's his comments:

"It doesn't sound like a httpd.conf configuration problem, with that many entries its probably a resource restriction problem.  Each cgi script is only allowed a certain amount of ram and cpu seconds before being killed off to prevent a single script from eating all resources and causing server issues.  These are not very tight restrictions but they do prevent a number of people from backing up their mysql database using cgi (which if you ask me is not really a good or reliable idea anyways.)  It takes some time to load a page with only 4 products on it.. it doesn't seem to efficient..   are there any options or other configurations to make it so?? Is it loading images from the database as well??"

Nick, your thoughts on this? Do you think that by switching to MySQL instead of CSV that it could help this problem?