EPrints Technical Mailing List Archive

See the EPrints wiki for instructions on how to join this mailing list and related information.

Message: #07689

< 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

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> wrote:
https://emea01.safelinks.protection.outlook.com/?url="">

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://emea01.safelinks.protection.outlook.com/?url="">>
> IG & Twitter : prazetyo
>
> *** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> *** Archive: https://emea01.safelinks.protection.outlook.com/?url="">
> *** EPrints community wiki: https://emea01.safelinks.protection.outlook.com/?url="">
> *** EPrints developers Forum: https://emea01.safelinks.protection.outlook.com/?url="">
*** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
*** Archive: http://www.eprints.org/tech.php/
*** EPrints community wiki: http://wiki.eprints.org/
*** EPrints developers Forum: http://forum.eprints.org/


--
Life isn't valuable if you don't have someone to care

IG & Twitter : prazetyo