Associating Users - vBlogetin Issue Tools
issueid=23118 Tue 4th Sep '07 7:49pm
Senior Member
Associating Users - vBlogetin

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 :

Code:
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
Issue Details
Project ImpEx
Category SQL error
Status Fixed (Closed)
Priority 5 - Medium
Affected Version 1.85
Fixed Version (none)
Users able to reproduce bug 2
Users unable to reproduce bug 0
Assigned Users Jerry
Tags (none)

Wed 5th Sep '07 1:58pm
ImpEx Developer
 
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.
Reply
Wed 5th Sep '07 2:48pm
Senior Member
 
That's where I get the error. Step 3 (after skipping step 2), when I select to associate users if emails match.
Reply
Wed 5th Sep '07 2:57pm
Senior Member
 
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.
Reply
Wed 5th Sep '07 4:03pm
Senior Member
 
Quote Originally Posted by 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.
Same situation with me

Quote Originally Posted by Jerry
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.
Reply
Thu 6th Sep '07 3:17pm
ImpEx Developer
 
This is now fixed, for any more issues, start a individual bug thread and one per bug.
Reply
Mon 12th May '08 6:46pm
New Member
 
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:
Reply
This petition for a change to System Bug was rejected
Mon 21st Jul '08 1:42am
Member
 
I get the same error as reported above with version 1.90
Reply