It happened for me when a customer logged in with a ' in their username. the
mysql insert for the AuthLog of course didn't like that. i didn't originally
use the the sql quoted special characters in my insert statement. I am using
those special characters now though. Not too crucial of an issue, i just
thought i'd mention it.
On 11-11-10 05:31 PM, Heikki Vatiainen wrote:
> On 11/10/2011 08:15 PM, Michael wrote:
>> In SqlDb.pm sub do{} should a mysql syntax error also be reason NOT to
>> disconnect/reconnect from/to the mysql server?
>
> Hmm, good question. If it does not mask a real problem, then probably yes.
>
> Isn't this something that happens with an incorrect configuration or can
> these errors happen during the normal operation. If so, what would be
> the reason for this?
>
> It would be useful to know why this happens before adding it.
>
> Thanks!
>
>> # Primary key violation is not a cause for disconnection.
>> # Also SQL syntax error.
>> return $rc if defined $rc
>> || $reason =~ /error in your SQL syntax/i
>> || $reason =~ /violation/i
>> || $reason =~ /duplicate key/im
>> || $reason =~ /Duplicate entry/im
>> || $reason =~ /^ORA-00001/;
>
>
_______________________________________________
radiator mailing list
radiator@open.com.au
http://www.open.com.au/mailman/listinfo/radiator
