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 < '2024-03-28 08:54:15' 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





    • 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

6 Comments »
Angela said:

What a pain in the ass. It's all about the money and they could care less about their customers. That's for damn sure!



Chris said:

ABC has to pay for Rachel's salary someway:)



Dawn said:

Actually if Cox pays for the HD channel 7 it would cost the customers more. Right now Cox doesn't charge for anything other than the box that you use to get the HD Channels. If Cox has to pay KETV for the HD channel (and mind you they aren't just asking to be paid for each HD subscriber, they are asking to be paid thier fee for EVERY Cox cable subscriber) then the cost would be pretty big and it would likely cause customer bills to go up. As for the issue with recording digitally on channel 7 from what i've heard there have been more than a few problems with that channel since the issue with Cox and KETV started up so who really knows whats going on there.



David said:

Memo to Chris: ABC has nothing to do with the Rachael Ray show or her salary. Her show, like Oprah's and Dr. Phil's, is syndicated.



Merri said:

Hi David....I do think Chris was joking, just knowing Chris. :-)



David said:

Good news, in case you aren't yet aware of it: KETV-DT is back on Cox Digital Cable as of Wednesday afternoon. It's on 806, though that channel position could change eventually.



Leave a Comment!

:mrgreen: :neutral: :twisted: :arrow: :shock: :smile: :???: :cool: :evil: :grin: :idea: :oops: :razz: :roll: :wink: :cry: :eek: :lol: :mad: :sad: :!: :?:

Please note: Comments may be moderated. It may take a while for them to show on the page.

Back To Main


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

    March 2024
    M T W T F S S
         
     123
    45678910
    11121314151617
    18192021222324
    25262728293031
    • 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 < '2024-03-28 08:54:15' 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