Received the following error when running update.php:
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'XXX.field_data_field_evttime_date' doesn't exist: SELECT DISTINCT ed.entity_id, ed.field_evttime_date_value AS value1, ed.field_evttime_date_value2 AS value2, field_evttime_date_timezone AS tz FROM field_data_field_evttime_date ed ORDER BY entity_id; Array ( ) in cod_schedule_update_7012() (line 142 of /home/XXX/profiles/cod/modules/contrib/cod_support/cod_schedule/cod_schedule.install).

Seems that line 142 of cod_schedule.install should call to field_evt_time_ instead of field_evttime_ ?

Line should read?:

function cod_schedule_update_7012() {
  $dates = db_query("SELECT DISTINCT ed.entity_id, ed.field_evt_time_date_value AS value1,
   ed.field_evt_time_date_value2 AS value2, field_evt_time_date_timezone AS tz
  FROM field_data_field_evt_time_date ed ORDER BY entity_id");

Comments

TxTwist2000 created an issue. See original summary.

TxTwist2000’s picture

After making the changes above, when running update.php again I received the following:

DatabaseSchemaObjectExistsException: Table field_data_field_url_title already exists. in DatabaseSchema->createTable() (line 657 of /home/XXX/includes/database/schema.inc).

TxTwist2000’s picture

Title: COD Schedule module » COD Schedule module Update 7012 Error
Issue summary: View changes
japerry’s picture

hmm thanks for the update. I'll try to take a look at this in the next 24 hours.

japerry’s picture

Status: Active » Closed (cannot reproduce)

Hmm, the field is field_data_field_evttime_date, not field_data_field_evt_time_date as listed in the summary.

kclarkson’s picture

Status: Closed (cannot reproduce) » Active

I also just received this error after updating from COD - 7.x-2.x COD to beta-4.

After running the update php script I got through all the updates except for one. And here is the error I am seeing:

Failed: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_evttime_date_timezone' in 'field list': SELECT DISTINCT ed.entity_id, ed.field_evttime_date_value AS value1, ed.field_evttime_date_value2 AS value2, field_evttime_date_timezone AS tz FROM field_data_field_evttime_date ed ORDER BY entity_id; Array ( ) in cod_schedule_update_7012() (line 142 of *****/profiles/cod/modules/contrib/cod_support/cod_schedule/cod_schedule.install)