Associating Users - vBlogetin

[Lizard King]

After second stage when i move to stage and what ever i do i always get a database error . The database error i get is as following :


ImpEx Database errormysql error: Invalid SQL:
INSERT INTO blog_user
(
bloguserid, importbloguserid, title, description, options,
viewoption, comments, lastblog, lastblogid,
lastblogtitle, lastcomment, lastcommenter, lastblogtextid,
entries, allowsmilie, subscribeown, subscribeothers,
moderation, deleted, draft, options_everyone,
options_buddy, options_ignore, ratingnum, ratingtotal,
rating, pending, uncatentries
)
VALUES
(
'0',
'7',
'title',
'description',
'0',
'all',
'0',
'0',
'0',
'',
'0',
'',
'0',
'0',
'1',
'none',
'none',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0'
)


mysql error: Duplicate entry '0' for key 1

mysql error number: 1062

Date: Wednesday 05th 2007f September 2007 01:44:13 AM
Database: ***
MySQL error:

We still have a problem while inserting data to blog_user table

[Jerry]

What second stage ? What model number ?

If you are importing from vBlogatin in to vBulletin and vBBlog, skip the manual association and merge the users in the user module on email address.

[Sychev_S]

That's where I get the error. Step 3 (after skipping step 2), when I select to associate users if emails match.

[Sychev_S]

btw, The import works fine if I do not checkmark "Associate users if emails match", but obviouslyl all suers show up as imported_username.
And also all of the entries show up as PRIVATE.
Just FYI.

[Lizard King]

btw, The import works fine if I do not checkmark "Associate users if emails match", but obviouslyl all suers show up as imported_username.
And also all of the entries show up as PRIVATE.
Just FYI.

Same situation with me


If you are importing from vBlogatin in to vBulletin and vBBlog, skip the manual association and merge the users in the user module on email address.

If i do that i again get the database error. I also want to say that i even tried this after truncating blog_user table. But it always gives the same database error.

[Jerry]

This is now fixed, for any more issues, start a individual bug thread and one per bug.

[Home Alone]

I receive this error using ImpEx build version : 1.89 when I try to associate users using the email address:


ImpEx Database errormysql error: Invalid SQL:
INSERT INTO blog_user
(
bloguserid, importbloguserid, title, description, options,
viewoption, comments, lastblog, lastblogid,
lastblogtitle, lastcomment, lastcommenter, lastblogtextid,
entries, allowsmilie, subscribeown, subscribeothers,
moderation, deleted, draft, options_everyone,
options_buddy, options_ignore, ratingnum, ratingtotal,
rating, pending, uncatentries
)
VALUES
(
'0',
'1358',
'title',
'description',
'0',
'all',
'0',
'0',
'0',
'',
'0',
'',
'0',
'7',
'1',
'none',
'none',
'0',
'0',
'0',
'3',
'3',
'0',
'0',
'0',
'0',
'0',
'0'
)


mysql error: Duplicate entry '0' for key 1

mysql error number: 1062

Date: Monday 12th 2008f May 2008 05:45:00 PM
Database: lipdev_lipstick
MySQL error:

[Merriweather]

I get the same error as reported above with version 1.90