I added a date field, created by the latest CCK version, and the view botches while fetching the data. It is a standard List View without any theme applied.

If I remove the field from the view then the view displays with no errors. It seems the code is erroneously adding an _timestamp to the table column name but I could not find anything in my entire drupal codebase that does a ."_timezone" string concatenation.

Here is the error found in the watchdog log.

Unknown column 'node_data_field_release_date.field_release_date_timezone' in 'field list' query: SELECT DISTINCT(node.nid), node.title AS node_title, node.changed AS node_changed, node_data_field_genre.field_genre_nid AS node_data_field_genre_field_genre_nid, node_data_field_release_date.field_release_date_value AS node_data_field_release_date_field_release_date_value, node_data_field_release_date.field_release_date_timezone AS node_data_field_release_date_field_release_date_timezone, node_data_field_description.field_description_value AS node_data_field_description_field_description_value, node_data_field_description.field_description_format AS node_data_field_description_field_description_format, node_data_field_developer.field_developer_nid AS node_data_field_developer_field_developer_nid, node_data_field_publisher.field_publisher_nid AS node_data_field_publisher_field_publisher_nid, node_data_field_platform.field_platform_nid AS node_data_field_platform_field_platform_nid, node_field_weburl_data_field_homepage.field_weburl AS node_field_weburl_data_field_homepage_field_weburl, node_data_field_operating_systems.field_operating_systems_value AS node_data_field_operating_systems_field_operating_systems_value FROM node node LEFT JOIN node_data_field_genre node_data_field_genre ON node.vid = node_data_field_genre.vid LEFT JOIN node_content_video_game node_data_field_release_date ON node.vid = node_data_field_release_date.vid LEFT JOIN node_data_field_description node_data_field_description ON node.vid = node_data_field_description.vid LEFT JOIN node_data_field_developer node_data_field_developer ON node.vid = node_data_field_developer.vid LEFT JOIN node_data_field_publisher node_data_field_publisher ON node.vid = node_data_field_publisher.vid LEFT JOIN node_data_field_platform node_data_field_platform ON node.vid = node_data_field_platform.vid LEFT JOIN node_field_weburl_data node_field_weburl_data_field_homepage ON node.vid = node_field_weburl_data_field_homepage.vid AND node_field_weburl_data_field_homepage.field_name = 'field_homepage' LEFT JOIN node_data_field_operating_systems node_data_field_operating_systems ON node.vid = node_data_field_operating_systems.vid WHERE (node.type IN ('content_video_game')) ORDER BY node.title ASC LIMIT 2, 1 in /var/www/vhosts/gamerhub.com/html/includes/database.mysql.inc on line 120.

Comments

KarenS’s picture

Project: Views (for Drupal 7) » Date
Version: 6.x-2.x-dev » 4.7.x-1.x-dev

This is a date module issue. It sounds like you don't have a proper database setup (the timezone field should be there). Did you do a database update for the date module?

KarenS’s picture

Status: Active » Closed (fixed)

No follow up. I assume there was a setup problem.