Gossamer Forum
Quote Reply
Email All Problems
Afternoon,

When Im in the Admin section, I goto Email and then Custom Lists --> Modify, and I get the following error...

A fatal error has occured:

Can't call method "fetchall_arrayref" on an undefined value at d:/virtualservers/055871/thebigtravelguide/cgi-bin/links/admin/Links/MassMailer.pm line 929.

Please enable debugging in setup for more details.

Stack Trace
======================================
Links (3592): Links::environment called at d:/virtualservers/055871/thebigtravelguide/cgi-bin/links/admin/Links.pm line 431 with no arguments.
Links (3592): Links::fatal called at d:/virtualservers/055871/thebigtravelguide/cgi-bin/links/admin/Links/MassMailer.pm line 929 with arguments
(Can't call method "fetchall_arrayref" on an undefined value at d:/virtualservers/055871/thebigtravelguide/cgi-bin/links/admin/Links/MassMailer.pm line 929.
).
Links (3592): ACTIONS::list_delete called at d:\virtualservers\055871\thebigtravelguide\cgi-bin\links\admin\admin.cgi line 128 with no arguments.
Links (3592): main::mailer_request called at d:\virtualservers\055871\thebigtravelguide\cgi-bin\links\admin\admin.cgi line 62 with no arguments.
Links (3592): main::main called at d:\virtualservers\055871\thebigtravelguide\cgi-bin\links\admin\admin.cgi line 24 with no arguments.
System Information
======================================
Perl Version: 5.006001
Links SQL Version: 2.1.2
DBI.pm Version: 1.37
Persistant Env: mod_perl (0) SpeedyCGI (0)
GT::SQL::error = Could not connect to database. Reason:
DBI::errstr = [Microsoft][ODBC SQL Server Driver]Timeout expired (SQL-HYT00)(DBD: db_login/SQLConnect err=-1)
@INC =
d:/virtualservers/055871/thebigtravelguide/cgi-bin/links/admin
D:/Perl/lib
D:/Perl/site/lib
.
CGI INPUT
======================================
action => list_delete
ENVIRONMENT
======================================
ALLUSERSPROFILE => C:\Documents and Settings\All Users
AUTH_PASSWORD => a1flight
AUTH_TYPE => Basic
AUTH_USER => dss
COMMONPROGRAMFILES => C:\Program Files\Common Files
COMPUTERNAME => INETC107
COMSPEC => C:\WINNT\system32\cmd.exe
CONTENT_LENGTH => 0
DISKEEPERICON => d:\Program Files\Executive Software\DiskeeperLite\
GATEWAY_INTERFACE => CGI/1.1
GT_TMPDIR => d:/virtualservers/055871/thebigtravelguide/cgi-bin/links/admin/tmp
HTTPS => off
HTTP_ACCEPT => text/html, image/png, image/jpeg, image/gif, image/x-xbitmap, */*;q=0.1
HTTP_ACCEPT_CHARSET => windows-1252, utf-8, utf-16, iso-8859-1;q=0.6, *;q=0.1
HTTP_ACCEPT_ENCODING => deflate, gzip, x-gzip, identity, *;q=0
HTTP_ACCEPT_LANGUAGE => en
HTTP_AUTHORIZATION => Basic ZHNzOmExZmxpZ2h0
HTTP_CONNECTION => Keep-Alive, TE
HTTP_HOST => www.thebigtravelguide.com
HTTP_TE => deflate, gzip, chunked, identity, trailers
HTTP_USER_AGENT => Mozilla/4.0 (compatible; MSIE 6.0; MSIE 5.5; Windows NT 5.1) Opera 7.03 [en]
INSTANCE_ID => 767
LOCAL_ADDR => 195.224.253.126
LOGON_USER => dss
NUMBER_OF_PROCESSORS => 1
OS => Windows_NT
OS2LIBPATH => C:\WINNT\system32\os2\dll;
PATH => D:\Perl\bin\;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\Program Files\Symantec\pcAnywhere\;C:\MSSQL7\BINN;c:\batch;d:\Program Files\Executive Software\DiskeeperLite\
PATHEXT => .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.VBS
PATH_INFO => /cgi-bin/links/admin/admin.cgi
PATH_TRANSLATED => d:\virtualservers\055871\thebigtravelguide\cgi-bin\links\admin\admin.cgi
PROCESSOR_ARCHITECTURE => x86
PROCESSOR_IDENTIFIER => x86 Family 6 Model 8 Stepping 10, GenuineIntel
PROCESSOR_LEVEL => 6
PROCESSOR_REVISION => 080a
PROGRAMFILES => C:\Program Files
QUERY_STRING => action=list_delete
REMOTE_ADDR => 81.101.218.61
REMOTE_HOST => 81.101.218.61
REMOTE_USER => dss
REQUEST_METHOD => GET
SCRIPT_NAME => /cgi-bin/links/admin/admin.cgi
SERVER_NAME => www.thebigtravelguide.com
SERVER_PORT => 80
SERVER_PORT_SECURE => 0
SERVER_PROTOCOL => HTTP/1.1
SERVER_SOFTWARE => Microsoft-IIS/5.0
SYSTEMDRIVE => C:
SYSTEMROOT => C:\WINNT
TEMP => C:\WINNT\TEMP
TMP => C:\WINNT\TEMP
UNMAPPED_REMOTE_USER => dss
USERPROFILE => C:\Documents and Settings\NetShowServices
WINDIR => C:\WINNT
GT::SQL::Table (3592): Could not connect to database. Reason: [Microsoft][ODBC SQL Server Driver]Timeout expired (SQL-HYT00)(DBD: db_login/SQLConnect err=-1) at d:/virtualservers/055871/thebigtravelguide/cgi-bin/links/admin/GT/SQL/Driver.pm line 84. GT::SQL::Table (3592): Could not connect to database. Reason: at d:/virtualservers/055871/thebigtravelguide/cgi-bin/links/admin/GT/SQL/Driver.pm line 88. Can't call method "fetchall_arrayref" on an undefined value at d:/virtualservers/055871/thebigtravelguide/cgi-bin/links/admin/Links/MassMailer.pm line 929.



If anyone can spot the problem with this, I would be greatful for the help. I've not edited this in anyway I must add.

Thanks
Scampi.

-----------------------------------------------------
A Little Madness Now And Then,
Is Relished By The Wisest Men
- Mr Willy Wonka
-----------------------------------------------------
Quote Reply
Re: [Scampi] Email All Problems In reply to
In Setup > Misc. Options , can you set 'debug' to 2, and post the results (minus dangerous information such as mysql details). Its easier to find the problem if we can see the MySQL error, and query.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Email All Problems In reply to
Strange,

I set the debug to 2, tried to recreate it and now it works! Set the debug back down to 0 and it still works!

What a strange bit of software where using : )

Thanks anyway
Scampi.

-----------------------------------------------------
A Little Madness Now And Then,
Is Relished By The Wisest Men
- Mr Willy Wonka
-----------------------------------------------------