[Dxspider-support] possible bug in MySQL routines ?

[Tim Tuck]

HI Dirk,

OK - makes sense - dunno if we can make a change from MySQL to SQLite3 
but I will investigate.

thanks

Tim


On 3/12/21 9:18 am, Dirk Koopman via Dxspider-support wrote:
> The sql database connections are not "supported", but I'm guessing 
> that it's barfing over utf8 characters in comments. The trouble is 
> that if one sets it up to accept utf8, then it will start bitching 
> about comments (from windows machines) sending out comments with 
> characters > 0x7f in in some random codepage or other. SQLite3 is not 
> so fussy.
>
> Dirk
>
> On 02/12/2021 19:27, Tim Tuck via Dxspider-support wrote:
>> Hi all,
>>
>> checking through the logs for anything else awry with my node I find 
>> that I have the occasional errors from DBD::mysql::db thus...
>>
>> root at dx:~# grep DBD /var/log/syslog
>> Dec  2 00:34:58 dx sh[41225]: DBD::mysql::db do failed: Incorrect 
>> string value: '\xF3venes...' for column 'comment' at row 1 at 
>> /spider/perl/DXSql.pm line 84.
>> Dec  2 11:15:41 dx sh[41225]: DBD::mysql::db do failed: Incorrect 
>> string value: '\xD82\xD872' for column 'comment' at row 1 at 
>> /spider/perl/DXSql.pm line 84.
>> Dec  2 13:35:39 dx sh[41225]: DBD::mysql::db do failed: Incorrect 
>> string value: '\xFCr das...' for column 'comment' at row 1 at 
>> /spider/perl/DXSql.pm line 84.
>> Dec  2 14:44:01 dx sh[41225]: DBD::mysql::db do failed: Incorrect 
>> string value: '\xFCltima...' for column 'comment' at row 1 at 
>> /spider/perl/DXSql.pm line 84.
>> Dec  2 15:42:21 dx sh[41225]: DBD::mysql::db do failed: Incorrect 
>> string value: '\xAA LOTE...' for column 'comment' at row 1 at 
>> /spider/perl/DXSql.pm line 84.
>> Dec  2 15:47:19 dx sh[41225]: DBD::mysql::db do failed: Incorrect 
>> string value: '\xEDa int...' for column 'comment' at row 1 at 
>> /spider/perl/DXSql.pm line 84.
>> Dec  2 16:26:52 dx sh[41225]: DBD::mysql::db do failed: Incorrect 
>> string value: '\xFCrs ne...' for column 'comment' at row 1 at 
>> /spider/perl/DXSql.pm line 84.
>> Dec  2 16:28:55 dx sh[41225]: DBD::mysql::db do failed: Incorrect 
>> string value: '\xD1O DE ...' for column 'comment' at row 1 at 
>> /spider/perl/DXSql.pm line 84.
>> Dec  2 16:59:54 dx sh[41225]: DBD::mysql::db do failed: Incorrect 
>> string value: '\xD814' for column 'comment' at row 1 at 
>> /spider/perl/DXSql.pm line 84.
>> Dec  2 17:42:17 dx sh[41225]: DBD::mysql::db do failed: Incorrect 
>> string value: '\xD3N' for column 'comment' at row 1 at 
>> /spider/perl/DXSql.pm line 84.
>> Dec  2 19:13:07 dx sh[51492]: DBD::mysql::db do failed: Incorrect 
>> string value: '\xB0 ACRA...' for column 'comment' at row 1 at 
>> /spider/perl/DXSql.pm line 84.
>> root at dx:~#
>>
>> Any ideas ?
>>
>> thanks
>>
>> Tim
>>
>>
>
>
> _______________________________________________
> Dxspider-support mailing list
> Dxspider-support at tobit.co.uk
> https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support

-- 
VK2XAX : QF56if : ITU59 : CQ30 : BMARC : WIA