WordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'author_Colony.wp_posts.post_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_date < '2024-04-26 17:12:19' AND post_date != '0000-00-00 00:00:00' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC

Yahoo for Goohoo

Ft. Stuart, Morning Day 889

“Hey Kara? I’m having trouble with the intel database.”

Kara ran over to Robert, taking over his keyboard. “Ooh, yes, of course you are. I’m still working on it, but let me link you to the new starting page for the intel area.”

The page came up and Kara slowly nudged him aside. “OK, there are so many different databases currently housing intel data, and I’m in the process of consolidating them. For now, though, I’ve cross-referenced most of them and you can just use this page to search what you need. Let’s use St James as an example.”

Kara punched in his name and many lines came up. “So now when you go into one entry, you’ll see the areas that are cross referenced. Use this key and it’ll automatically open any of the hyperlinked words into tabs behind the entry. Hit the key again and they all close.”

Moore stared at Kara as she worked, thinking that he hadn’t seen someone get this excited about databases since Harry Kim at University.

Kara continued, pausing just long enough for some air. “You’ll see with this St James search that it is pulling information from the colony’s public journals also. It isn’t finished, of course, but it is getting there.”

Kara realized she had taken over his workspace and had been rambling. She moved aside. “Sorry, Robert, I guess I got carried away.”

“I take it this is what you’ve been working on these past few days?” Robert asked.

“Yeah. It has been fun working with databases like this again. If you can’t tell, I kind of like them,” Kara said sheepishly.

Robert thought to himself, “You don’t say,” but instead said aloud, “It looks like you’re making great progress. Did you write all this yourself? Using C+9?”

Kara sat back at her workstation. “I brought some of my tools with me from Earth. I’m using an IBM MDM overlay, but their engine is a bit weak, so I replaced it with OTS Goohoo enterprise engine. I used this setup back on Earth with good results, and so far its working pretty well. Just some more manual referencing left to do, and the first stage should be done in the next day or so.”

“Is that the Goohoo 2.0 engine? That’s very outdated now. I’ll see if I can dig up the latest in my files. If not, I know some of the fixes they made, and I might be able to tweak the 2.0 code to fix some of the security holes and add some features. Let me know when you’re done and I’ll take a look.”

“Be still my beating heart. Someone else on this rock who knows they’re way around the back alley of computers. There aren’t many of us, and few have time for this stuff. Glad to have you on board, even more than I was yesterday.” Then Kara got back to work.

Robert smiled. “Making new friends here might be easier than I thought,” he said to himself.

Comments are closed.



Colony: Alchibah is a science fiction blog novel.
Any resemblance to persons living or dead is purely coincidental. Probably.

All Contents (written or photo/artwork) not attributed to other sources is
Copyright (C) 2006 - 2011 by Jeff Soyer. All rights reserved.