Hi,

I tried to import a small testfile and the D6 RC4 didn't work for this. So I tried to install the latest dev version for D6.

I actually came through to the actual import, but then it just kept importing rows, even though the file only had 15 rows. After having imported approx 1000 rows, I restored my DB to an earlier instance with Backup & Migrate module. After having verified that the import had stopped, I installed the old RC4 version again. This apparantly stopped the pending import that ran amoc.

But with RC4 I now get an error when trying to import:

-------------
user warning: Unknown column 'file_offset' in 'field list' query: INSERT INTO node_import_tasks (name, uid, created, changed, fid, has_headers, file_options, headers, type, map, defaults, options, file_offset, row_done, row_error, status) VALUES ('brugerdata.csv Companies uden fejl2', 1, 1258047925, 1258047925, 10, 1, 'a:9:{s:11:\"file_format\";s:0:\"\";s:16:\"record separator\";s:9:\"\";s:22:\"other record separator\";s:0:\"\";s:15:\"field separator\";s:1:\";\";s:21:\"other field separator\";s:0:\"\";s:14:\"text delimiter\";s:1:\"\"\";s:20:\"other text delimiter\";s:0:\"\";s:16:\"escape character\";s:1:\"\"\";s:22:\"other escape character\";s:0:\"\";}', 'a:13:{i:0;s:9:\"Firmanavn\";i:1;s:10:\"Personnavn\";i:2;s:4:\"Mail\";i:3;s:6:\"Gruppe\";i:4;s:10:\"Start dato\";i:5;s:9:\"Slut dato\";i:6;s:6:\"Street\";i:7;s:6:\"Postnr\";i:8;s:4:\"City\";i:9;s:3:\"CVR\";i:10;s:5:\"Phone\";i:11;s:8:\"Bank Reg\";i:12;s:12:\"Bank Account\";}', 'node:company', 'a:23:{s:5:\"title\";s:1:\"0\";s:23:\"cck:field_bankacc:value\";s:2:\"12\";s:23:\"cck:field_bankreg:value\";s:2:\"11\";s:19:\"cck:field_cvr:value\";s:1:\"9\";s:21:\"cck:field_phone:value\";s:2:\"10\";s:7:\"domains\";a:1:{s:0:\"\";s:0:\"\";}s:19:\"cck:field_fax:value\";s:0:\"\";s:20:\"cck:field_city:value\";s:1:\"8\";s:22:\"cck:field_postnr:value\";s:1:\"7\";s:22:\"cck:field_street:value\";s:1:\"6\";s:11:\"domain_site\";s:0:\"\";s:20:\"cck:field_mail:value\";s:1:\"2\";s:23:\"cck:field_country:value\";s:0:\"\";s:4:\"body\";s:0:\"\";s:23:\"cck:field_website:value\";s:0:\"\";s:6:\"format\";s:0:\"\";s:7:\"created\";s:0:\"\";s:3:\"uid\";s:0:\"\";s:6:\"sticky\";s:0:\"\";s:6:\"status\";s:0:\"\";s:7:\"promote\";s:0:\"\";s:4:\"path\";s:0:\"\";s:7:\"comment\";s:0:\"\";}', 'a:11:{s:7:\"comment\";s:1:\"0\";s:6:\"format\";s:1:\"1\";s:3:\"uid\";s:5:\"admin\";s:7:\"created\";s:0:\"\";s:3:\"log\";s:26:\"Imported with node_import.\";s:6:\"status\";s:1:\"1\";s:7:\"promote\";s:1:\"0\";s:6:\"sticky\";s:1:\"0\";s:11:\"domain_site\";i:0;s:7:\"domains\";a:4:{i:-1;i:-1;i:5;i:0;i:4;i:0;i:2;i:0;}s:4:\"type\";s:7:\"company\";}', 'a:0:{}', 0, 0, 0, 0) in /home/www/castra-network.dk/includes/common.inc on line 3468.
---------------

And the Recent log entries shows an error which is this
---------------

