Cheers, thats very helpful - that API method eventually calls the UpdateUser stored procedure which updates both the Users and UserPortals tables, so it's probable the error lies there.First thing to do is check the database logs to see if there were issues logged e.g. http://www.dotnetnuke.com/Resources/W...
If there were please post them here.
Secondly, when stored procedure or table upgrades have failed in the past it typically is caused by triggers added to core tables by 3rd party modules, could you please run the following and let me know the results
SELECT trigger_name = sysobjects.name, trigger_owner = USER_NAME(sysobjects.uid),table_schema = s.name, table_name = OBJECT_NAME(parent_obj),
isupdate = OBJECTPROPERTY( id, 'ExecIsUpdateTrigger'), isdelete = OBJECTPROPERTY( id, 'ExecIsDeleteTrigger'),
isinsert = OBJECTPROPERTY( id, 'ExecIsInsertTrigger'), isafter = OBJECTPROPERTY( id, 'ExecIsAfterTrigger'),
isinsteadof = OBJECTPROPERTY( id, 'ExecIsInsteadOfTrigger'),
[disabled] = OBJECTPROPERTY(id, 'ExecIsTriggerDisabled')
FROM sysobjects INNER JOIN sysusers ON sysobjects.uid = sysusers.uid
INNER JOIN sys.tables t ON sysobjects.parent_obj = t.object_id
INNER JOIN sys.schemas s ON t.schema_id = s.schema_id
WHERE sysobjects.type = 'TR'
If there are neither database errors logged, or triggers on core tables, then we need to either see the exact query (if you can record it in sql server profiler that would be brilliant), or else can you provide the details of the Tabs table and the UpdateUser stored procedure