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.
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.
Offline
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.
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
I'm having the DBD::AnyData errors. I just checked, and my database (CSV) files are all in ASCII.
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
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.
I still get the same issue too. Help please!!!
>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
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
>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.
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.
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.
Offline
All appropriate files uploaded in ascii mode (of course ) 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
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
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
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)
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.
Offline
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.
Offline