Advertisement:

Author Topic: [SMF Converter] punBB 1.3  (Read 66293 times)

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
[SMF Converter] punBB 1.3
« on: February 01, 2007, 09:04:03 AM »
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.   
« Last Edit: July 18, 2009, 02:55:28 PM by TE »
Follow me on Twitter

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

Offline caimlas

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] punBB 1.2.5
« Reply #1 on: February 18, 2007, 10:12:12 AM »
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.

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] punBB 1.2.5
« Reply #2 on: February 21, 2007, 10:40:39 AM »
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

Offline amit

  • Semi-Newbie
  • *
  • Posts: 16
Re: [SMF Converter] punBB 1.2.5
« Reply #3 on: July 25, 2007, 08:36:48 AM »
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. :)

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] punBB 1.2.5
« Reply #4 on: August 07, 2007, 12:40:44 AM »
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

Offline amit

  • Semi-Newbie
  • *
  • Posts: 16
Re: [SMF Converter] punBB 1.2.5
« Reply #5 on: August 07, 2007, 02:17:18 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! :)

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] punBB 1.2.5
« Reply #6 on: August 07, 2007, 02:59:17 AM »
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

Offline amit

  • Semi-Newbie
  • *
  • Posts: 16
Re: [SMF Converter] punBB 1.2.5
« Reply #7 on: August 07, 2007, 03:28:50 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! :)

Offline Tuplad

  • Semi-Newbie
  • *
  • Posts: 52
Re: [SMF Converter] punBB 1.2.5
« Reply #8 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?

Offline amit

  • Semi-Newbie
  • *
  • Posts: 16
Re: [SMF Converter] punBB 1.2.5
« Reply #9 on: March 22, 2008, 03:32:33 AM »
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!!

Offline Tuplad

  • Semi-Newbie
  • *
  • Posts: 52
Re: [SMF Converter] punBB 1.2.5
« Reply #10 on: March 22, 2008, 07:42:55 AM »
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).

Offline Tuplad

  • Semi-Newbie
  • *
  • Posts: 52
Re: [SMF Converter] punBB 1.2.5
« Reply #11 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 ?

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] punBB 1.2.5
« Reply #12 on: March 24, 2008, 01:18:32 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

Offline Tuplad

  • Semi-Newbie
  • *
  • Posts: 52
Re: [SMF Converter] punBB 1.2.5
« Reply #13 on: March 24, 2008, 05:17:02 PM »
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 ?

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] punBB 1.2.5
« Reply #14 on: March 25, 2008, 12:38:39 AM »
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

Offline Tuplad

  • Semi-Newbie
  • *
  • Posts: 52
Re: [SMF Converter] punBB 1.2.5
« Reply #15 on: March 25, 2008, 05:40:28 AM »
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:
Code: [Select]
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 ;)

Offline Tuplad

  • Semi-Newbie
  • *
  • Posts: 52
Re: [SMF Converter] punBB 1.2.5
« Reply #16 on: March 25, 2008, 05:44:43 AM »
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?
« Last Edit: March 25, 2008, 05:48:43 AM by Tuplad »

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] punBB 1.2.5
« Reply #17 on: March 25, 2008, 09:54:15 AM »
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

Offline Tuplad

  • Semi-Newbie
  • *
  • Posts: 52
Re: [SMF Converter] punBB 1.2.5
« Reply #18 on: March 25, 2008, 12:32:09 PM »
It works flawless now :) Thanks for everything!

Offline spikeweb

  • Semi-Newbie
  • *
  • Posts: 41
Re: [SMF Converter] punBB 1.2.5
« Reply #19 on: April 04, 2008, 07:26:10 AM »
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