Gossamer Forum
Quote Reply
Bulk Mail
Alex,

Installed beta 1. It's now live for everyone to break. I tried to send a message to the link owners. Got the following:

GT::Mail::BulkMail Error: Unable to open sendmail: open2: wtr should not be null at GT::Mail::BulkMail::_sendmail_connect line 6

Error: Can't call method "fetchrow_hashref" on an undefined value at (--my path---)/admin/nph-email.cgi line 142.



Quote Reply
Re: Bulk Mail In reply to
Hi,

Can you set debug to 1 in your setup and run this again? I need to see what GT::SQL error says in the debug.

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: Bulk Mail In reply to
Started at Mon Dec 4 09:17:38 2000.

Sending emails ...

GT::Mail::BulkMail Error: Unable to open sendmail: open2: wtr should not be null at GT::Mail::BulkMail::_sendmail_connect line 6

Error: Can't call method "fetchrow_hashref" on an undefined value at ............/admin/nph-email.cgi line 142.

Stack Trace
======================================
Links (4719): Links::environment called at Links.pm line 442.Links (4719): Links::fatal called at GT/Base.pm line 251.Links (4719): GT::Base::error_handler called at ............../admin/nph-email.cgi line 142.Links (4719): main::get_info called at .................../admin/nph-email.cgi line 80.Links (4719): main::__ANON__ called at GT::Mail::BulkMail::_send_coderef line 5.Links (4719): GT::Mail::BulkMail::_send_coderef called at GT/Mail/BulkMail.pm line 555.Links (4719): GT::Mail::BulkMail::send called at ............../admin/nph-email.cgi line 115.Links (4719): main::main called at ................./admin/nph-email.cgi line 25.

System Information
======================================
Perl Version: 5.00503
Links SQL Version: 2.0.0-beta1
DBI.pm Version: 1.13
GT::SQL::error = Failed to execute query: 'SELECT * FROM bzLinks WHERE Username = 'Lance Rasmussen' ' Reason: Unknown column 'Username' in 'where clause'
@INC =
/usr/local/lib/perl5/5.00503/i386-freebsd
/usr/local/lib/perl5/5.00503
/usr/local/lib/site_perl
/usr/local/lib/site_perl
.

CGI INPUT
======================================
emailsto => 1


CGI Cookies
======================================
Username => Lance Rasmussen
mysqlman_host => localhost
mysqlman_password => ......
mysqlman_username => ......


ENVIRONMENT
======================================
AUTH_TYPE => Basic
DOCUMENT_ROOT => ........
GATEWAY_INTERFACE => CGI/1.1
HTTP_ACCEPT => image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/msword, application/vnd.ms-powerpoint, */*
HTTP_ACCEPT_ENCODING => gzip, deflate
HTTP_ACCEPT_LANGUAGE => en-us
HTTP_AUTHORIZATION => Basic TGFuY2VSYXNtdXNzZW46YXVzdGluVFJPWQ==
HTTP_CONNECTION => Keep-Alive
HTTP_COOKIE => Username=Lance+Rasmussen; mysqlman_host=localhost; mysqlman_username=.....; mysqlman_password=.....
HTTP_HOST => www.bowlingzone.com
HTTP_REFERER => http://www.bowlingzone.com/cgi/admin/mailer.cgi?action=mailings
HTTP_USER_AGENT => Mozilla/4.0 (compatible; MSIE 5.5; Windows 98; CDE Software 5.5sp1)
PATH => /bin:/usr/bin:/usr/ucb:/usr/bsd:/usr/local/bin
QUERY_STRING => emailsto=1
REMOTE_ADDR => 216.163.67.57
REMOTE_PORT => 1055
REMOTE_USER => LanceRasmussen
REQUEST_METHOD => GET
REQUEST_URI => /cgi/admin/nph-email.cgi?emailsto=1
SCRIPT_FILENAME => .........../admin/nph-email.cgi
SCRIPT_NAME => /cgi/admin/nph-email.cgi
SERVER_ADDR => 161.58.224.85
SERVER_ADMIN => bzone@bowlingzone.com
SERVER_NAME => www.bowlingzone.com
SERVER_PORT => 80
SERVER_PROTOCOL => HTTP/1.1
SERVER_SIGNATURE =>
SERVER_SOFTWARE => Apache/1.3.12 OpenSSL/0.9.5a (Unix) mod_fastcgi/2.2.4 mod_perl/1.21 FrontPage/4.0.4.3 PHP/3.0.16
USER => ..........



Quote Reply
Re: Bulk Mail In reply to
By the gist of it, I am assuming that it is calling the column Username when the column name in the Links table is called LinkOwner??? I was e-mailing the link owners.

Lance



Quote Reply
Re: Bulk Mail In reply to
Hi,

Yes, that was indeed it. I've updated mailer so it uses the proper column, should have caught that one. =) Thanks!

Alex

--
Gossamer Threads Inc.