Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 10-07-2003 20:51:54

cybermed
Member
From: Burke Va - US
Registered: 09-06-2001
Posts: 54
Website

Upgrade Error Importing Your Online Catalog:

When I upgrade to TIKI 5.1 from 5.0 I get an error:

"Page can not be displayed"

On Step 3 of 6 - Importing your online catalog:

I suspect the reason why I get the error is that I have ALL my data in MYSQL and and NOT in the data files. Any help please?  Evan

PS CCP keeps getting better and better, Keep up the good work Nick!

Offline

 

#2 10-08-2003 07:09:22

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19871
Website

Re: Upgrade Error Importing Your Online Catalog:

Are you doing a MySQL to MySQL import/export?  Ie. are both CCP5 and CCP5.1 in MySQL using different databases?  You're having a timeout issue on the server side.  This means that the data set is too large to process in the time being allowed by the server.  This can become an issue quickly if you've got CCP5 data in MySQL and CCP5.1 data in CSV.  Try doing a MySQL to MySQL import/export and see if that happens in the alotted time.


Nick Hendler

Offline

 

#3 05-07-2004 16:46:45

Jesus
Member
Registered: 05-07-2004
Posts: 14

Re: Upgrade Error Importing Your Online Catalog:

Hello,

I don't have any information on a database, i think all of our information its located on csv the files and i'm getting the same error (Server time out probably) as i'm getting a blank page during the upgrade process.

Any help will be appreciatte it wink

Jesus

Offline

 

#4 05-07-2004 16:54:01

scoutch
Member
Registered: 07-03-2003
Posts: 3167

Re: Upgrade Error Importing Your Online Catalog:

I ... never thought I'd say this kind of nickname on this forum . . .

Anyway.

Now, since you did tried to upgrade with mySQL database, I'm pretty sure this server time out issue could be related to a server loading time problem. I'd call my ISP about this and get more information.

Also, if this only happends when using Perl modules, you might want to get some information from Perldiver (free web tools - downloadable) and capture the Perl Server Module's version.


______________________________________________

THIS USER HAS BEEN BANNED FROM THIS FORUM.

If this post contains any language related to
code samples, advice, etc., please read this
entire thread before making a decision to use
this post as a basis for any change to your
software installation.
______________________________________________

Offline

 

#5 05-07-2004 17:06:05

Jesus
Member
Registered: 05-07-2004
Posts: 14

Re: Upgrade Error Importing Your Online Catalog:

smile Thanks scoutch

i didn't try to upgrade using mysql, how can i try it, as i was saw on the post mysql to mysql, i really don't know if we're doing this using mysql.... i'm just trying to do the upgrade but i never did the 1st installation (5.0) so right now we're upgrading the system as we need to be 100% compatible with Authorize.net

So, i was following all the time the instructions on the documentation to make the upgrade and then i got to the point with the blank page.... how can i be sure i'm using mysql (from the program admin)? and how can i upgrade the data from 5.0 to 5.1

Thanks again for your answer,

Jesus

Offline

 

#6 05-07-2004 17:27:11

scoutch
Member
Registered: 07-03-2003
Posts: 3167

Re: Upgrade Error Importing Your Online Catalog:



I didn't try to upgrade using mysql, how can i try it

In your admin section, go to : Database Utilities and choose SQL database given by your hosting service.

Then, fill up your account info in the form and press submit. From there, try the upgrade again. You should get a better result.


______________________________________________

THIS USER HAS BEEN BANNED FROM THIS FORUM.

If this post contains any language related to
code samples, advice, etc., please read this
entire thread before making a decision to use
this post as a basis for any change to your
software installation.
______________________________________________

Offline

 

#7 05-10-2004 10:48:04

Jesus
Member
Registered: 05-07-2004
Posts: 14

Re: Upgrade Error Importing Your Online Catalog:

Hi scoutch, thanks again for your answer and sorry for my delay to answer you, i was on my way back home during the weekend.

I just did what you recommend me and i've the same problem, i'm getting a page not found message after i press the submit button on the page where i'm asked for the paths from my v5.0

Also i notice that on my previuos version (5.0) i'm not using mysql, what else could be wrong?

Thanks again for your help,

Jesus

Offline

 

#8 05-10-2004 10:51:34

scoutch
Member
Registered: 07-03-2003
Posts: 3167

Re: Upgrade Error Importing Your Online Catalog:

In this case, post your URL. I will take a look at it.

In the mean time, please post your web error logs about this issue. It will be easier to determine the problem.


