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!

Comments

slanger’s picture

Component: Miscellaneous » Code
Assigned: Unassigned » slanger
Category: support » bug
Status: Active » Patch (to be ported)
StatusFileSize
new2.26 KB

Hi 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.

rainbreaw’s picture

Beautiful! 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!

slanger’s picture

Status: Patch (to be ported) » Closed (fixed)

Thanks, 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.