mySQL error with query SELECT itime, SUBSTRING(itime,1,4) AS Year, SUBSTRING(itime,6,2) AS Month, SUBSTRING(itime,9,2) as Day FROM kyle_nucleus_item WHERE iblog=1 and itime <="2018-08-19 03:15:31" and idraft=0 GROUP BY Year, Month ORDER BY itime DESC: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'nucleus.kyle_nucleus_item.itime' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
There are many stories from my past that make me cringe when I think of them. However, most of them involve only me looking dumb.
So that's why this particular story continually rakes at my insides whenever I remember it. Because the end result was not me looking all that foolish, but rather me embarassing the person I was attempting to help. (more)
I don't like linking to stories from Slashdot, as, I figure most of my acquaintances would have seen them, and for the ones who hadn't, probably wouldn't care anyway.
However, I'll make an exception this time.
The Kama Sutra, as illustrated by the Scout Walkers from Star Wars:
