[Convert] Fail convert SMF2.0RC2 to phpBB3.9

[ashkir]

Has anyone else had this error? Trying to transfer a huge forum with almost a million posts.

[tbackoff]

Not sure how much help I can be, but I'll give it a shot.

Have you tried converting offline? What I mean is, create a copy of your SMF forum on your local machine, and then convert to phpBB.

[ashkir]

I have not. I don't have any of the programming languages installed to my pc (which is a chromebook or windows 8)

[tbackoff]

Have a read here -> Offline Conversions. For Windows 8, I use WampServer, but any of the *AMP programs should work.

[ashkir]

Thank you! I'm trying but wampserver is throwing a fit because our database is 2.5GB. Hahaha. Trying to find another way to import it so it stops giving duplicate errors because it times out

[tbackoff]

Sorry, I probably should have included this one too.
Using Bigdump to restore large database dumps

[ashkir]

It gives me UNEXPECTED: Can't set file pointer behind the end of file

Man I'm full of badluck. I'm going to try a Dump File Splitter now.

Thanks hopefully this will work so I can convert my DB to PHPBB. Going to try xf > phpbb first if it doesn't work again I'll try SMF > PHPBB. So far only converter we got working was XF > SMF

Edit: Okay looks like importing via command line is working the best.

[sakkiotto]

So I've tried this converter twice now an I am not sure what's going on. It appears to convert the users, passwords, and posts just fine. However, the attachments appear not to work. All I get is a white box that says "Attachments" and then lists the names of the attachments but does not display them. I have run the convert_links.php script as mentioned in earlier threads. I am wondering if I am supposed to specify the SMF attachments directory in ACP instead of "files" as is currently the default upload directory. I've attached a screen shot of what it looks like. Any help would be greatly appreciated.

Edit: I just noticed that my "Files" folder is empty. Is phpBB3 supposed to import all of my SMF attatchments into its own directory? Or is it supposed to some how read from my SMF attachment folder?

Thank You.

any suggest for this?

[Geonx]

I tried it with SMF 2.1 Beta 2 version and worked, with few changes in code.

[fusionater]

I got this error during conversion, thoughts?

Code: Select all

General Error
SQL ERROR [ mysqli ]

Unknown column 'forum_posts' in 'field list' [1054]

SQL

INSERT INTO phpbb_forums (forum_id, forum_name, parent_id, forum_parents, forum_desc, forum_type, forum_flags, forum_desc_bitfield, forum_desc_options, forum_desc_uid, forum_link, forum_password, forum_style, forum_image, forum_rules, forum_rules_link, forum_rules_bitfield, forum_rules_options, forum_rules_uid, forum_topics_per_page, forum_posts, forum_topics, forum_topics_real, forum_last_post_id, forum_last_poster_id, forum_last_post_subject, forum_last_post_time, forum_last_poster_name, forum_last_poster_colour, display_on_index, enable_indexing, enable_icons, left_id, right_id) VALUES (8869, 'General Discussion', 45014, '', '', 1, 34, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, 1, 1, '2', 3)

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/install/convertors/functions_smf20.php
LINE: 1014
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/install/install_convert.php(1028) : eval()'d code
LINE: 5
CALL: smf_insert_forums()

FILE: [ROOT]/install/install_convert.php
LINE: 1028
CALL: eval()

FILE: [ROOT]/install/install_convert.php
LINE: 214
CALL: install_convert->convert_data()

FILE: [ROOT]/install/index.php
LINE: 409
CALL: install_convert->main()

FILE: [ROOT]/install/index.php
LINE: 289
CALL: module->load()

[seobomj]

Help me please =) I tried to convert SMF 2.0.10 in phpBB 3.1.9 on the virtual server "Denwer". I get the error:

Code: Select all

Общая ошибка
SQL ERROR [ mysqli ]

Unknown column 'forum_posts' in 'field list' [1054]

SQL

INSERT INTO phpbb_forums (forum_id, forum_name, parent_id, forum_parents, forum_desc, forum_type, forum_flags, forum_desc_bitfield, forum_desc_options, forum_desc_uid, forum_link, forum_password, forum_style, forum_image, forum_rules, forum_rules_link, forum_rules_bitfield, forum_rules_options, forum_rules_uid, forum_topics_per_page, forum_posts, forum_topics, forum_topics_real, forum_last_post_id, forum_last_poster_id, forum_last_post_subject, forum_last_post_time, forum_last_poster_name, forum_last_poster_colour, display_on_index, enable_indexing, enable_icons, left_id, right_id) VALUES (76, 'FAQ!', 87, '', 'Информация для новичков - ОБЯЗАТЕЛЬНО ознакомьтесь с ней.\r\nМожет быть именно здесь вы найдёте ответы на все вопросы.', 1, 34, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, 1, 1, '2', 3)

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 852
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/install/convertors/functions_smf20.php
LINE: 1014
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/install/install_convert.php(1028) : eval()'d code
LINE: 5
CALL: smf_insert_forums()

