Looping on "Processed 1 records Step 1 - Importing Missing Member Albums"

[jobbe]

I'm upgrading from latest VB4 version to 5; it looped at 96% in the phase "Processed 1 records Step 1 - Importing Missing Member Albums".
After more than 8 hours I closed the window and run again upgrade.php and it started at: Upgrading to 5.0.2
Status: Processing 5.0.2 Release Candidate 1, Step 1 of 4
"Processed 1 records Step 1 - Importing Missing Member Albums"

Now I gotta go at work and I'll leave the process running for about 11 hours. When 'll back home, do you think it's normal that it's still processing members albums, considering that there are a couple thousands members and only 5 have their albums?

Thanks a lot in advance.

[Trevor Hannant]

Check your server's error logs and see if there is a message there relating to the upgrade script.

[szantog]

I've got the same. During debugging I found the record, which caused the infinite loop. The "if (!$missingAlbums->valid())" never can be true on line 93, because the affected row on album table have invalid (non exists) userid. This will cause problem in step 2 or 3 also, when the same happens in with attachment table records..
The solution for me was manually update the album and attachment tables set to records as a valid user id:
UPDATE attachment SET userid = '{existing_userid}' WHERE contentid = '{affected_contentid}'
UPDATE album SET userid = '{existing_userid}' WHERE albumid = '{affected_contentid}'

Warning! I'm quite newbie in vbulletin, and it is not an official support answer, I just tell my experiences. Please wait, until the support confirm this.

[jobbe]

Check your server's error logs and see if there is a message there relating to the upgrade script.

Thanks for your reply, but I don't know where to look for server's error logs

I've got the same. During debugging I found the record, which caused the infinite loop. The "if (!$missingAlbums->valid())" never can be true on line 93, because the affected row on album table have invalid (non exists) userid. This will cause problem in step 2 or 3 also, when the same happens in with attachment table records..
The solution for me was manually update the album and attachment tables set to records as a valid user id:
UPDATE attachment SET userid = '{existing_userid}' WHERE contentid = '{affected_contentid}'
UPDATE album SET userid = '{existing_userid}' WHERE albumid = '{affected_contentid}'

Warning! I'm quite newbie in vbulletin, and it is not an official support answer, I just tell my experiences. Please wait, until the support confirm this.

Thanks szantog, but I dind't get the file to look for line 93

[szantog]

Thanks szantog, but I dind't get the file to look for line 93

It is in core/install/includes/class_upgrade_502rc1.php. But no need to modify this file.

[jobbe]

It is in core/install/includes/class_upgrade_502rc1.php. But no need to modify this file.

Thanks again. It's just that I don't get where to get server's error logs, so I can't know what's the affected contentID

[jobbe]

Check your server's error logs and see if there is a message there relating to the upgrade script.

There's nothing concerning upgrade.php on error logs

[szantog]

Thanks again. It's just that I don't get where to get server's error logs, so I can't know what's the affected contentID

Not a bad idea, put this in the line 150 of class_upgrade_502rc1.php:

$this->show_message(sprintf($this->phrase['core']['processed_records_x'], implode(', ', $albumIdList))); 

Theoretically you will see when the album id starts to repeat under 'Processed x records';
Don't forget to make a copy of file before modify, and revert after debugging, I'm not sure what is the policy of vbullettin about this hack.

[jobbe]

Instead of "Processed 1 records" it spits "Processed 1 records Processed 7 records"
Thanks for your reply

[szantog]

It's good, you get the affected album id (7). If you can access the database directly (cli, adminer, phpmyadmin), you can now check, what is the problem exactly.
Find the albumid 7 in the album table, than look at the userid field in this row. Then go to the user table, and try to search for the userid. If not exists, you have exactly same like me, the diagnosis is ready.
If userid is valid, check, whether the coverattachmentid value exists in the attachment table. (This two foreign key are in the album table.)
If every two value is exists, I don't have more idea..

[jobbe]

Can I have this problem solved by one of the Vbulletin support team?

[jobbe]

Solved.

[Wayne Luke]

This would be in relation to this issue here: http://jira.vbulletin.com/browse/VBV-9795