Problem converting vBlah 3.0.0 to SMF 1.1.2

Started by Douglas, June 22, 2007, 01:41:44 PM

Previous topic - Next topic

Douglas

Converting posts (this may take some time)... Unsuccessful!
This query:
Caused the error:  Duplicate entry '263780' for key 1

Here's the two items...

INSERT INTO `douglas_bob`.z_messages
(ID_MSG, ID_TOPIC, posterTime, ID_MEMBER, subject, posterName, posterIP, ID_BOARD, smileysEnabled, body, posterEmail, modifiedName, icon)
VALUES ('263780', '14275', '1156282772', '80', 'Re: Fantasy Football', 'ALinChainz', '4.158.60.217', '11', '1', 'We have 14 as of today.

How many are we after?', '', '', 'xx'),


Doug Hazard
* Full Stack (Web) Developer for The Catholic Diocese of Richmond
(20+ Diocesan sites, 130+ Church sites & 24 School sites)
* Sports Photographer and Media Personality
* CFB Historian
* Tech Admin for one 1M+ post, one 2M+ post and one 10M+ post sites (last two are powered by multiple servers)
* WordPress Developer (Junkie / Guru / Maven / whatever)

Douglas

Update:  Okay, messages went through fine, but now it's choking on the polls.  It's created the categories, but I don't see the board names.
Doug Hazard
* Full Stack (Web) Developer for The Catholic Diocese of Richmond
(20+ Diocesan sites, 130+ Church sites & 24 School sites)
* Sports Photographer and Media Personality
* CFB Historian
* Tech Admin for one 1M+ post, one 2M+ post and one 10M+ post sites (last two are powered by multiple servers)
* WordPress Developer (Junkie / Guru / Maven / whatever)

Douglas

Adding the DB structure to this.  This is, again, for vBulletin 3.0.0
Second one is the one I grabbed from the converters, though I'm using Jay's latest convert.php

Doug Hazard
* Full Stack (Web) Developer for The Catholic Diocese of Richmond
(20+ Diocesan sites, 130+ Church sites & 24 School sites)
* Sports Photographer and Media Personality
* CFB Historian
* Tech Admin for one 1M+ post, one 2M+ post and one 10M+ post sites (last two are powered by multiple servers)
* WordPress Developer (Junkie / Guru / Maven / whatever)

JayBachatero

Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Advertisement: