[SMF Converter] phpBB - 2.0.19+

Started by JayBachatero, January 13, 2007, 02:47:08 AM

Previous topic - Next topic

Gonad The Barbarian

Check that last entry.......

('982', '0', '7556', '7604', '27', '323', '4', '&#0

Looks corrupt to me.  I'm guessing that you tried it a second time with the same result?

Chuckl

I really know squat about sql.

QuoteProblems with indexes of table `phpbb_sessions`
PRIMARY and INDEX keys should not both be set for column `session_id`
Problems with indexes of table `smf_messages`
UNIQUE and INDEX keys should not both be set for column `ID_TOPIC`
UNIQUE and INDEX keys should not both be set for column `ID_MEMBER`
More than one INDEX key was created for column `ID_MEMBER`

Gonad The Barbarian

Assuming you have phpMyAdmin installed........Did you try to "repair" and then "optimize" your phpBB2 tables before attempting to convert them?

Chuckl

PRIMARY and INDEX keys should not both be set for column `session_id`

I tried several times to repair this, and it never seems to work.

Gonad The Barbarian

You may want to post this in it's own thread, to make sure that Jay sees it.  I'm sure that he'll be able to help out.

rivang

#165
I keep getting the error...

This converter was unable to find SMF in the path you specified.

Please double check the path, and that it is already installed there.

I have SMF in this path... /domains/mydomain/public_html/forum2
I have a copy of my PHPBB in this path... /domains/mydomain/public_html/forum3

The two files for the converter have been uploaded to forum2, but when I run convert.php and fill in those two paths and database password, I get...

This converter was unable to find SMF in the path you specified.

Please double check the path, and that it is already installed there.

Any suggestions?

margarett

Well, is SMF already installed (with administrator user and sample board)?
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Gonad The Barbarian

Well.......if all goes well with the work I've got to get done today, I'm going to pull down the phpBB2 board sometime tonight, install SMF and take a shot at converting everything over.   :o Wish me luck!  :)

Bernie

Quote from: Gonad The Barbarian on March 17, 2007, 10:44:41 AM
Well.......if all goes well with the work I've got to get done today, I'm going to pull down the phpBB2 board sometime tonight, install SMF and take a shot at converting everything over.   :o Wish me luck!  :)


May you have all the luck of the Irish, even if you are a barbarian.  ;)
(\__/)
(='.'=)This is Bunny. Copy and paste bunny into your
(")_(")signature to help him gain world domination.
If you do this, you can become his
Evil Minion, and not just another victim.

Gonad The Barbarian

Quote from: Bernie on March 17, 2007, 02:00:11 PM
May you have all the luck of the Irish, even if you are a barbarian.  ;)

Thanks........I ran the conversion and everything seems to have gone pretty good, except for a couple of minor glitches that I was able to figure out pretty quick.  I'm still learning SMF, especially how it handles permissions, etc.  But thus far, I like what I see.

etdwh

#170
1 issue which is turning out to be pretty big now is the links in the forum.

Old forum installed at: www.xxx.com/forum
New forum installed at: www.xxx.com/v2/forum

There are alot of links in the old forum asking users to refer to www.xxx.com/forum/viewtopic.php?t=9070
Currently, this fails. Anyone have any ideas how to fix this? I am thinking of replacing the old file viewtopic.php with a simple php file which can redirect the link back to the new forum... :-\

EDIT: erm..just realized this is not something related to the converter...sorry for posting here..
If fact, the solution is also available: http://www.simplemachines.org/community/index.php?topic=118868.0

Thumann

This is the single most awsome script ever written in the history of written scripts that were awsome.  ;D

I salute you!

22.000 posts, 2500 topics and 500 users migrated in minutes.. with _NO_ errors what so ever..  :P

Regards.
Thumann

margarett

etdwh, there is one way, in fact... I also found out by myself...

Every link changes from:
www.something.com/viewtopic.php?t=xxxx
to:
www.something.com/index.php?topic=xxxx.0

