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

Converting from other board software? Good decision! Need help? Have a question about a convertor? Wish to offer a convertor package? Post here.
Get Involved
Locked
ashkir
Registered User
Posts: 11
Joined: Sun Sep 02, 2012 10:57 pm

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

Post by ashkir »

Has anyone else had this error? Trying to transfer a huge forum with almost a million posts.
User avatar
tbackoff
Former Team Member
Posts: 7068
Joined: Thu Jun 04, 2009 1:41 am
Location: cheerleading practice
Name: Tabitha Backoff

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

Post 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.
Flying is the second best thrill to cheerleaders; being caught is the first.
ashkir
Registered User
Posts: 11
Joined: Sun Sep 02, 2012 10:57 pm

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

Post 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)
User avatar
tbackoff
Former Team Member
Posts: 7068
Joined: Thu Jun 04, 2009 1:41 am
Location: cheerleading practice
Name: Tabitha Backoff

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

Post by tbackoff »

Have a read here -> Offline Conversions. For Windows 8, I use WampServer, but any of the *AMP programs should work.
Flying is the second best thrill to cheerleaders; being caught is the first.
ashkir
Registered User
Posts: 11
Joined: Sun Sep 02, 2012 10:57 pm

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

Post 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 :(
User avatar
tbackoff
Former Team Member
Posts: 7068
Joined: Thu Jun 04, 2009 1:41 am
Location: cheerleading practice
Name: Tabitha Backoff

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

Post by tbackoff »

Sorry, I probably should have included this one too. :lol:
Using Bigdump to restore large database dumps
Flying is the second best thrill to cheerleaders; being caught is the first.
ashkir
Registered User
Posts: 11
Joined: Sun Sep 02, 2012 10:57 pm

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

Post 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.
sakkiotto
Registered User
Posts: 236
Joined: Mon Jun 13, 2005 9:45 pm

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

Post 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:
Geonx
Registered User
Posts: 2
Joined: Thu Apr 21, 2016 7:14 pm

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

Post by Geonx »

I tried it with SMF 2.1 Beta 2 version and worked, with few changes in code.
fusionater
Registered User
Posts: 15
Joined: Wed May 25, 2016 7:14 am

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

Post 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()
seobomj
Registered User
Posts: 3
Joined: Sat May 28, 2016 8:31 pm

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

Post 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
cerb3r
Registered User
Posts: 1
Joined: Wed Sep 14, 2016 11:24 am

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

Post 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()
adkaush
Registered User
Posts: 2
Joined: Tue Oct 18, 2016 11:36 am

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

Post 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()
davidsanchezvasquez
Registered User
Posts: 8
Joined: Fri Jun 24, 2005 10:43 pm

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

Post 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.
davidsanchezvasquez
Registered User
Posts: 8
Joined: Fri Jun 24, 2005 10:43 pm

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

Post 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!
Locked

Return to “[3.0.x] Convertors”