I need some advice/help fixing this UserList bug:
http://www.webgui.org/bugs/tracker/user-list--template-problem
 
Some people have reported the UserList completely crashing. From the reports it looks like this is caused by entries in the userProfileField table that don't have a corresponding column in the userProfileData table. I think this is caused by earlier versions of the Dashboard that didn't delete its entries in the userProfileField table when it was deleted itself.
 
The purge method that does delete entries from the userProfileField table was added here:
https://svn.webgui.org/svnweb/plainblack/diff/WebGUI/lib/WebGUI/Asset/Wobject/Dashboard.pm?rev1=4809;rev2=4810
After that version the Dashboard names it's userProfileFields: 'contentPositions'.$assetId, before that version it was the other way around: $assetId.'contentPositions'.
The mysql error that was reported mentions a column that looks like it was added by the old version of Dashboard:
    * Unknown column 'userProfileData.RjXt9Ggl95L4cpsDDxydrAcontentPositions' in 'field list'
 
My first problem is that i can't confirm if i'm right because i don't have any sites that use Dashboards.
 
I'm also not sure how this bug should be fixed. I could build a check in the UserList to see if there are any profile fields that don't have a corresponding column in the userProfileData table. But i don't think that will be good for UserList's performance, which is already an issue now.
 
Another way to fix this would be to purge the entries from the userProfileField table that cause the problem. But i don't know enough about how the Dashboard works to be sure i can do this without causing any bigger problems.

Yung

If you're pretty sure that this is the problem, then I suggest writing  
a utility script that will check the integrity of the user profile  
table. Don't build it into User List. And then point the reporter of  
the bug to that script in the user contribs. That way you solve the  
problem, but don't add any impact on the User List asset.

I think i'll just change the User List to ignore anything that looks like it belongs to the Dashboard. That way i can find out if this is really the problem without messing with anyones database.

Yung