Gossamer Forum
Home : Products : DBMan : Customization :

records.cgi

Quote Reply
records.cgi
Has anyone gotten this to work. It's listed
in the MODS section of the resource center.
Here is the link:
http://www.gossamer-threads.com/...rces/jump.cgi?ID=763

It is supposed to generate a linked list of your categories with record counts of each.
I obviously am doing something wrong as whenever the SSI call in my static shtml page is executed I get blank/zilch/nada

Any help is appreciated.
Quote Reply
Re: records.cgi In reply to
You are most likely configuring it wrong. Yes, I've gotten it to work since I wrote the Mod!

Please save the record.cgi file as a text file, upload it to a publicly accessible directory on your server, and then post the URL where we can find the file.

Also, please provide the exact codes you are using for the SSI call in your .shtml file.

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
----------------------


Quote Reply
Re: records.cgi In reply to
Here you go Eliot:
www.treasure-house.com/records.txt

records.cgi is in my /cgi-bin/dbman directory and has chmoded to 755

The SSI call is cut-and-pasted directly from your instructions :
<!--#exec cgi="/cgi-bin/dbman/records.cgi"-->

I do not get "errors processing this directive" so I guess it is executing. But try www.treasure-house.com/test1.shtml - nothing but nothing.

Let me know if you need anything further.
Quote Reply
Re: records.cgi In reply to
Do you have a field called Category? If not, you need to change Category to the field name that you want to list.

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
----------------------


Quote Reply
Re: records.cgi In reply to
 
Quote:
Do you have a field called Category? If not, you need to change Category to the field name that you want to list.

Yes I do Eliot - In my books.cfg file here is the line that defines Category:
Category => [9, 'alpha', 0, 40, 1, '', ''],
Quote Reply
Re: records.cgi In reply to
I have four suggestions:

1) Make sure that you have changed the permission of the script to 755.

2) Also, make sure that you have the FULL ABSOLUTE PATH for your book.cfg file.

3) Test the script by itself by typing the location of the records.cgi file in your browser. See if the Categories and Record Numbers are printed. If not, then there is a problem with the script. If it does print, then you have a problem with SSI calls on your server.

4) Make sure that your Perl Path is correct. If you are on a NT Server and have Perl 5.00 or above, then you need to use the following path:

Code:
#!\perl5//bin//perl

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
----------------------




[This message has been edited by Eliot (edited December 05, 1999).]

[This message has been edited by Eliot (edited December 05, 1999).]
Quote Reply
Re: records.cgi In reply to
 
Quote:
I have only two other suggestions:

1) Make sure that you have changed the permission of the script to
755.

It is.

Quote:
2) Also, make sure that you have the FULL ABSOLUTE PATH for your
book.cfg file.

/home/treasure-house/www/cgi-bin/dbman/books.cfg

That's as full and absolute as it gets - have several scripts running with similar paths.

Quote:
3) Test the script by itself by typing the location of the records.cgi
file in your browser. See if the Categories and Record Numbers are
printed. If not, then there is a problem with the script. If it does
print, then you have a problem with SSI calls on your server.

Typed in http://www.treasure-house.com/cgi-bin/dbman/records.cgi in browser and get "Internal Server Error"

SSI calls are not a problem on my server - have others spread throughout my pages.
Quote Reply
Re: records.cgi In reply to
Then you need to use that absolute path not the one you have in your records.cgi file, which is:

Code:
/www/treasure-house/cgi-bin/dbman/books.cfg

Change that absolute path to the following:

Code:
/home/treasure-house/www/cgi-bin/dbman/books.cfg

If that doesn't work, then I would suggest looking at your Perl Error logs or use the following codes to check the syntax of the script:

Code:
perl -c records.cgi

Make sure that you connect to the directory where the file is located, by using the following command line:

Code:
cd /cgi-bin/dbman/

Hope this helps.

Regards.



------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
----------------------


Quote Reply
Re: records.cgi In reply to
 
Quote:

If that doesn't work, then I would suggest looking at your Perl Error
logs or use the following codes to check the syntax of the script:

code:


perl -c records.cgi



Make sure that you connect to the directory where the file is located,
by using the following command line:

code:


cd /cgi-bin/dbman/

Well Eliot, you'll be happy to know that the syntax checks out okay. This one has me stymied - the SSI call executes without error but no output, the implicit script call in the browser location causes internal server error - I don't get it. If you think of anything else I'm open to suggestions - is this currently running on your site?
Quote Reply
Re: records.cgi In reply to
You're on your own. I have provided all the suggestions I can to assist you. Everything I suggested should have made it work.

Quote:
is this currently running on your site?

BTW: The script does work. Go to the following URL to see it in action:

www.anthrotech.com/cgibin/career/ads/records.cgi

Regards.

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
----------------------




[This message has been edited by Eliot (edited December 06, 1999).]
Quote Reply
Re: records.cgi In reply to
Hi Eliot,

One thing I did notice is that your categories are all one word. I have categories that have two words ie: Coloring Books

Could this be a possible reason why the records.cgi doesn't work for me?

Thanks
Quote Reply
Re: records.cgi In reply to
That shouldn't matter. In fact, it really doesn't matter at all.

Good luck! I have done all I can.

Smile

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
----------------------