Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

OK... where do I start..IT just started HELP!

Quote Reply
OK... where do I start..IT just started HELP!
Well it's been awhile since I added or deleted a Forum from the admin panel

I click on LIST ALL from the Forum Adim panel menu and I get the error message below
(with debug turned on now of couse) xxxx replace pathes...to protect my site here...

Now the Forum works... but admin panel isn't ... mid error says something about a DBI
module needing to be installed to access the sql database. If this is the problem
how does the normal Forum view work! (see http://nasshq.org/cgi-bin/gforum.cgi)

...just checked other admin functions.... seems like avatars and stuff work but anything
'group' related seems croaked out here

HELP!!!!!


-------------------

A fatal error has occurred:

Can't call method "fetchall_hashref" on an undefined value at /xxx/xx/xxxxxxr/cgi-bin/admin/GForum/Forum.pm line 506.

Please enable debugging in setup for more details.

Stack Trace
======================================
GForum (62837): GForum::Forum::tpl_list called at /xxx/xx/xxxxxxr/cgi-bin/admin/GT/Template.pm line 690 with arguments
(admin).
GForum (62837): GT::Template::_call_func called at /xxx/xx/xxxxxxr/cgi-bin/admin/templates/admin/compiled/forums_list.html.compiled line 177 with arguments
(GForum::Template=HASH(0x8383610), GForum::Forum::tpl_list, admin).
GForum (62837): GT::Template::__ANON__ called at /xxx/xx/xxxxxxr/cgi-bin/admin/GT/Template.pm line 545 with arguments
(GForum::Template=HASH(0x8383610)).
GForum (62837): GT::Template::_parse called at /xxx/xx/xxxxxxr/cgi-bin/admin/GT/Template.pm line 91 with arguments
(GForum::Template=HASH(0x8383610), forums_list.html, HASH(0x8381c78)).
GForum (62837): GT::Template::parse called at /xxx/xx/xxxxxxr/cgi-bin/admin/GForum/Template.pm line 165 with arguments
(GForum::Template, forums_list.html, ARRAY(0x838b6d0), HASH(0x8381c78), 1).
GForum (62837): GForum::Template::parse called at /xxx/xx/xxxxxxr/cgi-bin/admin/GT/Template.pm line 105 with arguments
(GForum::Template, forums_list.html, GT::CGI=HASH(0x8376018), HASH(0x8380180), 1).
GForum (62837): GT::Template::parse_print called at /xxx/xx/xxxxxxr/cgi-bin/admin/GForum.pm line 366 with arguments
(GForum::Template, forums_list.html, GT::CGI=HASH(0x8376018), HASH(0x8380180)).
GForum (62837): GForum::page called at admin.cgi line 52 with no arguments.
GForum (62837): main::main called at admin.cgi line 26 with no arguments.



System Information
======================================
Perl Version: v5.00503
Gossamer Forum Version: 1.1.3
GForum.pm version: 1.109
GT::SQL Version: 1.098
GT::Template Version: 2.064
@INC =
/xxx/xx/xxxxxxr/cgi-bin/admin
/usr/local/lib/perl5/site_perl/5.005/i386-freebsd
/usr/local/lib/perl5/site_perl/5.005
.
/usr/libdata/perl/5.00503/mach
/usr/libdata/perl/5.00503
GT::SQL::error = Could not connect to database. Reason: DBI module not installed. You must install the perl database module DBI from: http://www.perl.com/...odules/by-module/DBI
$!: No such file or directory

CGI INPUT
======================================
do => page
page => forums_list.html


CGI Cookies
======================================
gforum_1006370746_remember => c454b2fxxxxxxxxxxxxxxxxxxx0fb1
login_id =>


ENVIRONMENT
======================================
AUTH_TYPE => Basic
DOCUMENT_ROOT => /xxx/xx/xxxxxxr/htdocs
GATEWAY_INTERFACE => CGI/1.1
GT_TMPDIR => /xxx/xx/xxxxxxr/cgi-bin/admin/tmp
HTTP_ACCEPT => application/vnd.ms-excel, application/msword, application/vnd.ms-powerpoint, application/x-shockwave-flash, image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, */*
HTTP_ACCEPT_ENCODING => gzip, deflate
HTTP_ACCEPT_LANGUAGE => en-us
HTTP_CONNECTION => Keep-Alive
HTTP_COOKIE => login_id=; gforum_xxxxxxxxxxxxx_remember=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
HTTP_HOST => www.nasshq.org
HTTP_REFERER => http://www.nasshq.org/...page=forums_nav.html
HTTP_USER_AGENT => Mozilla/4.0 (compatible; MSIE 6.0; Windows 98; Q312461)
PATH => /usr/local/bin:/usr/bin:/bin
QUERY_STRING => do=page;page=forums_list.html
REMOTE_ADDR => 24.35.104.38
REMOTE_PORT => 4594
REMOTE_USER => xxxxxxxxxx
REQUEST_METHOD => GET
REQUEST_URI => /cgi-bin/admin/admin.cgi?do=page;page=forums_list.html
SCRIPT_FILENAME => /xxx/xx/xxxxxxr/cgi-bin/admin/admin.cgi
SCRIPT_NAME => /cgi-bin/admin/admin.cgi
SERVER_ADDR => xxx.xxx.xxx.xxx
SERVER_ADMIN => xxxxxxx@xxxxx.com
SERVER_NAME => nasshq.org
SERVER_PORT => 80
SERVER_PROTOCOL => HTTP/1.1
SERVER_SOFTWARE => Apache/1.3.29 (Unix) FrontPage/5.0.2.2510 mod_ssl/2.8.16 OpenSSL/0.9.7c PHP-CGI/0.1b
UNIQUE_ID => P8vxxxxxxxxxxxxxAAPJYDWg




-------------------

If someone from admin could contact me I could forward permissions to access the site and see what's happened! The site auto archives emails and that is now working as well so I know it's not a nromal sql access problem. Perhaps a server directory permissions problem?

ptegler
Quote Reply
Re: [ptegler] OK... where do I start..IT just started HELP! In reply to
Damn.... I see also now that even validating a new user isn't working!


If my ISP upgraded their version of Perl, could this be the problem?
Am I going to have to manually edit the beginning of every script
to point to the right Perl dir? Or is there a possible way to re-run setup and
correct the path without wiping out the whole current db full of messages.

Now the interesting part is the email archiving has started working again...
(see my past posts) ..maybe a week ago.... this is what makes me think maybe
my isp has changed things

Any ideas guys about the Perl pathes (error below shows the pathes
the isp currently has online)


error message follows.........
--------------------------

A fatal error has occurred:
Can't call method "fetchall_hashref" on an undefined value at /xxxx/xx/xxxxx/cgi-bin/admin/GForum/User.pm line 514.


Please enable debugging in setup for more details.Stack Trace======================================GForum (58423): GForum::User::admin_validate called at /xxxx/xx/xxxxx/cgi-bin/admin/GT/Template.pm line 690 with no arguments.GForum (58423): GT::Template::_call_func called at /xxxx/xx/xxxxx/cgi-bin/admin/templates/admin/compiled/users_admin_validate.html.compiled line 44 with arguments (GForum::Template=HASH(0x83835c8), GForum::User::admin_validate).GForum (58423): GT::Template::__ANON__ called at /xxxx/xx/xxxxx/cgi-bin/admin/GT/Template.pm line 545 with arguments (GForum::Template=HASH(0x83835c8)).GForum (58423): GT::Template::_parse called at /xxxx/xx/xxxxx/cgi-bin/admin/GT/Template.pm line 91 with arguments (GForum::Template=HASH(0x83835c8), users_admin_validate.html, HASH(0x8382c30)).GForum (58423): GT::Template::parse called at /xxxx/xx/xxxxx/cgi-bin/admin/GForum/Template.pm line 165 with arguments (GForum::Template, users_admin_validate.html, ARRAY(0x838b688), HASH(0x8382c30), 1).GForum (58423): GForum::Template::parse called at /xxxx/xx/xxxxx/cgi-bin/admin/GT/Template.pm line 105 with arguments (GForum::Template, users_admin_validate.html, GT::CGI=HASH(0x8372bb4), HASH(0x8380138), 1).GForum (58423): GT::Template::parse_print called at /xxxx/xx/xxxxx/cgi-bin/admin/GForum.pm line 366 with arguments (GForum::Template, users_admin_validate.html, GT::CGI=HASH(0x8372bb4), HASH(0x8380138)).GForum (58423): GForum::page called at admin.cgi line 52 with no arguments.GForum (58423): main::main called at admin.cgi line 26 with no arguments.System Information======================================Perl Version: v5.00503Gossamer Forum Version: 1.1.3GForum.pm version: 1.109GT::SQL Version: 1.098GT::Template Version: 2.064@INC = /xxxx/xx/xxxxx/cgi-bin/admin /usr/local/lib/perl5/site_perl/5.005/i386-freebsd /usr/local/lib/perl5/site_perl/5.005 . /usr/libdata/perl/5.00503/mach /usr/libdata/perl/5.00503GT::SQL::error = Could not connect to database. Reason: DBI module not installed. You must install the perl database module DBI from: http://www.perl.com/CPAN/modules/by-module/DBI$!: No such file or directoryCGI INPUT======================================do => pagepage => users_admin_validate.htmlCGI Cookies====================================== gforum_1006370746_remember => c454b2fe39b7af3e50578aa5c5d00fb1login_id => ENVIRONMENT======================================AUTH_TYPE => BasicDOCUMENT_ROOT => /xxxx/xx/xxxxx/htdocsGATEWAY_INTERFACE => CGI/1.1GT_TMPDIR => /xxxx/xx/xxxxx/cgi-bin/admin/tmpHTTP_ACCEPT => application/vnd.ms-excel, application/msword, application/vnd.ms-powerpoint, application/x-shockwave-flash, image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, */*HTTP_ACCEPT_ENCODING => gzip, deflateHTTP_ACCEPT_LANGUAGE => en-usHTTP_CONNECTION => Keep-AliveHTTP_COOKIE => login_id=; gforum_1006370746_remember=c454b2fe39b7af3e50578aa5c5d00fb1HTTP_HOST => www.nasshq.orgHTTP_REFERER => http://www.nasshq.org/cgi-bin/admin/admin.cgi?do=page;page=users_nav.htmlHTTP_USER_AGENT => Mozilla/4.0 (compatible; MSIE 6.0; Windows 98; Q312461)PATH => /usr/local/bin:/usr/bin:/binQUERY_STRING => do=page;page=users_admin_validate.htmlREMOTE_ADDR => 24.35.104.38REMOTE_PORT => 1121REMOTE_USER => wizardzREQUEST_METHOD => GETREQUEST_URI => /cgi-bin/admin/admin.cgi?do=page;page=users_admin_validate.htmlSCRIPT_FILENAME => /xxxx/xx/xxxxx/cgi-bin/admin/admin.cgiSCRIPT_NAME => /cgi-bin/admin/admin.cgiSERVER_ADDR => 63.251.213.19SERVER_ADMIN => support@powweb.comSERVER_NAME => nasshq.orgSERVER_PORT => 80SERVER_PROTOCOL => HTTP/1.1SERVER_SOFTWARE => Apache/1.3.29 (Unix) FrontPage/5.0.2.2510 mod_ssl/2.8.16 OpenSSL/0.9.7c PHP-CGI/0.1bUNIQUE_ID => P8ztV38AAAEAAOP4V@I-------------------
Quote Reply
Re: [ptegler] OK... where do I start..IT just started HELP! In reply to
The error is stated as:

Quote:
Could not connect to database. Reason: DBI module not installed. You must install the perl database module DBI from: http://www.perl.com/CPAN/modules/by-module/DBI

By upgrading perl then the script will be using the new module tree and so DBI will need to be reinstalled.
Quote Reply
Re: [Recall] OK... where do I start..IT just started HELP! In reply to
OK... I already downloaded the dbi module fro mthe supplied link...

but how do I...the end user...install it? Is it part of gforum
or something the isp needs to do?
Quote Reply
Re: [ptegler] OK... where do I start..IT just started HELP! In reply to
If your ISP just upgraded Perl, then yes, you will need to add DBI back into perl (that does NOT carry over to the new version). By "you", I mean the ISP... because unlress you have root priveleges, they will have to do it. Only takes a minute, very easy.

Call them right away!

(BTW,
dave

Big Cartoon DataBase
Big Comic Book DataBase
Quote Reply
Re: [carfac] OK... where do I start..IT just started HELP! Probelm solved In reply to
OK..we were ALL wrong!

Gossamer guys and gals.... if your ISP updates to Perl 5.8 you MAY have problems.
A bunch of the CGI scripts in this system have #!/usr/bin/perl5 hard coded.

Perl 5.8 doesn't not like the 5 in Perl5. It considers it a 'downgrade'?

Anyway...I had to go through the directories and check every CGI and PL file.
Those that had Perl5 were changed to just Perl..and all is working again properly.

Apperantly this has never been a problem in Perl in past revisions, but it is NOW!

Thanks for your patience with me. This was a bit of a tuffy to figure out!
Quote Reply
Re: [ptegler] OK... where do I start..IT just started HELP! Probelm solved In reply to
Technically I was still correct =)

The error regarding DBI means the module can't be found, therefore it needs installing or reinstalling.
Quote Reply
Re: [ptegler] OK... where do I start..IT just started HELP! Probelm solved In reply to
In Reply To:
Perl 5.8 doesn't not like the 5 in Perl5. It considers it a 'downgrade'?

It appears that Perl 5.8 no longer installs a /usr/bin/perl5 executable, so running /usr/bin/perl5 is actually still running the old Perl. It sounds like the ISP made a mistake - when removing the old version of Perl, they ought to have either removed this file, or symlinked it to perl5.8.2.

For future versions, I've changed the path-to-perl detection code to look for /usr/bin/perl before /usr/bin/perl5. A couple years, looking for /usr/bin/perl5 was the better option as there were still a few servers out there with /usr/bin/perl being a Perl 4 executable, but hopefully those are rare - any users on such a server will now have to manually change the path to perl, but people installing on new servers won't run into this problem. It won't automatically fix upgrades, although you _could_ change the path to Perl in the config file, and then "upgrade" (even to the same version) your product to have all the paths upgraded for you.

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com