Closed (fixed)
Project:
Node import
Version:
6.x-1.x-dev
Component:
User interface
Priority:
Minor
Category:
Bug report
Assigned:
Reporter:
Created:
9 Jun 2009 at 08:14 UTC
Updated:
8 Oct 2009 at 05:50 UTC
When trying to import a .csv file on one of my servers I get this error:
user warning: Unknown column 'file_offset' in 'field list' query: UPDATE node_import_tasks SET status = 2, file_offset = 1953011 WHERE taskid = 3 in /home/onetwost/public_html/modules/node_import/node_import.inc on line 915.
The funny thing is that I have imported this file on another of my servers without fail.
| Comment | File | Size | Author |
|---|---|---|---|
| node_import-node_directory-3.txt | 17.27 KB | J-Chance |
Comments
Comment #1
psychoman commentedhave something similar )
user warning: Unknown column 'file_offset' in 'field list' query: INSERT INTO dr6_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 ('book2.csv', 1, 1245587240, 1245587240, 13, 1, 'a:10:{s:11:\"file_format\";s:9:\"csv-excel\";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:\"\";s:5:\"title\";s:26:\"Semicolon Separated Values\";}', 'a:10:{i:0;s:7:\"Name\";i:1;s:9:\"field_sex\";i:2;s:12:\"field_volume\";i:3;s:10:\"field_type\";i:4;s:10:\"field_year\";i:5;s:10:\"field_goal\";i:6;s:26:\"производитель\";i:7;s:11:\"Description\";i:8;s:3:\"sku\";i:9;s:10:\"sell_price\";}', 'node:product', 'a:30:{s:5:\"title\";s:1:\"0\";s:19:\"cck:field_sex:value\";s:1:\"1\";s:22:\"cck:field_volume:value\";a:1:{i:2;s:1:\"2\";}s:20:\"cck:field_type:value\";s:1:\"3\";s:20:\"cck:field_year:value\";s:1:\"4\";s:25:\"cck:field_image_cache:fid\";a:1:{s:0:\"\";s:0:\"\";}s:10:\"taxonomy:1\";a:1:{i:6;s:1:\"6\";}s:20:\"cck:field_goal:value\";a:1:{i:5;s:1:\"5\";}s:6:\"format\";s:0:\"\";s:4:\"body\";s:1:\"7\";s:5:\"model\";s:1:\"8\";s:10:\"list_price\";s:0:\"\";s:4:\"cost\";s:0:\"\";s:10:\"sell_price\";s:1:\"9\";s:9:\"shippable\";s:0:\"\";s:6:\"weight\";s:0:\"\";s:12:\"weight_units\";s:0:\"\";s:12:\"length_units\";s:0:\"\";s:6:\"length\";s:0:\"\";s:5:\"width\";s:0:\"\";s:6:\"height\";s:0:\"\";s:7:\"pkg_qty\";s:0:\"\";s:11:\"default_qty\";s:0:\"\";s:8:\"ordering\";s:0:\"\";s:7:\"created\";s:0:\"\";s:3:\"uid\";s:0:\"\";s:6:\"status\";s:0:\"\";s:6:\"sticky\";s:0:\"\";s:7:\"promote\";s:0:\"\";s:7:\"comment\";s:0:\"\";}', 'a:14:{s:7:\"comment\";s:1:\"2\";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:\"1\";s:6:\"sticky\";s:1:\"0\";s:10:\"taxonomy:1\";s:0:\"\";s:26:\"cck:field_image_cache:list\";i:1;s:4:\"type\";s:7:\"product\";s:12:\"weight_units\";s:2:\"lb\";s:12:\"length_units\";s:2:\"in\";s:11:\"default_qty\";i:1;}', 'a:3:{s:22:\"cck:field_volume:value\";a:1:{s:18:\"multiple_separator\";s:2:\"||\";}s:10:\"taxonomy:1\";a:1:{s:19:\"hierarchy_separator\";s:2:\">>\";}s:20:\"cck:field_goal:value\";a:1:{s:18:\"multiple_separator\";s:2:\"||\";}}', 0, 0, 0, 0) in Z:\home\drupal6.test\www\includes\common.inc on line 3422.
Comment #2
zserno commentedMake sure you run update.php, because it alters the database. That's why get those errors.
Comment #3
J-Chance commentedthank you. I figured it out a while ago and forgot to update this.
Comment #4
psychoman commentedthanks )