the continuing saga
Eric Henson
ehenson at pfsweb.com
Fri Jun 28 15:28:05 EDT 2013
Mysql: installed and working
Sendmail: installed and working
Passive.pl: working
remove.cgi: getting this error:
DBD::mysql::st execute failed: Out of range value for column 'octa' at row 1 at /var/www/cgi-bin/remove.cgi line 160., referer: http://prodantispam01.pfsweb.com/remove.html
My guess is that the remove.cgi isn't updating the database correctly.
Here it parses the IP:
if ($ip =~ /^(\d{1,3})\.(\d{1,3})\.(\d{1,3})\.(\d{1,3})$/) {
$octa = $1;
$octb = $2;
$octc = $3;
$octd = $4;
Here it writes to the database:
my $dbh;
# DBI connect params.
$dbh = Spamikaze::DBConnect();
my $sql = "UPDATE ipnumbers SET visible = 0 WHERE
octa = ? AND
octb = ? AND
octc = ? AND
octd = ? AND
visible = 1";
--
ERIC HENSON
Solutions Architect for Systems Organization
PFSweb | www.pfsweb.com<http://www.pfsweb.com/>
p: 972.881.2900 x3104
m: 972.948.3424
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kernelnewbies.org/pipermail/spamikaze/attachments/20130628/4bd8def3/attachment.html
More information about the Spamikaze
mailing list