[SMF Converter] phpBB - 2.0.19+

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

Previous topic - Next topic

JayBachatero

Should be good now.  We had hardware issues and some attachments were lost.
Follow me on Twitter

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

iatros

Come visit at hxxp:ppc-central.com [nonactive]

JayBachatero

Follow me on Twitter

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

efimomax

Quote from: Eddy Matthews on January 15, 2008, 04:02:18 AM
Converting avatar gallery images...
Fatal error: Call to undefined function: copy_dir() in /home/fhlinux208/p/paddleducks.co.uk/user/htdocs/smf/convert.php(665) : eval()'d code on line 20

Can anypne help with that one please?

Regards
Eddy

Got a same problem with converter from first post.

Can you help us?

Best regards
Max

JayBachatero

Need the latest convert.php as well.  That function was moved to the convert.php file.
Follow me on Twitter

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

sunny45


JayBachatero

Did you bother to search? ;)  Or even look up a bit ;).
[SMF Converter] phpBB3
Follow me on Twitter

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

conradchan

Hi, I am trying to convert from Phpbb 2.0.22 to SMf 1.1.4.  I got the following errors.  Jay, can u guide me what did I do wrong?

Converting...

Notice: Undefined index: convert_script in /home/conrad/public_html/smf/convert.php on line 586

Warning: Invalid argument supplied for foreach() in /home/conrad/public_html/smf/convert.php on line 589

Notice: Undefined index: convert_script in /home/conrad/public_html/smf/convert.php on line 594
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 939

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 949

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 957

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 967

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 980

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 993

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1039

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1041

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1047

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1053

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1064

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1065

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1846

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1073

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1075

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1081

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1082

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1088

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1089

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1846

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1113

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1115

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1121

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1133

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1846

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1158

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1160

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1197

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1198

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1235

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1240

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1301

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1303

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1339

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1358

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1846

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1846

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/conrad/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1381

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/conrad/public_html/smf/convert.php on line 1382
Successful.

JayBachatero

Follow me on Twitter

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


JayBachatero

Do they allow you to edit the php.ini file?
Follow me on Twitter

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

conradchan


menk

I have a similar problem, also with hostgator:

Recalculating forum statistics...
Notice: Undefined variable: result in /home/redaenet/public_html/forum/convert.php on line 1827

Notice: Undefined variable: result in /home/redaenet/public_html/forum/convert.php on line 1828

Notice: Undefined variable: result in /home/redaenet/public_html/forum/convert.php on line 1827

Notice: Undefined variable: result in /home/redaenet/public_html/forum/convert.php on line 1828

Notice: Undefined variable: result in /home/redaenet/public_html/forum/convert.php on line 1827

Notice: Undefined variable: result in /home/redaenet/public_html/forum/convert.php on line 1828

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/redaenet/public_html/forum/convert.php on line 1377

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/redaenet/public_html/forum/convert.php on line 1378
Successful.


Any advice?

JayBachatero

You need to edit the php.ini file and set the correct session.save_path.  It's towards the end of the file.
Follow me on Twitter

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

menk

#414
where would php.ini be, and what would i need to change?  Thanks for your help!

Edit: found it here!
http://www.simplemachines.org/community/index.php?topic=146192.0

REiT

I try convert the phpbb2 for smf, but i have this problem:

Unknown column 'variable' in 'field list'

REiT

new error:

Converting ranks... Successful.
Converting groups... Successful.
Converting members...
Warning: copy(/home2/ptracker/public_html/backup/phpBB2/images/avatars/65646129747ce669ca9c80.png) [function.copy]: failed to open stream: No such file or directory in /home2/ptracker/public_html/backup/smf_1-1-2_phpbb2_converter/convert.php(827) : eval()'d code on line 35

Warning: copy(/home2/ptracker/public_html/backup/phpBB2/images/avatars/53540521347cf1242ee7c0.gif) [function.copy]: failed to open stream: No such file or directory in /home2/ptracker/public_html/backup/smf_1-1-2_phpbb2_converter/convert.php(827) : eval()'d code on line 35

Warning: copy(/home2/ptracker/public_html/backup/phpBB2/images/avatars/117301126547d1f782a50ec.gif) [function.copy]: failed to open stream: No such file or directory in /home2/ptracker/public_html/backup/smf_1-1-2_phpbb2_converter/convert.php(827) : eval()'d code on line 35
Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board access... Successful.
Converting group access... Successful.
Converting moderators... Successful.
Converting avatar gallery images... Successful.
Converting censored words... Successful.
Converting reserved names... Successful.
Converting banned users... Successful.
Converting settings... Successful.
Converting attachment mod (if installed)... Unsuccessful!
This query:

    SELECT config_value
    FROM `ptracker_back`.ptracker_back_attachments_config
    WHERE config_name = 'upload_dir'
    LIMIT 1;

Caused the error:

    Table 'ptracker_back.ptracker_back_attachments_config' doesn't exist

r0ckstarr

Hi, im very new here. I've read through about 1/3 of this topic (quite a few pages of helpful info).

I have had phpBB 2.x.xx installed and running since 2006. Im wanting to convert over to SMF now. I have SMF installed and working in a separate folder from the phpBB installation, but before I go any further I had a few questions so that I know I understand this correctly.

For example, SMF can be in one folder and phpBB can be in a different folder, but both have to use the same host name for the database, correct?

If I am using the same database for both message boards, how do I clear out the old phpBB board from the database once everything is converted to SMF? I ask this because that database with the phpBB on it is a mess from previous mods and a bad install of Coppermine Photo Gallery.