So it should be possible to have phpmyadmin to change the "link" and adapt it.
But shure, the redirect solution is much easier ;)

Also, you can search for "viewtopic" and manually change the addresses :P
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Gonad The Barbarian

Quote from: Thumann on March 19, 2007, 09:21:48 AM
This is the single most awsome script ever written in the history of written scripts that were awsome.  ;D

I salute you!

22.000 posts, 2500 topics and 500 users migrated in minutes.. with _NO_ errors what so ever..  :P

Regards.
Thumann

On my conversion, I actually had a lot of errors, but they were all related to a bunch of smilies that I had added to my old forum.  I figured I could live without those and simply didn't sweat it.  All the users and all the posts seem to have migrated over without a hitch.

I did have a couple of problems where I had a handful of special users who essentially only really had a "special title" and their permissions weren't right.  But I fixed that pretty easily by setting them as "no primary user group" and then making sure they were members of various other groups.  I then went into their profile and added their "custom title" and that pretty much took care of it.

rivang

Are my paths correct? Those are the actual paths used for FTP to each of the root folders, forum2 and forum3.

To answer Margaret... I have a fresh install of SMF in the forum2 folder. I have a copy of my PHPBB board in the forum3 folder. Both boards use the same database. Yet I still get...

This converter was unable to find SMF in the path you specified.

Please double check the path, and that it is already installed there.

What am I doing wrong when I try to use the converter from PHPBB to SMF?

Quote from: margarett on March 16, 2007, 01:34:15 PM
Well, is SMF already installed (with administrator user and sample board)?
Quote from: rivang on March 16, 2007, 09:35:45 AM
I keep getting the error...

This converter was unable to find SMF in the path you specified.

Please double check the path, and that it is already installed there.

I have a stock version of SMF in this path... /domains/mydomain/public_html/forum2
I have a copy of my PHPBB board in this path... /domains/mydomain/public_html/forum3

The two files for the converter have been uploaded to forum2, but when I run convert.php and fill in those two paths and database password, I get...

This converter was unable to find SMF in the path you specified.

Please double check the path, and that it is already installed there.

Any suggestions?

margarett

I mean, if you access:
www.yourdomain.com/forum2
You can see the demo board? And you can login with your admin user?
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

etdwh

Quote from: margarett on March 19, 2007, 10:48:27 AM
etdwh, there is one way, in fact... I also found out by myself...

Every link changes from:
www.something.com/viewtopic.php?t=xxxx
to:
www.something.com/index.php?topic=xxxx.0

So it should be possible to have phpmyadmin to change the "link" and adapt it.
But shure, the redirect solution is much easier ;)

Also, you can search for "viewtopic" and manually change the addresses :P

Thats a lot of links to modify manually  :D

Found a script which can do it automatically: http://www.simplemachines.org/community/index.php?topic=118868.0
Testing at home, it works!!
But its times out on our server.  :(
Will attempt to do a start-pause-start like how the current converter does it...

snvhorse

I have a problem I haven't seen mentioned here yet.  I'm trying to convert a phpbb 2.0.19 installation to a new install of SMF.

I have the installation of SMF in [www.myhosting.com]/snvhforum
I have the installation of phpbb in [www.myhosting.com]/snvhorse

The new installation of SMF went fine and works properly, there is only the administrator user there, no posts except what comes with the original installation.

I have downloaded the converter and the associated sql file from this topic.

When I run the converter, I get these messages:

Converting...
Successful.
Recalculating forum statistics... Successful.


Nothing is converted, the SMF installation is still the same.
I have tried various ways of addressing the paths required, with no change in the results.
I have even tried leaving the paths blank, with no change in the results.
I have verified that the PW used for the database is correct.

So,  what am I doing wrongly?

Thanks in advance for your reply, and for all you do to create and support these programs.   :)

JayBachatero

Follow me on Twitter

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

snvhorse

#179
Thanks for the pointer!  :)

I asked the hoster to set the session save path and that worked.

Thanks again for all you do to support this product!

Advertisement: