[RADIATOR] SqlDb.pm - sql server failover.

[Michael]

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/;
>
>