Message Unknown column 'file_offset' in 'field list' query: INSERT INTO node_import_tasks (name, uid, created, changed, fid, has_headers, file_options, headers, type, map, defaults, options, file_offset, row_done, row_error, status) VALUES ('brugerdata.csv Companies uden fejl2', 1, 1258047925, 1258047925, 10, 1, 'a:9:{s:11:\"file_format\";s:0:\"\";s:16:\"record separator\";s:9:\"<newline>\";s:22:\"other record separator\";s:0:\"\";s:15:\"field separator\";s:1:\";\";s:21:\"other field separator\";s:0:\"\";s:14:\"text delimiter\";s:1:\"\"\";s:20:\"other text delimiter\";s:0:\"\";s:16:\"escape character\";s:1:\"\"\";s:22:\"other escape character\";s:0:\"\";}', 'a:13:{i:0;s:9:\"Firmanavn\";i:1;s:10:\"Personnavn\";i:2;s:4:\"Mail\";i:3;s:6:\"Gruppe\";i:4;s:10:\"Start dato\";i:5;s:9:\"Slut dato\";i:6;s:6:\"Street\";i:7;s:6:\"Postnr\";i:8;s:4:\"City\";i:9;s:3:\"CVR\";i:10;s:5:\"Phone\";i:11;s:8:\"Bank Reg\";i:12;s:12:\"Bank Account\";}', 'node:company', 'a:23:{s:5:\"title\";s:1:\"0\";s:23:\"cck:field_bankacc:value\";s:2:\"12\";s:23:\"cck:field_bankreg:value\";s:2:\"11\";s:19:\"cck:field_cvr:value\";s:1:\"9\";s:21:\"cck:field_phone:value\";s:2:\"10\";s:7:\"domains\";a:1:{s:0:\"\";s:0:\"\";}s:19:\"cck:field_fax:value\";s:0:\"\";s:20:\"cck:field_city:value\";s:1:\"8\";s:22:\"cck:field_postnr:value\";s:1:\"7\";s:22:\"cck:field_street:value\";s:1:\"6\";s:11:\"domain_site\";s:0:\"\";s:20:\"cck:field_mail:value\";s:1:\"2\";s:23:\"cck:field_country:value\";s:0:\"\";s:4:\"body\";s:0:\"\";s:23:\"cck:field_website:value\";s:0:\"\";s:6:\"format\";s:0:\"\";s:7:\"created\";s:0:\"\";s:3:\"uid\";s:0:\"\";s:6:\"sticky\";s:0:\"\";s:6:\"status\";s:0:\"\";s:7:\"promote\";s:0:\"\";s:4:\"path\";s:0:\"\";s:7:\"comment\";s:0:\"\";}', 'a:11:{s:7:\"comment\";s:1:\"0\";s:6:\"format\";s:1:\"1\";s:3:\"uid\";s:5:\"admin\";s:7:\"created\";s:0:\"\";s:3:\"log\";s:26:\"Imported with node_import.\";s:6:\"status\";s:1:\"1\";s:7:\"promote\";s:1:\"0\";s:6:\"sticky\";s:1:\"0\";s:11:\"domain_site\";i:0;s:7:\"domains\";a:4:{i:-1;i:-1;i:5;i:0;i:4;i:0;i:2;i:0;}s:4:\"type\";s:7:\"company\";}', 'a:0:{}', 0, 0, 0, 0) in /home/www/castra-network.dk/includes/common.inc on line 3468.
Severity error

---------------------

Can anybody help? I really need this import to work. But now I just need to get my Drupal to get healthy again.

Thanks

Morten E.

Comments

excaliburst’s picture

I also found a related Cron warning.

Message Attempting to re-run cron while it is already running.
Severity warning

Please can anyone help with this?

Thanks

Morten

excaliburst’s picture

Status: Active » Fixed

Hmmm - it seems that Drupal took matters in its own hands. Somehow it is now fixed. Apparantly things are back to normal.

I will never run a dev module on a non-testing environment.

Phew that was a close call.

Morten

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.