I'm using the latest non-dev release of views (5.x-1.6) and upgrading to date 5.x-2.7 (with PHP upgraded to 5.2) breaks views that use "now" as a filter argument for CCK date fields.

The problem may be the same as experiences by Drupal 6 users in this issue: http://drupal.org/node/426990.

Comments

mcantelon’s picture

mcantelon commented
Title: Views "now" argument does work with upgraded date module » Views "now" argument doesn't work with upgraded date module
deshilachado’s picture

deshilachado commented

Well then, did you try the soultions discussed for 6.x-2.2 ?
Did you try updating to the latest -dev?
Did you flush all caches?
If all this doesn't help, could you attach an export of you date field and of you view as well to help KarenS with debugging?

mikeybusiness’s picture

mikeybusiness commented

I was having the same issue with testing an upgrade from date 5.x-1.8 to date-5.x-2.7 on a test box. I flushed my cache after updating to date-5.x-2.x-dev. This is not time sensitive for me, I thought it might help though.

The PHP Error in the log

Watchdog

Unknown column 'node_data_.field_date_s_value' in 'where clause' query: SELECT node.nid, node_data_field_date_s.field_date_s_value AS node_data_field_date_s_field_date_s_value FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_date_s node_data_field_date_s ON node.vid = node_data_field_date_s.vid WHERE (node.type IN ('events')) AND (node.status = '1') AND (term_node.tid = '8') AND (DATE_FORMAT(ADDTIME(node_data_.field_date_s_value, SEC_TO_TIME(-18000)), '') >= '') ORDER BY node_data_field_date_s_field_date_s_value ASC LIMIT 0, 10 in /Applications/MAMP/htdocs/hooverlibrary/public_html/includes/database.mysql.inc on line 174.

View Export:

This view works fine when I remove the date field from the view

  $view = new stdClass();
  $view->name = 'events_teens';
  $view->description = 'Events for Teens';
  $view->access = array (
  0 => '1',
  1 => '2',
);
  $view->view_args_php = '';
  $view->page = TRUE;
  $view->page_title = 'Teen Events';
  $view->page_header = '';
  $view->page_header_format = '3';
  $view->page_footer = '';
  $view->page_footer_format = '3';
  $view->page_empty = 'Woops';
  $view->page_empty_format = '3';
  $view->page_type = 'node';
  $view->url = 'teens';
  $view->use_pager = TRUE;
  $view->nodes_per_page = '10';
  $view->sort = array (
    array (
      'tablename' => 'node_data_field_date_s',
      'field' => 'field_date_s_value',
      'sortorder' => 'ASC',
      'options' => '',
    ),
  );
  $view->argument = array (
    array (
      'type' => 'rss_feed',
      'argdefault' => '2',
      'title' => 'Teens RSS',
      'options' => 'Subscribe',
      'wildcard' => '',
      'wildcard_substitution' => '',
    ),
  );
  $view->field = array (
  );
  $view->filter = array (
    array (
      'tablename' => 'node',
      'field' => 'type',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
  0 => 'events',
),
    ),
    array (
      'tablename' => 'node',
      'field' => 'status',
      'operator' => '=',
      'options' => '',
      'value' => '1',
    ),
    array (
      'tablename' => 'term_node',
      'field' => 'tid',
      'operator' => 'AND',
      'options' => '',
      'value' => array (
  0 => '8',
),
    ),
    array (
      'tablename' => 'node_data_field_date_s',
      'field' => 'field_date_s_value_default',
      'operator' => '>=',
      'options' => '-37300',
      'value' => 'now',
    ),
  );
  $view->exposed_filter = array (
  );
  $view->requires = array(node_data_field_date_s, node, term_node);
  $views[$view->name] = $view;

MySql Export

From PhpMyadmin

-- phpMyAdmin SQL Dump
-- version 2.11.7.1

--
-- Host: localhost
-- Generation Time: May 13, 2009 at 02:50 PM
-- Server version: 5.0.41
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: 'drpl1'
--

-- --------------------------------------------------------

--
-- Table structure for table 'content_field_date_s'
--

