#soylent | Logs for 2021-05-02
« return
[00:01:18] <c0lo> Trickle up seems to work https://nationalinterest.org
[00:01:19] <systemd> ^ 03Trump Hates This: Biden's $1,400 Stimulus Checks Made the Economy Boom
[00:02:26] <Sulla> Have they made the previous round of stimulus tax free yet?
[00:23:18] <c0lo> https://crypto.com
[00:23:20] <systemd> ^ 03TrumpCoin Price | TRUMP Price, USD converter, Charts | Crypto.com
[00:24:14] <c0lo> capped @ 18M
[01:15:31] -!- Sulla has quit [Ping timeout: 264 seconds]
[01:52:55] -!- boru` [boru`!~boru@gyrz-07-356-391-63.dynamic.mnet-online.de] has joined #soylent
[01:52:57] -!- boru has quit [Killed (NickServ (GHOST command used by boru`!~boru@gyrz-07-356-391-63.dynamic.mnet-online.de))]
[01:53:00] boru` is now known as boru
[02:07:55] -!- Sulla [Sulla!Sulla@n-68-39-817-302.hsd6.or.comcast.net] has joined #soylent
[02:08:05] <kyonko`> HEY AZUMAHAZUKI
[02:21:23] * FatPhil passes round a caps lock key in case someone needs one
[02:23:22] <FatPhil> c0lo: so if the economy's "booming", then the velocity of money must be really high?
[02:23:48] * FatPhil checks the charts, and pisses himself with laughter.
[02:24:42] <FatPhil> looks like we're gonna need a bigger chart, as V ain't been this low for well more than 6 decades...
[02:41:55] -!- Sulla has quit [Ping timeout: 264 seconds]
[02:44:12] <bacterium> xavier rudd has this prophetic song, "the cost of living is getting high, high, high...", and my point is, i guess, we are all fucked in the medium term, we are completely, royally fucked
[02:44:42] <bacterium> the rent on this rock is about to get expensive
[02:45:14] <bacterium> economic models relying on "growth" are about to be punched in the nuts
[02:47:55] <bacterium> unless, of course, there's a big new war, and everyone is invited, and then i guess there's gonna be some re-shuffle and some "new" space to expand into
[02:48:42] <bacterium> cheers
[02:50:09] * bacterium explores 8côtes de gascogne
[02:52:21] <FatPhil> nah, there's no new space to expand into - there's a DDT stash from the 70s dumped there.
[02:59:00] <bacterium> lol
[03:00:33] <bacterium> you, just like almost everyone else, is severely underestimating just how big the next war may be
[03:12:31] -!- aqu4bot has quit [Ping timeout: 264 seconds]
[03:17:06] -!- Subsentient [Subsentient!~WhiteRat@pptdbxlc9.us] has joined #soylent
[03:37:59] <FatPhil> assuming facts not in evidence
[03:58:32] -!- Sulla [Sulla!Sulla@n-68-39-817-302.hsd6.or.comcast.net] has joined #soylent
[03:58:54] <Sulla> 100 weight key switches were made for those who want workers comp
[04:26:35] <Bender> [SoylentNews] - Drone Operators Challenge Surveyors' Turf in Mapping Dispute - https://sylnt.us - adverse-possession-is-a-thing
[04:40:30] <kyonko`> I got FreeBSD 12.1 and Linux Mint 20 dual booting with FreeBSD boot0 mbr boot mgr
[04:40:37] <kyonko`> now...... what to do
[04:40:45] <kyonko`> oh right, see if FBSD can read ext4
[04:40:55] <kyonko`> but LM20 can't read FBSD UFS
[04:41:06] <kyonko`> so its a one way thing and I gots to PHILOSOPHIZE
[04:41:30] <kyonko`> all part of a balanced samizdat diet
[04:42:05] -!- SoyCow3117 [SoyCow3117!~2d84734f@45.132.ivq.uv] has joined #soylent
[04:44:19] -!- Sulla has quit [Ping timeout: 264 seconds]
[04:44:40] -!- SoyCow3117 has quit [Client Quit]
[06:05:55] -!- halibut has quit [Ping timeout: 264 seconds]
[06:07:21] -!- halibut [halibut!~halibut@gvm-lo.effi.org] has joined #soylent
[06:59:20] -!- SoyCow8595 [SoyCow8595!~2d84734f@45.132.ivq.uv] has joined #soylent
[06:59:55] -!- SoyCow8595 has quit [Client Quit]
[07:12:29] -!- Sulla [Sulla!Sulla@n-68-39-817-302.hsd6.or.comcast.net] has joined #soylent
[07:13:57] -!- Sulla has quit [Client Quit]
[07:19:09] -!- Sulla [Sulla!Sulla@n-68-39-817-302.hsd6.or.comcast.net] has joined #soylent
[07:36:44] -!- Sulla has quit []
[09:05:43] <Bender> [SoylentNews] - Turkey Regulates Cryptocurrency with Anti-Terrorism Rules; Chia Reaches 1 Exabyte - https://sylnt.us - make-a-turkey-of-crypto-by-storing-chia-pets-in-the-cloud?
[10:57:29] <c0lo> FatPhil, you mean Biden's money don't take more than 1 or 2 steps to extinguish a debt to a bank?
[10:59:28] <c0lo> And the rest are Trump's money used to speculate on stock market?
[11:03:53] <c0lo> Subsistence agriculture must do wonders for heath and wellbeing https://www.sciencefocus.com
[11:03:53] <systemd> ^ 03Gardening just twice a week improves wellbeing and relieves stress
[11:07:17] <c0lo> A nod to fusta https://pbs.twimg.com
[11:10:38] <c0lo> Hey, FatPhil, what's the nowadays maximum number of times met police are allowed to hit vulnerable girls? https://www.theguardian.com
[11:10:39] <systemd> ^ 03Met police officer dismissed for hitting vulnerable girl ‘more than 30 times’ with baton
[11:18:41] <FatPhil> not sure, might depend on race, and whether there's a staircase nearby. dark skinned and staircase present, I don't think any hitting is done, just a terrible terrible accident.
[11:21:43] <FatPhil> https://www.youtube.com
[11:21:44] <systemd> ^ 03Constable Savage
[11:36:59] <c0lo> Boeing some of its employees free to join police forces https://mynorthwest.com
[11:37:00] <systemd> ^ 03Boeing reports firing of 65 employees over last 10 months for 'racist, hateful conduct'
[11:37:15] <c0lo> s/som/let som/
[11:37:15] <SedBot> <c0lo> Boeing let some of its employees free to join police forces https://mynorthwest.com
[11:56:06] <c0lo> =submit https://qz.com
[11:56:08] <systemd> ✓ Sub-ccess! "03Quartz India" (16p) -> https://soylentnews.org
[12:42:40] <Teckla> https://mobile.twitter.com
[12:42:41] <systemd> ^ 03Twitter
[13:55:57] <Bender> [SoylentNews] - Autonomous Laser-Weeding Robot - https://sylnt.us - Robots-with-Lasers
[14:57:56] <Bytram> coffee++
[14:57:56] <Bender> karma - coffee: 5545
[14:58:32] <Bytram> Is there anybody here who could help me with some MySQL questions?
[14:59:18] <Bytram> I am working on the soylentdev database (i.e. NOT production)
[14:59:42] <Bytram> There are existing values in the modreasons table
[15:01:17] <Bytram> I am looking at making an update to the table that would replace 5 existing rows
[15:01:54] <Bytram> the dev table is slightly different from prod.
[15:04:11] <Bytram> If at all possible, I'd prefer just changing values without having to stop and restart the database (K.I.S.S.)
[15:09:56] <Bytram> I am thinking of just using "INSERT IGNORE" for all of the values in the table, but I have some concerns
[15:21:09] <Bytram> On further thought, looks like I'll need to restart apache anyway
[15:21:33] <Bytram> phone call; biab!
[15:39:44] <FatPhil> if it's just 5, then you can just update the rows one by one manually
[15:50:21] <Bytram> back and 4th
[15:52:19] <Bytram> yes, I *could*, but that involves some manual (read error-prone) activity and I would prefer to debug the *process* beforehand, rather than trying to repair things afterwards.
[15:53:42] <Bytram> It does not help that the dev db has a couple different values for the "ordered" column than what is in prod...
[15:54:23] <Bytram> I intend to manually update those, first, so I am starting with dev == prod (at least for this table)
[15:58:26] <Bytram> UPDATE modreasons SET ordered = 101 WHERE ordered = 99 ;
[15:58:35] <Bytram> UPDATE modreasons SET ordered = 100 WHERE ordered = 98 ;
[16:00:02] <Bytram> Having done *that*, I expect the tables to then be the same.
[16:06:44] <Bytram> done, and very glad I am that I verify everything after each step! Found a few values for one row that were not set correctly on dev. Should be non impacting, but better safe than sorry!
[16:07:33] <Bytram> | id | name | m2able | listable | val | karma | fairfrac | unfairname | ordered | needs_prior_mod |
[16:07:36] <Bytram> | 100 | ----------- | 0 | 0 | 0 | 0 | 0.5 | | 100 | 0 |
[16:08:26] <AzumaHazuki> "fairfrac?" "unfairname?"
[16:09:35] <FatPhil> I'm more perturbed by m2able, I thought m2 was purged from the codebase!
[16:10:44] <Bytram> UPDATE modreasons SET listable = 1 WHERE id = 100
[16:10:45] <Bytram> UPDATE modreasons SET val = 1 WHERE id = 100
[16:11:46] <Bytram> FatPhil: from the *code*... looks like the DB was not completely purged. Not gonna hurt if not referenced, right? :/
[16:12:58] <Bytram> | 100 | ----------- | 0 | 1 | 1 | 0 | 0.5 | | 100 | 0 |
[16:14:02] <FatPhil> git grep is your friend - there should be no references remaining in the code, and therefore should be a safe removal from the schema.
[16:15:02] <FatPhil> are we using any stored functions - those would also need to be checked (though those should have themselves been updated when the code changed)
[16:17:18] <Bytram> I was wondering about that! Thanks for the reminder!!! How can I tell?
[16:19:18] <Bytram> Looks like there may be one other difference, but I am uncertain whether the difference is real, or mistake in my documentation of my intended changes... give me a few minutes
[16:21:05] <Bytram> currently, for id = 100, dev has karma = 0 but according to my notes, it should have karma = 1 BUT that makes no sense to me at all.
[16:39:07] <Bytram> yep. my bad. Just went over to prod and looked again...
[16:39:22] <Bytram> | id | name | m2able | listable | val | karma | fairfrac | unfairname | ordered | needs_prior_mod |
[16:39:25] <Bytram> | 100 | ----------- | 0 | 0 | 0 | 0 | 0.5 | | 100 | 0 |
[16:46:06] -!- Sulla [Sulla!Sulla@n-68-39-817-302.hsd6.or.comcast.net] has joined #soylent
[16:48:30] <Bytram> UPDATE modreasons SET listable = 0 WHERE id = 100 ;
[16:48:30] <Bytram> mysql> UPDATE modreasons SET val = 0 WHERE id = 100 ;
[16:48:30] <Bytram> mysql> UPDATE modreasons SET karma = 0 WHERE id = 100 ;
[16:49:40] <Sulla> Has ID 100 been a bad guy?
[16:50:25] <Bytram> No, but I am trying to concentrate, so can't really engage in smalltalk atm. sry!
[16:57:33] <Bytram> Okay, looks like the copy I have of the code that would create this table is incorrect. Whether that just means I have an old version of the code (in: rehash-master/plugins/Moderation/mysql_dump.sql) *OR* I just found a bug, cannot say right now. I'm low on memory so cannot go to our github source and see what we have there. :/
[16:58:47] <Bytram> If anybody wants to go take a look and report back, that would be great!
[16:59:11] <Bytram> that said, I'm going to take a short break. laters!
[17:17:59] <Bytram> Good that I did take a break!
[17:18:01] <Bytram> https://stackoverflow.com
[17:18:02] <systemd> ^ 03"INSERT IGNORE" vs "INSERT ... ON DUPLICATE KEY UPDATE"
[17:18:54] <Bytram> Suggests the approach I planned to take would have failed (silently!) on me.
[17:26:09] -!- SoyCow8667 [SoyCow8667!~88902b80@136.144.sw.kgh] has joined #soylent
[17:31:32] <FatPhil> the latter is probably what you would have wanted
[17:33:29] <Bytram> FatPhil: thank you!
[17:34:28] <Bytram> The main thing I am very unsure about is if there are any "stored procedures" or "triggers" or whatever MySQL calls them.
[17:35:41] <Bytram> Long ago I spent a bunch of time w/ Oracle, and that location had a boatload of stored procs that maintained integrity with foreign keys.
[17:36:22] <Bytram> Don't know what MySQL calls them, so I don't even know how to search if we are using anything like that in our DB.
[17:36:51] <Bytram> >>> If anyone can give me a clue I would *really* appreciate it!
[17:38:16] <Bytram> that said, I've been at this since early this AM. Since this is the first nice day in a while, I'm gonna step outside and take a walk and collect my thoughts.
[17:38:36] <Bytram> thanks for all the help! =)
[17:38:37] <Bytram> laters
[17:47:18] -!- SoyCow8667 has quit [Quit: Web client closed]
[18:13:42] -!- systemd has quit [Remote host closed the connection]
[18:13:51] -!- systemd [systemd!~systemd@973-462-098-954.res.spectrum.com] has joined #soylent
[18:13:51] -!- systemd has quit [Changing host]
[18:13:51] -!- systemd [systemd!~systemd@pid1] has joined #soylent
[18:23:19] <chromas> https://www.youtube.com
[18:23:21] <systemd> ^ 03A Retired Microsoft Engineer Explains How to Fix Your Computer Problem
[18:43:07] -!- Sulla has quit [Ping timeout: 264 seconds]
[18:45:57] <Bender> [SoylentNews] - Huge Rocket Looks Set for Uncontrolled Reentry Following Chinese Space Station Launch - https://sylnt.us - what-goes-up...
[18:52:23] <Bytram> Woo Hoo!
[18:52:33] <Bytram> https://stackoverflow.com
[18:52:34] <systemd> ^ 03How do you list all triggers in a MySQL database?
[18:53:05] <Bytram> On prod (fluorine):
[18:53:11] <Bytram> mysql> show triggers ;
[18:53:13] <Bytram> Empty set (0.00 sec)
[18:53:15] <Bytram> mysql> select trigger_schema, trigger_name, action_statement
[18:53:17] <Bytram> -> from information_schema.triggers ;
[18:53:19] <Bytram> Empty set (0.01 sec)
[18:53:21] <Bytram> mysql>
[18:53:43] <Bytram> Which tells me I don't have to worry about triggers at all!
[18:54:26] <Bytram> (Which also makes me wonder how we maintain foreign keys autonomously?!??)
[18:54:40] -!- Sulla [Sulla!Sulla@n-68-39-817-302.hsd6.or.comcast.net] has joined #soylent
[19:10:35] <Bytram> Digging a little further, https://stackoverflow.com
[19:10:36] <systemd> ^ 03Insert into a MySQL table or update if exists
[19:10:49] <Bytram> Also note that you can use VALUES (name) to reference to the value you attempt to insert e.g. INSERT INTO table (id, name, age) VALUES(1, "A", 19) ON DUPLICATE KEY UPDATE name=VALUES(name) , age=VALUES(age) – Curious Sam Mar 1 '16 at 10:07
[19:11:32] <Bytram> ^^^ Seems to be the best, all-round, safest approach.
[19:11:57] * Bytram scurries off to create SQL statements.
[20:22:28] <Bytram> first draft completed, but it's ugly, and I got things formatted ugly, before I got them sorted in the order that I wanted them applies.
[20:23:04] <Bytram> Progress, yes, but now I have to head out the door for a few hours.
[20:23:09] <Bytram> Laters!
[20:24:13] <Bytram> fwiw, this is just one of the records I have:
[20:24:16] <Bytram> INSERT INTO modreasons (id, name, m2able, listable, val, karma, fairfrac, ordered, needs_prior_mod) VALUES
[20:24:16] <Bytram> ( 0, 'Normal', 0, 0, 0, 0, 0.5, 0, 0 )
[20:24:16] <Bytram> ON DUPLICATE KEY UPDATE id=VALUES(id), name=VALUES(name), m2able=VALUES(m2able), listable=VALUES(listable),
[20:24:16] <Bytram> val=VALUES(val), karma=VALUES(karma), fairfrac=VALUES(fairfrac), ordered=VALUES(ordered),
[20:24:17] <Bytram> needs_prior_mod=VALUES(needs_prior_mod) ;
[20:24:26] <Bytram> gtg!
[20:25:33] <kyonko`> I saw something like this in the manual for a western digital winchester disk control card controller manual in 1983
[20:25:49] <kyonko`> a meager 2.5 mb
[21:16:44] <kyonko`> I thought I would have to go LMDE to get linux mint to boot with FBSD mbr boot mgr
[22:40:14] <c0lo> https://www.scotsman.com
[22:40:16] <systemd> ^ 03Donald Trump's firm claims up to £500,000 via Covid-19 job fund despite axing staff
[22:48:00] <c0lo> https://www.buzzfeednews.com
[22:48:02] <systemd> ^ 03BuzzFeed
[22:57:02] <Sulla> I would want to see the details rather than trusting buzzfeed. I help with administering the grant money and other relief efforts. We had many companies locally where employees realized they could make more on unemployment and the employees were laid off rather than having the employee quit in hopes to get the employee back when the unemployment ended. While I wouldn't put it past Trumps org
[22:57:02] <Sulla> to be doing all sorts of bad shit like businesses owned by several other politicans did, there are a lot of situations where employees wanted to be laid off so you take the stimulus to pay who wants it and lose those who want unemployment instead
[23:25:36] <c0lo> If you would want to see the detail, probably rtfa is one of the first steps.
[23:25:42] <c0lo> "It said at least 66 jobs had been lost at Turnberry since last summer, with some staff rehired on inferior terms, which it described as an “abuse” of the emergency initiative."
[23:26:03] <Bender> [SoylentNews] - Google is Reportedly Saving Over $1 Billion a Year Thanks to Remote Work Policy - https://sylnt.us - how's-YOUR-company-doing?
[23:58:10] <c0lo> =submit https://www.msnbc.com
[23:58:13] <systemd> ✓ Sub-ccess! "03Opinion | No, Men are Not Alright. and Women are Paying the Price." (19p) -> https://soylentnews.org