EPrints Technical Mailing List Archive

Message: #07688

< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

Re: [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&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C8ee5d94041f24914d0c008d691832b5e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=T3TUlqr7fvu%2BqxRkr%2BSrKZNYH2x9h7VStRE6m9UnNOg%3D&amp;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&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C8ee5d94041f24914d0c008d691832b5e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=hKxZhntV3JVrA9DIASTVDzTOOSdE8q%2BHkS5E%2BWvnijo%3D&amp;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