[SMF Converter] phpBB - 2.0.19+

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

Previous topic - Next topic

jackulator

#260
EDIT - sorry - posted this reply in the wrong topic...

here's a recap/update of my situation from the beginning:

1. I had a phpbb 2 forum and wanted more features, so I uploaded smf 1-1-3 to a new folder on my site and it installed fine

2. I then wanted to bring over all of my posts/members etc from the phpbb forum, so I ran the converter tool

3. the converter tool was telling me that the user name for the new smf database did not have access to the database for the phpbb forum

4. I deleted the smf install and redid it in a new folder, but this time having smf 1-1-3 install it's data into the same database as the phpbb forum, which is what was recommended on this site

5. the conversion successfully got as far as converting topics, at which point it failed saying there was a duplicate topicID

6. I used phpMyAdmin and could not find any duplicate topicID, and after doing some manipulation of the data that the converter was telling me was causing the error, I came to the conclusion that I had better start again

7. I noticed that the converter tool I had used was 'smf_1-1-2_phpbb2_converter.zip', but the install of smf I had was 'smf_1-1-3_install.zip', so I decided to do another fresh smf install of smf 1-1-2 and perhaps the converter tool might work

8. I went to my host's database manager and created a blank database

9. I uploaded 1-1-2 to a new folder on my site, and told the smf install to create data in the new database from step 8, and the install went perfectly as usual

10. I ran the converter tool again, and once again was told that the user name for the smf database did not have access to the phpbb forum, so I went to my host's control panel and found that they have it set up so that one cannot simply add a preexisting user to multiple databases, but rather one could click 'create user' and it would generate a random username/password for a new user - so bottom line, there was no way I was going to be able to have the user for the new smf database be able to access the database for the old phpbb forum

11. so I talked with my host company, and at the moment they are, and I believe the terminology is correct (I know nothing of any of this stuff), going to INSERT the entire phpbb database into my new swf database

Once this is done I'm hoping that:

1. when I launch the converter tool I can enter the same database for smf and phpbb and the converter tool won't object

2. when the converter tool runs I won't end up with the same problem as before - the phantom duplicate topicIDs or whatever the problem was that I replied to in someone's earlier reply in this topic

3. be able to upgrade to smf 1-1-3 after the conversion is successfully completed
over ELEVEN hours of prank calls done with megaboards like The Jackulator 9000 - with over 12,000 audio files from Jack Nicholson - check 'em out at www.jackulator.com [nofollow]

JayBachatero

Use the converter file from this topic.  The one on the download page are out of date.
Follow me on Twitter

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

Jtb

Quote from: JayBachatero on August 22, 2007, 12:52:23 PM
Use the converter file from this topic.  The one on the download page are out of date.

I hope there's a good reason why you're doing this..  :o

If the converter on the download page is out of date why don't you remove it or at least link to this topic?
There's no word about this inside the docs.

I'm really angry about this behaviour and I don't know if I want to switch to SMF anymore   :-\
I followed the docs and all I get are some unfriendly words that I haven't read (or at first found) this topic.

Please rethink your concept. 


btw: your angry-smiley isn't working  >:(

JayBachatero

If you notice I was away for a VERY long time and wasn't around as much to update the converters.  I'll be updating all the ones that need updating in the coming week :).
Follow me on Twitter

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

newbie1231

@moderators: I'm dyslexic. My search results concerning my scenario are all a jumble to me as most search results are, and I dont wish to offend by repeating a question thats probably already been answered .

Permission to contact someone via PM...? Or can one of you contact me?

Thanks...

newbie1231

no one has answered, so i will just ask here.

I installed my smf via fantastico which set up different pre-fixes, usernames and passwords than my fantastico/phpbb installation.

What can I do in my case interms of the converter? Because I get the permission error where smf cant read the phpbb2 installation as well...

Thanks...

margarett

You just need to go to your CPanel/databases, and add the user from SMF database to phpBB database
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

newbie1231

Quote from: margarett on August 30, 2007, 07:17:03 PM
You just need to go to your CPanel/databases, and add the user from SMF database to phpBB database
Ive seen this statement before, but I need you to explain in more detail as I am a novice. Im looking atthe cpanel and see no "databases" link that brings up a database overview or the equivalent.  Please advise...

newbie1231

I figured out THAT issue...now a i have the pm missing field issue.

What version of smf do i need w/ the phpbb converter?

margarett

With the converter from this topic, PHPBB 2.0.19 or greater and latest SMF version is fine.

What is the missing field issue?
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

Jyggafey

#270
Hi, we are currently preparing a move from phpbb 2.0.22 to smf 1.1.3.
Everything worked fine but there are topics and posts missing in smf. We could not determine any similarity for the missing posts so far, the only guess we currently have is that there are too many.
There are slightly above 21000 topics in phpBB and smf displays 18077 topics with 97654 posts, since that number in smf is just refined from the converted total sums stored on the board table and not recalculated (i guess), it cant be trusted but it shows a difference also.
The only hint of the missing topics is visible in the board display, there should be 15 topics per page but there are something between 0 and 13 topics per page (page count below is true for the total amount of posts there are just "empty" topic slots all over the place, tried playing with that value also).
We did not look into the converter so far, as we hope that somebody could have an idea what could have happened.
As last ressort we would like to know if somebody has ever attempted to write a script that recalculates the topics and posts from the existing data in the database instead of trusting the coloums in the board and topic tables.

JayBachatero

Try doing a stats recount and find and repair errors in Admin > Forum Maintenance.
Follow me on Twitter

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

Jyggafey

#272
find and fix errors action spams tons of:
Topic #7271 contains no (actual) messages.
and all related errors like missing subject, wrong last/first post etc
so ... maybe the phpbb_posts_text table has not been converted totally?
We had some php warnings and notices on the conversion complete page about missing indexes, could that have induced a too early "complete" message?

JayBachatero

Were you using the converter in the first post?
Follow me on Twitter

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

Jyggafey

#274
we used the phpbb2_to_smf.sql and convert.php from your post attachments yes
im tempted to just do it again :)

JayBachatero

Try converting again to see if it works.  Also copy down any errors that you get.
Follow me on Twitter

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

Jyggafey

Ok now i got an error:
Recalculating forum statistics... Unsuccessful!
This query:

    ALTER TABLE `smf`.smf_smileys
    ORDER BY LENGTH(code) DESC;

Caused the error:

    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 'LENGTH(code) DESC' at line 2

JayBachatero

Open convert.php and change ORDER BY LENGTH(code) DESC; to ORDER BY code DESC;
Follow me on Twitter

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

Jyggafey

would just remove the query ... smiley ordering is not that important ;P
with that change the conversion is complete but with the notices and warnings below (shouldnt be critical eh?).
Looks like that fixed our main problem, if some other things did go wrong ill report that :)

Recalculating forum statistics...
Notice: Undefined variable: result in /var/www/apache2-default/forum/convert.php on line 1845

Notice: Undefined variable: result in /var/www/apache2-default/forum/convert.php on line 1846

Notice: Undefined variable: result in /var/www/apache2-default/forum/convert.php on line 1845

Notice: Undefined variable: result in /var/www/apache2-default/forum/convert.php on line 1846

Notice: Undefined variable: result in /var/www/apache2-default/forum/convert.php on line 1845

Notice: Undefined variable: result in /var/www/apache2-default/forum/convert.php on line 1846

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /var/www/apache2-default/forum/convert.php on line 1381

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/apache2-default/forum/convert.php on line 1382
Successful.

JayBachatero

Uou can do a recount from the admin panel.
Follow me on Twitter

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

Advertisement: