Kryptronic Software Support Forum

a URL usually helps so we can see what your are talking about and help from there,

You might also want to check with your host to see if they have changed anything with their servers.  The program would not just stop working without sometype of change in the configuration.

Yea that is the first thing I asked. He told me they have not changed a thing. Plus we did a restor5e from a backup that was working fine. I am at a total loss to figure out how something could go bad like this.

I really do not know how to proceed here.

Tim G.

Hey Guys:

Does this mean anything to you. It should to me but I can't figure out where this code is coming from.

<TD WID

This shows up on my splash page. So I know that somewhere I got some broken code. I can get into the admin panel but I do not see this anywhere on the splash page html. I also do not see it in cp-app.cgi

I am assuming this is part of a CGI call. Here is the splash page again.



At this point I am just trying to run down everything to see if this finally gives me some clues.

Thanks.

Opinion anyone?

When I go into the catalog (in cp-admin.cgi) and edit a product and flip the switch to show it on the splash page, all I get is this (on the splash page).

<IMG SRC="http://www.uncletim.com

The product does not render and I am sure this code is not suppose to be present.

This seems to tell me that the code for this is broken.

When I try to view my catagories in cp-admin.cgi they do not show at all. In fact all I get is a blank page. I know that is not right.

Does anyone know the perl file name for the catagory page information. Maybe I could replace it and see what happens.

Maybe this is a question for Nick:

Is there a way to do a complete reinstall and one at a time reinstall my data files?

What I want to do is get a fresh sopy up and then once I am sure it is running okay, reload my own product files and condifuration files and see which one makes it break.

Does that make sense?

Tim G.

I think something else is going on. There are just too many aspects that are corrupt.

In fact when I look at product.csv, I do not find any html in it.

But there are just too many other things missing such as;

All Categories Sidebar
The Information Sidebar
The Store Links Sidebar

All the links on the bottom of the page.

I cannot go into the store at all. I get script errors. All I can do is get to the search page (thorugh the shopping cart link at the top) but there is very little there, just a blank search term form and no search criteria drop down. All the side bars are gone! Nothing below. This thing is hosed badly. It's like half it's brain was removed.

I totally reinstalled a good backup copy, set the rights again and same thing. I got a brain dead shipping cart that does not even come close to responding correctly (no offence intended).

There are so many parts of this system missing, I can't imagine actually trouble shooting it.  I have the same shopping cart installed on anothere web site on the same server and it is fine. I even checked the settings against it.

Do you think Nick would mind if I set up another instance of this software on this server just to see if that will work.

I am at a loss, this really seems like something outside of my control is hindering me.

Thanks for taking a look.

Tim G.

Thanks for asking.

Yes I did and I get what I would expect. A bunch of failed scripts.

Here is an typical exerpt.

[Wed Jul 21 20:22:07 2004] [error] [client 67.173.254.158] Premature end of script headers: /home/uncletim/public_html/cgi-bin/ccp51/cp-app.cgi
[Wed Jul 21 20:16:36 2004] [error] [client 67.173.254.158] File does not exist: /home/uncletim/public_html/500.shtml
[Wed Jul 21 20:16:36 2004] [error] [client 67.173.254.158] Premature end of script headers: /home/uncletim/public_html/cgi-bin/ccp51/cp-app.cgi
[Wed Jul 21 22:16:24 2004] [error] [client 67.173.254.158] Premature end of script headers: /home/uncletim/public_html/cgi-bin/ccp51/cp-app.cgi
[Wed Jul 21 20:04:18 2004] [error] [client 67.173.254.158] File does not exist: /home/uncletim/public_html/500.shtml


I set up a fresh copy of Tiki and updated it successfully to CCP 5103

I did it right next to the real copy and no problem. I got it up and updated within 30 minutes.

So I have the right permissions and the server has no problem with this.

Now I am curious as to what options I may have to get my actual data in this without reinstalling it all the manual way.

I believe somehow some files went corrupt. That is totally a guess. But it seems to make sense.

