[CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Converting from other board software? Good decision! Need help? Have a question about a convertor? Wish to offer a convertor package? Post here.
Ideas Centre
K|nG
Registered User
Posts: 25
Joined: Mon Apr 13, 2009 8:52 pm
Location: In&On
Contact:

Re: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by K|nG »

Code: Select all

General Error
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 'o Master'' at line 1 [1064]

SQL

SELECT uid FROM mybb_users WHERE username = 'DuO'o Master'

BACKTRACE

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

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

FILE:
LINE:
CALL: mybb_username_to_id()

FILE: install/install_convert.php
LINE: 2006
CALL: call_user_func_array()

FILE: install/install_convert.php
LINE: 1275
CALL: install_convert->process_row()

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()
Please i need help and fast :P please one from you here mabey can help me thanks :D
The quiter you become, the more your able to hear...
VisualMutation Hosting INC.
Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 27162
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by Paul »

Can you try this version of functions_mybb.php: http://my-trac.assembla.com/mybb_phpbb/ ... s_mybb.php
K|nG
Registered User
Posts: 25
Joined: Mon Apr 13, 2009 8:52 pm
Location: In&On
Contact:

Re: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by K|nG »

Im trying this and ill tell you when that will be sucessful :P

Code: Select all

[phpBB Debug] PHP Notice: in file /includes/session.php on line 531: include_once(./../includes/auth/auth_mybb.php) [function.include-once]: failed to open stream: No such file or directory
[phpBB Debug] PHP Notice: in file /includes/session.php on line 531: include_once() [function.include]: Failed opening './../includes/auth/auth_mybb.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php')
[phpBB Debug] PHP Notice: in file /includes/session.php on line 1007: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3493)
[phpBB Debug] PHP Notice: in file /includes/session.php on line 1007: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3493)
[phpBB Debug] PHP Notice: in file /includes/session.php on line 1007: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3493)
Show this bugs for moments but ill check At finish when will be Currect at Finish
The quiter you become, the more your able to hear...
VisualMutation Hosting INC.
K|nG
Registered User
Posts: 25
Joined: Mon Apr 13, 2009 8:52 pm
Location: In&On
Contact:

Re: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by K|nG »

That's not Successful

Show to me this Error how i can fix it ..!

Code: Select all

General Error
SQL ERROR [ mysqli ]

Duplicate entry 'adsbot [google]' for key 2 [1062]

SQL

INSERT INTO phpbb_users (username, username_clean, user_password, user_pass_convert, user_email, user_email_hash, group_id, user_type, user_permissions, user_timezone, user_dateformat, user_lang, user_style, user_actkey, user_ip, user_regdate, user_passchg, user_options, user_new, user_inactive_reason, user_inactive_time, user_lastmark, user_lastvisit, user_lastpost_time, user_lastpage, user_posts, user_dst, user_colour, user_occ, user_interests, user_avatar, user_avatar_type, user_avatar_width, user_avatar_height, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_message_rules, user_full_folder, user_emailtime, user_notify, user_notify_pm, user_notify_type, user_allow_pm, user_allow_viewonline, user_allow_viewemail, user_allow_massemail, user_sig, user_sig_bbcode_uid, user_sig_bbcode_bitfield, user_form_salt) VALUES ('AdsBot [Google]', 'adsbot [google]', '', 0, '', '00', 15, 2, '', 0, 'd.m.Y', 'en', 1, '', '', 1259493760, 1259493761, 230271, 0, 0, 0, 1259493761, 0, 0, '', 0, 1, '9E8DA7', '', '', '', 0, 0, 0, 0, 0, 0, 0, -3, 0, 0, 1, 0, 1, 1, 1, 0, '', '', '', 'aede2a2c8512e5ab')

BACKTRACE

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

FILE: includes/functions_user.php
LINE: 250
CALL: dbal_mysqli->sql_query()

FILE: includes/functions_convert.php
LINE: 1867
CALL: user_add()

FILE: install/install_convert.php(1652) : eval()'d code
LINE: 2
CALL: add_bots()

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

FILE: install/install_convert.php
LINE: 799
CALL: install_convert->jump()

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()
The quiter you become, the more your able to hear...
VisualMutation Hosting INC.
Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 27162
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by Paul »

K|nG wrote:Im trying this and ill tell you when that will be sucessful :P

Code: Select all

[phpBB Debug] PHP Notice: in file /includes/session.php on line 531: include_once(./../includes/auth/auth_mybb.php) [function.include-once]: failed to open stream: No such file or directory
[phpBB Debug] PHP Notice: in file /includes/session.php on line 531: include_once() [function.include]: Failed opening './../includes/auth/auth_mybb.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php')
[phpBB Debug] PHP Notice: in file /includes/session.php on line 1007: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3493)
[phpBB Debug] PHP Notice: in file /includes/session.php on line 1007: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3493)
[phpBB Debug] PHP Notice: in file /includes/session.php on line 1007: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3493)
Show this bugs for moments but ill check At finish when will be Currect at Finish
Thats because you havent uploaded includes/auth/auth_mybb.php. You can get this file from SVN
K|nG wrote:That's not Successful

Show to me this Error how i can fix it ..!

Code: Select all

General Error
SQL ERROR [ mysqli ]

Duplicate entry 'adsbot [google]' for key 2 [1062]

SQL

INSERT INTO phpbb_users (username, username_clean, user_password, user_pass_convert, user_email, user_email_hash, group_id, user_type, user_permissions, user_timezone, user_dateformat, user_lang, user_style, user_actkey, user_ip, user_regdate, user_passchg, user_options, user_new, user_inactive_reason, user_inactive_time, user_lastmark, user_lastvisit, user_lastpost_time, user_lastpage, user_posts, user_dst, user_colour, user_occ, user_interests, user_avatar, user_avatar_type, user_avatar_width, user_avatar_height, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_message_rules, user_full_folder, user_emailtime, user_notify, user_notify_pm, user_notify_type, user_allow_pm, user_allow_viewonline, user_allow_viewemail, user_allow_massemail, user_sig, user_sig_bbcode_uid, user_sig_bbcode_bitfield, user_form_salt) VALUES ('AdsBot [Google]', 'adsbot [google]', '', 0, '', '00', 15, 2, '', 0, 'd.m.Y', 'en', 1, '', '', 1259493760, 1259493761, 230271, 0, 0, 0, 1259493761, 0, 0, '', 0, 1, '9E8DA7', '', '', '', 0, 0, 0, 0, 0, 0, 0, -3, 0, 0, 1, 0, 1, 1, 1, 0, '', '', '', 'aede2a2c8512e5ab')

BACKTRACE

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

FILE: includes/functions_user.php
LINE: 250
CALL: dbal_mysqli->sql_query()

FILE: includes/functions_convert.php
LINE: 1867
CALL: user_add()

FILE: install/install_convert.php(1652) : eval()'d code
LINE: 2
CALL: add_bots()

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

FILE: install/install_convert.php
LINE: 799
CALL: install_convert->jump()

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()
Did you start with a complete new conversion? This error should not happen if you did
Skiilz
Registered User
Posts: 30
Joined: Sun Nov 29, 2009 2:23 pm

Re: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by Skiilz »

Am I able to use this convertor in the v3.0.6 of PHPBB?

Thank You.
K|nG
Registered User
Posts: 25
Joined: Mon Apr 13, 2009 8:52 pm
Location: In&On
Contact:

Re: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by K|nG »

THanks Fixed now no problem :D
The quiter you become, the more your able to hear...
VisualMutation Hosting INC.
Skiilz
Registered User
Posts: 30
Joined: Sun Nov 29, 2009 2:23 pm

Re: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by Skiilz »

I got this error when I try to convert:

Search index was not converted

Your old search index was not converted. Searching will always yield an empty result. To create a new search index go to the Administration Control Panel, select Maintenance and then choose Search index from the submenu.
Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 27162
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by Paul »

So, did you follow what the error said after that? :)

And no, the convertor isnt tested yet with 3.0.6, and might not work correctly.
K|nG
Registered User
Posts: 25
Joined: Mon Apr 13, 2009 8:52 pm
Location: In&On
Contact:

Re: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by K|nG »

Paul wrote:So, did you follow what the error said after that? :)

And no, the convertor isnt tested yet with 3.0.6, and might not work correctly.
I tested :D and work fine..!

Im convert Mybb1.4.x
To phpBB3.0.6 and work fine :) Thanx Paul:D
The quiter you become, the more your able to hear...
VisualMutation Hosting INC.
coreymanshack
Registered User
Posts: 29
Joined: Thu Oct 12, 2006 1:17 am
Contact:

Re: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by coreymanshack »

So you did fix that error I posted Paul? :)
K|nG
Registered User
Posts: 25
Joined: Mon Apr 13, 2009 8:52 pm
Location: In&On
Contact:

Re: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by K|nG »

Yeah the paul help me verymuch about that :)
The quiter you become, the more your able to hear...
VisualMutation Hosting INC.
Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 27162
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by Paul »

coreymanshack wrote:So you did fix that error I posted Paul? :)
No, I havent yet found the source of that error, sorry.
verad
Registered User
Posts: 11
Joined: Wed Dec 02, 2009 2:36 am

Re: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by verad »

I am trying to convert MyBB 1.4.9 to phpBB 3.0.6 and I'm having this problem:

Code: Select all

General Error
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()
I used Revision 9 to do this conversion.

P.S. I think it's the same issue coreymanshack had.
Trance Life, an electronic music community.

Trance | House | Hardstyle | Techno
http://www.trance-life.org
Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 27162
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: [CONVERTOR]myBB 1.4.x to phpBB 3.0.5

Post by Paul »

THat looks like the same issue yes. I was today able to reproduce it, and found a partial fix, but that caused the forums not to reconvert correctly, and causing that a lost posts not to convert, so thats not really a solution.
Locked

Return to “[3.0.x] Convertors”