[SMF Converter] phpBB3

[the-outdoorsman]

I figured out how to give it access to the database. At the end I get this:

Converting posts...
Duplicate entry '2' for key 'PRIMARY'

All the pics that were posted come up with red x now. Most of the pics were not attachments but rather bbcode for inset image. One more thing. When I installed SMF, I installed it to forum on my server. My phpbb forum was in this directory and I just renamed it to forum1. Will this make a difference?

Also it takes logging in three times to get logged in

[the-outdoorsman]

Well I ran the converter again and now it says it converted it. Still have the red x for the photos that were posted though. And I still have to log in three times the first time I log on.

[the-outdoorsman]

One more thing, If I admin a post all text is there for the image that was inserted with bbcode. I don't change a thing and then hit save and then the photos show up.

[Nalfeim]

Hi

I got a hell of a mess here. I'm trying to convert my phpBB 3.0.5. There's quite a lot of post, even after a good deal of cleaning oldies. PHP is in safe mode and I can't do anything about it. It means that I had to comment all the "set_time_limit" to get the script to run.
The problems is, I guess, that there's a timeout preventing the script to complete.

Is there any way to work around this? Maybe manually calling the step with specific url?...

I'm currently trying to duplicate the forum on a local apache server to convert it then import SMF database in a newly installed database on the web version. That's not going very well because my web provider is what you would call "free crap", the database export is messed up. I'll manage it somehow with time, but I would appreciate any easier way!

Thanks

[AussieGamer]

So, ran the converter, and the password fix in the LoginLogOut.php file, but have lost administrator privs.

Ran the database query to change member group to "1", however, that gives even LESS options that a 'Newbie'; having the administrator only allowed to choose "Home, Help and Logout"....

Any help?

Also, while we're at it, can anyone point me in the direction of a WordPress integration mod?

[oziboy]

Thanks to all you guys for all the work with the phpBB Converter.

UTF-8 was where I let myself down with my conversion, but I have it all sorted now - I hope.

[SavvyQc]

Hello,
trying to convert from phpbb3. Got the forums installed, and got familiar with the admin panel some. Then began the conversion. It's stalled out on the posts (there are many) and then stops after polls.

I can't login, so i downloaded the login fix package. But how am i supposed to install it, if i can't login?

thanks for any help or advice

[SavvyQc]

just ran it again,....it gets stuck at:

Converting posts...
Successful.
Converting polls... Successful.
Converting poll options...Duplicate entry '1607-3' for key 1




then halts. 

[SavvyQc]

ok - got past that by forcing the substeps in the url. Got to a sucessfull conversion page. Still can't login  >.<

"Password security has recently been upgraded. Please enter your password again."

I think the problem is that I started with a fresh password on this smf install. Now i have 2 id's with two different passwords?

I will have to try that manual edit on the passwords, but i'm not sure how to get which password fixed. Shoot, i should have used the same password. 

[SavvyQc]

hmm, whelp, got the loginout opened up and looks like this code is there!


um...... i don't know.

edited to say:
I tried to login using my test account. The password autofilled...... but then told me it was incorrect.

and it basically seems to be stuck in maintenance mode and admin login.

I'm super excited to get this going. I have been bashing my head on php coding for 12 years. I couldn't believe it when i started messing with the test smf forum (After a friend referred me) and the package installer - woow. calendar, subscriptions, newsletters, quickreply, shoutbox. bam. I'm very excited.

sorry for the multiple posts. I'll watch this spot for a reply. 

edited again to add:
i'll start reading through this entire 38 page thread, daunting that it is.  lol

edited 3rd time:
i wiped it all off the server and started over. This time my admin name is different. the whole board is there!!! everything!!
all the members, forums, threads.....it's beautiful.

can you hear the angels singing???

[TheZenith]

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 'zenith_smf120'@'localhost' for table 'pokechamps_users'

Could someone help? I'm converting 3.0.7 PL to SMF 1.11

