On existing working site with multiple views/displays updated Views 6.x-2.10 to 6.x-2.12 without any problems.
After updating Date 6.x-2.4 to 6.x-2.7 get following error msg on a view with Datetime fields:

• user warning: Unknown column 'node_data_field_news_date.field_news_date_value' in 'field list' query:
SELECT COUNT(*) FROM (SELECT DISTINCT DATE_FORMAT(STR_TO_DATE(node_data_field_news_date.field_news_date_value, '%Y-%m-%dT%T'), '%Y-%m') AS node_data_field_news_date_field_news_date_value,
COUNT(node.nid) AS num_records FROM node node LEFT JOIN content_field_publ_date node_data_field_publ_date ON node.vid = node_data_field_publ_date.vid WHERE ((node.status <> 0) AND (node.type in ('news_content')) AND (node.language in ('', 'sv'))) AND (DATE_FORMAT(STR_TO_DATE(node_data_field_publ_date.field_publ_date_value2, '%Y-%m-%dT%T'), '%Y-%m-%d') < '2011-01-17') GROUP BY node_data_field_news_date_field_news_date_value ORDER BY node_data_field_news_date_field_news_date_value DESC ) count_alias in /var/www/html/mysite/sites/all/modules/views/includes/view.inc on line 745.
• user warning: Unknown column 'node_data_field_news_date.field_news_date_value' in 'field list' query:
SELECT DISTINCT DATE_FORMAT(STR_TO_DATE(node_data_field_news_date.field_news_date_value, '%Y-%m-%dT%T'), '%Y-%m') AS node_data_field_news_date_field_news_date_value,
COUNT(node.nid) AS num_records FROM node node LEFT JOIN content_field_publ_date node_data_field_publ_date ON node.vid = node_data_field_publ_date.vid WHERE ((node.status <> 0) AND (node.type in ('news_content')) AND (node.language in ('', 'sv'))) AND (DATE_FORMAT(STR_TO_DATE(node_data_field_publ_date.field_publ_date_value2, '%Y-%m-%dT%T'), '%Y-%m-%d') < '2011-01-17') GROUP BY node_data_field_news_date_field_news_date_value ORDER BY node_data_field_news_date_field_news_date_value DESC LIMIT 0, 20 in /var/www/html/mysite/sites/all/modules/views/includes/view.inc on line 771.

Running these queries in phpmyadmin does not show any errors.

Comments

lilactiger89’s picture

lilactiger89 commented

I have the exact same problem. Nothing has changed from the old query and yet it no longer works after updating module versions

iamjon’s picture

iamjon commented
Status: Active » Postponed (maintainer needs more info)

Have you checked with date module could the problem be there?

iamjon’s picture

iamjon commented
Project: Views (for Drupal 7) » Date
Version: 6.x-2.12 » 6.x-2.7

I spoke with merlinofchaos about this on irc, we think this it could be a problem with date module moving the issue over there.

tomwrobel’s picture

tomwrobel commented

subscribing

skilip’s picture

skilip commented

subscribing

reaneyk’s picture

reaneyk commented

subscribing

benjohnstone’s picture

benjohnstone commented
Title: Error after updating Views and Date modules » subscribing

subscribing

realOFF’s picture

realOFF commented
Title: subscribing » Error after updating Views and Date modules

Setting back original title...

arlinsandbulte’s picture

arlinsandbulte commented
Status: Postponed (maintainer needs more info) » Closed (works as designed)

I *think* those unknown column errors had something to do with the arguments not set up correctly in the calendar view. You may need to recreate your calendar view.
OR, this might have been fixed. I remember some other issues regarding unknown column errors and I think most of those have been resolved.

If you are still getting this error, feel free to re-open.