I have read through every thread I could find on this issue and can't seem to find an answer to my problem.
I am importing my vBlogetin data to vBulletin Blog via Impex.
Here is the error I just got on trying to match by user id:
Can anyone help me figure this out?
I am importing my vBlogetin data to vBulletin Blog via Impex.
- I backed up the vBlogetin tables and the user table and put them into a temporary DB.
- I removed vBlogetin.
- I installed vBulletin Blog.
- I downloaded Impex from the members area and installed it.
- Step one was fine.
- I skipped step two.
- On step three, I choose to match by email address, and it always fails, telling me there is a duplicate key. **edited to add** I tried matching on user id and it gave me the same error.
Here is the error I just got on trying to match by user id:
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 ( '7', '7', 'title', 'description', '0', 'all', '0', '0', '0', '', '0', '', '0', '23', '1', 'none', 'none', '0', '0', '0', '3', '3', '0', '0', '0', '0', '0', '0' ) mysql error: Duplicate entry '7' for key 1 mysql error number: 1062 Date: Sunday 27th 2008f July 2008 12:06:41 AM Database: *** MySQL error:
Comment