Perl 6 - the future is here, just unevenly distributed

IRC log for #ilbot, 2017-07-22

| Channels | #ilbot index | Today | | Search | Google Search | Plain-Text | summary

All times shown according to UTC.

Time Nick Message
01:48 ilbot3 joined #ilbot
01:48 Topic for #ilbot is now ilbot -- http://moritz.faui2k3.org/en/ilbot -- logs at http://irclog.perlgeek.de/ilbot/today -- read UPGRADE.md and upgrade!
09:38 cgfbee joined #ilbot
13:51 moritz so, since the update to Debian Stretch, there are encoding issues on https://irclog.perlgeek.de/
13:52 AlexDaniel joined #ilbot
13:52 moritz the good news is that the logging before and after the update is consistent in its encoding fuckup
13:52 Zoffix joined #ilbot
13:52 moritz so now I've figured out way to correct the encoding
13:53 moritz I've created a copy of the ilbot_lines table, and now have a script that copies with correct encoding into the new table
13:53 moritz it seems with the current version of DBD::mysql and mariadb, you need both "set names utf8" *and* $dbh->{mysql_enable_utf8} = 1
13:54 moritz 17% of the table recoded now
13:56 Zoffix \o/
13:56 AlexDaniel moritz: any chance you may need some pre-fuckup json dumps?
13:56 AlexDaniel maybe to test that the conversion was successful or something
13:57 AlexDaniel I just realized that quotable6 is using these for its thing
13:57 AlexDaniel it's about 240MiB I think
13:59 AlexDaniel on the other hand, I may do it here myself once it's available
15:40 moritz AlexDaniel: thanks for the offer, but the conversion is pretty obvious
15:47 moritz AlexDaniel: this is what it looks like after the the conversion: https://irclog.perlgeek.de/perl6/2017-07-22#i_14907752
15:48 moritz or https://irclog.perlgeek.de/perl6/2017-07-22#i_14907056
15:48 AlexDaniel yeah, seems to be correct
15:48 AlexDaniel irc colors never worked before I guess
15:49 AlexDaniel (e.g. https://irclog.perlgeek.de/perl6/2017-07-22#i_14907867 )
15:50 moritz I guess I'll have to do a switch-over to the new table tonight
18:44 moritz I'll take down the logger, switch out the tables, and then I'll try to do some logging with the fixed code
18:44 moritz so, there will be a small down time
18:49 ilbot3 joined #ilbot
18:49 Topic for #ilbot is now ilbot -- http://moritz.faui2k3.org/en/ilbot -- logs at http://irclog.perlgeek.de/ilbot/today -- read UPGRADE.md and upgrade!
18:49 Zoffix "Internal Server Error" hehe :)
18:50 moritz Unicode test: ä - U+000E4 - LATIN SMALL LETTER A WITH DIAERESIS
18:51 moritz
18:53 moritz Zoffix: heh, I had changed the code to reference the fixed copy of the table
18:53 moritz Zoffix: had to change it back now
18:53 moritz https://irclog.perlgeek.de/perl6/2017-07-22#i_14908410 looks good
18:54 moritz i hereby declare everything fixed and rosy
18:55 ilbot-news joined #ilbot
18:55 ilbot-news [ilbot] moritz pushed 1 new commit to master: https://github.com/moritz/ilbot/commit/8d4be6f6f03723b18cb37a05efad718bee7fc4f8
18:55 ilbot-news ilbot/master 8d4be6f Moritz Lenz: Fix encoding issue on newers Perls + MariaDB
18:55 ilbot-news left #ilbot
18:58 Zoffix Sweet
18:58 Zoffix moritz++
18:58 Zoffix left #ilbot

| Channels | #ilbot index | Today | | Search | Google Search | Plain-Text | summary