• Welcome to Simple Machines Community Forum. Please login or sign up.
October 19, 2021, 11:44:55 AM

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

alsunna

True, the download file had the wrong file in it, pls correct for future issues.

The conversion went very smooth but got one error:

Fatal error: Call to undefined function: copy_dir() in /home/content/k/e/h/kehl1/html/sayf2/forum/convert.php(665) : eval()'d code on line 20

And I'm not able to log into the forum. It moved all topics, but did not move any of the member lists.

JayBachatero

Follow me on Twitter

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

alsunna

March 08, 2007, 01:04:58 PM #122 Last Edit: March 08, 2007, 01:07:43 PM by alsunna
Ok I downloaded the attached convert.php file and I did not get that error, but I get this:

Converting board access... Unsuccessful!

INSERT INTO `alsunna_org`.smf_forumboard_permissions
(ID_GROUP, ID_BOARD, permission)
VALUES
(2, 1, 'post_new'),
(2, 1, 'mark_notify'),
(2, 1, 'mark_any_notify'),
(2, 1, 'post_reply_any'),
(2, 1, 'modify_own'),
(2, 1, 'make_sticky'),
(2, 1, 'announce_topic'),
(2, 1, 'remove_own'),
(2, 1, 'delete_own'),
(2, 1, 'poll_vote'),
(2, 1, 'poll_view'),
(2, 1, 'poll_post'),
(2, 1, 'poll_add_own'),
(3, 1, 'post_new'),
(3, 1, 'mark_notify'),
(3, 1, 'mark_any_notify'),
(3, 1, 'post_reply_any'),
(3, 1, 'modify_own'),
(3, 1, 'make_sticky'),
(3, 1, 'announce_topic'),
(3, 1, 'remove_own'),
(3, 1, 'delete_own'),
(3, 1, 'poll_vote'),
(3, 1, 'poll_view'),
(3, 1, 'poll_post'),
(3, 1, 'poll_add_own');
Caused the error:

Duplicate entry '2-1-post_new' for key 1

Caused the error:

Duplicate entry '2-1-post_new' for key 1

The categories are up, I can access but it shows 1 member only:

Forum Stats
  1 Posts in 1 Topics by 1 Members. Latest Member: admin


JayBachatero

Did you start the conversion from scratch?
Follow me on Twitter

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

Fu-Ragz.com

Thanks Jay -I figured it out, now I just have to figure out why none of the avatars came over!!!  I'm working on that one as we speak!!!

alsunna

Yes.

I'm convert this forum www.alsunna.org/f to this www.alsunna.org/forum
Now if I click on memberlist, I'll see the members. But not in the Forum Stats I get the wrong infol


Forum Stats
 1 Posts in 1 Topics by 1 Members. Latest Member: admin


JayBachatero

Quote from: Fu-Ragz.com on March 08, 2007, 01:15:54 PM
Thanks Jay -I figured it out, now I just have to figure out why none of the avatars came over!!!  I'm working on that one as we speak!!!
Are youusing the latest files?  I though I fixed the avatar problem.

Quote from: alsunna on March 08, 2007, 01:16:42 PM
Yes.

I'm convert this forum www.alsunna.org/f to this www.alsunna.org/forum
Now if I click on memberlist, I'll see the members. But not in the Forum Stats I get the wrong infol


Forum Stats
  1 Posts in 1 Topics by 1 Members. Latest Member: admin


Seems like it didn't finish converting.  Send me ftp info and I'll see whats wrong.
Follow me on Twitter

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

Boredflak

I can't get away from this error:

QuoteSorry, 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: 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 '~^`[^`]+`.\d~' at line 1

I'm running

Mac OS X Server 10.4.8
PHP 5.0.4
MySQL 4.1.15

I'm using the latest convert.php and phpbb2_to_smf.sql from this thread.

Any ideas?

Fu-Ragz.com

Hi Jay - everything's working perfectly, but still can't figure out why the avatars didn't come over.  I have tried everything that I can think of (haha, not much, i'm not too good at this) and it's not working.  Any ideas would be GREATLY appreciated :)

Thanks much - Wen

JayBachatero

Quote from: Boredflak on March 08, 2007, 05:35:51 PM
I can't get away from this error:

QuoteSorry, 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: 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 '~^`[^`]+`.\d~' at line 1

I'm running

Mac OS X Server 10.4.8
PHP 5.0.4
MySQL 4.1.15

I'm using the latest convert.php and phpbb2_to_smf.sql from this thread.

Any ideas?
You need to give smf access to the phpBB database.

Quote from: Fu-Ragz.com on March 08, 2007, 08:43:09 PM
Hi Jay - everything's working perfectly, but still can't figure out why the avatars didn't come over.  I have tried everything that I can think of (haha, not much, i'm not too good at this) and it's not working.  Any ideas would be GREATLY appreciated :)

Thanks much - Wen
I'll look into it when I get a chance.
Follow me on Twitter

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

Boredflak

March 09, 2007, 04:41:43 PM #130 Last Edit: March 09, 2007, 05:32:41 PM by Boredflak
Quote from: JayBachatero on March 08, 2007, 10:40:49 PM
Quote from: Boredflak on March 08, 2007, 05:35:51 PM
I can't get away from this error:

QuoteSorry, 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: 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 '~^`[^`]+`.\d~' at line 1

I'm running

Mac OS X Server 10.4.8
PHP 5.0.4
MySQL 4.1.15

I'm using the latest convert.php and phpbb2_to_smf.sql from this thread.

Any ideas?
You need to give smf access to the phpBB database.

Sorry. Forgot to mention that. The smf MySQL user has full privileges for the phpBB database. In fact I even gave it the same privileges as the MySQL root user to no avail.

I should also mention that I'm running phpBB 2.0.22

I've triple checked my "Path to SMF" and "Path to phpBB2" and each of those fields has "This may be the right path." below them.

Thanks for your help Jay!

ladynada

Quote from: etdwh on January 28, 2007, 12:30:21 AM
Quote from: JayBachatero on January 26, 2007, 11:00:47 AM
You need to use the converter here not on that page.  I haven't committed these changes to CVS.

Tried it and it works :-)
Havnt checked how the ban controls were imported yet..

I did add 2 things to the SQL,
-add ordering to the smilies when imported (so it will be in the same order as it was in phpbb.
-convert announcements as sticky topics

Hi folks.

I am wondering if you can share the code and how you added the two fixes that you mentioned?
thanks,
nada
WORK for Truth, Print it, Take Time to READ ALL LINKS NOTED  click here --> The TWO Witnesses are Mom and Dad and SMF Skins

ladynada

Quote from: JayBachatero on February 01, 2007, 09:42:42 AM
Ok I had a typo for the attachments stuff thus the error.

Yea I already asked myself that question :P.  Why the heck does he has so many of them :P.  I just use ~3 :P :) and ;)

Also I changed the smileys stuff around to see if the query would run now.

Hi Jay,
Thanks for your help on the converter.  Just so I understand, when you post a fixed sql file within this thread, should I ignore it, if I already got the one that is posted on Page  One of this thread?

I am a lil confused here, thanks
nada
WORK for Truth, Print it, Take Time to READ ALL LINKS NOTED  click here --> The TWO Witnesses are Mom and Dad and SMF Skins

ladynada

Quote from: Bernie on February 02, 2007, 02:38:27 AM
Quote from: JayBachatero on February 02, 2007, 01:46:46 AM
No it was after I posted that one.  This is another version.

Just tried it...  100% success.  No errors reported.

I'll go look and see how it did in what it imported and post you a report later.


Hi,
Will you let us know in here when your board goes online with SMF, as I would love to see it!
nada
WORK for Truth, Print it, Take Time to READ ALL LINKS NOTED  click here --> The TWO Witnesses are Mom and Dad and SMF Skins

