EPrints Technical Mailing List Archive

Message: #07690

< 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

in /usr/share/eprints3/lib/plugins/EPrints/Stats/Handler.pm , at the beginning. 

Il 13/02/19 08:36, Ajunk Pracetio ha scritto:

Hi,

Where I can activate this debug?

Thank you

Best regards,
Agung Prasetyo W.
On Wed, Feb 13, 2019 at 2:16 PM Yuri via Eprints-tech <eprints-tech@ecs.soton.ac.uk <mailto:eprints-tech@ecs.soton.ac.uk>> wrote: 

    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%7C6a1be75a25f64d3e81b708d69189d605%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=slje5RzX7C4LVo%2F6hfNgp4J060VgHt66ibSswFqAM%2BE%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%7C6a1be75a25f64d3e81b708d69189d605%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=Ac6cCgNKRIfdOt%2FInAPBKYE7X6jihQmirZglNpBSPg4%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%7C6a1be75a25f64d3e81b708d69189d605%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=Ac6cCgNKRIfdOt%2FInAPBKYE7X6jihQmirZglNpBSPg4%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%7C6a1be75a25f64d3e81b708d69189d605%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=mI%2BPH6a%2Be7NDqzflFdEf%2BvMAcFY%2BgSrznF8uCYsb9Z8%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%7C6a1be75a25f64d3e81b708d69189d605%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=oGKlIIrcJYRJ3hiujKve6MsPdznWajknUFk%2BecFeNIM%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%7C6a1be75a25f64d3e81b708d69189d605%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=cFiXukgD9DKIzcQQRnlATumDy76QaCaHNMwu3sxe8xQ%3D&amp;reserved=0
    *** 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%7C6a1be75a25f64d3e81b708d69189d605%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=mI%2BPH6a%2Be7NDqzflFdEf%2BvMAcFY%2BgSrznF8uCYsb9Z8%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%7C6a1be75a25f64d3e81b708d69189d605%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=oGKlIIrcJYRJ3hiujKve6MsPdznWajknUFk%2BecFeNIM%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%7C6a1be75a25f64d3e81b708d69189d605%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=cFiXukgD9DKIzcQQRnlATumDy76QaCaHNMwu3sxe8xQ%3D&amp;reserved=0



--
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%7C6a1be75a25f64d3e81b708d69189d605%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=Ac6cCgNKRIfdOt%2FInAPBKYE7X6jihQmirZglNpBSPg4%3D&amp;reserved=0
IG & Twitter : prazetyo


--
Yuri Carrer

 CAB - Centro di Ateneo per le Biblioteche, Università di Padova
 Tel: 049/827 3615 - Via Anghinoni, 3 - Padova