Print Page - Converting from PHPbb 3.0.11 to SMF 2.0.14 Issue with ranks

Title: Converting from PHPbb 3.0.11 to SMF 2.0.14 Issue with ranks
Post by: Uhlakk on January 11, 2019, 07:41:16 PM

Hi, I checked a few other posts, but nothing worked for me.

I try to convert a PHPbb 3.0.11 forum to SMF2.0.14 but get the error below.
Host is one.com with PHP7.2
--------------------
Converting...
Converting ranks... Notice: Undefined property: mysqli_result::$EOF in /customers/a/8/d/avp-universe-germany.de/httpd.www/test/convert.php on line 2722 Notice: Undefined property: mysqli_result::$Fields in /customers/a/8/d/avp-universe-germany.de/httpd.www/test/convert.php on line 2726 Notice: Trying to get property 'Count' of non-object in /customers/a/8/d/avp-universe-germany.de/httpd.www/test/convert.php on line 2727 Fatal error: Uncaught Error: Call to undefined method mysqli_result::MoveNext() in /customers/a/8/d/avp-universe-germany.de/httpd.www/test/convert.php:2732 Stack trace: #0 /customers/a/8/d/avp-universe-germany.de/httpd.www/test/convert.php(1252): convert_fetch_assoc(Object(mysqli_result)) #1 /customers/a/8/d/avp-universe-germany.de/httpd.www/test/convert.php(51): doStep1() #2 {main} thrown in /customers/a/8/d/avp-universe-germany.de/httpd.www/test/convert.php on line 2732
-------------------------

What can I do?

Title: Re: Converting from PHPbb 3.0.11 to SMF 2.0.14 Issue with ranks
Post by: vbgamer45 on January 11, 2019, 09:06:07 PM

Did you try the one from
https://github.com/SimpleMachines/converters/tree/master/SMF2.0/phpBB/3.0

Title: Re: Converting from PHPbb 3.0.11 to SMF 2.0.14 Issue with ranks
Post by: Uhlakk on January 12, 2019, 06:11:51 AM

No. Thanks for the link.

Just tried it and got this:
Converting...
Converting ranks...Field 'description' doesn't have a default value

I'll check the table later. Or is there a solution already?

(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fphotos.app.goo.gl%2FxnMqGXksmQHoSt9f7&hash=bbeda564364edc105b96bb79b5bb67311a0b1757)

Title: Re: Converting from PHPbb 3.0.11 to SMF 2.0.14 Issue with ranks
Post by: Uhlakk on January 12, 2019, 06:37:17 AM

Here is a sreenshot from the table, but I can't find a field "description".

Title: Re: Converting from PHPbb 3.0.11 to SMF 2.0.14 Issue with ranks
Post by: vbgamer45 on January 12, 2019, 07:28:03 AM

Try this sql file I made a change

Title: Re: Converting from PHPbb 3.0.11 to SMF 2.0.14 Issue with ranks
Post by: Uhlakk on January 12, 2019, 09:33:01 AM

:)

Nice, works half way.

Converting...
Converting ranks... Successful.
Converting groups... Successful.
Converting members...Field 'openid_uri' doesn't have a default value

I tried to find this on in phpbb3_to_smf.sql but I am lost.

Title: Re: Converting from PHPbb 3.0.11 to SMF 2.0.14 Issue with ranks
Post by: vbgamer45 on January 12, 2019, 09:51:09 AM

Updated try

Title: Re: Converting from PHPbb 3.0.11 to SMF 2.0.14 Issue with ranks
Post by: Uhlakk on January 12, 2019, 09:52:59 AM

I'll tryed this one maybe: https://www.simplemachines.org/community/index.php?topic=518678.msg3670432#msg3670432

It's working now.

Thanks also to you, vbgamer45!

Thank you so much.

Title: Re: Converting from PHPbb 3.0.11 to SMF 2.0.14 Issue with ranks
Post by: vbgamer45 on January 12, 2019, 10:24:35 AM

Glad you have it working pushed the changes as well on github

Simple Machines Community Forum

SMF Support => Converting to SMF => phpBB => Topic started by: Uhlakk on January 11, 2019, 07:41:16 PM