Poll

phpBB3 to SMF 1.1.0 Error

failed
 1 (33.3%)
good
 2 (66.7%)

Total Members Voted: 3

Author Topic: phpBB3 to SMF 1.1.0 Error  (Read 345 times)

Offline moofa

  • Semi-Newbie
  • *
  • Posts: 15
    • Ejeet Networks
phpBB3 to SMF 1.1.0 Error
« on: November 04, 2009, 06:11:56 PM »
Hi there,

I was just running a conversion and got the following error.

Quote
Converting ranks... Successful.
Converting groups... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Preparing for categories conversion... Successful.
Converting categories... Successful.
Converting boards... Successful.
Fixing categories... Successful.
Converting topics... Successful.
Converting posts... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting attachments... Successful.
Recalculating forum statistics... Successful.
Unsuccessful!
This query:

    REPLACE INTO {$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1257376228),
    ("conversion_from", "phpbb3_to_smf.sql");

Caused the error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1257376228)' at line 1

Any suggestions?

Offline Norv

  • Senior Support Specialist
  • Simple Machines Hero
  • *
  • Posts: 5,106
  • Software is not released, only allowed to escape.
Re: phpBB3 to SMF 1.1.0 Error
« Reply #1 on: November 04, 2009, 06:20:20 PM »
Please disregard this error, it's a bug in the converter, rather than any problem with the conversion itself.

Your conversion has actually succeeded, congratulations and welcome to SMF!
File a security report  |  Bugtracker  |  Online Manual
Please note that I will not answer unsolicited PMs for support. Questions and answers should be publicly available.

Offline moofa

  • Semi-Newbie
  • *
  • Posts: 15
    • Ejeet Networks
Re: phpBB3 to SMF 1.1.0 Error
« Reply #2 on: November 04, 2009, 06:23:54 PM »
Thanks!

Its not my first SMF just an old gaming board I converted to SMF since SMF is the future!


Thanks mate!

Offline Norv

  • Senior Support Specialist
  • Simple Machines Hero
  • *
  • Posts: 5,106
  • Software is not released, only allowed to escape.
Re: phpBB3 to SMF 1.1.0 Error
« Reply #3 on: November 04, 2009, 06:27:11 PM »
Marking as solved. :)
File a security report  |  Bugtracker  |  Online Manual
Please note that I will not answer unsolicited PMs for support. Questions and answers should be publicly available.