vB 3.x convertor

[D¡cky]

Still the same message. I wonder if the problem is just this one user or all users. Would you look up user 1038 and see which forums he/she moderates?

[Nando]

Weird! there isn't such userid. The last user is 1037.

[Nando]

So, no idea? Damn... the conversion was already in one of the last steps... So close to finish!

[D¡cky]

So, no idea? Damn... the conversion was already in one of the last steps... So close to finish!

I haven't had much of a chance to look into this. I should get some time tonight.

Are you sure that there is not a user 1038? It has to be somewhere. The convertor wouldn't just make it up. Would you take another look in the user's table? The id's don't always go in order. You can place them in order by clicking on the user id column heading while browsing the user's table. In the meantime, I will be look to see if it might be stored somewhere else.

[Nando]

Well, I double checked it and the last userid is 1037

[Nando]

Here's the print screen, maybe I'm looking in the wrong table, but I think this is not the case, let me know if it is! hehehe

[D¡cky]

You can remove the image now. We don't need email addresses being displayed.

The reason that user 1038 is showiing up in the error message is becuase the convertor adds 1 to the user_id. The problem is actually with vBulletin user 1037.

I just ran the convertor on a test database that I have and it ran through without any problems. It seems like the problem has something to do with the permissions of your vBulletin user 1037. I will see if I can come up with some debug code to narrow the problem down. In the meantime, look in the vBulletin forumpermissions table and see what forums user_group 2 has permissions assigned.

If you can come up anything that may be related to the permissions of that particular user, it may be helpful.

[Nando]

What happens if I simply delete the user? Will it work?

The forum permission you requested is in the attachment.

[xprojectsx]

delete this

[Nando]

delete what?

[Nando]

I tried deleting user 1037 and the issue wasn't it. I get the same error message regarding user 1036 now

Code: Select all

General Error
SQL ERROR [ mysql4 ]

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

SQL

INSERT INTO phpbb_acl_users (user_id, forum_id, auth_role_id) VALUES (1037, -1, 11)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/functions_convert.php
LINE: 1512
CALL: dbal_mysql->sql_query()

FILE: install/convertors/functions_vb30.php
LINE: 708
CALL: mass_auth()

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

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

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

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

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

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

[D¡cky]

That eliminates one possibility of the error. I will try to come up with some debugging code to narrow down the cause of the problem.

[Nando]

Oh, that's wonderful news!! I'll wait, thanks!

[D¡cky]

First, check the vB moderator table and see if there is anything funky with the forum_id

If you see nothing wrong, do this:

OPEN functions_vb30.php
FIND

Code: Select all

		// And now the moderators
		// We make sure that they have at least standard access to the forums they moderate in addition to the moderating permissions
		foreach ($user_access as $forum_id => $access_map)
		{
			$forum_id = (int) $forum_id;
print "<pre>".print_r($forum_id, true)."</pre>";
			foreach ($access_map as $access)
			{
print "<pre>".print_r($access, true)."</pre>";
				mass_auth('user_role', $forum_id, (int) phpbb_user_id($access['userid']), 'MOD_STANDARD');
				mass_auth('user_role', $forum_id, (int) phpbb_user_id($access['userid']), 'FORUM_STANDARD');
			}

REPLACE with

Code: Select all

		// And now the moderators
		// We make sure that they have at least standard access to the forums they moderate in addition to the moderating permissions
		foreach ($user_access as $forum_id => $access_map)
		{
			$forum_id = (int) $forum_id;

			foreach ($access_map as $access)
			{
				mass_auth('user_role', $forum_id, (int) phpbb_user_id($access['userid']), 'MOD_STANDARD');
				mass_auth('user_role', $forum_id, (int) phpbb_user_id($access['userid']), 'FORUM_STANDARD');
			}

When the convertor gets to phpbb_convert_authentication("third"), an array will be displayed on the screen. Wait until the screen background changes from white to silver/gray. Then do ctrl+a(select all), ctrl+c(copy). Paste the copy here.

[Nando]

Ok, I checked the table you asked and I have no idea if it looks funky or not. hehehe Define funky!

Here's a print screen. Do I have a green light to replace the code you posted above?

thanks!