[CONVERTOR]myBB 1.4.x to phpBB 3.0.5

[verad]

Alright, I'm glad you're working on it. Please let me know when you find a fix .

[Skiilz]

Worked fine!
Thank you.

And It is working on 3.0.6
I have converted MyBB 1.4.9 to phpBB 3.0.6

[coreymanshack]

Glad to see that it's been fixed

[vovas]

Hi everyone!
I have same error during conversion from mybb 1.4.11 to phpbb3.0.6

Code: Select all

SQL ERROR [ mysqli ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 [1064]

SQL

UPDATE phpbb_forums SET left_id = left_id + 2, right_id = right_id + 2 WHERE left_id >

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: install/convertors/functions_mybb.php
LINE: 463
CALL: dbal_mysqli->sql_query()

FILE: install/install_convert.php(1003) : eval()'d code
LINE: 7
CALL: mybb_insert_forums()

FILE: install/install_convert.php
LINE: 1003
CALL: eval()

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

FILE: install/index.php
LINE: 405
CALL: install_convert->main()

FILE: install/index.php
LINE: 282
CALL: module->load()

Is anybody solve that problem?

[Paul]

Apart, I will have a look at it this evening to see if I can fix this issue.

[vovas]

Apart, I will have a look at it this evening to see if I can fix this issue.

Thanks for Your support. It very important for me!

[Jimmy1987]

Just tried it with converting a mybb 4.0.11 board to phpbb 3.0.7-pl1.

Worked flawlessly

[Hossam Fahmy]

Hello,

I have tried to convert myBB 1.4 to phpBB 3.0.7
But I got the following error...

Code: Select all

General Error
SQL ERROR [ mysqli ]

MySQL server has gone away [2006]

SQL

TRUNCATE TABLE phpbb_forums

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: install/convertors/functions_mybb.php
LINE: 321
CALL: dbal_mysqli->sql_query()

FILE: install/install_convert.php(1003) : eval()'d code
LINE: 7
CALL: mybb_insert_forums()

FILE: install/install_convert.php
LINE: 1003
CALL: eval()

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

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

FILE: install/index.php
LINE: 286
CALL: module->load()

Do you have a solution for that??

[D¡cky]

MySQL server has gone away is a problem with your server not having enough resources to handle the conversion. This is something you need to talk to your host about and see if they will temporarily raise the limits for you. Some common remedies are listed in MySQL Server has Gone Away.

If your host will not raise the limits, the alternative is to do the conversion locally on your computer. Use EasyPHP, WampServer, or XAMPP.
Some helpful tips are in this Knowledge Base article, Offline Conversions

[Alex597]

Hi everyone!
I have same error during conversion from mybb 1.4.11 to phpbb3.0.6

Code: Select all

SQL ERROR [ mysqli ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 [1064]

SQL

UPDATE phpbb_forums SET left_id = left_id + 2, right_id = right_id + 2 WHERE left_id >

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: install/convertors/functions_mybb.php
LINE: 463
CALL: dbal_mysqli->sql_query()

FILE: install/install_convert.php(1003) : eval()'d code
LINE: 7
CALL: mybb_insert_forums()

FILE: install/install_convert.php
LINE: 1003
CALL: eval()

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

FILE: install/index.php
LINE: 405
CALL: install_convert->main()

FILE: install/index.php
LINE: 282
CALL: module->load()

Is anybody solve that problem?

i get this same problem, Paul were you able to find a fix?

[D¡cky]

Hi everyone!
I have same error during conversion from mybb 1.4.11 to phpbb3.0.6

Code: Select all

SQL ERROR [ mysqli ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 [1064]

SQL

UPDATE phpbb_forums SET left_id = left_id + 2, right_id = right_id + 2 WHERE left_id >

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: install/convertors/functions_mybb.php
LINE: 463
CALL: dbal_mysqli->sql_query()

FILE: install/install_convert.php(1003) : eval()'d code
LINE: 7
CALL: mybb_insert_forums()

FILE: install/install_convert.php
LINE: 1003
CALL: eval()

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

FILE: install/index.php
LINE: 405
CALL: install_convert->main()

FILE: install/index.php
LINE: 282
CALL: module->load()

Is anybody solve that problem?

i get this same problem, Paul were you able to find a fix?

Would you browse to the MyBB forums table with phpMyadmin and post a screenshot of it please?
Also, what version of MyBB?

[vovas]

Hello.
Do you want mybb_forums table or list of tables?

2010-03-22 15-07.jpg (484.81 KiB) Viewed 2663 times

Sorry for my english

[D¡cky]

mybb_forums table. Don't worry about it being too wide. I need just the leftmost 12 or 15 columns.

[vovas]

ok.
That is it

2010-03-22 17-59.jpg (166.82 KiB) Viewed 2653 times

[D¡cky]

vovas,

Your first screenshot shows that you have 15 forums. Your second screenshot shows only 6 forums. I need to see all 15 forums if they do actually exist.