[BETA] SMF 1.1 RC2 Converter - Including update for vB 3.5

[xodiaq]

Yeah. Then I've got a real problem here. I believe i found the post you were referring to, i even C&P'd the SQL query subbing in my own table name so it searched the right one, came up with almost the same number of entries as the board has in total, so I must not be doing something right.

I have no clue how to find these dupes, how to tell if they're dupes and delete only ONE of the dupes and not both... Where do i find this stuff out? This stuff isn't intuitive without knowing programming at all... am I pretty much out of luck or what?

[www.vwdforum.com]

ok ran into snag...

converting phpbb 2.0.18 to smf 1.1RC2

Path to SMF: /domain/smf

Path to phpBB2: /domain/forums

phpbb_ tables in same DB as smf_

I uploaded and tried convert.php and phpbb_to_smf from HERE, this topic and the
downloads page with all giving the same error:

The installation of SMF in the path you specified is not a version this converter can deal with. If it is older than SMF 1.0, you need to upgrade first. If it is newer, you need to use a different converter.

so if anyone wants to post the correct phpBB to smf converter file for me to use, it would be great.
Thanks in advance. (ps I searched forums and didnt have any luck)

my problem is now resolved thanks to another member providing the correct converter files

Can you tell us where you got these files please??

Cheers

Mal

[Deaks]

the files are at the bottom of the first post

[www.vwdforum.com]

I'm sorry but I cant see any reference to phpbb to ....

I've tried convert.php and that didn't work

Cheers

Mal

[xodiaq]

vwd - convert.php is only half the trick, i think...

http://www.simplemachines.org/community/index.php?action=dlattach;topic=38966.0;attach=11043

that should be the file you're looking for

its in the middle of the list on grudges post here... http://www.simplemachines.org/community/index.php?topic=38966.0

[www.vwdforum.com]

Thanks for your help.

I'm still having issues!

I've installed 1.07 again and transfered my files.  I'm going to try changing servers and then upgrading to 1.1

wish me luck!

Mal

[JayBachatero]

This converter is just for 1.1 RC2.  For 1.0.7 go to the Downloads page, under the Converters section.

xodiaq what table is it that it's saying that it has duplicate entries?

[xodiaq]

ibf_posts, I think.

Actually Jay, one of my board members put a duplication clause in the SQL conversion file and that seems to have done it, so it only uses the initial instance and ignores any dupicates. I couldnt tell you HOW she did it but it brought the entire board over in about 3 minutes flat, then the settings.php corrupted and wouldnt let us take the board out of maintenance mode.

*sigh*

Not quite sure, but i think somebody hates me somewhere...

[Shax]

I am converting from mybb to smf and I am getting the following error 

Code Select Expand

Recalculating forum statistics... Unsuccessful!
This query:
UPDATE `shax_smf2`.smf_boards
SET ID_LAST_MSG = 94, lastUpdated = 1149657564
WHERE ID_BOARD = 1
LIMIT 1;
Caused the error:

Unknown column 'lastUpdated' in 'field list'


Any help would be greatly appreciated 

[JayBachatero]

Make sure that the convert.php you are using is the one located here.  It seems like you are using the wrong convert.php.

[Shax]

Make sure that the convert.php you are using is the one located here.  It seems like you are using the wrong convert.php.

that was it  lol Thanks again Jay! 

[runespy]

i tried to convert it but it said there was an unknown colum "buddy_list"... what is wrong with this???
im running VB 3.5.2

[JayBachatero]

Can you please make sure that you are using the convert.php and the .sql file from this topic not the 1.1 Converters one.

[HWB]

I keep getting this error

Code Select Expand

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of vBulletin 3.5. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.


What am I doing wrong?

[JayBachatero]

Put the SMF user in the vB database.  If you have cPanel just add the user to the database.

[sandytoo]

I am trying to be the nice guy for my ex husband and convert his phpbb2 to smf. But I am getting exasperated.

I put BOTH required files in his folder (phpbb2_to_smf.php and convert.php) and I ran the converter. Its tells me I cant use that version of the converter. He has phpbb version 2.0.20 and smf version 1.1 RC 2

AM I running the wrong converter? Is there another one I should be aware of. I only saw one in the downloads list. If you can help, you can save my ex husband from being drawn and quartered...he,he..

Sandy

[sandytoo]

Ok....well, I played around a little and figured out I was supposed to run the CONVERT file and not the PHPBB2_TO_SFM file..

So...everything converted successfully EXCEPT...

Recalculating forum statistics... Unsuccessful!
This query:
UPDATE `mgarrity_test`.smf_boards
SET ID_LAST_MSG = 69, lastUpdated = 1150323211
WHERE ID_BOARD = 2
LIMIT 1;
Caused the error:Unknown column 'lastUpdated' in 'field list'[/i]

Not sure what that means yet....can anyone give me a clue?

I will only draw my ex...not quarter him now

Sandy

[sandytoo]

Well, now I know what the statistics are....

I can no longer log into the board...it says my password doesnt exist...acutally it says "I" dont exist...but my name is on the homepage as a registered member. IF I cant get in, I cant access the admin page. I have been checking out other posts but havent found a solution.

help...

[sandytoo]

Well, I was able to figure out a way around my problem

I found out the admin username and password transferred to the new forum...so I used those and got in Makes sense, I guess.

Thanks anyway....I suppose it helped to just put this down here..helped to get my thoughts straight

[JayBachatero]

That error is related to you using an outdated convert.php file.  Glad to hear you solved it though .