Author Topic: [SMF Converter] phpBB3  (Read 183703 times)

Offline Norv

  • Senior Support Specialist
  • Simple Machines Hero
  • *
  • Posts: 5,106
  • Software is not released, only allowed to escape.
Re: [SMF Converter] phpBB3
« Reply #680 on: October 29, 2009, 06:35:45 PM »
The converter will wipe some tables and replace their contents with the converted data. Just as well, it will re-calculate various statistics and update them into existing tables. That means that at least the accounts are replaced, yes. You will have the old account from phpBB.

I'm not sure of all details of TP and SMG will need, but I tend to think that the safest way to do is still to convert over an installation with no TP/SMG and install them after.
Otherwise there can be surprising behaviors. In case you set TP to show a certain board as articles, for example, the conversion will remove that board and eventually replace that board with the one from phpBB which happens to have the same ID, if any.
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 Inquisitor

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] phpBB3
« Reply #681 on: October 30, 2009, 09:31:35 PM »
Thanks. So, anyway, I'll try. I'll backup my data and try to convert. If I'll get unpredicted things, I'll investigate why that happened, rollback and try to control the process of conversion. I'll report later about a result.

Offline Norv

  • Senior Support Specialist
  • Simple Machines Hero
  • *
  • Posts: 5,106
  • Software is not released, only allowed to escape.
Re: [SMF Converter] phpBB3
« Reply #682 on: October 31, 2009, 02:38:23 PM »
I'm not sure there's any need to rollback, as the converter doesn't do any modification to the data from phpBB, while the SMF tables it needs should be emptied every time it's run.
Please feel free to post here any errors you may have, and we will try to assist you.
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 [-Trogan-]

  • Semi-Newbie
  • *
  • Posts: 28
Re: [SMF Converter] phpBB3
« Reply #683 on: November 06, 2009, 05:18:46 PM »
Alright i have a question.


Will this converter work for phpbb3.0.6rc3?

Offline Norv

  • Senior Support Specialist
  • Simple Machines Hero
  • *
  • Posts: 5,106
  • Software is not released, only allowed to escape.
Re: [SMF Converter] phpBB3
« Reply #684 on: November 07, 2009, 02:24:27 AM »
Most probably, as both converters (to SMF 1.1.10 and to SMF 2.0 RC1.2) were tested on 3.0.5. In case there were no relevant database changes, it should work with any 3.x version, and normally there are no such changes on minor versions. (usually, in any software, that is).
In any case you can try it on your board. It won't do anything wrong anyway, it doesn't touch the phpbb installation, only tries taking the data from it. In case anything goes wrong please feel free to let us know.
You can find all information for the conversion here: Converting 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 [-Trogan-]

  • Semi-Newbie
  • *
  • Posts: 28
Re: [SMF Converter] phpBB3
« Reply #685 on: November 07, 2009, 01:56:24 PM »
Ok how do i get started with this conversion (i got the files now where do i put them in my site?) (and then what do i do?)

Offline Norv

  • Senior Support Specialist
  • Simple Machines Hero
  • *
  • Posts: 5,106
  • Software is not released, only allowed to escape.
Re: [SMF Converter] phpBB3
« Reply #686 on: November 07, 2009, 06:07:25 PM »
Please check out the step-by-step manual : Converting to SMF

Mainly, the files should be in the SMF folder (SMF should be installed) and you run convert.php from the browser.
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 [-Trogan-]

  • Semi-Newbie
  • *
  • Posts: 28
Re: [SMF Converter] phpBB3
« Reply #687 on: November 07, 2009, 08:09:08 PM »
uh-oh.

got an error.


Code: [Select]
Notice: Undefined variable: to_prefix in /home/beastmag/domains/torous1234.co.cc/public_html/forum/convert.php on line 1821
Unsuccessful!
This query:

    REPLACE INTO settings (variable, value)
    VALUES ('conversion_time', 1257642369),
    ('conversion_from', 'phpbb3_to_smf.sql');

Caused the error:

    No database selected

what can i do


(user edit)It wont let me insert a modification that i know works because i have used it on another of my smf forums (non converted) the one i'm trying to get installed is tinypicplugin_smf_mod_v1.0.0
« Last Edit: November 07, 2009, 09:11:33 PM by [-Trogan-] »

Offline narqelion

  • Semi-Newbie
  • *
  • Posts: 70
Re: [SMF Converter] phpBB3
« Reply #688 on: November 07, 2009, 10:09:14 PM »
Based on your edit can I assume you worked through the conversion error and have your board converted and running?

Offline [-Trogan-]

  • Semi-Newbie
  • *
  • Posts: 28
Re: [SMF Converter] phpBB3
« Reply #689 on: November 07, 2009, 10:35:50 PM »
It seems that the error didnt affect anything at all.
odd.
Never heard of a false error message.

but yea it works.

Offline sandoz

  • Newbie
  • *
  • Posts: 7
Re: [SMF Converter] phpBB3
« Reply #690 on: November 13, 2009, 03:39:51 AM »
i get this:
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of phpBB3. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user 'xxx'@'72.167.xxx' for table 'phpbb_users'

apparently the mysql userinfo is wrong, but i cannot enter the pphbb3 mysql login

Offline Norv

  • Senior Support Specialist
  • Simple Machines Hero
  • *
  • Posts: 5,106
  • Software is not released, only allowed to escape.
Re: [SMF Converter] phpBB3
« Reply #691 on: November 13, 2009, 03:57:23 AM »
Please check out: Common conversion errors.
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 sandoz

  • Newbie
  • *
  • Posts: 7
Re: [SMF Converter] phpBB3
« Reply #692 on: November 16, 2009, 02:53:43 AM »
yes, ok, because the php db was on another account

now i imported the php db to the same db as smf forum, but still i get this error:
what am i doing wrong?
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of phpBB3. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.

The error that was received from the Database was: SELECT command denied to user 'xxx'@'72..185' for table 'phpbb_users'

Offline Norv

  • Senior Support Specialist
  • Simple Machines Hero
  • *
  • Posts: 5,106
  • Software is not released, only allowed to escape.
Re: [SMF Converter] phpBB3
« Reply #693 on: November 16, 2009, 03:03:03 AM »
Even though you imported the php db, the converter asks you for phpbb path and reads a configuration file from it, in which most probably it's the old phpbb database pointed to. So the converter will try connecting to that one still, for phpbb data.
You can:
Option 1: - install SMF in the same database where phpbb was installed (not the other way around)
Option 2: - let them in different databases, but check in your host's panel if you can add the user of the SMF database to the phpbb database.
Option 3: - change the phpbb configuration file to point to the SMF database (where you imported the phpbb tables) - I don't recommend this, because your phpbb will try to work then from this copied tables, and if any is missing or whatnot, phpbb installation won't work. Rather, make a copy of the config file, and place it in another folder (random folder) and point the converter to that folder as "phpbb installation".
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.