Page 7 of 7

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

Posted: Wed Jun 04, 2014 9:41 am
by ashkir
Has anyone else had this error? Trying to transfer a huge forum with almost a million posts.

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

Posted: Mon Jun 09, 2014 11:50 pm
by 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.

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

Posted: Tue Jun 10, 2014 12:36 am
by ashkir
I have not. I don't have any of the programming languages installed to my pc (which is a chromebook or windows 8)

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

Posted: Tue Jun 10, 2014 1:22 am
by tbackoff
Have a read here -> Offline Conversions. For Windows 8, I use WampServer, but any of the *AMP programs should work.

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

Posted: Tue Jun 10, 2014 3:36 pm
by 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 :(

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

Posted: Tue Jun 10, 2014 3:39 pm
by tbackoff
Sorry, I probably should have included this one too. :lol:
Using Bigdump to restore large database dumps

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

Posted: Tue Jun 10, 2014 4:06 pm
by 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.

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

Posted: Wed Feb 24, 2016 10:52 am
by sakkiotto
blogger419 wrote: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? :cry:

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

Posted: Thu Apr 21, 2016 7:17 pm
by Geonx
I tried it with SMF 2.1 Beta 2 version and worked, with few changes in code.

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

Posted: Wed May 25, 2016 7:24 am
by 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()

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

Posted: Sat May 28, 2016 8:36 pm
by 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

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

Posted: Wed Sep 14, 2016 11:28 am
by 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()

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

Posted: Tue Oct 18, 2016 3:51 pm
by 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()

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

Posted: Wed Dec 07, 2016 1:04 pm
by davidsanchezvasquez
adkaush wrote: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.

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

Posted: Wed Dec 07, 2016 1:13 pm
by davidsanchezvasquez
sakkiotto wrote:
blogger419 wrote: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? :cry:
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!