News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

[SMF Converter] punBB 1.3

Started by JayBachatero, February 01, 2007, 09:04:03 AM

Previous topic - Next topic

JayBachatero

Software: punBB
Version: 1.3

This is the official support topic for punBB converter.  Use this topic to ask for support for this converter.

Changelog
! When converting posts make sure to select the correct posterName and not 'Guest'. (punbb_to_smf.sql)
!Updated for punBB 1.3 Support.

Password Support for punBB 1.3 and above
punBB 3 has their own custom password hash so you need to edit LogInOut.php to add support for password conversion. Alternatively, you can used the punbb_login_fix.zip modification (attached below) via Package Manager.

convert.php
Use this convert.php with the .sql file attached in this topic.   
Follow me on Twitter

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

caimlas

Thank you for your intrepid efforts!

I have PunBB installed on the same server, but using a database on a different server (godaddy) and I'm trying to convert. Additionally, I'm on 1.2.12.

From what I understand, there haven't been too many chances from 1.2.5 to .12 so unless the conversion script has some odd behavior, it should work. Right? Also, it bases it off the database (as far as I know) so would it not be just as easy to have a file dialog to provide a database dump which to process from (local to the server or file dialog)? I'm sorry, I know I ask for a lot.

JayBachatero

The converter should work on .12.  The converter works dirrectly from the database so you can't convert from a database dump.
Follow me on Twitter

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

amit

umm, would it be too hard to add the facility in converter to migrate PMs and polls? actually I've mods for those two installed & would like to migrate them as well if its not too much of a hassle. :)

JayBachatero

ATM there is no way to convert these.  Maybe in the future.
Follow me on Twitter

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

amit

Quote from: JayBachatero on August 07, 2007, 12:40:44 AM
ATM there is no way to convert these.  Maybe in the future.

ah! will it be near future or far away future? I'll think about writing one myself! :)

JayBachatero

Can't really guarantee anything since I'm busy with RL ATM.
Follow me on Twitter

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

amit

Quote from: JayBachatero on August 07, 2007, 02:59:17 AM
Can't really guarantee anything since I'm busy with RL ATM.

ok, no problem, I'll see if I get around to writing one! :)

Tuplad

So like, how does this actually work ? I'm running a punBB forum with a couple of addons (also private message addon and a poll topic addon). How does the convertation goes?

amit

Quote from: Tuplad on March 21, 2008, 02:58:29 PM
So like, how does this actually work ? I'm running a punBB forum with a couple of addons (also private message addon and a poll topic addon). How does the convertation goes?
It will not import polls & private messages from PunBB!! Unfortunately I haven't gotten around to write a modification for that as well!!

Tuplad

It's no biggy, screw the PMs and polls, there's just one poll anyway. But how do I use it ? I really can't figure it out. I've got a SMF installation ready on an other server(I want to move there).

Tuplad

Oh I pretty much figured it out, damn, can't it just convert my database in a new file so I can import it ?

JayBachatero

Quote from: Tuplad on March 22, 2008, 08:29:54 AM
Oh I pretty much figured it out, damn, can't it just convert my database in a new file so I can import it ?
What do you mean?  You mean convert w/o having punBB installed?  If so then you would need to replicate the config file for punBB and point the converter to the directory where you placed the config file.
Follow me on Twitter

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

Tuplad

Quote from: JayBachatero on March 24, 2008, 01:18:32 AM
Quote from: Tuplad on March 22, 2008, 08:29:54 AM
Oh I pretty much figured it out, damn, can't it just convert my database in a new file so I can import it ?
What do you mean?  You mean convert w/o having punBB installed?  If so then you would need to replicate the config file for punBB and point the converter to the directory where you placed the config file.
Aha, that's nice. But I recall getting an error when I tried to import the mysql database backup from my old server to my new one and I got some kind of error. Shall I post it here or is it of no use ?

JayBachatero

Post the error here and I'll see what's up.
Follow me on Twitter

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

Tuplad

So, I ran convert.php on my server, and it converted perfectly :) Example: http://tuplad.vass373.com/SMF/

