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:
- Install Project tools
- Create a project
- Enable activity stream for project tools or make sure that is working
- Go to your project and start doing stuff
- Go to your member profile and check the activity stream, make sure it contains stuff from project tools
- Go to admin cp, disable the plugin, uninstall the plugin
- Go to member profile, in my case was something like www.mysite.com/members/user
- 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.