Gossamer Forum
Home : Products : Others : MySQLMan :

Error in deleteing

Quote Reply
Error in deleteing

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


Quote Reply
Re: Error in deleteing In reply to

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


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:

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.


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