DROP TABLE IF EXISTS content_field_date_s;
CREATE TABLE IF NOT EXISTS content_field_date_s (
  vid int(10) unsigned NOT NULL default '0',
  delta int(10) unsigned NOT NULL default '0',
  nid int(10) unsigned NOT NULL default '0',
  field_date_s_value varchar(20) default NULL,
  field_date_s_value2 varchar(20) default NULL,
  PRIMARY KEY  (vid,delta),
  KEY nid (nid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table 'content_field_date_s'
--

INSERT INTO content_field_date_s VALUES(993, 0, 382, '2009-06-22T14:00:00', '2009-06-22T14:00:00');
INSERT INTO content_field_date_s VALUES(1147, 0, 450, '2009-10-26T14:00:00', '2009-10-26T14:00:00');
INSERT INTO content_field_date_s VALUES(1148, 0, 451, '2009-11-23T14:00:00', '2009-11-23T14:00:00');
INSERT INTO content_field_date_s VALUES(1130, 0, 435, '2009-04-07T12:30:00', '2009-04-07T12:30:00');
INSERT INTO content_field_date_s VALUES(1146, 0, 449, '2009-09-28T14:00:00', '2009-09-28T14:00:00');
INSERT INTO content_field_date_s VALUES(1209, 0, 493, '2009-05-05T12:30:00', '2009-05-05T12:30:00');
INSERT INTO content_field_date_s VALUES(1145, 0, 448, '2009-08-24T14:00:00', '2009-08-24T14:00:00');
INSERT INTO content_field_date_s VALUES(1078, 0, 418, '2009-03-22T14:30:00', NULL);
INSERT INTO content_field_date_s VALUES(1079, 0, 419, '2009-05-28T18:30:00', '2009-05-28T18:30:00');
INSERT INTO content_field_date_s VALUES(993, 1, 382, '2009-06-22T18:30:00', '2009-06-22T18:30:00');
INSERT INTO content_field_date_s VALUES(1149, 0, 452, '2009-12-14T14:00:00', '2009-12-14T14:00:00');
INSERT INTO content_field_date_s VALUES(991, 0, 380, '2009-04-20T14:00:00', '2009-04-20T14:00:00');
INSERT INTO content_field_date_s VALUES(991, 1, 380, '2009-04-20T18:30:00', '2009-04-20T18:30:00');
INSERT INTO content_field_date_s VALUES(1125, 0, 433, '2009-04-16T18:30:00', '2009-04-16T18:30:00');
INSERT INTO content_field_date_s VALUES(1095, 0, 422, '2009-04-21T18:30:00', '2009-04-21T18:30:00');
INSERT INTO content_field_date_s VALUES(992, 1, 381, '2009-05-18T18:30:00', '2009-05-18T18:30:00');
INSERT INTO content_field_date_s VALUES(992, 0, 381, '2009-05-18T14:00:00', '2009-05-18T14:00:00');
INSERT INTO content_field_date_s VALUES(1144, 0, 447, '2009-07-27T14:00:00', '2009-07-27T14:00:00');
INSERT INTO content_field_date_s VALUES(1136, 0, 441, '2009-04-27T18:30:00', '2009-04-27T18:30:00');
INSERT INTO content_field_date_s VALUES(1179, 0, 479, '2009-05-01T09:00:00', '2009-05-22T18:00:00');
INSERT INTO content_field_date_s VALUES(1139, 0, 444, '2009-03-29T14:30:00', '2009-03-29T14:30:00');
INSERT INTO content_field_date_s VALUES(1140, 0, 445, '2009-03-01T13:00:00', '2010-03-01T13:00:00');
INSERT INTO content_field_date_s VALUES(1141, 0, 446, '2009-04-01T09:00:00', '2009-04-30T21:00:00');
INSERT INTO content_field_date_s VALUES(1144, 1, 447, '2009-07-27T18:30:00', '2009-07-27T18:30:00');
INSERT INTO content_field_date_s VALUES(1145, 1, 448, '2009-08-24T18:30:00', '2009-08-24T18:30:00');
INSERT INTO content_field_date_s VALUES(1146, 1, 449, '2009-09-28T18:30:00', '2009-09-28T18:30:00');
INSERT INTO content_field_date_s VALUES(1147, 1, 450, '2009-10-26T18:30:00', '2009-10-26T18:30:00');
INSERT INTO content_field_date_s VALUES(1148, 1, 451, '2009-11-23T18:30:00', '2009-11-23T18:30:00');
INSERT INTO content_field_date_s VALUES(1149, 1, 452, '2009-12-14T18:30:00', '2009-12-14T18:30:00');
INSERT INTO content_field_date_s VALUES(1150, 0, 453, '2009-04-06T18:30:00', '2009-04-06T18:30:00');
INSERT INTO content_field_date_s VALUES(1167, 0, 470, '2009-04-09T10:00:00', '2009-04-09T10:00:00');
INSERT INTO content_field_date_s VALUES(1152, 0, 455, '2009-04-09T18:30:00', '2009-04-09T18:30:00');
INSERT INTO content_field_date_s VALUES(1153, 0, 456, '2009-04-19T14:30:00', '2009-04-19T14:30:00');
INSERT INTO content_field_date_s VALUES(1154, 0, 457, '2009-04-16T14:00:00', '2009-04-16T14:00:00');
INSERT INTO content_field_date_s VALUES(1155, 0, 458, '2009-04-25T10:15:00', '2009-04-25T10:15:00');
INSERT INTO content_field_date_s VALUES(1156, 0, 459, '2009-04-30T18:30:00', '2009-04-30T18:30:00');
INSERT INTO content_field_date_s VALUES(1157, 0, 460, '2009-04-02T10:00:00', '2009-04-02T10:00:00');
INSERT INTO content_field_date_s VALUES(1158, 0, 461, '2009-05-07T10:00:00', '2009-05-07T10:00:00');
INSERT INTO content_field_date_s VALUES(1159, 0, 462, '2009-06-04T10:00:00', '2009-06-04T10:00:00');
INSERT INTO content_field_date_s VALUES(1160, 0, 463, '2009-07-02T10:00:00', '2009-07-02T10:00:00');
INSERT INTO content_field_date_s VALUES(1161, 0, 464, '2009-08-06T10:00:00', '2009-08-06T10:00:00');
INSERT INTO content_field_date_s VALUES(1162, 0, 465, '2009-09-03T10:00:00', '2009-09-03T10:00:00');
INSERT INTO content_field_date_s VALUES(1163, 0, 466, '2009-10-01T10:00:00', '2009-10-01T10:00:00');
INSERT INTO content_field_date_s VALUES(1164, 0, 467, '2009-11-10T10:00:00', '2009-11-10T10:00:00');
INSERT INTO content_field_date_s VALUES(1165, 0, 468, '2009-12-03T10:00:00', '2009-12-03T10:00:00');
INSERT INTO content_field_date_s VALUES(1166, 0, 469, '2009-05-14T10:00:00', '2009-05-14T10:00:00');
INSERT INTO content_field_date_s VALUES(1151, 0, 454, '2009-04-23T18:30:00', '2009-04-23T18:30:00');
INSERT INTO content_field_date_s VALUES(1168, 0, 471, '2009-06-11T10:00:00', '2009-06-11T10:00:00');
INSERT INTO content_field_date_s VALUES(1169, 0, 472, '2009-07-09T10:00:00', '2009-07-09T10:00:00');
INSERT INTO content_field_date_s VALUES(1170, 0, 473, '2009-08-13T10:00:00', '2009-08-13T10:00:00');
INSERT INTO content_field_date_s VALUES(1171, 0, 474, '2009-09-10T10:00:00', '2009-09-10T10:00:00');
INSERT INTO content_field_date_s VALUES(1172, 0, 475, '2009-10-08T10:00:00', '2009-10-08T10:00:00');
INSERT INTO content_field_date_s VALUES(1173, 0, 476, '2009-11-12T10:00:00', '2009-11-12T10:00:00');
INSERT INTO content_field_date_s VALUES(1174, 0, 477, '2009-12-10T10:00:00', '2009-12-10T10:00:00');
INSERT INTO content_field_date_s VALUES(1034, 0, 393, '2009-03-26T19:00:00', '2009-03-26T19:00:00');
INSERT INTO content_field_date_s VALUES(1035, 0, 394, '2009-04-23T19:00:00', '2009-04-23T19:00:00');
INSERT INTO content_field_date_s VALUES(1059, 0, 403, '2009-05-28T19:00:00', '2009-05-28T19:00:00');
INSERT INTO content_field_date_s VALUES(1060, 0, 404, '2009-06-25T19:00:00', '2009-06-25T19:00:00');
INSERT INTO content_field_date_s VALUES(1061, 0, 405, '2009-07-23T19:00:00', '2009-07-23T19:00:00');
INSERT INTO content_field_date_s VALUES(1062, 0, 406, '2009-08-27T19:00:00', '2009-08-27T19:00:00');
INSERT INTO content_field_date_s VALUES(1104, 0, 423, '2009-09-24T19:00:00', '2009-09-24T19:00:00');
INSERT INTO content_field_date_s VALUES(1105, 0, 424, '2009-10-22T19:00:00', '2009-10-22T19:00:00');
INSERT INTO content_field_date_s VALUES(1178, 0, 478, '2009-03-31T10:00:00', '2009-03-31T10:00:00');
INSERT INTO content_field_date_s VALUES(1183, 0, 480, '2009-05-18T09:00:00', '2009-05-18T21:00:00');
INSERT INTO content_field_date_s VALUES(1187, 0, 481, '2009-05-07T19:00:00', '2009-05-07T19:00:00');
INSERT INTO content_field_date_s VALUES(1188, 0, 482, '2009-04-22T12:00:00', '2009-04-23T01:00:00');
INSERT INTO content_field_date_s VALUES(1193, 0, 483, '2009-05-17T14:30:00', '2009-05-17T14:30:00');
INSERT INTO content_field_date_s VALUES(1194, 0, 484, '2009-05-18T09:00:00', '2009-07-17T21:00:00');
INSERT INTO content_field_date_s VALUES(1197, 0, 487, '2009-06-02T10:30:00', '2009-06-02T10:30:00');
INSERT INTO content_field_date_s VALUES(1198, 0, 488, '2009-06-04T10:30:00', '2009-06-04T10:30:00');
INSERT INTO content_field_date_s VALUES(1205, 0, 489, '2009-05-26T13:30:00', '2009-05-26T13:30:00');
INSERT INTO content_field_date_s VALUES(1206, 0, 490, '2009-05-26T18:30:00', '2009-05-26T18:30:00');
INSERT INTO content_field_date_s VALUES(1207, 0, 491, '2009-05-27T10:30:00', '2009-05-27T10:30:00');
INSERT INTO content_field_date_s VALUES(1215, 0, 496, '2009-06-02T13:30:00', '2009-06-02T13:30:00');
INSERT INTO content_field_date_s VALUES(1216, 0, 497, '2009-06-02T18:30:00', '2009-06-02T18:30:00');
INSERT INTO content_field_date_s VALUES(1208, 0, 492, '2009-05-14T18:30:00', '2009-05-14T18:30:00');
INSERT INTO content_field_date_s VALUES(1196, 0, 486, '2009-05-26T10:30:00', '2009-05-26T10:30:00');
INSERT INTO content_field_date_s VALUES(1213, 0, 494, '2009-05-31T15:00:00', '2009-05-31T15:00:00');
INSERT INTO content_field_date_s VALUES(1214, 0, 495, '2009-05-18T09:00:00', '2009-07-31T18:00:00');
INSERT INTO content_field_date_s VALUES(1217, 0, 498, '2009-06-03T10:30:00', '2009-06-03T10:30:00');
INSERT INTO content_field_date_s VALUES(1218, 0, 499, '2009-06-03T13:30:00', '2009-06-03T13:30:00');
INSERT INTO content_field_date_s VALUES(1287, 0, 563, '2009-07-14T10:30:00', '2009-07-14T10:30:00');
INSERT INTO content_field_date_s VALUES(1220, 0, 501, '2009-05-27T13:30:00', '2009-05-27T13:30:00');
INSERT INTO content_field_date_s VALUES(1223, 0, 504, '2009-06-09T10:30:00', '2009-06-09T10:30:00');
INSERT INTO content_field_date_s VALUES(1224, 0, 505, '2009-06-09T13:30:00', '2009-06-09T13:30:00');
INSERT INTO content_field_date_s VALUES(1225, 0, 506, '2009-06-09T18:30:00', '2009-06-09T18:30:00');
INSERT INTO content_field_date_s VALUES(1226, 0, 507, '2009-06-10T10:30:00', '2009-06-10T10:30:00');
INSERT INTO content_field_date_s VALUES(1227, 0, 508, '2009-06-10T13:30:00', '2009-06-10T13:30:00');
INSERT INTO content_field_date_s VALUES(1228, 0, 509, '2009-06-11T10:30:00', '2009-06-11T10:30:00');
INSERT INTO content_field_date_s VALUES(1229, 0, 510, '2009-06-15T18:30:00', '2009-06-15T18:30:00');
INSERT INTO content_field_date_s VALUES(1230, 0, 511, '2009-06-16T10:30:00', '2009-06-16T10:30:00');
INSERT INTO content_field_date_s VALUES(1231, 0, 512, '2009-06-16T13:30:00', '2009-06-16T13:30:00');
INSERT INTO content_field_date_s VALUES(1232, 0, 513, '2009-06-16T18:30:00', '2009-06-16T18:30:00');
INSERT INTO content_field_date_s VALUES(1233, 0, 514, '2009-06-17T10:30:00', '2009-06-17T10:30:00');
INSERT INTO content_field_date_s VALUES(1234, 0, 515, '2009-06-17T13:30:00', '2009-06-17T13:30:00');
INSERT INTO content_field_date_s VALUES(1235, 0, 516, '2009-06-18T10:30:00', '2009-06-18T10:30:00');
INSERT INTO content_field_date_s VALUES(1236, 0, 517, '2009-05-18T09:00:00', '2009-07-17T18:00:00');
INSERT INTO content_field_date_s VALUES(1237, 0, 518, '2009-06-09T18:30:00', '2009-06-09T18:30:00');
INSERT INTO content_field_date_s VALUES(1276, 0, 557, '2009-06-22T18:00:00', '2009-06-22T18:00:00');
INSERT INTO content_field_date_s VALUES(1274, 0, 555, '2009-06-16T18:30:00', '2009-06-16T18:30:00');
INSERT INTO content_field_date_s VALUES(1240, 0, 521, '2009-06-11T19:00:00', '2009-06-11T19:00:00');
INSERT INTO content_field_date_s VALUES(1241, 0, 522, '2009-06-27T10:15:00', '2009-06-27T10:15:00');
INSERT INTO content_field_date_s VALUES(1242, 0, 523, '2009-06-18T18:30:00', '2009-06-18T18:30:00');
INSERT INTO content_field_date_s VALUES(1243, 0, 524, '2009-06-24T12:00:00', '2009-06-24T12:00:00');
INSERT INTO content_field_date_s VALUES(1244, 0, 525, '2009-07-22T12:00:00', '2009-07-22T12:00:00');
INSERT INTO content_field_date_s VALUES(1245, 0, 526, '2009-08-16T14:30:00', '2009-08-16T14:30:00');
INSERT INTO content_field_date_s VALUES(1246, 0, 527, '2009-06-25T18:30:00', '2009-06-25T18:30:00');
INSERT INTO content_field_date_s VALUES(1247, 0, 528, '2009-07-30T18:30:00', '2009-07-30T18:30:00');
INSERT INTO content_field_date_s VALUES(1248, 0, 529, '2009-08-27T18:30:00', '2009-08-27T18:30:00');
INSERT INTO content_field_date_s VALUES(1249, 0, 530, '2009-06-07T14:30:00', '2009-06-07T14:30:00');
INSERT INTO content_field_date_s VALUES(1250, 0, 531, '2009-07-01T12:00:00', '2009-07-31T23:00:00');
INSERT INTO content_field_date_s VALUES(1251, 0, 532, '2009-06-23T10:30:00', '2009-06-23T10:30:00');
INSERT INTO content_field_date_s VALUES(1252, 0, 533, '2009-06-23T13:30:00', '2009-06-23T13:30:00');
INSERT INTO content_field_date_s VALUES(1253, 0, 534, '2009-06-23T18:30:00', '2009-06-23T18:30:00');
INSERT INTO content_field_date_s VALUES(1254, 0, 535, '2009-06-24T10:30:00', '2009-06-24T10:30:00');
INSERT INTO content_field_date_s VALUES(1255, 0, 536, '2009-06-24T13:30:00', '2009-06-24T13:30:00');
INSERT INTO content_field_date_s VALUES(1256, 0, 537, '2009-06-25T10:30:00', '2009-06-25T10:30:00');
INSERT INTO content_field_date_s VALUES(1257, 0, 538, '2009-06-27T10:30:00', '2009-06-27T10:30:00');
INSERT INTO content_field_date_s VALUES(1258, 0, 539, '2009-06-27T14:00:00', '2009-06-27T14:00:00');
INSERT INTO content_field_date_s VALUES(1259, 0, 540, '2009-06-30T10:30:00', '2009-06-30T10:30:00');
INSERT INTO content_field_date_s VALUES(1260, 0, 541, '2009-06-30T13:30:00', '2009-06-30T13:30:00');
INSERT INTO content_field_date_s VALUES(1261, 0, 542, '2009-06-30T18:30:00', '2009-06-30T18:30:00');
INSERT INTO content_field_date_s VALUES(1262, 0, 543, '2009-07-01T10:30:00', '2009-07-01T10:30:00');
INSERT INTO content_field_date_s VALUES(1263, 0, 544, '2009-07-01T13:30:00', '2009-07-01T13:30:00');
INSERT INTO content_field_date_s VALUES(1264, 0, 545, '2009-07-02T10:30:00', '2009-07-02T10:30:00');
INSERT INTO content_field_date_s VALUES(1265, 0, 546, '2009-07-07T10:30:00', '2009-07-07T10:30:00');
INSERT INTO content_field_date_s VALUES(1266, 0, 547, '2009-07-07T13:30:00', '2009-07-07T13:30:00');
INSERT INTO content_field_date_s VALUES(1267, 0, 548, '2009-07-07T18:30:00', '2009-07-07T18:30:00');
INSERT INTO content_field_date_s VALUES(1268, 0, 549, '2009-07-08T10:30:00', '2009-07-08T10:30:00');
INSERT INTO content_field_date_s VALUES(1269, 0, 550, '2009-07-08T13:30:00', '2009-07-08T13:30:00');
INSERT INTO content_field_date_s VALUES(1270, 0, 551, '2009-07-09T10:30:00', '2009-07-09T10:30:00');
INSERT INTO content_field_date_s VALUES(1271, 0, 552, '2009-07-10T10:30:00', '2009-07-10T10:30:00');
INSERT INTO content_field_date_s VALUES(1272, 0, 553, '2009-07-13T18:30:00', '2009-07-13T18:30:00');
INSERT INTO content_field_date_s VALUES(1273, 0, 554, '2009-06-06T18:30:00', '2009-06-06T18:30:00');
INSERT INTO content_field_date_s VALUES(1277, 0, 558, '2009-06-23T18:30:00', '2009-06-23T18:30:00');
INSERT INTO content_field_date_s VALUES(1278, 0, 559, '2009-07-07T16:30:00', '2009-07-07T16:30:00');
INSERT INTO content_field_date_s VALUES(1279, 0, 560, '2009-07-14T18:30:00', '2009-07-14T18:30:00');
INSERT INTO content_field_date_s VALUES(1280, 0, 561, '2009-07-20T18:00:00', '2009-07-20T18:00:00');
INSERT INTO content_field_date_s VALUES(1281, 0, 562, '2009-07-21T18:30:00', '2009-07-21T18:30:00');
INSERT INTO content_field_date_s VALUES(1288, 0, 564, '2009-07-14T13:30:00', '2009-07-14T13:30:00');
INSERT INTO content_field_date_s VALUES(1289, 0, 565, '2009-07-14T18:30:00', '2009-07-14T18:30:00');
mikeybusiness’s picture

mikeybusiness commented

Number 2 of the Troubleshooting guide on the main page states:

Run update.php. Be sure to watch carefully to see if there are messages that you need to re-run it. Some updates that are dependent on other updates have to be aborted the first time or two. You may need to run update.php several times until you quit seeing messages to re-run it.

For some reason if the updating the database gets botched and you go mucking around for a while without finishing ALL of the updates (like I did) you can get an error with the NOW feature in views. I wasn't even getting the value filed in views, just the option field.

I don't know why but even after I tried to go back and run update.php it no updates were happening. So what I did was restored from a backup to the last state before the update and re-ran the updates again. I caught this error.

Duplicate entry '26-2-65535-0' for key 1 query: ALTER TABLE webform_submitted_data CHANGE cid cid smallint unsigned NOT NULL default '0' in /Applications/MAMP/htdocs/hooverlibrary/public_html/includes/database.mysql.inc on line 174.

If you see this, run update again. It fixed the offending table entry in the database for me. All is well as far as I can tell - the view looks good for me. Maybe you could try this mcantelon.

mikeybusiness’s picture

mikeybusiness commented

Update:

If I upgrade to version 2.7 following all of the troubleshooting guidelines views with filter date NOW will work properly. However, if I go to the content type and click "edit" then "save" without changing anything all views using the filter by date for that field will break. When I navigate to the view setup, the "Value" field will be missing.

What would be the best information to present so that I could get some ideas on what to do?

Unknown column 'node_data_.field_date_s_value' in 'where 
clause' query: SELECT node.nid, 
node_data_field_date_s.field_date_s_value AS 
node_data_field_date_s_field_date_s_value FROM node node LEFT JOIN 
term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy 
term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN 
content_field_date_s node_data_field_date_s ON node.vid = 
node_data_field_date_s.vid LEFT JOIN node n ON node.nid = n.nid WHERE 
((n.moderate != 1)) AND ( (node.type IN ('events')) AND 
(node.status = '1') AND (term_node.tid = '8') AND 
(DATE_FORMAT(ADDTIME(node_data_.field_date_s_value, 
SEC_TO_TIME(-18000)), '') >= '') ) ORDER BY 
node_data_field_date_s_field_date_s_value ASC LIMIT 0, 10 in 
/Applications/MAMP/htdocs/hooverlibrary/public_html/includes/database.mysql.inc 
on line 174.

array_pop() [<a href='function.array-pop'>function.array-pop</a>]: The 
argument should be an array in 
/Applications/MAMP/htdocs/hooverlibrary/public_html/sites/all/modules/date/date/date_views.inc
lias’s picture

lias commented

I'm getting this same error message in my logs for the date, a bunch of them, using the latest dev version of date, dateapi although I am not having problems displaying the date in my views. It does show up correctly although the actual date is off.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near &#039;DESC LIMIT 0, 5&#039; at line 1 query: SELECT DISTINCT(node.nid), event_start, node.title AS node_title, node.changed AS node_changed, node_data_field_date.field_date_value AS node_data_field_date_field_date_value FROM node node LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid WHERE (node.status = &#039;1&#039;) AND (node.type IN (&#039;event&#039;)) AND (og_ancestry.group_nid = -1) ORDER BY DESC LIMIT 0, 5 in D:\www\public_html\domain\includes\database.mysql.inc on line 174.
arlinsandbulte’s picture

arlinsandbulte commented
Status: Active » Closed (won't fix)

Version 5.2 is critical bugfix only, no other support, no new features.