VBulletin broken: WSN Support

VBulletin broken
Defunct PM folders

Version: 3.3.5

VBulletin broken

kontrabass

Usergroup: Customer
Joined: May 18, 2004
Total Topics: 3
Total Posts: 10

Posted 02/13/06 - 11:57 AM:	#1
I can't confirm this for certain, but I suspect my attempt to upgrade my WSN Links install to latest version has messed with my VBulletin 3.5.3 intallation. Problem: VBulletin users can no longer access their custom PM folders (users can create new folders in which to store private messages). This error coincided with my upgrade of WSN Links. The upgrade added a whole slew of things to my VBulletin user table: (Adding member fields: timezone rating pmfolders notifyofpms acceptpms cookieduration banned location homepage occupation bio aim icq msn yahoo inactive timeonline totalpms buddies ignored isonline acceptims adminpermissions referrer groupreverttime grouprevertto moderationpm secondarygroups linksperpage commentsperpage shouts customtitle shoutban topicbans forumbans visibility birthdate lastsession interests posteditor forumaccess pmpopup pmnotify modnotes guestnotes salt lastmodnote newpms imflag orderalbums lastguestnote autosubscribe notifymethod showavatars showsigs warninglevel topics posts chatcolor) And what else it did I don't know. But my VBulletin is broken and I'm getting a strong sense it was related to my links upgrade.

kontrabass

Usergroup: Customer
Joined: May 18, 2004
Total Topics: 3
Total Posts: 10

Posted 02/13/06 - 12:03 PM:	#2
Is there an uninstall script for WSN? Or an easy way to clean out my VBulletin User table?

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6316

Posted 02/13/06 - 09:09 PM:	#3
I don't see signature listed in your list, but I've seen the signature field cause a problem before because vB has a field in another table it uses with the same name. Haven't seen that with recent versions of vB though, that was back around 2.3.0 or so that field caused a problem on my site. Fields can be deleted with phpmyadmin.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

kontrabass

Usergroup: Customer
Joined: May 18, 2004
Total Topics: 3
Total Posts: 10

Posted 02/14/06 - 07:11 AM:	#4
Is there a file/list where I can see every change specifically, every mysql command, that the WSN install/upgrade performed on my VBulletin tables? That would help a lot.

kontrabass

Usergroup: Customer
Joined: May 18, 2004
Total Topics: 3
Total Posts: 10

Posted 02/14/06 - 07:13 AM:	#5
Also, is the "user" table the only one modified, or are there others? Thanks.

kontrabass

Usergroup: Customer
Joined: May 18, 2004
Total Topics: 3
Total Posts: 10

Posted 02/14/06 - 07:22 AM:	#6
Paul, Figured it out. The field "pmfolders" added to the VBulletin "user" table breaks the VBulletin 3.5 PM system, FYI. Probably for the same reason that you mentioned above - the user[pmfolders] var is used by VB php script, probably grabbed the info from the WSN user field. Still though as I continue to 'clean house' the specific DB changes would help. Thanks. Edited by kontrabass on 02/14/06 - 07:30 AM

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6316

Posted 02/16/06 - 03:51 AM:	#7
Okay, adding a $newpmfolders = 'wsnpmfolders'; line to the integration file should make them use different fields... might have to manually create wsnpmfolders. The changes are that any fields in wsnlinks_members that aren't in user are added to user.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

You don't have permission to post.