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 08-07-2002 22:10:57

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

Installation Issues - CCP5 - Summary

Hello everyone.  It seems that some of the installs you're trying to do are resulting in errors.  There were a number of posts on the forum today that addressed these.  Most of these posts have been removed in order to address the issues in one consolidated post.

First off, the program should install on any server out there and not require the installation of any Perl modules on the server to get it running.  The program does use DBI and DBD::AnyData (both Perl modules) that are contained in the ./cgi-bin/modules directory.  Both of these modules can run in pure perl mode, which means they don't need to be installed (compiled) by your host.

We installed the program via FTP (zip) and SSH (.tar.gz) on a number of platforms and everything tested out fine.  It seems from the posts we've seen that anyone doing a .tar.gz install via SSH is not having any issues.  That means there is an issue with how some of you are uploading files via FTP.

That said, let's address some of the errors you're seeing:

### DBD::AnyData SQL Errors

DBD::AnyData::st execute failed: Can't use string ("CAN'T FIND COLUMN NAMES ON FIRST") as an ARRAY ref while "strict refs" in use at /home/user/public_html/ccp5/cgi-bin/modules/AnyData.pm line 126, <GEN0> line 2.

DBD::AnyData::st fetchall_arrayref failed: Attempt to fetch row from a Non-SELECT statement at /usr/local/etc/httpd/sites/poesia.com/htdocs/cgi-local/ccp5/library/common/database.pl line 407

These two errors seem to be common.  If you are receiving these errors it means that the program is having trouble reading your database tables.  The tables are stored in the ./data/tables directory and all have a .csv extension.  They need to be uploaded in ASCII mode, as they are text files.  You may need to modify your FTP client's upload configuration to make sure these files are transferred as ASCII.

If anyone has an issue after those files are uploaded as ASCII, please reply to this post and we'll research further.

### Can't locate Perl Module DBI

Can't locate DBI.pm in @INC (@INC contains: D:/Perl/lib D:/Perl/site/lib . d:/html/users/railsnwcom/html/cgi-bin/cccp5/modules) at d:/html/users/railsnwcom/html/cgi-bin/cccp5/library/common/initialize.pl line 189, <DATA> line 64.

This problem popped up once, but is very easy to fix.  Make sure the file DBI.pm was uploaded to the ./cgi-bin/modules directory.

### Registration Issue

During registration: Cannot connect to central registration server.

This issue only showed up once as well.  Our registration server goes offline between 12 AM and 12:10 AM each night to run backups and other cron tasks.  Perhaps registration was attempted during that time period?

### General Perl Module Issues

Please note that Perl modules have the extension .pm and are found in the ./cgi-bin/modules directory.  These files need to be uploaded in ASCII mode too.

### HTML Errors

<BODY BGCOLOR="13981" MARGINHEIGHT="13981" MARGINWIDTH="13981" TOPMARGIN="13981" BOTTOMMARGIN="13981" RIGHTMARGIN="13981" LEFTMARGIN="13981" ALINK="13981" VLINK="13981" LINK="13981"

If you're seeing something like what's shown above in your HTML source and you see a black or blue screen when acessing admin, you most likely have an issue with your .csv files.  Try to re-upload them as ASCII and this should correct the problem.


Nick Hendler

Offline

 

#2 08-07-2002 22:15:47

Guest
Guest

Re: Installation Issues - CCP5 - Summary

I did a tar.gz install both times - we are running a cobalt Raq3i:

### HTML Errors

<BODY BGCOLOR="13981" MARGINHEIGHT="13981" MARGINWIDTH="13981" TOPMARGIN="13981" BOTTOMMARGIN="13981" RIGHTMARGIN="13981" LEFTMARGIN="13981" ALINK="13981" VLINK="13981" LINK="13981"

If you're seeing something like what's shown above in your HTML source and you see a black or blue screen when acessing admin, you most likely have an issue with your .csv files. Try to re-upload them as ASCII and this should correct the problem.

 

#3 08-07-2002 22:22:06

Guest
Guest

Re: Installation Issues - CCP5 - Summary

Well, my problem is not handled in the above solutions. It's detailed at <A HREF="https://forum.kryptronic.com/viewtopic.php?id=425">https://forum.kryptronic.com/viewtopic.php?id=425</A>

Thanks-
Rich

 

#4 08-07-2002 22:24:27

Guest
Guest

Re: Installation Issues - CCP5 - Summary

I'm having the DBD::AnyData errors.  I just checked, and my database (CSV) files are all in ASCII.

 

#5 08-07-2002 22:26:50

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

Re: Installation Issues - CCP5 - Summary

In that case, email ec@kryptronic.com your FTP login info and we'll take a look in the morning.  Thanks.


Nick Hendler

Offline

 

#6 08-07-2002 22:36:19

Guest
Guest

Re: Installation Issues - CCP5 - Summary

Thank you for your prompt response, But just to let you know I still having some of the problem with the table not been reading I upload the files via FTP in SCSII mode and even reload them twice

Thank you once again

 

#7 08-07-2002 23:43:37

