[BETA] SMF 1.1 to phpBB3 Convertor

Converting from other board software? Good decision! Need help? Have a question about a convertor? Wish to offer a convertor package? Post here.
Anti-Spam Guide
oojacoboo
Registered User
Posts: 12
Joined: Wed Nov 07, 2007 11:19 pm

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by oojacoboo »

Jelly,

Any ideas for me? Thanks.
User avatar
A_Jelly_Doughnut
Former Team Member
Posts: 34457
Joined: Sat Jan 18, 2003 1:26 am
Location: Where the Rivers Run
Contact:

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by A_Jelly_Doughnut »

oojacoboo:
A_Jelly_Doughnut wrote:I would be willing to take a look at your database to see if I can spot the failure. I'd need a link where I can download the database, and of course PM would be the best way to receive that :)
I'm sure you understand how it could be hard to fix a problem that cannot be reproduced.

7earitup and bluenix: I have found a bug in the convertor when there is only one administrator. Is this the case on your SMF board?
A Donut's Blog
"Bach's Prelude (Cello Suite No. 1) is driving Indiana country roads in Autumn" - Ann Kish
bluenix
Registered User
Posts: 4
Joined: Thu Nov 08, 2007 1:41 pm

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by bluenix »

A_Jelly_Doughnut wrote: 7earitup and bluenix: I have found a bug in the convertor when there is only one administrator. Is this the case on your SMF board?
Yes, it is!
7earitup
Registered User
Posts: 22
Joined: Thu Nov 08, 2007 6:36 am
Location: Somewhere.
Contact:

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by 7earitup »

Yes, I believe that is my case too. Every other person I had setup as a Global Moderator. Any ideas how to fix it? :D
7earitup/Tearitup/Brent
http://www.go-diaf.com
User avatar
A_Jelly_Doughnut
Former Team Member
Posts: 34457
Joined: Sat Jan 18, 2003 1:26 am
Location: Where the Rivers Run
Contact:

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by A_Jelly_Doughnut »

I have fixed the bug that oojacoboo was experiencing, and also a bug with polls. The oojacoboo's issue is related to the one that 7earitup and bluenix were having. I'll upload a new beta in about two hours :)
A Donut's Blog
"Bach's Prelude (Cello Suite No. 1) is driving Indiana country roads in Autumn" - Ann Kish
7earitup
Registered User
Posts: 22
Joined: Thu Nov 08, 2007 6:36 am
Location: Somewhere.
Contact:

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by 7earitup »

A_Jelly_Doughnut wrote:I have fixed the bug that oojacoboo was experiencing, and also a bug with polls. The oojacoboo's issue is related to the one that 7earitup and bluenix were having. I'll upload a new beta in about two hours :)
Sounds good. Would it have been easier just for me to make another admin account? Lol. Either way, I am glad I can help you out with this. We all appreciate the work your doing. Thanks! ;)
7earitup/Tearitup/Brent
http://www.go-diaf.com
User avatar
A_Jelly_Doughnut
Former Team Member
Posts: 34457
Joined: Sat Jan 18, 2003 1:26 am
Location: Where the Rivers Run
Contact:

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by A_Jelly_Doughnut »

Well, it turns out that the user with ID 1 was simply not being converted. On most SMF boards, this is the (main) administrator. The board I built the convertor with was not this way, so I didn't catch the bug.
A Donut's Blog
"Bach's Prelude (Cello Suite No. 1) is driving Indiana country roads in Autumn" - Ann Kish
7earitup
Registered User
Posts: 22
Joined: Thu Nov 08, 2007 6:36 am
Location: Somewhere.
Contact:

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by 7earitup »

A_Jelly_Doughnut wrote:Well, it turns out that the user with ID 1 was simply not being converted. On most SMF boards, this is the (main) administrator. The board I built the convertor with was not this way, so I didn't catch the bug.
It's all good. ;) Once again, thanks for all your effort. PM me or post here once it is updated - I am on the computer just about 24/7 so I would like to try it out as soon as you have it updated. :mrgreen:
7earitup/Tearitup/Brent
http://www.go-diaf.com
User avatar
A_Jelly_Doughnut
Former Team Member
Posts: 34457
Joined: Sat Jan 18, 2003 1:26 am
Location: Where the Rivers Run
Contact:

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by A_Jelly_Doughnut »

