WordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'merri_wrdp1.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 < '2019-01-15 21:07:10' 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





    • The 2006 Weblog Awards



      Design by





























JonBenet Ramsey: Closure on a Cold Case?

Following crime cases pretty regularly, the news in the JonBenet Ramsey case was quite a development.

BOULDER, Colo. — A former schoolteacher was arrested Wednesday in Thailand in the slaying of 6-year-old beauty queen JonBenet Ramsey — a surprise breakthrough in a lurid, decade-old murder mystery that had cast a cloud of suspicion over her parents.

Ramsey family attorney Lin Wood identified the suspect as John Mark Karr, 41. Federal officials, speaking on condition of anonymity, confirmed the name, and one law enforcement official told The Associated Press that Boulder police had tracked him down online.

Wood said the arrest vindicated JonBenet’s parents, John and Patsy Ramsey. Patsy Ramsey died of ovarian cancer June 24.

“John and Patsy lived their lives knowing they were innocent, trying to raise a son despite the furor around them,” Wood said. “The story of this family is a story of courage, and story of an American injustice and tragedy that ultimately people will have to look back on and hopefully learn from.”

It truly is a shame that the press was hellbent on vilifying John and Patsy Ramsey in the public eye. I wondered a number of times today whether Patsy would have faced her cancer diagnosis with a stronger will had she and her family’s reputation not been muddied publically so long.

I can’t help but wonder.

I hope the media can figure out that their role should be to report news, and not try and convict people in their news stories. Well, one *can* hope, right?

WordPress database error: [Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'merri_wrdp1.wp_comments.comment_type' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
SELECT comment_author, comment_author_url, comment_type, MAX(comment_ID) as comment_ID, SUBSTRING_INDEX(comment_content,'strong',2) as trackback_title, SUBSTRING_INDEX(comment_author,' » ',1) as pingback_blog, SUBSTRING_INDEX(comment_author,' » ',-1) as pingback_title FROM wp_comments WHERE (comment_post_ID='574' AND comment_approved = '1') AND (comment_type = 'trackback' OR comment_type = 'pingback') GROUP BY comment_author, comment_author_url ORDER BY comment_ID DESC LIMIT 50


Party Gal

Now I have to admit that I do my fair share of partying…..but a THREE DAY RECOVERY? Take another aspirin, suck down some Pepto and get back to bloggin ya wuss!

WordPress database error: [Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'merri_wrdp1.wp_comments.comment_type' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
SELECT comment_author, comment_author_url, comment_type, MAX(comment_ID) as comment_ID, SUBSTRING_INDEX(comment_content,'strong',2) as trackback_title, SUBSTRING_INDEX(comment_author,' » ',1) as pingback_blog, SUBSTRING_INDEX(comment_author,' » ',-1) as pingback_title FROM wp_comments WHERE (comment_post_ID='573' AND comment_approved = '1') AND (comment_type = 'trackback' OR comment_type = 'pingback') GROUP BY comment_author, comment_author_url ORDER BY comment_ID DESC LIMIT 50


    WordPress database error: [Expression #1 of ORDER BY clause is not in SELECT list, references column 'merri_wrdp1.wp_posts.post_date' which is not in SELECT list; this is incompatible with DISTINCT]
    SELECT DISTINCT MONTH(post_date) AS month, YEAR(post_date) AS year FROM wp_posts WHERE post_date < '2006-08-01' AND post_status = 'publish' ORDER BY post_date DESC LIMIT 1

    WordPress database error: [Expression #1 of ORDER BY clause is not in SELECT list, references column 'merri_wrdp1.wp_posts.post_date' which is not in SELECT list; this is incompatible with DISTINCT]
    SELECT DISTINCT MONTH(post_date) AS month, YEAR(post_date) AS year FROM wp_posts WHERE post_date > '2006-08-01' AND MONTH( post_date ) != MONTH( '2006-08-01' ) AND post_status = 'publish' ORDER BY post_date ASC LIMIT 1

    August 2006
    M T W T F S S
         
     123456
    78910111213
    14151617181920
    21222324252627
    28293031  
    • WordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'merri_wrdp1.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 < '2019-01-15 21:07:10' 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