Gossamer Forum
Home : Products : Others : MySQLMan :

Error in deleteing

Quote Reply
Error in deleteing
Error

MySQL said: You have an error in your SQL syntax near '(0x82a2078) LIMIT 1' at line 1.

Query: DELETE FROM user WHERE CGI=HASH(0x82a2078) LIMIT 1

Back


Quote Reply
Re: Error in deleteing In reply to
Hello,

It appears that you have an older version of the CGI module (CGI.pm). Newer versions of this module can be downloaded at:

http://www.perl.com/...dules/by-module/CGI/

Once you have upgraded the module, the problem should be solved automatically.

If you do not wish to upgrade the module, then you can add the following sub-routine in mysql.cgi:

Code:
sub escape {
$DefaultClass = 'CGI' unless defined $CGI::DefaultClass;

shift() if ref($_[0]) || $_[0] eq $DefaultClass;
my $toencode = shift;
return undef unless defined($toencode);
$toencode=~s/([^a-zA-Z0-9_.-])/uc sprintf("%%x",ord($1))/eg;
return $toencode;
}
... and replace each $in->escape($var) with &escape($var) where $var stands for any variable.

This will be fixed in the next release to avoid the problem from occurring again.

Cheers,

--
Gossamer Threads, Inc.
Quote Reply
Re: Error in deleteing In reply to
where to put in this cgi.pm file ?

Ashish