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

[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 at 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%7C2fa8da9963a2495e7e2008d691860a6e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=AwOxJQRvcB0gDQzyFBzXilkx8%2BNFHoZKVfApMyq726I%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%7C2fa8da9963a2495e7e2008d691860a6e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=awrr8Xq7LDPnHzW5IAI0hGQxviIXVAgHde61ZeLvsAw%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%7C2fa8da9963a2495e7e2008d691860a6e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=awrr8Xq7LDPnHzW5IAI0hGQxviIXVAgHde61ZeLvsAw%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%7C2fa8da9963a2495e7e2008d691860a6e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=yydzEOcv2JVFhbzxXpQ6VulqP54xWwdNeeC8%2BytU2lU%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%7C2fa8da9963a2495e7e2008d691860a6e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=tujOXZRxXlEmMCbuRxhGlcpBh43eXufYKxR%2BFjX%2BYIk%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%7C2fa8da9963a2495e7e2008d691860a6e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=m306tZAQgxNwzCxh4W9poqsUxnjjjR0otwkzoA%2FjLtE%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%7C2fa8da9963a2495e7e2008d691860a6e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=yydzEOcv2JVFhbzxXpQ6VulqP54xWwdNeeC8%2BytU2lU%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%7C2fa8da9963a2495e7e2008d691860a6e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=tujOXZRxXlEmMCbuRxhGlcpBh43eXufYKxR%2BFjX%2BYIk%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%7C2fa8da9963a2495e7e2008d691860a6e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=m306tZAQgxNwzCxh4W9poqsUxnjjjR0otwkzoA%2FjLtE%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%7C2fa8da9963a2495e7e2008d691860a6e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=awrr8Xq7LDPnHzW5IAI0hGQxviIXVAgHde61ZeLvsAw%3D&amp;reserved=0
IG & Twitter : prazetyo
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20190213/783e5f89/attachment.html