#ossasepia | 2019-11-27

04:23

diana_coman: EOD Report: 6.5hr done of saltmines, I wound up spending closer to 3h today on researching/ordering parts. I used an extra 1hr 15min to read/study Spanish. I investigated the 0000 gmt datetime bug. The problem I am almost certain arose after I revived my dead sql process. mpwp uses the 0000 to signify a null date, and my new sql process has a setting that makes the date invalid and rejects the insert. The new time cons

04:23

whaack

uming item I have is I must make trips to the atm (1h by taxi each way) to acquire cash to pay rent and have enough cash to be able to make bank deposits to order the computer parts. I am trying to speed the cash acquiring process up by doing a btc-buy in the us and a btc-sell locally.

~ 3 hours 46 minutes ~

08:09

04:23	whaack	diana_coman: EOD Report: 6.5hr done of saltmines, I wound up spending closer to 3h today on researching/ordering parts. I used an extra 1hr 15min to read/study Spanish. I investigated the 0000 gmt datetime bug. The problem I am almost certain arose after I revived my dead sql process. mpwp uses the 0000 to signify a null date, and my new sql process has a setting that makes the date invalid and rejects the insert. The new time cons
04:23	whaack	uming item I have is I must make trips to the atm (1h by taxi each way) to acquire cash to pay rent and have enough cash to be able to make bank deposits to order the computer parts. I am trying to speed the cash acquiring process up by doing a btc-buy in the us and a btc-sell locally.
		~ 3 hours 46 minutes ~
08:09	diana_coman	whaack: mpwp has 0000 set as default for dates indeed; does the insert rely on default values though? it sounds rather surprising because you'd end up with those 0000 everywhere then, hm; what happened to the "sql process" that it had to be revived anyway?
08:10	diana_coman	the btc-buy/sell locally will be useful anyway.
		~ 1 hours 23 minutes ~
09:33	diana_coman	asciilifeform: atm whaack doesn't really have the luxury of figuring out how to build an UPS from scratch too, on top of everything else; yes, a working APC UPS is not ideal nor best nor anything else; it still is a working UPS.
		~ 1 hours 51 minutes ~
11:25	diana_coman	jfw: how's this: http://ossasepia.com/2010/05/11/mica-fabula-de-kafka/#comment-7096
		~ 53 minutes ~
12:19	whaack	diana_coman: I am not sure what killed the mysql process. 9 days ago digitalocean sent out an email saying they, "rolled out mitigation efforts across our entire fleet" to address Intel's statement regarding a vulnerability, "Machine Check Error Avoidance On Page Size Change." It may be that they restarted my machine and my mysql process is not set to run on startup.
12:20	diana_coman	whaack: eurgh; such "service".
12:21	whaack	diana_coman: Well recall digitalocean was the lifeboat from the TMSR fire. I think that I should find a new provider and use them as a test for recovering my backups.
12:24	diana_coman	sounds like a plan.
		~ 1 hours 9 minutes ~
13:34	whaack	I found a solution to Incorrect datetime value bug. I edited the /etc/mysql/mysql.conf.d/mysqld.cnf file and added the line sql-mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,ALLOW_INVALID_DATE' . The change from my original sql_mode was I removed NO_ZERO_IN_DATE,NO_ZERO_DATE and added ALLOW_INVALID_DA
13:34	whaack	TES. Note that although in the client the variable is SQL_MODE in the cnf file you must assign the variable sql-mode with a hyphen. If you need to see your current sql mode you can run "SHOW VARIABLES LIKE 'sql_mode' ;" in the mysql client.
13:34	ossabot	Logged on 2019-11-26 00:12:53 whaack: For tomorrow's unexpected task list: I have a strange error that prevents me from saving drafts of articles on ztkfg. The error is some datetime value is getting set to 0000-00-00 00:00:00. My servers clock / date function seem to be working, and in the error log it shows some fields with the date/time set correctly.
13:38	diana_coman	whaack: do the dates end up now invalid in db though?
13:40	*	whaack goes to check
13:45	whaack	The dates end up as 0000-00-00 00:00:00 as I understand is intended. But I am going to see if I can remove the ALLOW_INVALID_DATES flag since that may not be necessary having already removed "NO_ZERO_DATE" and "NO_ZERO_IN_DATE".
13:51	diana_coman	whaack: uhm, dunno if intended; afaik in my db the dates are properly set really, for both post_date and post_date_gmt
13:51	diana_coman	the default values are 000 but I don't think it's meant to insert without setting it
13:52	diana_coman	hence my q yesterday and hint to go and look at the insert because it's not as much that it should allow bogus dates but rather WHY does it try to enter bogus dates to start with?
13:53	diana_coman	the trouble with unexpected resets and "updates" is that they might have fucked whatever versions of anything and therefore who knows how long it takes to track this down
13:53	whaack	diana_coman: The post_date is set correctly, but the post_date_gmt gets set to 0000. I will take a look as to why.
13:53	diana_coman	so yeah, can probably leave it at whatever non-breaking thing for now if it's not obvious, but should find a less time-consuming place for your blog indeed, by the looks of it
13:54	whaack	Also I did not need to set the flag ALLOW_INVALID_DATES, and I removed it. I also can keep the NO_ZERO_IN_DATE flag. I just needed to remove the NO_ZERO_DATE flag.
13:54	diana_coman	gotta love the 3 flags for same thing approach, myeah.
14:05	whaack	diana_coman: Okay I did a small investigation. The sql schema has the 0000 date as the defaults. The post_date_gmt gets left at the default, 0000, to represent that the article has not been posted yet (because one is saving a draft). That said, the other date variable "post_date" is being set when one saves a draft.
14:07	diana_coman	whaack: ah, so it's set fine when you publish it, then?
14:07	diana_coman	(I don't really keep drafts so yeah, I wouldn't notice that case)
14:09	whaack	diana_coman: yes.
14:10	diana_coman	ok then.
14:10	*	whaack bootstraps
		~ 1 hours 24 minutes ~
15:34	BingoBoingo	jfw: It's just about a week until you hop on the plane. Any loose ends outstanding for your Montevideo trip?
		~ 2 hours 38 minutes ~
18:12	dorion_road	hiya #o, good afternoon/evening. any one around willing and able to !!up me in #t ?
		~ 23 minutes ~