Please upgrade here. These earlier versions are no longer being updated and have security issues.

Error when importing from Vanilla 1 to 2 (row 1 doesn't contain data for all columns)

JoosBuijsJoosBuijs New
edited July 2010 in Vanilla 2.0 - 2.8
I've just installed Vanilla version 2 on our Windows server with Apache 2.2.9, PHP 5.2.9 and MySQL version 5.0.51a.

There is however a problem when I try to import the data from Vanilla 1, exported using Vanilla Porter 1.0.1.

The error I get is as follows:
Row 1 doesn't contain data for all columns|Gdn_Database|Query|load data infile 'D:\\Websites\\forum/uploads/import/User.txt' into table GDN_zUser character set utf8 columns terminated by ',' optionally enclosed by '"' escaped by '\\' lines terminated by '\n' ignore 1 lines

The first lines of user.txt look as follows (of course garbled some fields on purpose)
UserID,Name,Password,Email,Photo,CountDiscussions,CountComments,DateFirstVisit,DateLastActive
1,"user","$P$BJ4DerPRxiD7xblaGARBLEWI/4Al/","[email protected]",\N,1,3,"2009-01-01 17:05:00","2010-06-30 13:37:77"

If anyone can help me track, but more interestingly solve the problem, I would be very happy!

Thanks in advance,

Joos
Tagged:

Comments

Sign In or Register to comment.