BoldMinded

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!

#1

BoldMinded (Brian)

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

#2

BoldMinded (Brian)

I don’t see a log file…

#3

BoldMinded (Brian)

Can you share the log file via Dropbox or something?

#4

BoldMinded (Brian)

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}
#5

BoldMinded (Brian)

Comment has been marked private.

#6

Gregory Maher

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

Greg

#7

BoldMinded (Brian)

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

#8

Gregory Maher

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

#9

BoldMinded (Brian)

Good to hear! I look forward to reading it 😊

Login to reply