______________________________________________

THIS USER HAS BEEN BANNED FROM THIS FORUM.

If this post contains any language related to
code samples, advice, etc., please read this
entire thread before making a decision to use
this post as a basis for any change to your
software installation.
______________________________________________

Offline

 

#9 05-10-2004 12:31:26

Jesus
Member
Registered: 05-07-2004
Posts: 14

Re: Upgrade Error Importing Your Online Catalog:

Hello scoutch....

ERROR LOG

Mon May 10 05:30:48 2004] [error] [client 210.243.203.145] File does not exist: /www/sportstube/sumthin [Mon May 10 10:47:28 2004] [error] [client 201.135.35.228] File does not exist: /www/sportstube/ccp51/cgi-bin/ccp51/cp-app.pl [Mon May 10 10:47:33 2004] [error] [client 201.135.35.228] File does not exist: /www/sportstube/ccp51/cgi-bin/ccp51/cp-app.pl You (sportstube) are not allowed to use this program (crontab) You (sportstube) are not allowed to use this program (crontab) You (sportstube) are not allowed to use this program (crontab)


I notice the file doesn't exists error: File does not exist: /www/sportstube/ccp51/cgi-bin/ccp51/cp-app.pl

my paths are:
$server_script_path = "/home/www/sportstube/cgi-bin/ccp51";
$server_data_path = "/home/www/sportstube/ccp51/data";
$server_media_path = "/home/www/sportstube/ccp51/media";

$url_script_path = "http://www.sportstube.com/cgi-bin/ccp51";
$url_media_path = "http://www.sportstube.com/ccp51/media";

Thanks in advance,

Jesus

Offline

 

#10 05-10-2004 12:54:55

scoutch
Member
Registered: 07-03-2003
Posts: 3167

Re: Upgrade Error Importing Your Online Catalog:

In this case, download Perldiver from the web (free tool) and upload the script into the cgi-bin folder.

Then, set the CHMOD 755 on Perldiver.cgi file.

Then, run perldiver.cgi from the web.

You should all your server paths in there. Just follow the paths that Perldiver gives you and input them into cp-app.pl and cp-admin.pl file.

As for this :



You (sportstube) are not allowed to use this program (crontab) You (sportstube) are not allowed to use this program (crontab) You (sportstube) are not allowed to use this program (crontab)

I'd suggest you send a tech support request to your hosting service (if Perldiver also fails). It looks to me like some permissions has not been set from the server related to your server account.

(It happened to me the first times on my account, I had to notify my ISP about this problem. Everything was fine since then).


______________________________________________

THIS USER HAS BEEN BANNED FROM THIS FORUM.

If this post contains any language related to
code samples, advice, etc., please read this
entire thread before making a decision to use
this post as a basis for any change to your
software installation.
______________________________________________

Offline

 

#11 05-10-2004 13:27:40

Jesus
Member
Registered: 05-07-2004
Posts: 14

Re: Upgrade Error Importing Your Online Catalog:

What i really don't understand very well... why the program are looking for the file on: File does not exist: /www/sportstube/ccp51/cgi-bin/ccp51/cp-app.pl

and not on the paths i define.

As you might see the file not found it's inside:

/www/sportstube/ccp51/cgi-bin/ccp51/

and the paths are:

/home/www/sportstube/cgi-bin/ccp51



also checking my paths using the file path.cgi, i'm getting

SERVER PATH: /home/www/sportstube/cgi-bin 
SCRIPT_FILENAME: /www/sportstube/cgi-bin/path.cgi




Offline

 

#12 05-10-2004 13:30:30

scoutch
Member
Registered: 07-03-2003
Posts: 3167

Re: Upgrade Error Importing Your Online Catalog:

Replace this :

/www/sportstube/ccp51/cgi-bin/ccp51/

to read :

/home/www/sportstube/cgi-bin/ccp51


______________________________________________

THIS USER HAS BEEN BANNED FROM THIS FORUM.

If this post contains any language related to
code samples, advice, etc., please read this
entire thread before making a decision to use
this post as a basis for any change to your
software installation.
______________________________________________

Offline

 

#13 05-10-2004 15:36:22

Jesus
Member
Registered: 05-07-2004
Posts: 14

Re: Upgrade Error Importing Your Online Catalog:

I currently have it that way.

My current paths are:

$server_script_path = "/home/www/sportstube/cgi-bin/ccp51";
$server_data_path = "/home/www/sportstube/ccp51/data";
$server_media_path = "/home/www/sportstube/ccp51/media";