So, now I'm going to export all smf_ tables in my database and import it to: http://inventivecircle.com/tuplad/

I get this:
Error

SQL query:

--
-- Dumping data for table `smf_attachments`
--
INSERT INTO `smf_attachments` ( `ID_ATTACH` , `ID_THUMB` , `ID_MSG` , `ID_MEMBER` , `attachmentType` , `filename` , `size` , `downloads` , `width` , `height` )
VALUES ( 1, 0, 0, 3, 0, '3.jpg', 3536, 0, 0, 0 ) , ( 2, 0, 0, 4, 0, '4.jpg', 8923, 0, 0, 0 ) , ( 3, 0, 0, 5, 0, '5.jpg', 3859, 0, 0, 0 ) , ( 4, 0, 0, 7, 0, '7.gif', 5694, 0, 0, 0 ) , ( 5, 0, 0, 8, 0, '8.jpg', 4059, 0, 0, 0 ) , ( 6, 0, 0, 9, 0, '9.jpg', 3608, 0, 0, 0 ) , ( 7, 0, 0, 10, 0, '10.jpg', 5814, 0, 0, 0 ) , ( 8, 0, 0, 11, 0, '11.jpg', 6699, 0, 0, 0 ) , ( 9, 0, 0, 20, 0, '20.jpg', 6074, 0, 0, 0 ) , ( 10, 0, 0, 12, 0, '12.jpg', 7924, 0, 0, 0 ) , ( 11, 0, 0, 14, 0, '14.png', 36201, 0, 0, 0 ) , ( 12, 0, 0, 17, 0, '17.jpg', 4730, 0, 0, 0 ) , ( 13, 0, 0, 16, 0, '16.jpg', 4431, 0, 0, 0 ) , ( 14, 0, 0, 22, 0, '22.jpg', 3585, 0, 0, 0 ) , ( 15, 0, 0, 23, 0, '23.jpg', 11742, 0, 0, 0 ) , ( 16, 0, 0, 25, 0, '25.jpg', 6021, 0, 0, 0 ) , ( 17, 0, 0, 26, 0, '26.jpg', 3552, 0, 0, 0 ) , ( 18, 0, 0, 50, 0, '50.jpg', 5493, 0, 0, 0 ) , ( 19, 0, 0, 28, 0, '28.jpg', 4413, 0, 0, 0 ) , ( 20, 0, 0, 31, 0, '31.jpg', 9152, 0, 0, 0 ) , ( 21, 0, 0, 35, 0, '35.jpg', 8746, 0, 0, 0 ) , ( 22, 0, 0, 45, 0, '45.jpg', 5131, 0, 0, 0 ) , ( 23, 0, 0, 46, 0, '46.jpg', 7202, 0, 0, 0 ) , ( 24, 0, 0, 53, 0, '53.jpg', 3897, 0, 0, 0 ) , ( 25, 0, 0, 57, 0, '57.jpg', 3632, 0, 0, 0 ) ;


Answer MySQL: 
#1062 - Duplicate entry '1' for key 1


Whilst if I import it into an other, empty MySQL database it goes perfect. I'll try cleaning the DB and importing it fresh.



:-\ AND IT WORKS !!! MUAHAHHAA :D I will rule the world!

Thanks for the support fellas ;)

Tuplad

#16
Hmm, but this problem appears now: I can not login. I always get the error: "Failed to login. Check your cookie settings."

I even requested my password and it still didn't work.

EDIT: It works with my other browser though. Weird, I probably have to clear my cookies?

JayBachatero

Change the cookie name.  Admin > Server Settings > Feature Configuration.

If that doesn't work then make a new topic about the issues since it's not really converter related.
Follow me on Twitter

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

Tuplad

It works flawless now :) Thanks for everything!

spikeweb

Thanks for this great converter !!
I just tried to run it against a 1.2.17 Punbb and works fine.
I just need to fix a database error where I get accentuated characters wrong when in SMF.
Example on the screenshot attached.

Both PunBB and SMF DB are UTF-8 encoded, utf8_general_ci

Any idea on how to get it right ?

Thanks

Advertisement: