Advertisement:

Author Topic: Problem converting vBlah 3.0.0 to SMF 1.1.2  (Read 4554 times)

Offline Douglas

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 3,084
  • Gender: Male
  • Non sibi sed patriae
    • @BearlyDoug on Twitter
    • TwoCentsRadio.net
Problem converting vBlah 3.0.0 to SMF 1.1.2
« on: June 22, 2007, 01:41:44 PM »
Converting posts (this may take some time)... Unsuccessful!
This query:
Caused the error:  Duplicate entry '263780' for key 1

Here's the two items...

Code: [Select]
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
* Web Developer / Operations Analyst for Richweb.com
* Sports Media Personality covering Collegiate Football and Basketball
* CFB Historian (GridironHistory.com)
* Tech Admin for one 1M+ post, one 2M+ post and one 8M+ post sites (last two are powered by 10+ servers)
* SMF Fanatic

Offline Douglas

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 3,084
  • Gender: Male
  • Non sibi sed patriae
    • @BearlyDoug on Twitter
    • TwoCentsRadio.net
Re: Problem converting vBlah 3.0.0 to SMF 1.1.2
« Reply #1 on: June 23, 2007, 11:07:37 AM »
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
* Web Developer / Operations Analyst for Richweb.com
* Sports Media Personality covering Collegiate Football and Basketball
* CFB Historian (GridironHistory.com)
* Tech Admin for one 1M+ post, one 2M+ post and one 8M+ post sites (last two are powered by 10+ servers)
* SMF Fanatic

Offline Douglas

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 3,084
  • Gender: Male
  • Non sibi sed patriae
    • @BearlyDoug on Twitter
    • TwoCentsRadio.net
Re: Problem converting vBlah 3.0.0 to SMF 1.1.2
« Reply #2 on: June 23, 2007, 01:06:40 PM »
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
* Web Developer / Operations Analyst for Richweb.com
* Sports Media Personality covering Collegiate Football and Basketball
* CFB Historian (GridironHistory.com)
* Tech Admin for one 1M+ post, one 2M+ post and one 8M+ post sites (last two are powered by 10+ servers)
* SMF Fanatic

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: Problem converting vBlah 3.0.0 to SMF 1.1.2
« Reply #3 on: June 25, 2007, 12:24:24 AM »
Updated converter.
Follow me on Twitter

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