FILE: [ROOT]/install/install_convert.php
LINE: 1028
CALL: eval()

FILE: [ROOT]/install/install_convert.php
LINE: 214
CALL: install_convert->convert_data()

FILE: [ROOT]/install/index.php
LINE: 409
CALL: install_convert->main()

FILE: [ROOT]/install/index.php
LINE: 289
CALL: module->load()

Russian language

[cerb3r]

0.4.4 version, SMF 2.0.11 -> phpBB 3.0.14, postgresql database. How fix it?

Code: Select all

General Error
SQL ERROR [ postgres ]

ERROR: operator does not exist: smallint = character varying LINE 3: WHERE (membergroups.id_group IN(members.additional_groups) A... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. []

SQL

SELECT membergroups.id_group, members.id_member FROM fspmembergroups membergroups, fspmembers members WHERE (membergroups.id_group IN(members.additional_groups) AND members.id_member > 1) ORDER BY membergroups.id_group ASC LIMIT 2000 OFFSET 0

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/postgres.php
LINE: 211
CALL: dbal->sql_error()

FILE: [ROOT]/includes/db/postgres.php
LINE: 266
CALL: dbal_postgres->sql_query()

FILE: [ROOT]/includes/db/dbal.php
LINE: 170
CALL: dbal_postgres->_sql_query_limit()

FILE: [ROOT]/install/install_convert.php
LINE: 1233
CALL: dbal->sql_query_limit()

FILE: [ROOT]/install/install_convert.php
LINE: 203
CALL: install_convert->convert_data()

FILE: [ROOT]/install/index.php
LINE: 326
CALL: install_convert->main()

FILE: [ROOT]/install/index.php
LINE: 203
CALL: module->load()

[adkaush]

Wow, this is an old issue and there doesn't seem to be any development on the converter.

I'm getting the same issue like many others have experienced ..

Code: Select all

General Error
SQL ERROR [ mysqli ]

Unknown column 'forum_posts' in 'field list' [1054]

SQL

INSERT INTO phpbb_forums (forum_id, forum_name, parent_id, forum_parents, forum_desc, forum_type, forum_flags, forum_desc_bitfield, forum_desc_options, forum_desc_uid, forum_link, forum_password, forum_style, forum_image, forum_rules, forum_rules_link, forum_rules_bitfield, forum_rules_options, forum_rules_uid, forum_topics_per_page, forum_posts, forum_topics, forum_topics_real, forum_last_post_id, forum_last_poster_id, forum_last_post_subject, forum_last_post_time, forum_last_poster_name, forum_last_poster_colour, display_on_index, enable_indexing, enable_icons, left_id, right_id) VALUES (118, 'Introduce Yourself', 123, '', 'Welcome to the IV Forum, please introduce yourself!', 1, 34, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, 1, 1, '2', 3)

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/install/convertors/functions_smf20.php
LINE: 1014
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/install/install_convert.php(1028) : eval()'d code
LINE: 5
CALL: smf_insert_forums()

FILE: [ROOT]/install/install_convert.php
LINE: 1028
CALL: eval()

FILE: [ROOT]/install/install_convert.php
LINE: 214
CALL: install_convert->convert_data()

FILE: [ROOT]/install/index.php
LINE: 409
CALL: install_convert->main()

FILE: [ROOT]/install/index.php
LINE: 289
CALL: module->load()

[davidsanchezvasquez]

Wow, this is an old issue and there doesn't seem to be any development on the converter.
I'm getting the same issue like many others have experienced ..

are you are you trying to convert to phpbb 3.0.x? if the answer is NO, then that's your problem.

[davidsanchezvasquez]

So I've tried this converter twice now an I am not sure what's going on. It appears to convert the users, passwords, and posts just fine. However, the attachments appear not to work. All I get is a white box that says "Attachments" and then lists the names of the attachments but does not display them. I have run the convert_links.php script as mentioned in earlier threads. I am wondering if I am supposed to specify the SMF attachments directory in ACP instead of "files" as is currently the default upload directory. I've attached a screen shot of what it looks like. Any help would be greatly appreciated.

Edit: I just noticed that my "Files" folder is empty. Is phpBB3 supposed to import all of my SMF attatchments into its own directory? Or is it supposed to some how read from my SMF attachment folder?

Thank You.

any suggest for this?

hey, same problem here. all the posts, topics etc were migrated without problems, but not the attachments. I am not sure if I should have moved the attachment files (from the SMF's attachment folder) to the files folder form PHPBB before running the script. If someone managed to migrate successfully the attachments please share what you did. Thanks!