Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    Leave a comment:


  • jobbe
    replied
    Solved.

    Leave a comment:


  • szantog
    commented on 's reply
    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
    replied
    Can I have this problem solved by one of the Vbulletin support team?

    Leave a comment:


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

    Leave a comment:


  • szantog
    replied
    Originally posted by jobbe View Post
    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:

    PHP Code:
    $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.

    Leave a comment:


  • jobbe
    replied
    Originally posted by Trevor Hannant View Post
    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

    Leave a comment:


  • jobbe
    replied
    Originally posted by szantog View Post
    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

    Leave a comment:


  • szantog
    replied
    Originally posted by jobbe View Post
    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.

    Leave a comment:


  • jobbe
    replied
    Originally posted by Trevor Hannant View Post
    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


    Originally posted by szantog View Post
    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

    Leave a comment:


  • szantog
    replied
    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.

    Leave a comment:


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

    Leave a comment:


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

    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.


Related Topics

Collapse

Working...
X