[xenovanis]

hmm, whelp, got the loginout opened up and looks like this code is there!


um...... i don't know.

edited to say:
I tried to login using my test account. The password autofilled...... but then told me it was incorrect.

and it basically seems to be stuck in maintenance mode and admin login.

I'm super excited to get this going. I have been bashing my head on php coding for 12 years. I couldn't believe it when i started messing with the test smf forum (After a friend referred me) and the package installer - woow. calendar, subscriptions, newsletters, quickreply, shoutbox. bam. I'm very excited.

sorry for the multiple posts. I'll watch this spot for a reply. 

edited again to add:
i'll start reading through this entire 38 page thread, daunting that it is.  lol

edited 3rd time:
i wiped it all off the server and started over. This time my admin name is different. the whole board is there!!! everything!!
all the members, forums, threads.....it's beautiful.

can you hear the angels singing???

Very sorry for the late reply, SavvyQc. To what version of SMF did you convert? You might want to reset your password by using the "forgot your password?" link and see if you're able to login then.

If you converted to SMF 1.1.11, in the first post of this topic is a mod attached that should fix the login problems. Once you gained access to your forum, you can install it in Admin -> Main -> Packages.

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 'zenith_smf120'@'localhost' for table 'pokechamps_users'

Could someone help? I'm converting 3.0.7 PL to SMF 1.11

Please continue here:
http://www.simplemachines.org/community/index.php?topic=403862.msg2810166#msg2810166

[trollxp]

Hi all

I've got fresh installation of SMF and phpbb3 working forum. Everytime I use convert.php file I got a message:

The requested URL /smf/', $_SERVER['PHP_SELF'], ' was not found on this server.

SMF is here: www hxxp:mydomain.pl/smf [nonactive]
convert is here: www hxxp:mydomain.pl/smf/convert.php [nonactive]
localpath is: /domains/mydomain.pl/public_html/smf/

What am I doing wrong?

Regards
Troll

[mrpeco]

hello, sory for asking this question. but i don't know how to fix it. hope somebody feel free to help me
i got this error :

Caused the error:

    Duplicate entry '4173-1' for key 1

anybody know ? thx

[ThorstenE]

can you please post the full error message? the interesting part is missing (which part was it? topics, messages?)

[mrpeco]

Converting posts... Successful.
Converting polls... Successful.
Converting poll options... Unsuccessful!
This query:

    INSERT INTO `kroniko_phpb1`.smf_poll_choices
    (ID_POLL, ID_CHOICE, label, votes)
    VALUES ('198', '1', 'boxer', '6'),
    ('4173', '1', 'sayang etong', '0'),
    ('4173', '1', 'Setuju', '7'),
    ('4036', '1', 'Wat Mcm Xnah Wujud', '3'),
    ('3875', '1', 'Setiap kali bangun pagi sahaja', '0'),
    ('2261', '1', 'I encode movies', '0'),
    ('2208', '1', '300MB MOVIES', '0'),
    ('2206', '1', '300MB MOVIES THREAD', '1'),
    ('1929', '1', 'Ya', '1'),
    ('425', '1', 'batu gajah berwarna/hitam/putih', '1'),
    ('4173', '2', 'Tak Setuju', '1'),
    ('3875', '2', 'Setiap kali bangun pagi dan sebelum tidur malam', '3'),
    ('425', '2', 'batu 1 line standard size berwarna/hitam/putih', '0'),
    ('2261', '2', 'to H.264 codec', '0'),
    ('4173', '2', 'xsayang etong', '0'),
    ('2208', '2', '300MB MOVIES MOVIE THREAD', '0'),
    ('4036', '2', 'Anggap Perkara 2 Xnah Berlaku', '4'),
    ('2206', '2', '300MB', '0'),
    ('1929', '2', 'Tidak', '2'),
    ('198', '2', 'spende', '0'),
    ('198', '3', 'boxer &amp;amp; spende', '1'),
    ('4036', '3', 'X Dpt Terima Knyataan (Cerai/Minx Cerai)', '5'),
    ('2208', '3', '10,000 BC', '1'),
    ('3875', '3', 'Setiap kali lepas makan', '0'),
    ('425', '3', 'batu oktant 3 bintang', '0'),
    ('3875', '4', 'Setiap kali mandi', '1'),
    ('4036', '4', 'Balas Balik Apa Yg Suami/Isteri Wat Dulu', '1'),
    ('425', '4', 'batu oktant bunga sekuntum', '1'),
    ('425', '5', 'batu oktant 3segi', '0'),
    ('3875', '5', 'Sebelum solat 5 waktu', '1'),
    ('4036', '5', 'Redha', '15'),
    ('4036', '6', 'Lain-lain (Nyatakan)', '1'),
    ('3875', '6', 'Setiap satu jam', '0'),
    ('425', '6', 'batu oktant bentuk S', '0'),
    ('3875', '7', 'Bila teringat nak berus gigi', '1'),
    ('3875', '8', 'Kadang-kadang bila nak jer', '0'),
    ('3875', '9', 'Tak pernah berus gigi langsung', '0'),
    ('4679', '1', 'Merempit', '2'),
    ('4679', '2', 'Sambut di dataran atau konsert memana', '3'),
    ('4679', '3', 'Nengok tv je kat rumah', '1'),
    ('4679', '4', 'Memancing ikan mahupun awek', '2'),
    ('4679', '5', 'Mengadap skrin komputer', '10'),
    ('4679', '6', 'Tidur tak ingat donia', '5'),
    ('4679', '7', 'Layan bunga api', '7'),
    ('4692', '1', 'Kronik dahulu', '7'),
    ('4692', '2', 'Kronik Skrang', '14'),
    ('4722', '1', 'Sudah', '11'),
    ('4722', '2', 'Belum', '9'),
    ('4722', '3', 'Tak pasti', '9'),
    ('8855', '1', 'mutiara naga', '4'),
    ('8848', '4', 'Super Sentai/Power Rangers', '5'),
    ('8848', '3', 'Gaban/Gransazer/Ryukendo', '2'),
    ('8848', '2', 'Ultraman', '5'),
    ('8848', '1', 'Kamen Rider', '5'),
    ('8688', '5', 'biasa2 aja.', '2'),
    ('8688', '4', 'banyak keje!', '3'),
    ('8688', '3', 'bosan!', '1'),
    ('8688', '2', 'tak de kawan!', '2'),
    ('8688', '1', 'suka bangat!', '2'),
    ('6865', '1', 'yes', '1'),
    ('6865', '2', 'no', '1'),
    ('6865', '3', 'no comment', '0'),
    ('7811', '1', 'Baca Yassin', '7'),
    ('7811', '2', 'Keluar town dengan member-member', '5'),
    ('7811', '3', 'Ngadap PC', '9'),
    ('7811', '4', 'Lepak kt kedai makan', '0'),
    ('7811', '5', 'Sambut kt tmpat lain', '0'),
    ('7811', '6', 'Lepak dengan family', '0'),
    ('7811', '7', 'Kerja', '0'),
    ('7811', '8', 'Lain-lain...(nyatakan)', '3'),
    ('8100', '1', 'mmg da bom', '1'),
    ('8100', '2', 'oklah', '2'),
    ('8100', '3', 'cam poyo jer', '3'),
    ('8175', '1', 'mintak no tepon', '17'),
    ('8175', '2', 'ajak tgk wayang', '2'),
    ('8175', '3', 'ekori dia', '2'),
    ('8175', '4', 'pegi depan2. cakap i love u!', '9'),
    ('8855', '2', 'misteri naga', '0'),
    ('8855', '3', 'doraemon', '2'),
    ('8855', '4', 'yuyuhakusho', '0'),
    ('8855', '5', 'naruto', '2'),
    ('8855', '6', 'one piece', '0'),
    ('8855', '7', 'bleach', '0'),
    ('8855', '8', 'slam dunk', '0'),
    ('8869', '1', 'manga - jepun', '4'),
    ('8869', '2', 'komik - hongkong', '2'),
    ('8874', '1', 'magazine', '0'),
    ('8874', '2', 'wikipedia', '0'),
    ('8874', '3', 'dictionary', '0'),
    ('8874', '4', 'movie subtitles', '2'),
    ('8874', '5', 'internet', '1'),
    ('8874', '6', 'story book', '1'),
    ('8874', '7', 'english blog', '0'),
    ('8976', '2', 'arnab', '0'),
    ('8874', '8', 'music (latest added)', '5'),
    ('8976', '1', 'kucing', '11'),
    ('8874', '9', 'game', '1'),
    ('8976', '3', 'ikan', '2'),
    ('8976', '4', 'kura-kura', '0'),
    ('8976', '5', 'burung', '0'),
    ('8976', '6', 'hamster', '1'),
    ('9050', '1', 'Sokong Gilakk!!', '8'),
    ('9050', '2', 'Sokong...', '2'),
    ('9050', '3', 'Agak Arh...', '0'),
    ('9050', '4', 'Ok Jer??', '2'),
    ('198', '4', 'freestyle @_@', '1'),
    ('9239', '1', 'A. Tindakkan SUK Perak Betul', '0'),
    ('9239', '2', 'B. Tindakkan SUK Perak Tidak Betul', '2'),
    ('9239', '3', 'C. Tidak Pasti', '0'),
    ('9242', '1', 'A. Sah', '2'),
    ('9242', '2', 'B. Tidak Sah', '1'),
    ('9242', '3', 'C. Tidak Tahu', '0'),
    ('9540', '1', '01. Gembira Gelak Ketawa', '0'),
    ('9540', '2', '02. Aku Jiwa Music', '3'),
    ('9540', '3', '03. Burung', '0'),
    ('9540', '4', '04. Cahaya Bintang', '2'),
    ('9540', '5', '05. Hitam Putih', '1'),
    ('9540', '6', '06. I Love You Songsang', '1'),
    ('9540', '7', '07. Tombok', '0'),
    ('9540', '8', '08. Dino Clothings Rawr!', '1'),
    ('9047', '1', 'cik_are', '3'),
    ('9047', '2', 'uchiha_lat', '0'),
    ('9047', '3', 'lipan13', '1'),
    ('9047', '4', 'long_jiwa', '3'),
    ('9047', '5', 'iza', '0'),
    ('9047', '6', 'paanjeng', '2'),
    ('9047', '7', 'mikacarrick', '1'),
    ('9047', '8', 'eijizen', '0'),
    ('9047', '9', 'teh-ais', '1'),
    ('9047', '10', 'ecah88', '12'),
    ('9047', '11', 'hendrastar', '1'),
    ('9047', '12', 'shutmeup', '1'),
    ('9743', '1', 'YA !! SAYA AKAN MENUTUP LAMPU... SEBAGAI MENYOKONG EARTH HOUR 09', '11'),
    ('9743', '2', 'TENGOK KEADAAN DULU........', '1'),
    ('9743', '3', 'BUAT APA PADAM LAMPU.... BUANG MASA JE !!', '2'),
    ('9782', '1', 'LELAKI', '46'),
    ('9782', '2', 'PEREMPUAN', '11'),
    ('9787', '1', 'avast!', '1'),
    ('9787', '2', 'Avira', '3'),
    ('9787', '3', 'AVG Anti-Virus', '3'),
    ('9787', '4', 'BitDefender', '1'),
    ('9787', '5', 'F-Secure Anti-Virus', '0'),
    ('9787', '6', 'Kaspersky Anti-Virus', '13'),
    ('9787', '7', 'McAfee', '1'),
    ('9787', '8', 'NOD32 Antivirus/Smart Security', '13'),
    ('9787', '9', 'Norman ASA', '0'),
    ('9787', '10', 'Symantec Norton AntiVirus/Norton 360/Internet Security', '0'),
    ('9787', '11', 'Panda Security/Panda Titanium Antivirus', '1'),
    ('9787', '12', 'Trend Micro Internet Security', '0'),
    ('9787', '13', 'ZoneAlarm', '0'),
    ('9871', '1', 'yes', '5'),
    ('9871', '2', 'no', '0'),
    ('9871', '3', 'word... what? joomla lagi best', '1'),
    ('10850', '1', 'Lim Kok Wing University', '1'),
    ('10850', '2', 'KLMU (atau Cosmopoint)', '0'),
    ('10850', '3', 'MMU', '8'),
    ('10850', '4', 'Others', '0'),
    ('11082', '1', '20-25', '7'),
    ('11082', '2', '25-30', '14'),
    ('11082', '3', '30-35', '2'),
    ('11082', '4', '35-40', '0'),
    ('11082', '5', '40- ??', '0'),
    ('11086', '1', 'Acer', '3'),
    ('11086', '2', 'Asus', '0'),
    ('11086', '3', 'Compaq [HP]', '4'),
    ('11086', '4', 'Dell', '0'),
    ('11086', '5', 'Lenovo', '1'),
    ('11086', '6', 'MSI', '0'),
    ('11086', '7', 'Samsung', '0'),
    ('11090', '1', 'Manchester United', '12'),
    ('11090', '2', 'Barcelone', '11'),
    ('11286', '1', 'Aku cuba mengejar sedaya upaya peragut tu! ', '9'),
    ('11286', '2', 'Aku tolong telefon polis ', '2'),
    ('11286', '3', 'Aku tolong menjerit bagi menarik perhatian orang lain', '4'),
    ('11286', '4', 'Tak buat apa-apa pun, bukan masalah aku', '0'),
    ('12221', '1', 'thank you bro!', '2'),
    ('12221', '2', 'not interested...', '0'),
    ('12221', '3', 'duplicate post.. lame', '0'),
    ('12571', '1', 'Ya ', '5'),
    ('12571', '2', 'Tidak', '5'),
    ('12571', '3', 'sapa CR7?', '3'),
    ('13576', '1', 'Laptop', '10'),
    ('13576', '2', 'Desktop', '10'),
    ('17163', '1', '1 layan', '4'),
    ('17163', '2', '2 tidak layan', '1'),
    ('22875', '1', 'SETUJU', '31'),
    ('22875', '2', 'X SETUJU', '6');