The download link in the first post has been updated to the second beta :)
A Donut's Blog
"Bach's Prelude (Cello Suite No. 1) is driving Indiana country roads in Autumn" - Ann Kish
7earitup
Registered User
Posts: 22
Joined: Thu Nov 08, 2007 6:36 am
Location: Somewhere.
Contact:

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by 7earitup »

A_Jelly_Doughnut wrote:The download link in the first post has been updated to the second beta :)
Worked great but it didn't transfer over my attachments. Besides that, it is fantastic. Thanks a bunch! :D
7earitup/Tearitup/Brent
http://www.go-diaf.com
lockelymarkets
Registered User
Posts: 14
Joined: Sun May 13, 2007 7:56 am

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by lockelymarkets »

Hello, I am converting my SMF board to phpBB3, and im having issues :?
I get the following error: :o

Code: Select all

General Error
SQL ERROR [ mysql4 ]

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 'WHERE field = 'body'' at line 1 [1064]

SQL

SHOW FULL COLUMNS FROM smf_messages WHERE field = 'body'

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: install/convertors/functions_smf11.php
LINE: 76
CALL: dbal_mysql->sql_query()

FILE: install/convertors/functions_smf11.php
LINE: 2227
CALL: smf_set_encoding()

FILE: install/install_convert.php(1004) : eval()'d code
LINE: 2
CALL: smf_conv_file_settings()

FILE: install/install_convert.php
LINE: 1004
CALL: eval()

FILE: install/install_convert.php
LINE: 203
CALL: install_convert->convert_data()

FILE: install/index.php
LINE: 402
CALL: install_convert->main()

FILE: install/index.php
LINE: 274
CALL: module->load()
I have SMF 1.1.4 and am wishing to convert it to phpBB3 RC7. :|

Thanks :)
7earitup
Registered User
Posts: 22
Joined: Thu Nov 08, 2007 6:36 am
Location: Somewhere.
Contact:

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by 7earitup »

lockely, You are using the new Beta 2 of the converter script, correct?
7earitup/Tearitup/Brent
http://www.go-diaf.com
bluenix
Registered User
Posts: 4
Joined: Thu Nov 08, 2007 1:41 pm

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by bluenix »

A_Jelly_Doughnut wrote:The download link in the first post has been updated to the second beta :)
It works perfect now!
Thank you very much for your efforts! I really appreciate it!
User avatar
A_Jelly_Doughnut
Former Team Member
Posts: 34457
Joined: Sat Jan 18, 2003 1:26 am
Location: Where the Rivers Run
Contact:

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by A_Jelly_Doughnut »

lockelymarkets wrote:Hello, I am converting my SMF board to phpBB3, and im having issues :?
I get the following error: :o
[snip]
I have SMF 1.1.4 and am wishing to convert it to phpBB3 RC7. :|

Thanks :)
It appears that you are running an older version of MySQL (than 5.0.x). I'm looking into a fix for you :)
A Donut's Blog
"Bach's Prelude (Cello Suite No. 1) is driving Indiana country roads in Autumn" - Ann Kish
dkarlovi
Registered User
Posts: 23
Joined: Mon Sep 24, 2007 11:28 am

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by dkarlovi »

I'm running the second conversion and it crossed my mind:
- could this code get transfered in a form of a CLI PHP script, it should run much smoother like that and it's easier to renice it or leave it running on the server overnight when the load is lower
- it would be nice if it would print out progress, but with end values, "10854 out of 71312 complete" is much more informative then just "10854 complete"

As I said, great work indeed, I'm really thrilled with phpBB3's options once it got some data in there.
Locked

Return to “[3.0.x] Convertors”