Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Error when importing from Vanilla 1 to 2 (row 1 doesn't contain data for all columns)
JoosBuijs
New
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/","someone@example.com",\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
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/","someone@example.com",\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
0
Comments
http://github.com/vanillaforums/Garden/issues
See http://github.com/vanillaforums/Garden/issues/issue/477
I'll try to get database access via some tool so I can see what the tables in both Vanilla 1 and 2 look like.
Joos