Can't send newsletter's to link owners...

Since I've gone thru the beta's and was upgraded from Links SQL 1 back in the early phases, I may have missed something in the tables.

Thanks!!!

Lance Rasmussen
Bowlingzone.com

Started at Wed Feb 7 11:29:53 2001.

Sending emails ...

A fatal error has occured:Can't call method "fetchrow_array" on an undefined value at ........../cgi/admin/nph-email.cgi line 90, chunk 8.
Please enable debugging in setup for more details.
Stack Trace
======================================
Links (36519): Links::environment called at ........../cgi/admin/Links.pm line 452 with no arguments.Links (36519): Links::fatal called at ........../cgi/admin/GT/Base.pm line 212 with arguments (Can't call method "fetchrow_array" on an undefined value at /usr/local/etc/httpd/vhosts/bzone/cgi/admin/nph-email.cgi line 90, chunk 8.
).Links (36519): GT::Base::__ANON__ called at ........../cgi/admin/nph-email.cgi line 90 with arguments (Can't call method "fetchrow_array" on an undefined value at ........../cgi/admin/nph-email.cgi line 90, chunk 8.
).Links (36519): main::__ANON__ called at GT::Mail::BulkMail::_send_coderef line 5 with no arguments.Links (36519): GT::Mail::BulkMail::_send_coderef called at ........../cgi/admin/GT/Mail/BulkMail.pm line 555 with arguments (GT::Mail::BulkMail=HASH(0x83dea10), CODE(0x8400a04)).Links (36519): GT::Mail::BulkMail::send called at ........../cgi/admin/nph-email.cgi line 127 with arguments (GT::Mail::BulkMail=HASH(0x83dea10), CODE(0x8400a04)).Links (36519): main::main called at ........../cgi/admin/nph-email.cgi line 30 with no arguments.

System Information
======================================
Perl Version: 5.00503
Links SQL Version: 2.0.1
DBI.pm Version: 1.13
GT::SQL::error = Failed to execute query: 'SELECT ID,Email,LinkID FROM bzEmailMailings WHERE Mailing = '5' ' Reason: Unknown column 'LinkID' in 'field list'
@INC =
........../cgi/admin
/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 => 5


CGI Cookies
======================================
LastLoginDT => 02-02-2001 11:52 AM
lastLogin => 2451943.1152
s => 03bc287f2afb352204d6f970eeae9dee

Hi,

You should run from your SQL monitor:

ALTER TABLE bzEmailMailings ADD LinkID INT

and it should work. This got added in very early and I didn't think anyone was still using it. =)

Cheers,

Alex

--
Gossamer Threads Inc.