<div dir="ltr"><div>Hi,</div><div><br></div><div>Where I can activate this debug?</div><div><br></div><div>Thank you</div><div><br></div><div>Best regards,</div><div>Agung Prasetyo W.<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Feb 13, 2019 at 2:16 PM Yuri via Eprints-tech <<a href="mailto:eprints-tech@ecs.soton.ac.uk">eprints-tech@ecs.soton.ac.uk</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><a href="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%7C2fa8da9963a2495e7e2008d691860a6e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&sdata=AwOxJQRvcB0gDQzyFBzXilkx8%2BNFHoZKVfApMyq726I%3D&reserved=0" originalSrc="https://stackoverflow.com/questions/10957238/incorrect-string-value-when-trying-to-insert-utf-8-into-mysql-via-jdbc" shash="If4RVZBMhpqFAlZElsKP+NkTlD+s63j57u00i0+EpTIbIN1EP4HAcV9VuCFJa1K0hfG8HzFQmrzP28KJWPhxS92p2wuM95faWySJUKA24Tepl2ewbv4dmOHBAo+lH6QwWlPggFa3lO5L3YbSluf525bjfEcSAOrXC850c1eYGqo=" rel="noreferrer" target="_blank">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</a><br>
<br>
maybe this?<br>
<br>
\xF76 should be a four byte utf-8. But Eprints itself don't have this <br>
problem, so it is something in Irstats connection or irstat tables with <br>
different column encoding. Anyway, you can activate<br>
<br>
my $DEBUG_SQL = 0; (switch to 1) to debug the sql.<br>
<br>
Il 13/02/19 01:58, Ajunk Pracetio via Eprints-tech ha scritto:<br>
> Hi,<br>
><br>
> Previously, I migrated eprints 3.3.12 to 3.4 on Ubuntu 12.04 LTS. <br>
> Currently I have managed to move eprints from an old server to a <br>
> server using Ubuntu 16.04 LTS.<br>
><br>
> Only, when doing the irstats process, the *process_stats REPOID <br>
> --setup --verbose* command appears an error like the following:<br>
><br>
> *DBD::mysql::st execute failed: Incorrect string value: '\xF76' for <br>
> column 'value' at row 1 at <br>
> /usr/share/eprints3/lib/plugins/EPrints/Stats/Handler.pm line 653.<br>
> ....<br>
> DBD::mysql::st execute failed: Data too long for column 'value' at row <br>
> 1 at /usr/share/eprints3/lib/plugins/EPrints/Stats/Handler.pm line 653.*<br>
><br>
> Did this error occur because our previous database actually came from <br>
> the version of mysql 5.5.54 (eprints 3.3.12 and Ubuntu 12.04) and <br>
> changed to mysql 5.7.25 (eprints 3.4 and Ubuntu 16.04).<br>
><br>
> I have searched Google and haven't found a solution. Can anyone help <br>
> us with this error? Then will this error affect the amount of data <br>
> displayed on IRStats?<br>
><br>
> thank you.<br>
><br>
> Best regards.<br>
> Agung Prasetyo W.<br>
><br>
> -- <br>
> Life isn't valuable if you don't have someone to care<br>
><br>
> Blog : <a href="https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fagungprasetyo.net%2F&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C2fa8da9963a2495e7e2008d691860a6e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&sdata=awrr8Xq7LDPnHzW5IAI0hGQxviIXVAgHde61ZeLvsAw%3D&reserved=0" originalSrc="https://agungprasetyo.net/" shash="fwF/NEEmzC07xLYFrhNFJhidh7CBzBRA4k3ipprzJr1xDQhYY3gBpLaobZ3JtpjnG3wpA8Hm/sYhEdDn9VgUNwTOEa3hJZaCqRt/nz06p7LTzAoCs8FZobvFtxoNgiHMrzq7T9Kp2Tg9vwlijEENnU7rMbjBoUpSzkBoCTog9/Q=" rel="noreferrer" target="_blank">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</a> <br>
> <<a href="https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fagungprasetyo.net%2F&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C2fa8da9963a2495e7e2008d691860a6e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&sdata=awrr8Xq7LDPnHzW5IAI0hGQxviIXVAgHde61ZeLvsAw%3D&reserved=0" originalSrc="https://agungprasetyo.net/" shash="fwF/NEEmzC07xLYFrhNFJhidh7CBzBRA4k3ipprzJr1xDQhYY3gBpLaobZ3JtpjnG3wpA8Hm/sYhEdDn9VgUNwTOEa3hJZaCqRt/nz06p7LTzAoCs8FZobvFtxoNgiHMrzq7T9Kp2Tg9vwlijEENnU7rMbjBoUpSzkBoCTog9/Q=" rel="noreferrer" target="_blank">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</a>><br>
> IG & Twitter : prazetyo<br>
><br>
> *** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech" rel="noreferrer" target="_blank">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
> *** Archive: <a href="https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C2fa8da9963a2495e7e2008d691860a6e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&sdata=yydzEOcv2JVFhbzxXpQ6VulqP54xWwdNeeC8%2BytU2lU%3D&reserved=0" originalSrc="http://www.eprints.org/tech.php/" shash="BhoNeaZuqvhnT3FGsTmZkLPrZWxqgF5y88G8dmEi6eP1dbJbGyRetZnNzUcLkvV0b8ERuXyuNHa2KP2aHFzl/VD+UwZnT5o0kgaSuVQIeuIo+/tqAoLO2oR0XpGXQ7K3weEsD1hx6UmXZV9s/PE/noEADce1Fq6VCB6LfWb4nPw=" rel="noreferrer" target="_blank">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</a><br>
> *** EPrints community wiki: <a href="https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C2fa8da9963a2495e7e2008d691860a6e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&sdata=tujOXZRxXlEmMCbuRxhGlcpBh43eXufYKxR%2BFjX%2BYIk%3D&reserved=0" originalSrc="http://wiki.eprints.org/" shash="g7RtRjb7sPqczq7yKlgACVMC3Dm5X+HUbrLEnQ89KPgXBjtHJebZ1BkUXIhnW/vTMuIQvzMoO2ixa32Fp1UP+RA8Oaq139Ud+MnZh54aTxgJQuEfkuHX7RV745QQSSvK+7STe9mJcOKj2QSnSMMgpU6kFTcwfB6RKsztaX10svA=" rel="noreferrer" target="_blank">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</a><br>
> *** EPrints developers Forum: <a href="https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fforum.eprints.org%2F&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C2fa8da9963a2495e7e2008d691860a6e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&sdata=m306tZAQgxNwzCxh4W9poqsUxnjjjR0otwkzoA%2FjLtE%3D&reserved=0" originalSrc="http://forum.eprints.org/" shash="MQ+JEJjr7crjqftNWgwfjmPSj0bH7U/e8PzmyXWK1zSCOCr3o5Ozz7kqsNite5/pjXWgO8u0wRHqZQnWkDBV4TFwY4AIcmhse5CVbq+uQhzAMYk3+ocCkqTfs1iiUM56zVeG0rR/XzXDgiNitEZZOcmm4U9/nAlr9hK//W19CEg=" rel="noreferrer" target="_blank">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</a><br>
*** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech" rel="noreferrer" target="_blank">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
*** Archive: <a href="https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C2fa8da9963a2495e7e2008d691860a6e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&sdata=yydzEOcv2JVFhbzxXpQ6VulqP54xWwdNeeC8%2BytU2lU%3D&reserved=0" originalSrc="http://www.eprints.org/tech.php/" shash="BhoNeaZuqvhnT3FGsTmZkLPrZWxqgF5y88G8dmEi6eP1dbJbGyRetZnNzUcLkvV0b8ERuXyuNHa2KP2aHFzl/VD+UwZnT5o0kgaSuVQIeuIo+/tqAoLO2oR0XpGXQ7K3weEsD1hx6UmXZV9s/PE/noEADce1Fq6VCB6LfWb4nPw=" rel="noreferrer" target="_blank">http://www.eprints.org/tech.php/</a><br>
*** EPrints community wiki: <a href="https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C2fa8da9963a2495e7e2008d691860a6e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&sdata=tujOXZRxXlEmMCbuRxhGlcpBh43eXufYKxR%2BFjX%2BYIk%3D&reserved=0" originalSrc="http://wiki.eprints.org/" shash="g7RtRjb7sPqczq7yKlgACVMC3Dm5X+HUbrLEnQ89KPgXBjtHJebZ1BkUXIhnW/vTMuIQvzMoO2ixa32Fp1UP+RA8Oaq139Ud+MnZh54aTxgJQuEfkuHX7RV745QQSSvK+7STe9mJcOKj2QSnSMMgpU6kFTcwfB6RKsztaX10svA=" rel="noreferrer" target="_blank">http://wiki.eprints.org/</a><br>
*** EPrints developers Forum: <a href="https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fforum.eprints.org%2F&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C2fa8da9963a2495e7e2008d691860a6e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&sdata=m306tZAQgxNwzCxh4W9poqsUxnjjjR0otwkzoA%2FjLtE%3D&reserved=0" originalSrc="http://forum.eprints.org/" shash="MQ+JEJjr7crjqftNWgwfjmPSj0bH7U/e8PzmyXWK1zSCOCr3o5Ozz7kqsNite5/pjXWgO8u0wRHqZQnWkDBV4TFwY4AIcmhse5CVbq+uQhzAMYk3+ocCkqTfs1iiUM56zVeG0rR/XzXDgiNitEZZOcmm4U9/nAlr9hK//W19CEg=" rel="noreferrer" target="_blank">http://forum.eprints.org/</a><br>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div>Life isn't valuable if you don't have someone to care<br></div><div><br></div><div>Blog : <a href="https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fagungprasetyo.net%2F&data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C2fa8da9963a2495e7e2008d691860a6e%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&sdata=awrr8Xq7LDPnHzW5IAI0hGQxviIXVAgHde61ZeLvsAw%3D&reserved=0" originalSrc="https://agungprasetyo.net/" shash="fwF/NEEmzC07xLYFrhNFJhidh7CBzBRA4k3ipprzJr1xDQhYY3gBpLaobZ3JtpjnG3wpA8Hm/sYhEdDn9VgUNwTOEa3hJZaCqRt/nz06p7LTzAoCs8FZobvFtxoNgiHMrzq7T9Kp2Tg9vwlijEENnU7rMbjBoUpSzkBoCTog9/Q=" target="_blank">https://agungprasetyo.net/</a><br></div><div>IG & Twitter : prazetyo<br></div></div></div>