The Official Status Thread
-
This post is deleted!
-
@Gustav said in The Official Status Thread:
You remind me of that one guy who was trying extremely hard
Wow, projecting much? Good job.
I'm going back to fucking around in PHP now, enjoy your pity party.
-
This post is deleted!
-
@Gustav said in The Official Status Thread:
Projecting what
@Gustav said in The Official Status Thread:
that one guy who
@Gustav said in The Official Status Thread:
on whom?
@Gustav said in The Official Status Thread:
You
@Gustav said in The Official Status Thread:
Did you even read what I said?
Did you know what you wrote?
@Gustav said in The Official Status Thread:
did you stop at my username and assumed I'm wrong by default?
More projecting, thanks. I don't care who you think you are but we're done here.
-
This post is deleted!
-
@Gustav said in The Official Status Thread:
@Tsaukpaetra one thing reminding me of another thing is projection now? Fuck, I miss times when words had meanings.
Yeah, you should go back to that time and fix the Sims 3 so we never have this garbage in the Status Thread.
-
This post is deleted!
-
@Gustav said in The Official Status Thread:
Fuck you and goodbye.
-
Status: Dog gamnit I hate bugs that are impossible to reproduce locally because reasons.
Also, I feel like I can improve this in some way...
Context should be
E
but for some reason it's (partially) setting it toA
for.... reasons?Good stuff.
-
-
Status: Methinks my dev database is not using the same settings as the production database...
Error in query (1055): Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'cm3_db.cm_Attendee_Badges.date_created' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Query in question:
SELECT DATE_FORMAT( `cm_Attendee_Badges`.`date_created`, "%Y-%m-%d" ) as `period` FROM `cm_Attendee_Badges` WHERE `cm_Attendee_Badges`.`date_created` >= "2036-01-01 00:00:00" GROUP BY DATE_FORMAT( `cm_Attendee_Badges`.`date_created`, "%Y-%m-%d" ) ORDER BY `cm_Attendee_Badges`.`date_created`
I understand this to mean that since I'm not copying the Group By term exactly I can't Order By just the column alone.
I think this is indeed more correct, so that's really more a issue with my ORM code.Good times.
-
@Tsaukpaetra youâre ordering by a term not being used for grouping, which means thereâs ambiguity about what should be used for ordering and what the value would mean.
Specifically, youâre turning timestamps into y-m-d and then asking it to sort by the timestamp - but the grouping operation necessarily affects that.
This particular case is fairly clear cut but there are plenty of more insidious ones which is why itâs been the default to behave this way in MySQL since 2011.
-
@Arantor said in The Official Status Thread:
since 2011
Yeah, that makes me wonder what other things my local db is doing weirdly.
-
@Tsaukpaetra did you upgrade to 5.6 recently? Or is something somewhere running in non-strict mode?
Check the sql_mode variable on the server (and the code )
-
@Arantor said in The Official Status Thread:
upgrade to 5.6 recently
Not recently, but it's been migrated from the time I was running my server from a Linksys NSLU2 micro-nas device. Use this knowledge wisely.
Edit: It says this about
SQL_MODE
:@@GLOBAL.sql_mode ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
-
@Tsaukpaetra said in The Official Status Thread:
@Arantor said in The Official Status Thread:
upgrade to 5.6 recently
wisely.
-
@Tsaukpaetra said in The Official Status Thread:
@Arantor said in The Official Status Thread:
upgrade to 5.6 recently
Not recently, but it's been migrated from the time I was running my server from a Linksys NSLU2 micro-nas device. Use this knowledge wisely.
Edit: It says this about
SQL_MODE
:@@GLOBAL.sql_mode ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
Yeah⌠so thereâs no ONLY_FULL_GROUP_BY in there which is in the default, so something somewhere is different. You can reset that on the server, or per sessionâŚ
-
@Arantor said in The Official Status Thread:
@Tsaukpaetra youâre ordering by a term not being used for grouping, which means thereâs ambiguity about what should be used for ordering and what the value would mean.
Specifically, youâre turning timestamps into y-m-d and then asking it to sort by the timestamp - but the grouping operation necessarily affects that.
The odd thing is converting the same clause into a named column (
period
) and then not just using that in bothGROUP BY
andORDER BY
. The optimizer might pick that up... but I wouldn't count on it.Without that, you have the problem of an ordering having more information than the group really has (unless you nominate a representative row to stand for the group, which is out of the SQL spec). DBs really vary a lot in what they do about that.
-
STATUS Never should have gone to the pub yesterday. Hungover and sick now. Ireland won though! And I have a three day weekend.
What have ye done to Gaska again?
-
@dkf previously, MySQL used to have a âgood enoughâ behaviour for it based on specific quirks of its optimiser but theyâre trying to push people towards standard SQL behaviour with âyouâre grouping, you probably should be sorting on something in the groupâ (for that exact reason) and a surprising amount of MySQL users went âwut?â
The extra column shenanigans are unlikely to help. The preparser step (âdo I have the thingsâ) is extremely conservative, even down to forcing the group by to have things that it wouldnât need when it starts talking about things that are functionally dependent. It just⌠doesnât seem to care and says no anyway.
-
@DogsB said in The Official Status Thread:
What
have ye done to Gaskahas @Gustav done to himself again?
-
@dkf said in The Official Status Thread:
@Arantor said in The Official Status Thread:
@Tsaukpaetra youâre ordering by a term not being used for grouping, which means thereâs ambiguity about what should be used for ordering and what the value would mean.
Specifically, youâre turning timestamps into y-m-d and then asking it to sort by the timestamp - but the grouping operation necessarily affects that.
The odd thing is converting the same clause into a named column (
period
) and then not just using that in bothGROUP BY
andORDER BY
. The optimizer might pick that up... but I wouldn't count on it.You know, that's an excellent idea! I'll put that on the list for implementation!
-
@DogsB said in The Official Status Thread:
What have ye done to Gaska again
Refused to pretend that people aren't stupid by default.
-
status: shit, forgot to do Replicon. Whoops.
-
@dkf said in The Official Status Thread:
The odd thing is converting the same clause into a named column (period) and then not just using that in both GROUP BY and ORDER BY.
IIRC, some database engines - and I think especially of mysql - did not cope with that some time ago.
Or was that Oracle?
:CRS:
-
The Traumatic Database Experiences thread is
-
@Zerosquare Show me on the doll where the database hurt you.
-
@HardwareGeek said in The Official Status Thread:
@Zerosquare Show me on the doll where the database hurt you.
Right on the cross outer join!
-
Status: Last night's push to prod exposed an off-by-one error that was the actual underlying cause of the issue from the beginning.
Hooray?
Except the exposure came in the form of complete breakage on the initial form step so you couldn't actually progress in the explicit intent of the site.
Ray hoo...
-
The forecast for today did not include rain. I finally got around to going outside to do some yardwork I should have done months ago. Guess what started as soon as I walked outside.
-
@HardwareGeek said in The Official Status Thread:
The forecast for today did not include rain. I finally got around to going outside to do some yardwork I should have done months ago. Guess what started as soon as I walked outside.
Free water cooling!
-
Status: Windows Vista Home Premium! On a Celeron! With 4Gb of RAM!
Some asshole designer at Dell really had their laugh.
-
@Tsaukpaetra why would you resurrect such a poor, misbegotten creature? wasn't it enough that it suffered in its first life?
-
@Arantor said in The Official Status Thread:
you resurrect
I'm not. I am tasked with secure wiping the drive and then potentially donating it.
-
@Tsaukpaetra said in The Official Status Thread:
Do you have a point or are you being loopy
-
@Tsaukpaetra said in The Official Status Thread:
I am tasked with secure wiping the drive
Nuke it from orbit.
-
@Tsaukpaetra said in The Official Status Thread:
Status: Windows Vista Home Premium! On a Celeron! With 4Gb of RAM!
Some asshole designer at Dell really had their laugh.
Edit: Shit, the sticker lied. It's a Core(tm)2 Duo T5450 @ 1.55GHz and only 2 GB of RAM!
-
@Tsaukpaetra said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
Status: Windows Vista Home Premium! On a Celeron! With 4Gb of RAM!
Some asshole designer at Dell really had their laugh.
Edit: Shit, the sticker lied. It's a Core(tm)2 Duo T5450 @ 1.55GHz and only 2 GB of RAM!
That thing doesn't need secure wiped, it needs the business end of a shotgun
-
@izzion Or a flamethrower. Nobody's ever got data out of smoke and ashes.
-
@dkf said in The Official Status Thread:
Nobody's ever got data out of smoke and ashes.
Pre-colonial residents of the North American continent would like to disagree with you on that one
-
@izzion Never said anything about modulating them after creation.
-
Status: Replacing the motherboard in my bust machine seems to have done the trick; it's now got an OS and boots, which isn't too bad given that I suspect the old system had a memory controller behaving slightly out of spec (but just sometimes, such as when the case temperature went up; it was very marginal so it only showed up occasionally, but gradually got worse) and that had resulted in corrupted memory, and that in turn meant corrupted files too. I've just got to figure out how to let the new mobo get a driver update so that it can use its network card and I'll be able to get everything else sorted...
Because there was definitely file (and filesystem) corruption with the old mobo, I'm reinstalling absolutely everything. Couldn't trust anything to behave right. Fortunately, I hadn't gotten around to putting much on the system besides games (due to ).
-
@izzion said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
Status: Windows Vista Home Premium! On a Celeron! With 4Gb of RAM!
Some asshole designer at Dell really had their laugh.
Edit: Shit, the sticker lied. It's a Core(tm)2 Duo T5450 @ 1.55GHz and only 2 GB of RAM!
That thing doesn't need secure wiped, it needs the business end of a shotgun
Would certainly be faster. 47Mbps at the beginning of the drive, I wonder what it'll be at the end...
I think if I get this booted off wifi it would be faster!
-
@izzion said in The Official Status Thread:
That thing doesn't need secure wiped, it needs the business end of a shotgun
@dkf said in The Official Status Thread:
@izzion Or a flamethrower. Nobody's ever got data out of smoke and ashes.
-
Status: Pentium 4! With 1 GB RAM! 120 GB of spinning rust!
At least this one has a more reasonable Windows XP SP2 install on it.
Doesn't boot off of USB, so I'm being creative.
Unarchived a rather old image of ReaToGoXP on CDROM I made (physical media) and.... holy shit it still works! Good times. This disc has Worms and Starcraft on it!
Anyways, use that to clone a USB flashdrive prepared with rufus and DBAN on it to the spinning rust so that it can boot and nuke... itself!
I am a sick and twisted little thing sometimes.
-
@Tsaukpaetra said in The Official Status Thread:
I am a sick and twisted little thing sometimes.
Only sometimes?
-
@Zerosquare said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
I am a sick and twisted little thing sometimes.
Only sometimes?
Sometimes I'm a little fucker! Or at least, I play one in fiction.
-
@HardwareGeek said in The Official Status Thread:
@Zerosquare Show me on the doll where the database hurt you.
select * from doll where hurtbyid = db.id
-
-
@Tsaukpaetra said in The Official Status Thread:
I am a sick and twisted little thing sometimes.
If your little thing is twisted, no wonder you're sick