Is there anyway I can run SMF on a new database and still convert the phpBB over?

If any of this doesn't make any sense, it's probably because im pretty lost at this point when it comes to actually messing with the database. Thanks in advance for any help.


JayBachatero

REiT - Did you install the attachments mod before?

Quote from: r0ckstarr on April 04, 2008, 02:52:33 AM
For example, SMF can be in one folder and phpBB can be in a different folder, but both have to use the same host name for the database, correct?
Correct.  They don't have to be in the same database but the SMF database user MUST have access to the phpBB database.  If you can't have 1 user in 2 databases then just install SMF in the same database as phpBB.

Quote
If I am using the same database for both message boards, how do I clear out the old phpBB board from the database once everything is converted to SMF? I ask this because that database with the phpBB on it is a mess from previous mods and a bad install of Coppermine Photo Gallery.
You can just remove the tables with the phpbb_ prefix.

Quote
Is there anyway I can run SMF on a new database and still convert the phpBB over?
As stated above.  As long as SMF has access to both databases it should be able to convert.

If you need help converting take a look at.
Converting to SMF
Follow me on Twitter

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

r0ckstarr

#419
Thanks for the help. I got the conversion started and got this error:

Converting topics... Unsuccessful!
This query:
INSERT INTO `r0ckstarr`.smf_topics
(ID_TOPIC, isSticky, ID_FIRST_MSG, ID_LAST_MSG, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_BOARD, ID_POLL, locked, numReplies, numViews)
VALUES ('2108', '0', '48519', '49100', '2', '2', '7', '', '0', '2', '26'),
('2109', '0', '48523', '50365', '2', '2', '7', '', '0', '8', '48'),
('2110', '0', '48525', '48838', '2', '11', '7', '', '0', '1', '18'),
('2111', '0', '48527', '48835', '2', '11', '7', '', '0', '1', '35'),
('2112', '0', '48528', '48834', '2', '11', '7', '', '0', '1', '18'),
('2113', '0', '48531', '48812', '2', '11', '7', '', '0', '4', '16'),
('2114', '0', '48533', '48832', '2', '11', '7', '', '0', '1', '14'),
('2115', '0', '48534', '50358', '2', '11', '7', '', '0', '8', '33'),
('2117', '0', '48579', '49578', '2', '6', '3', '', '0', '10', '73'),
('2118', '0', '48648', '49986', '58', '23', '3', '', '0', '36', '450'),
('2120', '0', '48727', '72743', '53', '7', '2', '', '0', '14', '599'),
('2122', '0', '48797', '49777', '24', '2', '2', '', '0', '8', '299'),
('2123', '0', '48897', '49187', '58', '12', '3', '', '0', '30', '677'),
('2124', '0', '48927', '49150', '26', '11', '3', '', '0', '26', '69'),
('2125', '0', '48951', '49650', '24', '23', '3', '', '0', '10', '102'),
('2126', '0', '48952', '49198', '24', '2', '3', '', '0', '25', '91'),
('2127', '0', '48953', '49134', '2', '2', '3', '', '0', '9', '49'),
('2128', '0', '48972', '51129', '2', '2', '7', '', '0', '5', '143'),
('2129', '0', '48996', '50595', '9', '11', '3', '', '0', '72', '282'),
('2130', '0', '49002', '49246', '17', '17', '14', '', '0', '2', '97'),
('2131', '0', '49018', '51023', '8', '9', '3', '', '0', '40', '166'),
('2132', '0', '49074', '49231', '72', '72', '14', '', '0', '9', '177'),
('2133', '0', '49075', '49320', '17', '2', '10', '', '0', '7', '33'),
('2134', '0', '49098', '115877', '6', '66', '15', '', '0', '14', '262'),
('2135', '0', '49102', '49183', '6', '2', '2', '', '1', '16', '551'),
('2136', '0', '49165', '50868', '11', '2', '3', '', '0', '14', '70'),
('2137', '0', '49166', '52318', '11', '25', '4', '', '0', '19', '139'),
('2138', '0', '49168', '49475', '11', '4', '4', '', '0', '3', '25'),
('2139', '0', '49169', '50319', '11', '11', '4', '', '0', '9', '129'),
('2140', '0', '49170', '49943', '11', '40', '4', '', '0', '7', '51'),
('2141', '0', '49194', '50266', '2', '53', '3', '', '0', '35', '145'),
('2143', '0', '49222', '49632', '29', '23', '3', '', '0', '13', '74'),
('2144', '0', '49234', '51912', '29', '12', '3', '', '0', '57', '188'),
('2145', '0', '49238', '50440', '29', '23', '3', '31', '0', '102', '357'),

it continues on and on for miles and ends with this:

('2638', '0', '60159', '62853', '9', '59', '3', '', '0', '116', '441'),
('2640', '0', '60185', '60361', '26', '24', '3', '', '0', '14', '66'),
('2641', '0', '60314', '60771', '11', '66', '3', '', '0', '24', '97'),
('2642', '0', '60321', '60701', '11', '6', '3', '', '0', '40', '127');
Caused the error:

Duplicate entry '2108' for key 1


I thought maybe it was the Coppermine Photo Gallery causing the error, so I dropped all of it's tables and still get the error. Hitting try again doesnt help.

Again, thanks in advance for helping out. I'm pretty sure this is just something simple.

Edit: Ok, I tried repairing and optimizing and that didnt work either.

Advertisement: