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-04-26 08:59:45' 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





























August 8th, 2006

Dixie Chicks Reaping What They Sowed?

Perhaps a cost of isolating your fans, Dixie Witches?

NASHVILLE, Tenn. — Several concerts on the Dixie Chicks’ “Accidents & Accusations” tour have been canceled after slow ticket sales, but the group says it has replaced them with other dates.

Kansas City, Houston, St. Louis, Memphis and Knoxville are among 14 cities no longer on the original schedule released in May, according to a revised itinerary posted Thursday on the Dixie Chick’s Web site.

Other shows, including Nashville, Los Angeles, Denver and Phoenix, have been pushed back to later dates.

The Midwest and the South are the areas that are experiencing “lackluster sales.” It appears that bashing President Bush and their patriotic fans have sent them across the border to cover for the cancellation of their Midwest and Southern shows:

Group spokeswoman Kathy Allmand said Monday that the total number of North American dates remains the same, with several Canadian cities added in place of the U.S. shows.

Anyone up for helping them cancel some more U.S. stops? Heh.

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='569' 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

So said Merri | Idiotic Musings, Patriotic Musings | Comments & Trackbacks (3) | Link

    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 < '2024-04-26 08:59:45' 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



    •