Guest
Guest

Re: Installation Issues - CCP5 - Summary

This does not cover our issue.  We install via SSH, checked permissions, etc. and we are receiving this error:

DBD::AnyData::db do failed: Parse error near at /home/blinds/public_html/ccp5/cgi-bin/modules/DBD/AnyData.pm line 126.

 

#8 08-08-2002 00:14:28

Guest
Guest

Re: Installation Issues - CCP5 - Summary

I still get the same issue too.  Help please!!!

 

#9 08-08-2002 08:15:25

JohnG
Member
Registered: 05-08-2002
Posts: 49

Re: Installation Issues - CCP5 - Summary

>This does not cover our issue.
> We install via SSH,
>checked permissions, etc. and we
>are receiving this error:
>
>DBD::AnyData::db do failed: Parse error near
>at /home/blinds/public_html/ccp5/cgi-bin/modules/DBD/AnyData.pm line 126.

This is the same case for me "JohnG" posted elsewhere. This happened after 0777'ing a previous file and then I proceeded to 0777 this AnyData.pm file but same error... Thanks

Offline

 

#10 08-08-2002 00:17:21

Guest
Guest

Re: Installation Issues - CCP5 - Summary

What about ....

Script Execution Error
The following error was just encountered:

/home/ipen4/indianapen-www/cgi-bin/ccp/library/common/initialize.pl did not return a true value at cp-app.cgi line 47, <DATA> line 64.

On both app and admin

 

#11 08-08-2002 01:10:36

Guest
Guest

Re: Installation Issues - CCP5 - Summary

>That said, let's address some of
>the errors you're seeing:
>
>### DBD::AnyData SQL Errors
>
>DBD::AnyData::st execute failed: Can't use string ("CAN'T FIND COLUMN NAMES ON FIRST") as an ARRAY ref while "strict refs" in use at /home/user/public_html/ccp5/cgi-bin/modules/AnyData.pm line 126, <GEN0> line 2.
>
>DBD::AnyData::st fetchall_arrayref failed: Attempt to fetch
>row from a Non-SELECT statement
>at /usr/local/etc/httpd/sites/poesia.com/htdocs/cgi-local/ccp5/library/common/database.pl line 407
>
>These two errors seem to be
>common.  If you are
>receiving these errors it means
>that the program is having
>trouble reading your database tables.
> The tables are stored
>in the ./data/tables directory and
>all have a .csv extension.
> They need to be
>uploaded in ASCII mode, as
>they are text files. 
>You may need to modify
>your FTP client's upload configuration
>to make sure these files
>are transferred as ASCII.
>
>If anyone has an issue after
>those files are uploaded as
>ASCII, please reply to this
>post and we'll research further.

Yep.  Still having the problem.  I uploaded them in ASCII twice.

Here is the exact error received.

<Wed Aug  7 23:54:28 2002> cp-admin.cgi:
<Wed Aug  7 23:54:28 2002> cp-admin.cgi: Execution ERROR: Can't use string ("CAN'T FIND COLUMN NAMES ON FIRST") as an ARRAY ref while "strict refs" in use at /home/cgi-bin/cp/modules/AnyData.pm line 126,  line 2.
<Wed Aug  7 23:54:28 2002> cp-admin.cgi:  called from /home/cgi-bin/cp/library/common/database.pl at 345.
<Wed Aug  7 23:54:28 2002> cp-admin.cgi:
<Wed Aug  7 23:54:28 2002> cp-admin.cgi: DBD::AnyData::st fetchall_arrayref failed: Attempt to fetch row from a Non-SELECT statement at /home/cgi-bin/cp/library/common/database.pl line 407.
DBD::AnyData::st fetchall_arrayref failed: Attempt to fetch row from a Non-SELECT statement at /home/cgi-bin/cp/library/common/database.pl line 407.

 

#12 08-08-2002 01:21:48

Guest
Guest

Re: Installation Issues - CCP5 - Summary

Re uploaded the tables again (third time) using ASCII reset CHMOD 777 on all after upload to make sure. 

CGI Error Log
Here you can view any recent CGI errors that were logged.

<Thu Aug  8 00:03:47 2002> cp-admin.cgi:
<Thu Aug  8 00:03:47 2002> cp-admin.cgi: Execution ERROR: Can't use string ("CAN'T FIND COLUMN NAMES ON FIRST") as an ARRAY ref while "strict refs" in use at /home/cgi-bin/cp/modules/AnyData.pm line 126,  line 2.
<Thu Aug  8 00:03:47 2002> cp-admin.cgi:  called from /home/cgi-bin/cp/library/common/database.pl at 345.
<Thu Aug  8 00:03:47 2002> cp-admin.cgi:
<Thu Aug  8 00:03:47 2002> cp-admin.cgi: DBD::AnyData::st fetchall_arrayref failed: Attempt to fetch row from a Non-SELECT statement at /home/cgi-bin/cp/library/common/database.pl line 407.
DBD::AnyData::st fetchall_arrayref failed: Attempt to fetch row from a Non-SELECT statement at /home/cgi-bin/cp/library/common/database.pl line 407.


