[SMF Converter] phpBB3

[JayBachatero]

Page 2.

[jimmyeatworld]

It worked, but attachments did not come and, and I got no Admin Privilege.

Jimmy

[JayBachatero]

Attachments should be copied over.  Check to see that th attachments dir for SMF is writeable.  About admin.  What group did you have in phpBB?  The converter uses the original groups to check if you are an admin or not.

[jimmyeatworld]

I was an admin, and attachments were copied, but did not seem to attach them selves to the post.

Not sure where to go from here.

Jim

[jimmyeatworld]

Also across the top a lit of stuff is missing...

Forum, Help, Search, profile, my messages, logout, etc

all that is missing, only stuff I see is: HOME, HELP, LOGOUT.

but if I create a new account, I seem to get all that info across the top no problem. So the issues lies in the conversion process somewhere.


this is what i did, let me know if i did it wrong:

1. Create a new DB for SMF and did a clean install
2. Imported my DB from phpbb3 via phpmyadmin and phbbb3 (tried both, got the same problem) backup. Restored it using Bigdump.
So now PHPBB_ and SMF_ are now in the same DB

3. Uploaded convert.php and pbpbb3 to smf.sql
4. went to Convert.php followed step by step

Not sure what to do now. No rush, just trying to figure what I did wrong, or perhaps a bug with the converter.

[JayBachatero]

Check in the database and check what is the value for the ID_GROUP field for your user.  Also keep in mind that permissions are not transferred besides the admin permission.

[jimmyeatworld]

Got It Thank You. You rock!

Jim

[rhys100]

i get the following error: SELECT command denied to user 'ccecyout_smf2'@'localhost' for table 'phpbb_users' which means that SMF and Software X are in separate databases and the SMF database user does not have access to Software X's database.

So i gave all permissions to ccecyout_smf2 to access ccecyout_phpb1 but it still doesnt work.

do  i need to import the php tables into the smf table. how can i do that on phpmyadmin..? ive been trying for hours

[JayBachatero]

What access did you give it?

[rhys100]

i gave as much access as i could :S


SELECT
CREATE
INSERT    
ALTER
UPDATE    
DROP
DELETE    
LOCK
TABLES
INDEX    
REFERENCES
CREATE TEMPORARY TABLES    
CREATE ROUTINE

[JayBachatero]

Umm that should work.  Sure you gave it to the right database? Has to be smf user with access to the phpbb database.  Not the other way around.

[rhys100]

yea still wont work. can u im me. my msn is [email protected] - i have alrdy added u

cheers

[JayBachatero]

IM me.  It didn't go through.

[GuardianX00]

Hey, the conversion worked great besides for one thing.

The subs-forum do not show up in the section where you can manage the Boards.

They do however, show up where they should on the forum and in most of the other admin features.

There is one thing I noticed:
Abysmal Empire > Other > Gaming
Abysmal Empire >  > Gaming > Tournaments
and there is a blank category on the index (not in the admin)


Thanks



EDIT:  I fond a way to fix it.

[jimbo101]

Were am i going wrong
i think i have done everything in the guide but when i run convert.php i get the following


public_html/smf/convert.php(398) : eval()'d code on line 1
Table 'thisstra_php3.member' doesn't exist

Thanks for your help Jim

[leifo]

Hi,

I am trying to convert my phpBB3 board and it is rather big 127 000 posts + PM

The language is Swedish and the conversion of posts goes well (with UTF-8) for approx half of the posts then it messes up the Swedish letters.

Usually I use Latin-7 when I have imported the database (changed web host for ex.) because UTF-8 is doing like this also when importing a "clean" phpBB database into MySql.

How can I manage this because I can not find Latin-7 as an option

[Sarge]

Usually I use Latin-7 when I have imported the database (changed web host for ex.) because UTF-8 is doing like this also when importing a "clean" phpBB database into MySql.

AFAIK, the converter only supports UTF-8, so the phpBB3 database and the installed SMF forum need to be both in UTF-8.

One way to convert the phpBB3 database to UTF-8 would be to:
1) export a backup the phpBB3 database as latin7,
2) switch all character set and collation information for the database, tables, and possibly fields, to utf8 and utf8_general_ci respectively in the backup,
3) drop the existing database and recreate it using utf8 as the default character set,
4) import the backup into the recreated database.

It's best to work on a copy of the phpBB3 database, just in case something goes wrong. phpMyAdmin offers an option to create a database copy (replica).

Do you have shell access? If you do, you can use the mysqldump, sed and mysql commands to perform the 4 operations outlined above. Otherwise, you can use backup and restore scripts to convert the database. Sed should be available in most Linux systems; if you use Windows, you can get sed from the homepage of Sed for Windows.

[leifo]

Sorry, maybe I was not clear.....

My databade is UTF-8 But I have never succeded to import it using utf-8 I always need to use latin7 if it is the post or privmsg file that is big. Dont ask me why!!!! lut the swedish letters get corrupt if I dont do it this way. ( I have had 4 or 5 webhosts and they works the same) The swedish lerrers are åäö ÅÄÖ.

[Sarge]

I always need to use latin7 if it is the post or privmsg file that is big.

You mean it's only big messages that get corrupted?

If you want, you can PM me the download link for a database backup and I will have a look.

[Yoohoo]

where is the attachment for the converter of phpbb3 to smf?