[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.
Get Involved
Locked
lukasamd
Registered User
Posts: 100
Joined: Sat Jul 12, 2008 8:14 am

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

Post by lukasamd »

Working!
Thank you very much :)
edward.81
Registered User
Posts: 5
Joined: Tue May 04, 2010 10:47 am

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

Post by edward.81 »

Thanks for the work but for me is failing also with the mod in the sort order.

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: 467
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()
Look at the screen of the source forum. The forum with fid=12 is not converted. And look at their parent id, is forum 105 that are not already converted.
Attachments
fail_convert.jpeg
fail_convert.jpeg (71.76 KiB) Viewed 3008 times
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

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

Post by D¡cky »

edward.81,

The attached file will fix your forum insertion problems
Attachments
functions_mybb.zip
Fixes insertion of forums
(13.47 KiB) Downloaded 107 times
Have you hugged someone today?
edward.81
Registered User
Posts: 5
Joined: Tue May 04, 2010 10:47 am

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

Post by edward.81 »

Thanks !
Now the conversion run fine.
I have noticed just some problems.
-The previus Administrators can't no longer access to adm
- In images\avatars\gallery\ are copied the full folder/files of mybb thread.
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

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

Post by D¡cky »

edward.81 wrote:I have noticed just some problems.
-The previus Administrators can't no longer access to adm
The permissions conversion is not done yet, but it should at least give myBB Administrators Founder status so they can access the Administration Panel. What is the message when Administrators try to access the Administration Panel, or what is happening?
edward.81 wrote:- In images\avatars\gallery\ are copied the full folder/files of mybb thread.
I don't understand what you mean. It copies a thread?
Have you hugged someone today?
edward.81
Registered User
Posts: 5
Joined: Tue May 04, 2010 10:47 am

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

Post by edward.81 »

Sorry my English is bad as hell :D

The login error:
"Access to the Administration Control Panel is not allowed as you do not have administrative permissions."
After checking my user are in the old mybb administrator group, but the group are not granted to access the adm. Re-enabling adm access via phpmyadmin is a bit hard if u don't know hot to do it.

For the second error.
In the directory images\avatars\gallery\ i have found here all the mybb files and directory. Like index.php, cache etc.
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

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

Post by D¡cky »

edward.81 wrote:Sorry my English is bad as hell :D

The login error:
"Access to the Administration Control Panel is not allowed as you do not have administrative permissions."
After checking my user are in the old mybb administrator group, but the group are not granted to access the adm. Re-enabling adm access via phpmyadmin is a bit hard if u don't know hot to do it.
If they can see the Administration Control Panel link, that means they do have Administrative permissions. The problem could be a redirection problem because of an incorrect script path, or server name in phpBB, or it could be a cookie problem. Are they getting logged out when accessing the admin panel?
edward.81 wrote:For the second error.
In the directory images\avatars\gallery\ i have found here all the mybb files and directory. Like index.php, cache etc.
heh. I hadn't noticed that before. :oops: I will check into it.
Have you hugged someone today?
edward.81
Registered User
Posts: 5
Joined: Tue May 04, 2010 10:47 am

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

Post by edward.81 »

D¡cky wrote:If they can see the Administration Control Panel link, that means they do have Administrative permissions. The problem could be a redirection problem because of an incorrect script path, or server name in phpBB, or it could be a cookie problem. Are they getting logged out when accessing the admin panel?
Humm, no, the link for adm is not present, and if i log in and go manually to adm i get logged out.
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

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

Post by D¡cky »

Look at the mybb_usergroups table and tell me what the gid is for the Administrators group and what the value of the cancp field is for the Administrators.
Also look at the mybb_users table and tell me what the usergroup and additional groups is for your user_id.

In the meantime, you can give yourself Administrator status with the following query. Log off the board before running the query.

Code: Select all

UPDATE phpbb_users SET user_type = 3, user_permissions = '' WHERE user_id = XX;
Replace XX with your user_id and replace phpbb_ with your phpbb table prefix if necessary.
Have you hugged someone today?
edward.81
Registered User
Posts: 5
Joined: Tue May 04, 2010 10:47 am

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

Post by edward.81 »

The Mybb administrator group ID is 4 (and this group cannot be modified or deleted).
My main usergroup is 2 and additional 4,7
Can be this, but in converted phpbb i found for my user
user_type 0
group_id 2
And in phpbb_user_group
group_id,user_id
2, 12
4, 12
7, 12
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

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

Post by D¡cky »

Edward,

The convertor kept you in the MyBB groups, but didn't add you to the phpBB groups. The best thing to do for now, is run the query I gave you. This will get you into the Administration Panel so you can fix the permissions and the groups.

I believe it has been mentioned before that this convertor does not convert permissions. I am working on it, but it does take time.
Have you hugged someone today?
omenator
Registered User
Posts: 2
Joined: Wed Apr 23, 2008 2:25 pm

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

Post by omenator »

i get this error when i try to convert
SQL ERROR [ mysqli ]

Out of range value adjusted for column 'poll_option_total' at row 1 [1264]

SQL

INSERT INTO phpbb_poll_options (topic_id, poll_option_text, poll_option_total) VALUES ('7747', 'Seawolf', '266852967')

BACKTRACE

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

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

FILE: install/install_convert.php(1073) : eval()'d code
LINE: 1
CALL: mybb_insert_vote_options()

FILE: install/install_convert.php
LINE: 1073
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()
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

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

Post by D¡cky »

omenator wrote:i get this error when i try to convert
Would you run this query and paste the results here

Code: Select all

SELECT * FROM mybb_polls WHERE tid = 7747;
Change mybb_ if your MyBB table prefix is not mybb_
Have you hugged someone today?
omenator
Registered User
Posts: 2
Joined: Wed Apr 23, 2008 2:25 pm

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

Post by omenator »

the prefix is mybb_ so i don't need to change that
Attachments
Untitled.png
Untitled.png (31.06 KiB) Viewed 2830 times
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

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

Post by D¡cky »

omenator,

The problem is votes = 266852967||~|~||4742564124. That is supposed to be the number of votes for each option. Since numvotes = 2, each option should have only 1 vote.

Are all your polls like that or just that one? If just that one, edit that row so votes is 1||~|~||1
Have you hugged someone today?
Locked

Return to “[3.0.x] Convertors”