Issue: Member profile error after uninstall

  1. issueid=374 03-01-2016 08:49 PM
    Number of reported issues by lucky:
    Member profile error after uninstall
    The member profile section stops working after uninstall + fix

    Hi there,

    I have found an error with the tool, I had to uninstall the tool to make a fresh install of my vBulletin installation and I found an issue.

    Steps to reproduce:

    1. Install Project tools
    2. Create a project
    3. Enable activity stream for project tools or make sure that is working
    4. Go to your project and start doing stuff
    5. Go to your member profile and check the activity stream, make sure it contains stuff from project tools
    6. Go to admin cp, disable the plugin, uninstall the plugin
    7. Go to member profile, in my case was something like
    8. A 500 error is going to appear

    After some debugging I found that the error was produced because some data it's kept inside {PREFIX}_activitystream table, but not the data inside {PREFIX}_activitystreamtype.

    So I think a query was failing trying to join both and finding stuff in the first one but not in the second one. What I did was to check the existing type inside {PREFIX}_activitystreamtype and I build and run a query like this:

    DELETE FROM `{PREFIX}_activitystream` WHERE `typeid` NOT IN(1,2,3,4,5,6,7,8,9,10,11,12)

    That query removed all the types that I didn't have inside {PREFIX}_activitystreamtype, and with that I was able to access again the member profile.

    I think there is a missing step in the uninstall/install script.
Issue Details
Issue Number 374
Project Project Tools
Category Show Stopper
Status No Response
Priority 1 - Highest
Affected Version 2.2.2
Fixed Version (none)
Milestone (none)
Users able to reproduce bug 0
Users unable to reproduce bug 0
Assigned Users (none)
Tags (none)

  1. Note:
    This issue contains some replies but it seems you don't have the permission to show them. To see them, you should log in.

    Once logged in, if the administrator decided it, you can still be able to not see replies.
+ Reply