$url_script_path = "http://www.sportstube.com/cgi-bin/ccp51";
$url_media_path = "http://www.sportstube.com/ccp51/media";

Jesus

Offline

 

#14 05-10-2004 15:39:56

scoutch
Member
Registered: 07-03-2003
Posts: 3167

Re: Upgrade Error Importing Your Online Catalog:

And what's Perldiver's version about this ?


______________________________________________

THIS USER HAS BEEN BANNED FROM THIS FORUM.

If this post contains any language related to
code samples, advice, etc., please read this
entire thread before making a decision to use
this post as a basis for any change to your
software installation.
______________________________________________

Offline

 

#15 05-10-2004 16:12:35

Jesus
Member
Registered: 05-07-2004
Posts: 14

Re: Upgrade Error Importing Your Online Catalog:

sad i'm still waiting for the password to have acces and download the perldiver software

in the mean time i'm using a program called path.cgi

and you can download it from here:

Offline

 

#16 05-10-2004 16:13:29

Jesus
Member
Registered: 05-07-2004
Posts: 14

Re: Upgrade Error Importing Your Online Catalog:

i just got the email from them, let me install the software.

Offline

 

#17 05-10-2004 16:21:30

Jesus
Member
Registered: 05-07-2004
Posts: 14

Re: Upgrade Error Importing Your Online Catalog:

I installed perldiver 2.31 and under the Environment Variables i see this:

SCRIPT_FILENAME /www/sportstube/cgi-bin/perldiver/perldiver.cgi
SCRIPT_NAME /cgi-bin/perldiver/perldiver.cgi

Thanks,

Jesus

Offline

 

#18 05-10-2004 17:25:23

scoutch
Member
Registered: 07-03-2003
Posts: 3167

Re: Upgrade Error Importing Your Online Catalog:

No problem. smile


______________________________________________

THIS USER HAS BEEN BANNED FROM THIS FORUM.

If this post contains any language related to
code samples, advice, etc., please read this
entire thread before making a decision to use
this post as a basis for any change to your
software installation.
______________________________________________

Offline

 

#19 05-10-2004 17:40:06

Jesus
Member
Registered: 05-07-2004
Posts: 14

Re: Upgrade Error Importing Your Online Catalog:

sorry scoutch, do i need to use this new paths? (the ones showed by perldiver)

Jesus

Offline

 

#20 05-10-2004 17:43:10

scoutch
Member
Registered: 07-03-2003
Posts: 3167

Re: Upgrade Error Importing Your Online Catalog:



sorry scoutch, do i need to use this new paths? (the ones showed by perldiver)

Yes, that is the point.

Just replace those :



/www/sportstube/cgi-bin/perldiver/perldiver.cgi
/cgi-bin/perldiver/perldiver.cgi

To read :

Code:


$server_script_path = "/www/sportstube/cgi-bin/ccp51";
$server_data_path = "/www/sportstube/ccp51/data";
$server_media_path = "/www/sportstube/ccp51/media";

$url_script_path = "http://www.yourdomainname.com/cgi-bin/ccp51";
$url_media_path = "http://www.yourdomainname.com/ccp51/media";

In your cp-app.cgi and cp-admin.cgi files.

In the mean time, rename your data folder for security reasons.


______________________________________________

THIS USER HAS BEEN BANNED FROM THIS FORUM.

If this post contains any language related to
code samples, advice, etc., please read this
entire thread before making a decision to use
this post as a basis for any change to your
software installation.
______________________________________________

Offline

 

#21 05-10-2004 17:59:02

Jesus
Member
Registered: 05-07-2004
Posts: 14

Re: Upgrade Error Importing Your Online Catalog:

I'm still getting the same error... it's a timeout... well anyway, we just have 3 products, i'll add the products myself.. the thing i'm worried about it it's the way the current store looks right now, can i use the same inteface? without redoing all the work?

Jesus

Offline

 

#22 05-10-2004 18:03:25

scoutch
Member
Registered: 07-03-2003
Posts: 3167

Re: Upgrade Error Importing Your Online Catalog:

Looks to me like a simple bad configuration entry somewhere in your cart. E-mail me for more info on this.


______________________________________________

THIS USER HAS BEEN BANNED FROM THIS FORUM.

If this post contains any language related to
code samples, advice, etc., please read this
entire thread before making a decision to use
this post as a basis for any change to your
software installation.
______________________________________________

Offline

 

Board footer