Caused the error:

    Duplicate entry '4173-1' for key 1

[ThorstenE]

you have to edit the phpbb3_to_smf.sql, find:

Code Select Expand

/******************************************************************************/
--- Converting poll options...
/******************************************************************************/

---* {$to_prefix}poll_choices
SELECT
topic_id AS ID_POLL, poll_option_id AS ID_CHOICE,
SUBSTRING(poll_option_text, 1, 255) AS label, poll_option_total AS votes
FROM {$from_prefix}poll_options;
---*
replace it with:

Code Select Expand

/******************************************************************************/
--- Converting poll options...
/******************************************************************************/

---* {$to_prefix}poll_choices
---{
$ignore = true;
---}
SELECT
topic_id AS ID_POLL, poll_option_id AS ID_CHOICE,
SUBSTRING(poll_option_text, 1, 255) AS label, poll_option_total AS votes
FROM {$from_prefix}poll_options;
---*

then restart the converter.

[mrpeco]

yeah! it's work. you're truly hero!!!!
but my forum got a problem to view image and certain bbcode is not work and also my admin access is not working. i can't login

[ThorstenE]

the login issue is easy, check out the first post from this topic (phpbb3_login_fix.tgz)
I accidentally deleted my admin account, what do I do?

[mrpeco]

run fine now. i can login my admin panel big thanks to you !!