I double checked.  The paths are correct.  /home on my server automatically routes to my root directory. 

 

#13 08-08-2002 03:18:24

thekiko
Member
Registered: 07-11-2002
Posts: 126

Re: Installation Issues - CCP5 - Summary

Eh... how about this.

http://www.game-skins.com/ccp5/cgi-bin/cp-app.cgi

I don't even get the luxury of recieving an error message.  Just to prove that I know what I am doing and the validity of my server please check my CCP4 install here http://www.game-skins.com/cp/cgi-bin/cp-app.cgi (however ugly it may be, but it does function properly)

I SSH'd the ccp5.tar.gz to my Cobalt RaQ4 (linux).  I regret joining the CCP family at this late date as the recent events have not given much to be positive about.

Any help would be appreciated.


TheKiko

Offline

 

#14 08-08-2002 03:47:33

Guest
Guest

Re: Installation Issues - CCP5 - Summary

All appropriate files uploaded in ascii mode (of course wink ) and still getting the error:

DBD::AnyData::st execute failed: Can't use string ("CAN'T FIND COLUMN NAMES ON FIRST") as an ARRAY ref while "strict refs" in use at /home/user/public_html/ccp5/cgi-bin/modules/AnyData.pm line 126, <GEN0> line 2.


Myros


 

#15 08-08-2002 05:44:32

Emiliano
Member
Registered: 08-07-2002
Posts: 13

Re: Installation Issues - CCP5 - Summary

I'm still doing some tests, I have a tar.gz installation and a FTP installation. Both ends up with the same error:

DBD::AnyData::st fetchall_arrayref failed: Attempt to fetch row from a Non-SELECT statement at /usr/local/etc/httpd/sites/poesia.com/htdocs/ccp5/ccp5/cgi-bin/library/common/database.pl line 407

I was wondering why the TAR.GZ put the /data/tables/*.csv with permissions like 0775 when the readme file says set to 0777 the whole dir and its contents

regards
Emiliano

Offline

 

#16 08-08-2002 06:55:58

Emiliano
Member
Registered: 08-07-2002
Posts: 13

Re: Installation Issues - CCP5 - Summary

I reinstall the stuff for the third time.
This are the errors I give every time
(FTP AND SSH install give the same errors) 

1) /ccp5/cgi-bin/cp-app.cgi   returns a BLANK WIDE screen with all the paths and links wrong

BODY BGCOLOR="144141" MARGINHEIGHT="144141" MARGINWIDTH="144141" TOPMARGIN="144141" BOTTOMMARGIN="144141" RIGHTMARGIN="144141" LEFTMARGIN="144141" ALINK="144141" VLINK="144141" LINK="144141"

A HREF="144141&pg=splash">home</
A HREF="144141&pg=store">online store</A
A HREF="144141&pg=cart">shopping cart</A
A HREF="144141&pg=ste_chkout_proc">checkout


2) Then I delete the /data/tables/*.csv , upload again in ASCII mode, set the permissions to 0777 and the error change to:

DBD::AnyData::st fetchall_arrayref failed: Attempt to fetch row from a Non-SELECT statement at /usr/local/etc/httpd/sites/poesia.com/htdocs/ccp5/cgi-bin/library/common/database.pl line 407




Offline

 

#17 08-08-2002 06:59:56

Guest
Guest

Re: Installation Issues - CCP5 - Summary

Yes, I wonder about permissions too.  I've installed via the tar.gz file  I have the following error. 

Script Execution Error
The following error was just encountered:

DBD::AnyData::db do failed: Parse error near at /usr/lib/perl5/site_perl/5.6.1/DBD/AnyData.pm line 126

Because of a post you (webmaster) made earlier about permissions the confusion is there.  You said the tables should be 0777 but yet the tar.gz file set them to 0755.  Please let us know what is correct. 

Will (Same Host as Myros)  smile 

 

#18 08-08-2002 07:14:34

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

Re: Installation Issues - CCP5 - Summary

The files in the cgi-bin on back should be 755, everything else 777.  We've gota number of FTP logins for the various install issues people are having and we will be working out the issues today.  Please stay tuned here for updates.

We may be releasing an easier to install version later today if these issues are within the program.  If the issues are all user/install related, we'll be updating our FAQ and posting details here.


Nick Hendler

Offline

 

#19 08-08-2002 08:12:26

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

Re: Installation Issues - CCP5 - Summary

For the colored screens, we were able to determine that some older versions of Perl are not interpolating variables correctly in ./cgi-bin/library/common/display.. When using split, the older version do not like:

$display_line =~ s/<CGIVAR>(.*?)</CGIVAR>/$$1/ges;

But work fine with:

$display_line =~ s/<CGIVAR>(.*?)</CGIVAR>/display_print_var($1)/ges;

and the creation of a new routine.  Needless to say, we'll be patching the software later today.  If you're seeing this issue, it looks like everything else is working fine.

Now on to some of the other issues.


Nick Hendler

Offline

 

Board footer