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
p: 972.881.2900  x3104
m: 972.948.3424