Advertisement:

Author Topic: yabb gold 1.4 to smf 1.1.1 (problems converting)  (Read 4979 times)

Offline iougs

  • Newbie
  • *
  • Posts: 4
yabb gold 1.4 to smf 1.1.1 (problems converting)
« on: December 31, 2006, 08:08:43 PM »
trying to convert yabb 1 gold sp 4 to smf 1.1.1 ...
using the converter on the download page which i assume works for converting from yabb 1.4 to smf 1.1.1

if i need to use smf 1.1 instead of 1.1.1, please let me know because it's not clear which version of smf you are supposed to convert to (assuming it makes a difference).
« Last Edit: January 03, 2007, 03:00:07 PM by iougs »

Offline iougs

  • Newbie
  • *
  • Posts: 4
Re: yabb gold 1.4 to smf 1.1.1
« Reply #1 on: January 02, 2007, 09:12:25 PM »
ok, did a fresh install of smf 1.1.1 and ran the 'yabb to smf' converter that's in the download area and this is what i get:

Quote
Converting members... Successful.
Converting settings... Successful.
Converting personal messages... Successful.
Converting boards and categories... Successful.
Converting mark read data... Unsuccessful!
This query:

    INSERT INTO `peaceforum_sql`.smf_log_boards
    (logTime, ID_MEMBER, ID_BOARD)
    VALUES ('1166217249', '1', '15'),
    ('1164810940', '1', '1'),
    ('1166902911', '1', '3'),
    ('1166896472', '1', '7'),
    ('1130332328', '6', '2'),
    ('1130332168', '6', '4'),
    ('1130332196', '6', '1'),
    ('1159844476', '37', '10'),

    etc etc etc

    ('1167745208', '2', '8'),
    ('1166039576', '2', '11'),
    ('1166485302', '2', '4'),
    ('1166641572', '2', '16');

Caused the error:

    Unknown column 'logTime' in 'field list'

any ideas on how to proceed? thanks in advance.
« Last Edit: January 03, 2007, 09:20:19 AM by iougs »

Offline iougs

  • Newbie
  • *
  • Posts: 4
Re: yabb gold 1.4 to smf 1.1.1 (problems converting)
« Reply #2 on: January 03, 2007, 06:20:21 PM »
used the sql that's in that thread and it worked:
http://www.simplemachines.org/community/index.php?topic=134431.0
from yabb 1 sp 1.4 to smf 1.1.1