[Dxspider-support] possible bug in MySQL routines ?

[J.Marcio]

Hi,
Could you try  in mysql utf8mb4. Alter table codification to (UTF-8 Unicode
(utf8mb4)) it maybe fix.

https://stackoverflow.com/Questions/1168036/how-to-fix-incorrect-string-value-errors

73, PY4OG. J.Marcio


Em qui., 2 de dez. de 2021 às 16:27, Tim Tuck via Dxspider-support <
dxspider-support at tobit.co.uk> escreveu:

> 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
>
>
> --
> VK2XAX : QF56if : ITU59 : CQ30 : BMARC : WIA
>
>
> _______________________________________________
> Dxspider-support mailing list
> Dxspider-support at tobit.co.uk
> https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support
>
-- 
J.Marcio
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.tobit.co.uk/pipermail/dxspider-support/attachments/20211202/5548d961/attachment.htm>