ladynada

Quote from: JayBachatero on February 04, 2007, 01:37:55 AM
You can delete your old forum and database.

After you install smf to the smf dir you can then move it to the root dir and use repair_settings.php to fix the paths.
What is repair_settings.php?

I just dl that, and I think it should be zipped up with all the converters.
nada
WORK for Truth, Print it, Take Time to READ ALL LINKS NOTED  click here --> The TWO Witnesses are Mom and Dad and SMF Skins

ladynada

Quote from: JayBachatero on February 04, 2007, 02:04:57 AM
Just try the file that I posted.

this is a little unrelated, but, when I reply with quote here, and hit POST, the screen that I am returned to, is BLANK.  I have to copy the url of this thread into my browser address window in order to come right back. 

if it helps, I just registered today as a new user.  maybe my cookies are messed up... awww this probaby needs to go to the webmaster!
nada
WORK for Truth, Print it, Take Time to READ ALL LINKS NOTED  click here --> The TWO Witnesses are Mom and Dad and SMF Skins

ladynada

Quote from: SRaven on February 05, 2007, 07:39:37 PM
Quote from: JayBachatero on February 05, 2007, 02:06:07 AM
Umm I set it correctly on the convert file. Open the file.  There is a line like this "$row['signature'] = substr($row['signature'], 0, 65534);".  Does the line match or is there a 1 after $row['signature']?

Found that line in the sql file, not the convert file(convert.php)...
and this is what it says in the file I have:

$row['signature'] = substr($row['signature'], 1, 65534);
So yes, there was a 1

I just checked mine also, the one with the 1 is the sql file in the zip file on the page with the list of converters.

nada
WORK for Truth, Print it, Take Time to READ ALL LINKS NOTED  click here --> The TWO Witnesses are Mom and Dad and SMF Skins

ladynada

Quote from: etdwh on February 05, 2007, 10:44:02 PM
Quote from: margarett on February 05, 2007, 09:51:43 AM
Yes I agree with you. For instance the ;) has 3 codes:

;)
;-)
:wink:


And the first one is :wink:. Well, I like the ;) much more, so I changed it my way ;)

I agree, thats why i have created a seperate SQL script to setup the smilies once the conversion is complete. ;)
There is about 200+ smilies in my forum now, so manually editing it ONCE should be enough  :D

So far so good. I have been doing all the conversions as a test at home with no problems. Hopefully the live conversion goes well  :-\

hi,
can you share that script?
nada
WORK for Truth, Print it, Take Time to READ ALL LINKS NOTED  click here --> The TWO Witnesses are Mom and Dad and SMF Skins

ladynada

btw,
I found where the phpBB Newbie is, after conversion.  It is in the ranking names, so you can just modify it after you convert.

no biggie
nada
WORK for Truth, Print it, Take Time to READ ALL LINKS NOTED  click here --> The TWO Witnesses are Mom and Dad and SMF Skins

Bernie

Quote from: ladynada on March 09, 2007, 05:57:56 PM
Quote from: Bernie on February 02, 2007, 02:38:27 AM
Quote from: JayBachatero on February 02, 2007, 01:46:46 AM
No it was after I posted that one.  This is another version.

Just tried it...  100% success.  No errors reported.

I'll go look and see how it did in what it imported and post you a report later.


Hi,
Will you let us know in here when your board goes online with SMF, as I would love to see it!
nada


I'll be happy to Ladynada, but it won't be for awhile yet.  I just took on another project with a higher priority, so getting switched to SMF is on the back burner for the moment.

Also, since it's a WWII history and wargaming board I'm not sure just how interesting you'd find it.  Great community though, a genuine "virtual band of brothers". 

(Where else are you going to find a group that will pay the round-trip airfare for a student from Finland to join us for a tour of Gettysburg?)
(\__/)
(='.'=)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.

Advertisement: