2022-10-16T00:14:35  <malcolmlewis> Eighth_Doctor, I expect forums.opensuse.org hellcp yes?
2022-10-16T00:17:06  <hellcp> the same as the current forums
2022-10-16T07:43:49  <bmwiedemann[m]> Does someone know why there is a ipx-galera[123] cluster and if it should really be using over 100GB of RAM (total)
2022-10-16T10:15:40  <arthur> .help
2022-10-16T11:33:49  <hellcp> <bmwiedemann[m]> "Does someone know why there is a..." <- I wonder if I'm making it worse by testing db imports
2022-10-16T11:33:59  <hellcp> that is a lot of ram though
2022-10-16T11:39:00  <hellcp> huh, weird, discourse had backups enabled every 7 days and did them daily instead
2022-10-16T11:39:04  <hellcp> and also filled out space right away
2022-10-16T12:08:39  <hellcp> cboltz: I have a small mapping I'm collecting of mixed encoding content on the forums that I would like to fix up in the master db, since it makes importing a bit easier, would you be willing to help out with writing sql queries for that later?
2022-10-16T12:10:29  <hellcp> I do unfortunately have to turn all the broken characters into question marks, because the script doesn't really enjoy working with broken utf-8 strings, so I wanna salvage as much as we can here
2022-10-16T12:21:42  <cboltz> sounds doable ;-)
2022-10-16T13:12:17  <hellcp> cboltz: wrote what I currently have here https://progress.opensuse.org/issues/118927
2022-10-16T13:12:57  <hellcp> oh, I should have written what the messages should be, huh?
2022-10-16T13:13:25  <cboltz> yeah, that might help ;-)
2022-10-16T13:15:00  <cboltz> just wondering, since we are looking at a small number of individual posts - would it make sense to fix them via phpMyAdmin (and save the UPDATE query it uses)?
2022-10-16T13:22:45  <hellcp> sure, I guess so
2022-10-16T13:23:05  <hellcp> I can't submit my update to redmine
2022-10-16T13:23:15  <hellcp> I think it can't cope with the characters
2022-10-16T13:23:56  <hellcp> yeah, wow
2022-10-16T13:24:35  <hellcp> and paste.o.o says I'm a spammer
2022-10-16T13:24:35  <hellcp> outstanding
2022-10-16T13:31:20  <hellcp> cboltz: there you go, added a comment instead of editing the post https://progress.opensuse.org/issues/118927#note-1
2022-10-16T13:34:56  <hellcp> I'm gonna try decoding whatever that thing I couldn't decode said
2022-10-16T13:38:38  <hellcp> ah, it looks pretty familiar, I have seen that encoding before I think
2022-10-16T13:48:54  <cboltz> the \xFC in 4 is probably �, not �
2022-10-16T13:56:20  <hellcp> they both appear as broken characters to me
2022-10-16T13:57:07  <cboltz> well, "J\xFcrgen" looks like the german name "J�rgen"
2022-10-16T14:05:14  <hellcp> yeah, probably then
2022-10-16T14:41:38  <hellcp> oh, I know why I did that mistake
2022-10-16T14:41:47  <hellcp> I thought it was f6 and not fc
2022-10-16T16:15:37  <cboltz> hellcp: FYI: I fixed the � -> � in your ticket comment
2022-10-16T16:16:08  <hellcp> thanks
2022-10-16T17:40:44  *** teepee_ is now known as teepee
2022-10-16T17:50:26  <bmwiedemann[m]> btw: when re-encoding, you could also replace umlauts with `&uuml;` for ü so that encoding problems do not come back as easily
2022-10-16T17:52:18  <bmwiedemann[m]> or will UTF8 be the solution forever and for everything?
2022-10-16T18:00:11  <hellcp> utf-8 is what we are converting into
2022-10-16T18:01:13  <hellcp> unlike vb, discourse does utf-8 pretty well >:D
2022-10-16T19:47:23  <hellcp> cboltz: used phpmyadmin on https://forums.opensuse.org/showthread.php/431469-asus_atk0110-not-working-on-Asus-P7P55D-PRO, seems to work
2022-10-16T19:47:44  <hellcp> I guess I will just update the rest like that
2022-10-16T19:48:04  <hellcp> (I used html entity codes not to mess up the db further)
2022-10-16T19:49:08  <hellcp> (the jürgen part of it will be fixed by the script anyway, so I will keep that intentionally broken)
2022-10-16T19:50:16  <hellcp> ah, I also figured out the last few characters of https://forums.opensuse.org/showthread.php/420929-Artisan-50-CD-DVD-CD-DVD-Printer
2022-10-16T19:50:30  <hellcp> it's `｜アヴァシス株式会社`
2022-10-16T19:51:46  <cboltz> nice :-)
2022-10-16T20:54:25  <hellcp> fixed that one too https://forums.opensuse.org/showthread.php/420929-Artisan-50-CD-DVD-CD-DVD-Printer
2022-10-16T22:15:47  <malcolmlewis> hellcp, and that link should be deleted :( it 404's and would be classified as spam... <shrug>
2022-10-16T22:16:29  <hellcp> :shrug:
2022-10-16T22:17:06  <hellcp> I'm not against it, one thing less to migrate >:D
2022-10-16T22:17:16  <malcolmlewis> hellcp, no point in wasting your time on old stuff.... maybe replace it "link broken" or something...?
2022-10-16T22:18:08  <malcolmlewis> hellcp, if it works, all good, if it doesn't very likely the link can be deleted and just leave it?
2022-10-16T22:18:31  <hellcp> at this point it is all fixed, so may as well leave it
2022-10-16T22:18:44  <malcolmlewis> hellcp, ok :)
2022-10-16T22:19:30  <hellcp> the only real issues with the migration are encoding issues, those are annoying
2022-10-16T22:26:04  *** teepee_ is now known as teepee