I've hit a new issue, and I believe I've combed through the documentation pretty thoroughly... perhaps there is a quick answer to this.
Everything seems to go quite nicely until I run cron. I've even tried running cron with nd=1 so that I'm just trying to pull one day's worth of events, which is only about 5 items.
Here is the error I get from drush:
WD cron: PDOException: SQLSTATE[42S22]: Column not found:[error]
1054 Unknown column 'eid.field_evanced_id_value' in
'where clause': SELECT n.nid, n.created FROM {node}
n, {field_data_field_event_evancedid} eid WHERE
eid.entity_id = n.nid AND eid.bundle = :bundle AND
eid.field_evanced_id_value = :evanced_id ; Array
(
[:bundle] => event
[:evanced_id] => 32818
)
in evanced_events_importer_select_node_action() (line
555 of
/XXX[personalRemoved]XXX/sites/all/modules/evanced_events_importer/evanced_events_importer.xml2node.inc).
Cron run successfully.
And here is the error I get returned from the site (in this case I'm using Cron Debug to isolate the cron run, but it happens either way, with or without Cron Debug):
Notice: Undefined offset: 0 in evanced_events_importer_offsite_address() (line 147 of /XXX[personalRemoved]XXX/sites/all/modules/evanced_events_importer/evanced_events_importer.xml2node.inc).
Notice: Trying to get property of non-object in evanced_events_importer_offsite_address() (line 147 of /XXX[personalRemoved]XXX/sites/all/modules/evanced_events_importer/evanced_events_importer.xml2node.inc).
Notice: Undefined index: in evanced_events_importer_offsite_address() (line 150 of /XXX[personalRemoved]XXX/sites/all/modules/evanced_events_importer/evanced_events_importer.xml2node.inc).
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'eid.field_evanced_id_value' in 'where clause': SELECT n.nid, n.created FROM {node} n, {field_data_field_event_evancedid} eid WHERE eid.entity_id = n.nid AND eid.bundle = :bundle AND eid.field_evanced_id_value = :evanced_id ; Array ( [:bundle] => event [:evanced_id] => 32818 ) in evanced_events_importer_select_node_action() (line 555 of /XXX[personalRemoved]XXX/sites/all/modules/evanced_events_importer/evanced_events_importer.xml2node.inc).
I'm not sure what I'm missing here. Do I need an "offsite address" field in my content type? Should I have named the Evanced Events ID field something different? I named it
"Evanced Events ID"
and the machine name is
"field_event_evancedid"
I've also attached screencaps of the settings for XML Mapper and the Fields in the Content Type.
Thank you!
| Comment | File | Size | Author |
|---|---|---|---|
| #1 | variable-correction-1479456.patch | 2.26 KB | slanger |
| xmlmapper-config.png | 55.65 KB | rainbreaw | |
| evanced-fields.png | 46.65 KB | rainbreaw |
Comments
Comment #1
slanger commentedHi rainbreaw:
Sorry that you encountered an error. It was caused by some vestigial code that was unintentionally left behind after upgrading the module from Drupal 6 to Drupal 7. I've attached a patch that will hopefully correct this (plus, make some additional tweaks).
Looking at your screen captures, I noticed that there are some configuration settings that may cause you additional problems. Go to the module's "XML Mapper" screen (/config/development/evanced-events-importer/xmlmapper). There, you'll find a section entitled "Suggested Settings". Expand it and (where applicable) match your configuration to what you see there.
I hope that helps! Let me know if the patch resolves the problem.
Comment #2
rainbreaw commentedBeautiful! The patch worked like a charm, instantly! Cron ran so fast I thought maybe something else was wrong, but the events came in perfectly, just as I was hoping. Thank you so much. Superb!
Comment #3
slanger commentedThanks, rainbreaw -- that's terrific to hear! I appreciate you reporting back. FYI: This patch has been applied to version 7.x-3.x-dev of the Evanced Events Importer.