Gossamer Forum
Home : Products : DBMan : Customization :

Spreadsheet JPDeni Mod

Quote Reply
Spreadsheet JPDeni Mod
I have tried several times to get JPDeni's "Spreadsheet" mod to work on my unchanged version of DBMan, however each time, it says that there is an internal error.

I don't know exactly where to start, so I am going to post my html.pl public in the drive. It will be located at http://www.eosgrad.com/listings/html.pl

I can't figure it out. Can someone help me? I have tried inserting several times and I just can't seem to get it to work, and I am not exactly sure what I should put here to get you the information you need to help me.

Thanks!

Jamie H.
Edwin O. Smith High School Alumni Network

Quote Reply
Re: [jamiers] Spreadsheet JPDeni Mod In reply to
Hi,

without any error message, I think there will be not much help. Can you check perl syntax of that file and view the logfile in the webserver?

Cheers,

Dat

Programming and creating plugins and templates
Blog
Quote Reply
Re: [jamiers] Spreadsheet JPDeni Mod In reply to
Look at the subject "Internal error" posted just below here for a tip on how to get a report on the errors.
-------------
David Olley
Anglo & Foreign International Limited,
http://www.firehelmets.co.uk

There are 10 types of people in the world: those who understand binary, and those who don't.
Quote Reply
Re: [davidolley] Spreadsheet JPDeni Mod In reply to
Thanks for getting the error posting working....! This is what I get, and I don't understand it!

Thanks for any help!

Jamie


DBMan encountered an internal error. CGI ERROR==========================================Error Message : Error loading required libraries.Check that they exist, permissions are set correctly and that they compile.Reason: Type of arg 1 to each must be hash (not concatenation (.) or string) at ./html.pl line 85, near "$rec{'Year'}$rec{'Name'} |;"Compilation failed in require at default.cfg line 50.Compilation failed in require at /home/jamie/custard_html/listings/db.cgi line 51. Script Location : /home/jamie/custard_html/listings/db.cgiPerl Version : 5.006001Setup File : default.cfgForm Variables------------------------------------------- Environment Variables-------------------------------------------DOCUMENT_ROOT : /home/jamie/custard_html/GATEWAY_INTERFACE : CGI/1.1HTTP_ACCEPT : image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, */*HTTP_ACCEPT_ENCODING: gzip, deflateHTTP_ACCEPT_LANGUAGE: en-usHTTP_CONNECTION : Keep-AliveHTTP_HOST : www.eosgrad.comHTTP_REFERER : http://www.eosgrad.com/listings/HTTP_USER_AGENT : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461)PATH : /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/binQUERY_STRING : REMOTE_ADDR : 24.151.44.94REMOTE_HOST : dhcp094-44-151-24.wl02-c5.cpe.charter-ne.comREMOTE_PORT : 3213REQUEST_METHOD : GETREQUEST_URI : /listings/db.cgiSCRIPT_FILENAME : /home/jamie/custard_html/listings/db.cgiSCRIPT_NAME : /listings/db.cgiSERVER_ADDR : 217.151.100.9SERVER_ADMIN : webmaster@custard.orgSERVER_NAME : www.eosgrad.comSERVER_PORT : 80SERVER_PROTOCOL : HTTP/1.1SERVER_SIGNATURE : Apache/1.3.24 Server at www.eosgrad.com Port 80



SERVER_SOFTWARE : Apache/1.3.24 (Unix) mod_ssl/2.8.8 OpenSSL/0.9.6c PHP/4.1.2

Last edited by:

jamiers: Apr 16, 2002, 3:50 AM
Quote Reply
Re: [jamiers] Spreadsheet JPDeni Mod In reply to
I have tried and tried to get this error log into something people can read... . I can't.... I'm sorry... when I add returns and put "code" around it.... both ways it gets screwed up! the script is at http://www.eosgrad.com/listings/db.cgi
Quote Reply
Re: [jamiers] Spreadsheet JPDeni Mod In reply to
Jamier

Please preview your postings to ensure that they are correctly formatted!Crazy

The error messages point very clearly to errors in your .cfg file and your html.pl file, but without seeing them, we cannot help further (no need to post them, though!)

Check the directory settings and then look for syntax errors in the html.pl in the areas indicated by the line numbers. It is bound to be something very simple. Mad

I assume you are using a proper text editor, like EditPlus or EditPad Lite?

If not, then download it NOW.



-------------
David Olley
Anglo & Foreign International Limited,
http://www.firehelmets.co.uk

There are 10 types of people in the world: those who understand binary, and those who don't.
Quote Reply
Re: [davidolley] Spreadsheet JPDeni Mod In reply to
I don't understand what this error message means though:

Code:

Error Message : Error loading required libraries
Check that they exist, permissions are set correctly and that they compile.
Reason: Type of arg 1 to each must be hash (not concatenation (.) or string) at ./html.pl line 85, near "$rec{'Year'}$rec{'Name'}
Compilation failed in require at default.cfg line 50.
Compilation failed in require at /home/jamie/custard_html/listings/db.cgi line 51.
DBMan worked before I started making these changes which probably proves that all over the libraries were available. I am also using PICO as my main editing program.

Thanks for any help you can provide! Here are the files located in my directory:

http://www.eosgrad.com/listings/db.cgi

http://www.eosgrad.com/listings/html.pl

http://www.eosgrad.com/listings/default.cfg



Jamie

Last edited by:

jamiers: Apr 16, 2002, 5:21 AM
Quote Reply
Re: [jamiers] Spreadsheet JPDeni Mod In reply to
Jamiers

The first thing I see is that your html.pl file is very badly wrong!

You are using an editor that converts the < and > characters into "&lt;" and "&gt;". This is the sort of thing that MS FrontPage has a nasty habit of doing!

You must use Global Replace (carefully) to change all these back, then try again.


The db.cgi file that you linked to was, in fact, your error message printout.


I have not had a chance to look at your cfg file yet, but you should be able to do that, and check that the server paths are all correct.





-------------
David Olley
Anglo & Foreign International Limited,
http://www.firehelmets.co.uk

There are 10 types of people in the world: those who understand binary, and those who don't.

Last edited by:

davidolley: Apr 16, 2002, 7:27 AM
Quote Reply
Re: [davidolley] Spreadsheet JPDeni Mod In reply to
Jamier

You have not registered your email address in your profile, so I cannot send you an email.

Contact me at david@afil.co.uk and I will email you a corrected version of your html.pl file.



-------------
David Olley
Anglo & Foreign International Limited,
http://www.firehelmets.co.uk

There are 10 types of people in the world: those who understand binary, and those who don't.