• Welcome to Simple Machines Community Forum. Please login or sign up.
September 17, 2021, 10:27:12 PM

News:

SMF 2.0.18 has been released! Please update. Read more.


[SMF Converter] phpBB - 2.0.19+

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

Previous topic - Next topic

SKeeper

September 13, 2007, 01:49:10 PM #280 Last Edit: September 13, 2007, 02:45:16 PM by SKeeper
A quick question.  I am converting from phpBB 2.0.22.

Everything runs fine, except for one little problem.

Let's say a user:  Gern Blanston is quoted in a post.  When it's converted over it brings the quotes:  [quote="Gern Blanston"] Quoted Text here ... [/quote]

This is displayed in the converted forum as: 
Quote from: Gern
Blanston Quoted Text here ...

When you click "Modify" and "Save" makes the quote appear correctly.

Looking at the base field in SQL it goes from:  [quote="Gern Blanston"] to [quote="Gern Blanston"]

When a user is quoted in the private messages area, this converts correctly during conversion.  I don't know enough about MySQL to understand why it's not doing it for the posts.

Thanks,
Keeper

EDIT:  Ok, revisited the personal messages.  They are off and on at best.  I think the ones that work are where the user actually typed out the quote string rather than used the quote button.

Anyway, I see a replace '"', '"' in the .sql file.  I changed that to '"','"' and it seemed to do the trick.  I'm going to add that to the PM side as well and test it out.

JayBachatero

Is the forum live or you just converted?
Follow me on Twitter

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

SKeeper

September 13, 2007, 05:33:46 PM #282 Last Edit: September 13, 2007, 05:42:55 PM by SKeeper
I just converted.  I'm playing around with writing some Packages, and each time I reconvert.

Making that change fixed both the posts and the private messages.

If you want to see it, I can redo it from scratch...just let me know.

JayBachatero

Follow me on Twitter

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

SKeeper

Same thing.  I had already tried something similar to that.

I PMed you the address to an example.

JayBachatero

What does it look like after it's converted?
Follow me on Twitter

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

SKeeper

September 13, 2007, 10:30:11 PM #286 Last Edit: September 14, 2007, 11:21:14 AM by SKeeper
Ok, here's the problem

We have [ and ] in our names.  If the name doesn't have the [ ] then it looks fine.


If it does then it has the problem I talked about before.


A combination of things?

I changed your line to $row['body'] =  preg_replace('~\[quote="(.+?)"\]~is', '[quote author="$1"]', $row['body']);

And the " in the Quote from: line go away.  Looks just like I want it.  Do you agree with this look?

It's how SMF does it if I edit that post.

JayBachatero

Looks good.  Are all of them converted correctly?
Follow me on Twitter

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

SKeeper

Yes, they all look fine.  Now I've got to tackle the posted links to other threads :(

I added that same "routine" to the private messages.  They too look good now.

ecoomber

September 14, 2007, 11:42:22 PM #289 Last Edit: September 14, 2007, 11:55:59 PM by ecoomber
How do I find out what the mysql password is?  It says to use the one from settings.php, but I used fantastico to install it.

JayBachatero

FTP to your site into the SMF dir.  There you will see a file called Settings.php.  That file has the password.
Follow me on Twitter

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

Fox-Alpha

Hi all,
i have tried to convert my phpBB 2.0.22 to SMF but i have an error.
I have used the last updates convert.php and  phpbb2_to_smf.sql from here.

The error is :

QuoteConverting...
Converting ranks... Successful.
Converting groups... Successful.
Converting members... Unsuccessful!
This query:

    INSERT INTO `smf`.smf_members
    (ID_MEMBER, memberName, realName, passwd, lastLogin, dateRegistered, location, posts, ID_GROUP, instantMessages, emailAddress, unreadMessages, MSN, AIM, ICQ, YIM, websiteTitle, websiteUrl, showOnline, timeOffset, hideEmail, avatar, signature, pm_email_notify, is_activated, lngfile, buddy_list, pm_ignore_list, messageLabels, personalText, timeFormat, usertitle, memberIP, secretQuestion, secretAnswer, validation_code, additionalGroups, smileySet, passwordSalt, memberIP2)
    VALUES (

...
...

Caused the error:

    Incorrect integer value: '' for column 'ID_GROUP' at row 1


All the values for ID_Group are empty, what can i do ?
I hope anyone can help me.

Greets
Fox-Alpha

aronshade

I'm sorry to add on to your problems, i tried to convert to smf from phpBB2 and it gave me an error, keep in mind the directories are correct for both sources, the problem i suspect is that it's connecting to the wrong place to find the sql database, the error given was:

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

The error MySQL gave was: SELECT command denied to user 'random'@'65.36.215.12' for table 'phpbb_users'
****

however my sql database ip info is 'random'@'67.59.151.175', the converter doesn't give me the option to change the ip, can you assist?

Snakehit

Your user 'random' doesn't have rights to do selects.

Second thing: the IP-address is your $db_server in your Settings.php file. 99% percent of the time you can say $db_server='localhost'

Bust_Ed

Hi,
I'm totaly newbie. ;-) I have forum on phpbb2. And i want to use SMF, but on another hosting. What are general directions to move all the base from phpbb2 on one hosting to SMF on another?

margarett

1 - move phpBB
2 - convert

OR:
1 - backup your phpBB database
2 - upload it to a new database on your new server (use bigdump.php --> search here, lots of explanations)
3 - create a user for that database
4 - create a folder "forum" (or whatever you what to call your forum folder) and put there the file "configure.php" from phpBB configured with DB, DB_USER, DB_PASS.
5 - Upload and install SMF.
6 - Upload and run the converter
7 - delete "configure.php"

That's it ;)
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

Bust_Ed

O, really that's simple?
Ok, i'll try and post with results.

ecbrad

I got this exact same error =( If anyone could shed some light on it I'd be really thankful.

cheers,
Brad

Quote from: Fox-Alpha on September 15, 2007, 11:47:37 AM
Hi all,
i have tried to convert my phpBB 2.0.22 to SMF but i have an error.
I have used the last updates convert.php and  phpbb2_to_smf.sql from here.

The error is :

QuoteConverting...
Converting ranks... Successful.
Converting groups... Successful.
Converting members... Unsuccessful!
This query:

    INSERT INTO `smf`.smf_members
    (ID_MEMBER, memberName, realName, passwd, lastLogin, dateRegistered, location, posts, ID_GROUP, instantMessages, emailAddress, unreadMessages, MSN, AIM, ICQ, YIM, websiteTitle, websiteUrl, showOnline, timeOffset, hideEmail, avatar, signature, pm_email_notify, is_activated, lngfile, buddy_list, pm_ignore_list, messageLabels, personalText, timeFormat, usertitle, memberIP, secretQuestion, secretAnswer, validation_code, additionalGroups, smileySet, passwordSalt, memberIP2)
    VALUES (

...
...

Caused the error:

    Incorrect integer value: '' for column 'ID_GROUP' at row 1


All the values for ID_Group are empty, what can i do ?
I hope anyone can help me.

Greets
Fox-Alpha

ecbrad

Ugh, I'm dying here. I tried the fixed listed: http://www.simplemachines.org/community/index.php?topic=142124.240

But that line of code doesn't even exist in the converter.php anymore.

Brad

ecbrad

Hmm after searching the forums this seems a common problem that a few people have had. Funny that in each case the request for help has gone unanswered.

Thanks for looking at least. I'll try and find forum software that can convert it elsewhere

Cheers,
Brad

Advertisement: