Closed (fixed)
Project:
Node import
Version:
5.x-1.1
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
28 May 2007 at 05:37 UTC
Updated:
12 Nov 2008 at 16:51 UTC
This module looks very promising and hope that it eventually gets some of the bugs sorted out because it is certainly a very powerful tool.
Tried it out and i get about 10% of my records dumped due to "data too long" warnings such as these:
# user warning: Data too long for column 'title' at row 1 query: INSERT INTO node_revisions (nid, vid, title, body, teaser, timestamp, uid, format, log) VALUES (208, 208, 'Agent immobilier affili� R. La Salle', '', '', 1180330088, 1, 0, '') in C:\Inetpub\websites\drupal-5.1\includes\database.mysql.inc on line 172.
# user warning: Data too long for column 'field_contact_value' at row 1 query: INSERT INTO content_type_contact (field_contact_value, vid, nid) VALUES ('Ren� La Salle', 208, 208) in C:\Inetpub\websites\drupal-5.1\includes\database.mysql.inc on line 172.
# user warning: Data too long for column 'field_contact_value' at row 1 query: INSERT INTO content_type_contact (field_contact_value, vid, nid) VALUES ('Rose M. D�silets', 209, 209) in C:\Inetpub\websites\drupal-5.1\includes\database.mysql.inc on line 172.
# user warning: Data too long for column 'field_rue_value' at row 1 query: UPDATE content_type_contact SET field_rue_value = '137, mont�e de la Source' WHERE vid = 212 AND nid = 212 in C:\Inetpub\websites\drupal-5.1\includes\database.mysql.inc on line 172.
# user warning: Data too long for column 'title' at row 1 query: INSERT INTO node (nid, vid, title, type, uid, status, created, changed, comment, promote, sticky) VALUES (213, 213, 'A Toute S�curit�', 'contact', 1, 1, 1180330088, 1180330088, 0, 0, 0) in C:\Inetpub\websites\drupal-5.1\includes\database.mysql.inc on line 172.
of course the data fields being filled are long enough to hold the contents being dumped; so perhaps this is a core issue ???
also, when the import is done is suggested that 101 nodes were created... which does match the number of records i was trying to create; but this isnt actually the number that were created.. i suspect it is out by the number of errors such as those above that i received.
Comments
Comment #1
liquidcms commentedok, i have figured out the issue.. but not the solution.
in the sample test import data above there are numerous "?" - these are actually accented e's since the data has french names in it. I guess when imported this screws up along the way and mysql/drupal sees things as a data too long issue.
not sure if this is an issue with table character set definition or something missing from this module... anyone have any ideas?
i'll do a little character set digging
Comment #2
liquidcms commentedok, found the issue here: http://drupal.org/node/84902
i guess fgetcsv php function isnt unicode compliant.. and this is what node import uses as well.
looking around for a solution...
Comment #3
Robrecht Jacques commentedThe code in node_import 5.x-1.8 (released shortly) has been rewritten not to use fgetcsv. UTF8 characters should no longer be an issue.
Reopen this issue if after you have tried 5.x-1.8 you still get the same error.
Comment #4
Anonymous (not verified) commentedAutomatically closed -- issue fixed for two weeks with no activity.