[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[EP-tech] Error when running irstats



https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F10957238%2Fincorrect-string-value-when-trying-to-insert-utf-8-into-mysql-via-jdbc&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C8ee5d94041f24914d0c008d691832b5e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&sdata=T3TUlqr7fvu%2BqxRkr%2BSrKZNYH2x9h7VStRE6m9UnNOg%3D&reserved=0

maybe this?

\xF76 should be a four byte utf-8. But Eprints itself don't have this 
problem, so it is something in Irstats connection or irstat tables with 
different column encoding. Anyway, you can activate

my $DEBUG_SQL = 0; (switch to 1) to debug the sql.

Il 13/02/19 01:58, Ajunk Pracetio via Eprints-tech ha scritto:
> Hi,
>
> Previously, I migrated eprints 3.3.12 to 3.4 on Ubuntu 12.04 LTS. 
> Currently I have managed to move eprints from an old server to a 
> server using Ubuntu 16.04 LTS.
>
> Only, when doing the irstats process, the *process_stats REPOID 
> --setup --verbose* command appears an error like the following:
>
> *DBD::mysql::st execute failed: Incorrect string value: '\xF76' for 
> column 'value' at row 1 at 
> /usr/share/eprints3/lib/plugins/EPrints/Stats/Handler.pm line 653.
> ....
> DBD::mysql::st execute failed: Data too long for column 'value' at row 
> 1 at /usr/share/eprints3/lib/plugins/EPrints/Stats/Handler.pm line 653.*
>
> Did this error occur because our previous database actually came from 
> the version of mysql 5.5.54 (eprints 3.3.12 and Ubuntu 12.04) and 
> changed to mysql 5.7.25 (eprints 3.4 and Ubuntu 16.04).
>
> I have searched Google and haven't found a solution. Can anyone help 
> us with this error? Then will this error affect the amount of data 
> displayed on IRStats?
>
> thank you.
>
> Best regards.
> Agung Prasetyo W.
>
> -- 
> Life isn't valuable if you don't have someone to care
>
> Blog : https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fagungprasetyo.net%2F&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C8ee5d94041f24914d0c008d691832b5e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&sdata=hKxZhntV3JVrA9DIASTVDzTOOSdE8q%2BHkS5E%2BWvnijo%3D&reserved=0 
> <https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fagungprasetyo.net%2F&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C8ee5d94041f24914d0c008d691832b5e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=hKxZhntV3JVrA9DIASTVDzTOOSdE8q%2BHkS5E%2BWvnijo%3D&amp;reserved=0>
> IG & Twitter : prazetyo
>
> *** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> *** Archive: https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C8ee5d94041f24914d0c008d691832b5e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=jG%2B9sgJN%2FtMgqmAOHn1%2FJCCh%2BzYo%2BUgb%2B1J01CO3ybI%3D&amp;reserved=0
> *** EPrints community wiki: https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C8ee5d94041f24914d0c008d691832b5e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=pK0sicaY3zYsjNmndX7abtfNwC7vAt1jLmF3ydE%2FoWE%3D&amp;reserved=0
> *** EPrints developers Forum: https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fforum.eprints.org%2F&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C8ee5d94041f24914d0c008d691832b5e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=f8L%2FQpljrUV%2BUz19%2Fq6QcJ3Wv9eK8kpdfI3F0doiOwA%3D&amp;reserved=0