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 20:57:18' 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





























Can’t Cox and KETV Just Get Along?

Okay, so I usually don’t give a crap when it comes to contractual disagreements between companies - whatever, right? But this is personally affecting me and these twits seem to be blaming each other.

We got a postcard from our cable company saying that Hearst-Argyle Television, the company that owns channel 7 (KETV), and Cox Communications cannot seem to come to an agreement regarding the rates for offering channel 7’s digital programming. SO….KETV’s owners have agreed that it is okay to allow the analog channel 7 (so us poor customers don’t have to do without the programming), but they cannot offer the digital channel effective right away. So, as much as I love football in HD, at least we still have our LOCAL TV CHANNEL on our cable offering, right?

For those of you wishing to be bored, the story is here on KETV’s website. An exerpt:

OMAHA, Neb. — KETV-TV Channel 7 and KETV-DT Channel 20, which are among Omaha’s leading analog and digital television stations, respectively, on Sunday announced that the digital high definition signal of KETV-DT is no longer being carried on Cox cable television systems.

The removal of the station’s digital signals from the Cox system is the result of unsuccessful negotiations between representatives of Hearst-Argyle Television, Inc., KETV-TV’s parent company, and Cox. Hearst-Argyle is seeking fair and reasonable terms from Cox in return for allowing Cox to carry KETV-DT’s programming and charge its subscribers for access to that programming.

Here’s the rub for ME, though. I have DVR. And I record a LOT on DVR. But since this little spat (found out about it just yesterday), Cox Communications won’t allow me to DVR anything on Channel 7’s analog channel, with an error that comes up “unrecordable channel.” That’s complete bullshit. So….I have to do without the Rachael Ray Show and the other two shows on ABC I record will have to be watched live versus recorded. Um, there’s a REASON I record these shows, you idiots.

If you want to have your little arm-wrestling match in the backyard, fine. But if both of you truly care about your customers, you will want to allow us to have the conveniences that WE PAY FOR by subscribing to your service. And if I can’t record my shows, ABC, I don’t watch your shows. Get a clue.

/rant

UPDATE: So I wrote a note to Cox Cable to complain and the response today - and I paraphrase: “Lady, you are whacked. There’s no problem. We had this one technical issue on Thursday, but that channel isn’t restricted.” Um….so, why in the hell would I take the time to write you, buffoon, to tell you there’s a problem if there isn’t one? Magically, when I went home all was recordable again. And of course the response I received was canned and not even signed by a human. Eh. Who cares, I can use my DVR on ABC again.

…and Chris? Somehow I don’t think our little Omaha channel would come anywhere close to paying for Rachael’s salary. Phpht! :-)

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='604' 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-10-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-10-01' AND MONTH( post_date ) != MONTH( '2006-10-01' ) AND post_status = 'publish' ORDER BY post_date ASC LIMIT 1

    October 2006
    M T W T F S S
         
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    3031  
    • 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 20:57:18' 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