Publisher does not support the Fluid field type. Please do not contact asking when support will be available.

If you purchased an add-on from expressionengine.com, be sure to visit boldminded.com/claim to add the license to your account here on boldminded.com.

Ticket: Running imports after saving

Status	Resolved
Add-on / Version	DataGrab 4.0.1
Severity
EE Version	6.2.7

Gregory Maher

Apr 04, 2022

We set up a new import to test the new version of Datagrab and I’m running into an issue when I try to run the import after saving it.

The first time I tried to run it I got the warning seen in the attached screenshot.

All subsequent click on the start import button, bring up the bar in the status column, like it’s going to run, but the import does not start.

Based on the log file (attached) it looks like an issue with a relationship field is throwing an error and the import is failing because of that.

Any ideas on how to proceed.

And, THANKS FOR RESURRECTING DATAGRAB! MUCH APPRECIATED!

BoldMinded (Brian)

Apr 04, 2022

I’ll look at that first unlink() error, but you’ll need to provide an error log for the relationship issue. https://docs.boldminded.com/datagrab/docs/troubleshooting

BoldMinded (Brian)

Apr 04, 2022

I don’t see a log file…

BoldMinded (Brian)

Apr 04, 2022

Can you share the log file via Dropbox or something?

BoldMinded (Brian)

Apr 04, 2022

19:30:53 04/04/2022 Import #5 Started
19:30:53 04/04/2022 Import #5 Initialized
19:30:53 04/04/2022 Begin Importing [TEST Smoking Cigarettes in West Texas]
19:30:53 04/04/2022 [TEST Smoking Cigarettes in West Texas] already exists. Updating.
19:30:53 04/04/2022 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'parent_entry_id' in 'where clause':

SELECT `child_id`, `order`
FROM (`exp_relationships`)
WHERE `parent_entry_id` =  2563
AND `parent_field_id` =  9
ORDER BY `order`
19:30:53 04/04/2022 #0 /system/ee/legacy/database/drivers/mysqli/mysqli_driver.php(112): CI_DB_mysqli_connection->query('SELECT `child_i…')
#1 /system/ee/legacy/database/DB_driver.php(260): CI_DB_mysqli_driver->_execute('SELECT `child_i…')
#2 /system/ee/legacy/database/DB_driver.php(175): CI_DB_driver->simple_query('SELECT `child_i…')
#3 /system/ee/legacy/database/DB_active_rec.php(1076): CI_DB_driver->query('SELECT `child_i…')
#4 /system/user/addons/datagrab/fieldtypes/datagrab_relationship.php(140): CI_DB_active_record->get('exp_relationshi…')
#5 /system/user/addons/datagrab/models/datagrab_model.php(2019): Datagrab_relationship->rebuild_post_data(Object(Datagrab_model), 9, Array, Array)
#6 /system/user/addons/datagrab/models/datagrab_model.php(794): Datagrab_model->_prepare_update_data(2563, Array, Array)
#7 /system/user/addons/datagrab/mod.datagrab.php(147): Datagrab_model->do_import(Object(Datagrab_xml), Array)
#8 /system/ee/legacy/libraries/Actions.php(175): Datagrab->run_action()
#9 /system/ee/legacy/libraries/Core.php(604): EE_Actions->__construct(true, Object(Closure))
#10 /system/ee/legacy/controllers/ee.php(51): EE_Core->generate_action(true)
#11 [internal function]: EE->index()
#12 /system/ee/ExpressionEngine/Core/Core.php(257): call_user_func_array(Array, Array)
#13 /system/ee/ExpressionEngine/Core/Core.php(113): ExpressionEngine\Core\Core->runController(Array)
#14 /system/ee/ExpressionEngine/Boot/boot.php(161): ExpressionEngine\Core\Core->run(Object(ExpressionEngine\Core\Request))
#15 /httpdocs/index.php(164): require_once('/var/www/vhosts…')
#16 {main}

BoldMinded (Brian)

Apr 04, 2022

Comment has been marked private.

Gregory Maher

Apr 04, 2022

Trying the new build now - thanks for getting it out so quickly!

Greg

BoldMinded (Brian)

Apr 04, 2022

“Smoking Cigarettes in West Texas” - Really curious what that is all about :D

Gregory Maher

Apr 04, 2022

This latest build worked great! Thanks, Brian!

And, we’ll let you know when the site is live so you can read all about “Smoking Cigarettes in West Texas”! lol

Thanks again!

Greg

BoldMinded (Brian)

Apr 04, 2022

Good to hear! I look forward to reading it 😊