leupold wrote
there seem to be duplicate userID entries in the userID table of your database. try to delete the duplicates and rerun the failed statement on users table of previous upgrade before retrying the failed statements.
i just verified that there are *not* duplicate user ids.
from what i can gather these are two tests:
SELECT
COLUMNPROPERTY( OBJECT_ID('dbo.[FolderPermission]'),'UserID','AllowsNull')
SELECT COLUMNPROPERTY( OBJECT_ID('dbo.[ModulePermission]'),'UserID','AllowsNull')
each of these ends up being '1', which isn't null, and based on the scripts i'd think the alter statements wouldn't be executed, but i could be wrong?
but then i read the exception message and it looks like it's not finding a key in the users table, which i did verify (there are no keys nor indexes). so... what happened to my users table? is that the problem?