Do you see anything in these error logs that I don't?

Once again thanks for asking.

Tim G.

I downloaded perldiver and got it up and running. Thanks. I don't see where it provides any information on cgi wrap.  Any pointers?

I do believe this is wrapped up in permissions or something like that.

I don't get how I could get another copy up in  no time but I can't seem to trouble shoot this.

Thanks for your input, it really does help.

Tim G.

Uncletim,07/22/2004 10:29:09 AM wrote:

I downloaded perldiver and got it up and running. Thanks. I don't see where it provides any information on cgi wrap.  Any pointers?

I do believe this is wrapped up in permissions or something like that.

I don't get how I could get another copy up in  no time but I can't seem to trouble shoot this.

Thanks for your input, it really does help.

Tim G.

For the wrap issue , basically if you could execute perldiver , wrap is okay for that location . so it sounds like wrap is okay . 

Okay here is another tip , if you have shell access try executing your admin.cgi script from the shell command line . it should give you the line that its failing on and maybe a little more info on whats causing the premature script failure . Then take a look at the line that it fails at , normally it fails because it can't find or can't open something . Typically if your paths are all good then its a permissions or percieved corruption ( like a binary upload of a script ) try chmoding everything to 777 and see what happens

If you are just totally stuck , I would be willing to go in on your shell and go through it and try and get it running for you . if you want to do that just email me your login info .

Hi Tim,

I had this same problem twice with CCP.  The only thing that showed up on the screen was broken HTML.   I made sure that there werent any problems in my html code and still the cart would not function properly.

Both times this happened when my ccp files were copied to a new domain.  The first problem was due to a row in my product table.  The row had a very long description and was somehow goofing things up.  The row was removed and ccp worked glitch free.

The second time this happened, exact same symptoms as yours, it was due to my cart using to many resources up.  The cart would not function correctly when the product table was running in CSV mode.  After the move all the tables were running in CSV mode when prior to tyhe move they were running in MYSQL. To fix this, after many hours of frustration, I switched all my tables except for the product table to run in MYSQL and the cart began to work flawlessly.  Import and export of the product table from mysql to csv mode worked without a glitch.

First thing you must do is create a mysql database for ccp.  If you have a cpanel
function through your website administartion utility these are the steps.

In your web accounts cpanel go to |site management tools | MYSQL Databases |.

Go to create a mysql database and name your db: (ex. *ccp*)

Now click on create MYSQL Database

Now when you go back to the MYSQL database page you should see the database you just created prefixed with your web accounts user name: (ex. *tim_ccp*)

Now you need to create a username and password to link to your new database.
In the |site management | Mysql databases| page of your cpanel account (hoping that you use cpanel) scroll down to add mysql user or existing mysql user and add your username and password:
    EX.
    Username: mountain
    Password: 1234 (your username will be prefixed with your web accounts username)(ex. *tim_mountain*)

Now scroll down to grant permissions on your mysql table to your MySql user. In the text drop down box where it says USER select your username (ex. *tim_mountain*), and your DATABASE name (ex. *tim_ccp*).

Now select the *all* box radio button and click on grant permissions.  After granting permissions when you go back you'll notice your database and username are now linked together and your MYSQL table is ready to configure with ccp.

Now go into ccp admin | Data Base Utilities | Configure RDBMS Connection |.

Select your RDBMS Server Type and hit submit.

Now just fill in the fields:

    ex.
    Host Name: localhost
    Database Name: tim_ccp
    Username: tim_mountain
    Password: 1234

Click submit and your MYSQL table should now be linked with CCP.

Now you should be ready to convert your ccp tables from CSV to MYSQL. In CCP Admin go to | Data Base Utilities | Manage Table Data Sources |.  Just click on *change* for whichever tables you would like to run in MYSQL.  That should do it.    

Mysql is definately the way to go , faster , much more reliable and nice convenient backups for the entire database . ( just go into backups in your cpanel and there is a seperate one just for your MySql databases ) Especially if you have a large number of records .
Glad to see you got it back up and running !