This post seemed to be on point with my problems, but the SQL failed to locate any faulty users. This modification did the trick for me (including aspnet_profile in the test): Like above: Use this SQL at your own risk.
--First run this to see if the tables are out of Sync:
select u.userid, au.username as a_user, u.username as u_user, u.email
,ap.propertyvaluesstring
from aspnet_Users au
left outer join Users u
on au.UserName = U.UserName
left join aspnet_profile ap
on ap.userid = au.userid
where U.UserName is null or ap.propertyvaluesstring is null
order by u.username
go
--If that returns records then you can remove them by running this:
DECLARE @UserName varchar (50)
--get a cursor to hold all the orphaned users
--that are in aspnet_Users table that are not in the DNN Users table
DECLARE users_cursor CURSOR FOR
SELECT au.UserName from aspnet_Users au
left outer join Users u
on au.UserName = U.UserName
left join aspnet_profile ap
on ap.userid = au.userid
where U.UserName is null or ap.propertyvaluesstring is null
OPEN users_cursor
-- Perform the first fetch.
FETCH NEXT FROM users_cursor INTO @UserName
-- Check @@FETCH_STATUS to see if there are any more rows to fetch.
WHILE @@FETCH_STATUS = 0
BEGIN
--delete the user from all the aspnet_* tables that it may be in
--one at a time to avoid referrential integrity constraints
delete from aspnet_Membership where UserId =
(select am.UserId from aspnet_Membership am inner join aspnet_Users au on am.UserId = au.UserId
where au.Username =@UserName)
delete from aspnet_Profile where UserId =
(select ap.UserId from aspnet_Profile ap inner join aspnet_Users au on ap.UserId = au.UserId
where au.Username =@UserName)
delete from aspnet_UsersInRoles where UserId
in (select uir.UserId from aspnet_UsersInRoles uir inner join aspnet_Users au on uir.UserId = au.UserId
where au.Username =@UserName)
delete from aspnet_Users where Username =@UserName
--get a cursor to hold all the orphaned users
--that are in aspnet_Users table that are not in the DNN Users table
DECLARE users_cursor CURSOR FOR
SELECT au.UserName FROM aspnet_Users au
LEFT OUTER JOIN Users u on au.UserName = U.UserName
WHERE U.UserName is null
OPEN users_cursor
-- Perform the first fetch.
FETCH NEXT FROM users_cursor INTO @UserName
-- Check @@FETCH_STATUS to see if there are any more rows to fetch.
WHILE @@FETCH_STATUS = 0
BEGIN
--delete the user from all the aspnet_* tables that it may be in
--one at a time to avoid referrential integrity constraints
delete aspnet_Membership where UserId =
(select am.UserId from aspnet_Membership am inner join aspnet_Users au on am.UserId = au.UserId
where au.Username =@UserName AND PortalId=0)
delete aspnet_Profile where UserId =
(select ap.UserId from aspnet_Profile ap inner join aspnet_Users au on ap.UserId = au.UserId
where au.Username =@UserName AND PortalId=0)
delete aspnet_UsersInRoles where UserId
in (select uir.UserId from aspnet_UsersInRoles uir inner join aspnet_Users au on uir.UserId = au.UserId
where au.Username =@UserName AND PortalId=0)
delete from aspnet_Users where Username =@UserName
FETCH NEXT FROM users_cursor INTO @UserName
END
CLOSE users_cursor
DEALLOCATE users_cursor
GO
But I still get the error: There is an error in your query!
When I run the normal script in the query analyzer I get:
Server: Msg 512, Level 16, State 1, Line 21
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
(0 row(s) affected)
(0 row(s) affected)
Server: Msg 547, Level 16, State 1, Line 32
DELETE statement conflicted with COLUMN REFERENCE constraint 'FK__aspnet_Me__UserI__76D69450'. The conflict occurred in database 'NukeSqlServer', table 'aspnet_Membership', column 'UserId'.
The statement has been terminated.
Server: Msg 512, Level 16, State 1, Line 21
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
(0 row(s) affected)
(0 row(s) affected)
Server: Msg 547, Level 16, State 1, Line 32
DELETE statement conflicted with COLUMN REFERENCE constraint 'FK__aspnet_Me__UserI__76D69450'. The conflict occurred in database 'NukeSqlServer', table 'aspnet_Membership', column 'UserId'.
The statement has been terminated.
Does someone have another option for me to solve this problem?
I'm having the same problem where I can't create a new portal and this script (below) still retuns results.
select * from aspnet_Users au left outer join Users u on au.UserName = U.UserName where U.UserName is null
I've upgraded to 3.1.1 tonight hoping that this would fix the problem and it hasn't. If anybody can give me some help here I'd greatly appreciate it. I've got so much invested in my current installation that it would be a nightmare to just up and start over.
Fixing it is really the best option for me!
I too am having this problem. I have tried to run the scripts and it does not return out of sync entries. I have had to use osql on a different machine. My enterprise manager is down right now. Does anyone have any ideas?
I'm having this problem as well. My site had already been upgraded past 3.0.13 to 3.1.0 before I discovered the problem, so I don't think that the earlier posts about changing the revision number in dnn.config is helping. Geert's script to detect and fix
the symptoms (user accounts page not displaying) works, but I have no idea how to solve the root cause.
Is there a way to fix this even though I've already upgraded to 3.1.0? Any help would be greatly appreciated!!!
The plot thickens... I went searching through the install directory looking for *.sql files thinking that perhaps something didn't get applied to the database during one of the upgrades. I discovered the %root%\Providers\DataProviders\SqlDataProvider folder,
and in it found what appear to be the log files for the SQL portion of the upgrades that have been performed on this portal. In particular, it looks like back in March an upgrade to 3.00.12 (03.00.12.log) had some problems (lines cut for brevity -- please
let me know if I need to post all of them):
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModuleControls'. Cannot insert duplicate key in object 'ModuleControls'.
The upgrade to 3.00.13 on 9/21 had more problems (03.00.13.log):
System.Data.SqlClient.SqlException: 'FK_Profile_Users' is not a constraint.
Could not drop constraint. See previous errors.
...
ALTER TABLE dbo.Profile
DROP CONSTRAINT FK_Profile_Users
...
System.Data.SqlClient.SqlException: 'FK_UsersOnline_Users' is not a constraint.
Could not drop constraint. See previous errors.
...
ALTER TABLE dbo.UsersOnline
DROP CONSTRAINT FK_UsersOnline_Users
...
System.Data.SqlClient.SqlException: Invalid column name 'Email'.
...
create procedure dbo.AddUser
...
System.Data.SqlClient.SqlException: Invalid column name 'Email'.
...
create procedure dbo.UpdateUser
And finally 03.01.00.log had even more:
System.Data.SqlClient.SqlException: Invalid column name 'ModuleName'.
...
CREATE procedure dbo.AddDesktopModule
...
System.Data.SqlClient.SqlException: Invalid column name 'ModuleName'.
...
CREATE procedure dbo.UpdateDesktopModule
...
System.Data.SqlClient.SqlException: Invalid column name 'ModuleName'.
...
CREATE procedure dbo.GetDesktopModuleByModuleName
...
System.Data.SqlClient.SqlException: Invalid column name 'DefaultCacheTime'.
...
CREATE procedure dbo.AddModuleDefinition
...
System.Data.SqlClient.SqlException: Invalid column name 'DefaultCacheTime'.
...
CREATE procedure dbo.UpdateModuleDefinition
...
System.Data.SqlClient.SqlException: Invalid column name 'SupportedFeatures'.
...
CREATE PROCEDURE dbo.GetSearchModules
...
System.Data.SqlClient.SqlException: Invalid column name 'Servers'.
...
CREATE PROCEDURE dbo.GetSchedule
...
System.Data.SqlClient.SqlException: Invalid column name 'Servers'.
...
CREATE PROCEDURE dbo.AddSchedule
...
System.Data.SqlClient.SqlException: Invalid column name 'Servers'.
...
CREATE PROCEDURE dbo.GetScheduleNextTask
...
System.Data.SqlClient.SqlException: Invalid column name 'Servers'.
...
CREATE PROCEDURE dbo.GetScheduleByTypeFullName
...
Error: The stored procedure 'dbo.AddSchedule' doesn't exist.
I've just started helping my brother support this portal, it looks like we're in a world of hurt right now. Is there any way to save ourselves and fix this mess? I discovered and fixed a series of duplicated tables in his database that I believe might have
been the root of it all -- there were 65 tables duplicated under two different object owners (the non dbo objects appear to be from a previous failed installation, they have all been deleted but are in a backup if they need to be restored).
Please, oh dotnetnuke gods, shine down upon me this evening! I've got extensive SQL DBA knowledge and previous ASP (couple of years have past) programming knowledge, but dotnetnuke is a new animal for me...
As a general rule, you should start a new thread. Posting in an old thread, unless providing new information or an answer will usually "hide" your request for help, since it will only be seen by few people.
Onto your problem:
1 - The scripts in the folder are used by DNN for the install and upgrade routines. When problems exist, DNN creates a log. Some of the lines you posted are probabbly from those logs. And mostly they say that the could not drop certain contraints because
of the described errors. Being an SQL DBA you should read them carefully to pinpoint the problemsand solve them
2 - What you say about the duplicated tables looks as if someone added a owner qualifier in the web.config in one of the installs or ran the scripts manually without it from the SQL module.
It will help to know a bit more about what exactly you did to upgrade DNN.
After looking into into the same folder on my server, it seems my problems started with the 3.0.13 upgrade. Here's a dump from that log:
System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'Email' in table 'dbo.Users' is specified more than once.
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
ALTER TABLE dbo.Users ADD
Email nvarchar(256) NULL
System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.AddUser', because it does not exist in the system catalog.
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
drop procedure dbo.AddUser
System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.UpdateUser', because it does not exist in the system catalog.
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
McMolar
Member
35 Points
7 Posts
Re: User Accounts is currently unavailable
Aug 17, 2005 01:21 PM|LINK
This post seemed to be on point with my problems, but the SQL failed to locate any faulty users. This modification did the trick for me (including aspnet_profile in the test): Like above: Use this SQL at your own risk.
--First run this to see if the tables are out of Sync:
select u.userid, au.username as a_user, u.username as u_user, u.email
,ap.propertyvaluesstring
from aspnet_Users au
left outer join Users u
on au.UserName = U.UserName
left join aspnet_profile ap
on ap.userid = au.userid
where U.UserName is null or ap.propertyvaluesstring is null
order by u.username
go
--If that returns records then you can remove them by running this:
DECLARE @UserName varchar (50)
--get a cursor to hold all the orphaned users
--that are in aspnet_Users table that are not in the DNN Users table
DECLARE users_cursor CURSOR FOR
SELECT au.UserName from aspnet_Users au
left outer join Users u
on au.UserName = U.UserName
left join aspnet_profile ap
on ap.userid = au.userid
where U.UserName is null or ap.propertyvaluesstring is null
OPEN users_cursor
-- Perform the first fetch.
FETCH NEXT FROM users_cursor INTO @UserName
-- Check @@FETCH_STATUS to see if there are any more rows to fetch.
WHILE @@FETCH_STATUS = 0
BEGIN
--delete the user from all the aspnet_* tables that it may be in
--one at a time to avoid referrential integrity constraints
delete from aspnet_Membership where UserId =
(select am.UserId from aspnet_Membership am inner join aspnet_Users au on am.UserId = au.UserId
where au.Username =@UserName)
delete from aspnet_Profile where UserId =
(select ap.UserId from aspnet_Profile ap inner join aspnet_Users au on ap.UserId = au.UserId
where au.Username =@UserName)
delete from aspnet_UsersInRoles where UserId
in (select uir.UserId from aspnet_UsersInRoles uir inner join aspnet_Users au on uir.UserId = au.UserId
where au.Username =@UserName)
delete from aspnet_Users where Username =@UserName
FETCH NEXT FROM users_cursor INTO @UserName
END
CLOSE users_cursor
DEALLOCATE users_cursor
GO
BarrierMan
Member
95 Points
19 Posts
Betreft: Re: User Accounts is currently unavailable
Aug 17, 2005 07:29 PM|LINK
DECLARE @UserName varchar (50)
--get a cursor to hold all the orphaned users
--that are in aspnet_Users table that are not in the DNN Users table
DECLARE users_cursor CURSOR FOR
SELECT au.UserName FROM aspnet_Users au
LEFT OUTER JOIN Users u on au.UserName = U.UserName
WHERE U.UserName is null
OPEN users_cursor
-- Perform the first fetch.
FETCH NEXT FROM users_cursor INTO @UserName
-- Check @@FETCH_STATUS to see if there are any more rows to fetch.
WHILE @@FETCH_STATUS = 0
BEGIN
--delete the user from all the aspnet_* tables that it may be in
--one at a time to avoid referrential integrity constraints
delete aspnet_Membership where UserId =
(select am.UserId from aspnet_Membership am inner join aspnet_Users au on am.UserId = au.UserId
where au.Username =@UserName AND PortalId=0)
delete aspnet_Profile where UserId =
(select ap.UserId from aspnet_Profile ap inner join aspnet_Users au on ap.UserId = au.UserId
where au.Username =@UserName AND PortalId=0)
delete aspnet_UsersInRoles where UserId
in (select uir.UserId from aspnet_UsersInRoles uir inner join aspnet_Users au on uir.UserId = au.UserId
where au.Username =@UserName AND PortalId=0)
delete from aspnet_Users where Username =@UserName
FETCH NEXT FROM users_cursor INTO @UserName
END
CLOSE users_cursor
DEALLOCATE users_cursor
GO
But I still get the error: There is an error in your query!
BarrierMan
Member
95 Points
19 Posts
Betreft: Re: User Accounts is currently unavailable
Aug 21, 2005 09:03 AM|LINK
Server: Msg 512, Level 16, State 1, Line 21
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
(0 row(s) affected)
(0 row(s) affected)
Server: Msg 547, Level 16, State 1, Line 32
DELETE statement conflicted with COLUMN REFERENCE constraint 'FK__aspnet_Me__UserI__76D69450'. The conflict occurred in database 'NukeSqlServer', table 'aspnet_Membership', column 'UserId'.
The statement has been terminated.
Server: Msg 512, Level 16, State 1, Line 21
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
(0 row(s) affected)
(0 row(s) affected)
Server: Msg 547, Level 16, State 1, Line 32
DELETE statement conflicted with COLUMN REFERENCE constraint 'FK__aspnet_Me__UserI__76D69450'. The conflict occurred in database 'NukeSqlServer', table 'aspnet_Membership', column 'UserId'.
The statement has been terminated.
Does someone have another option for me to solve this problem?
J7Mitch
Star
13145 Points
2632 Posts
Re: Betreft: Re: User Accounts is currently unavailable
Aug 21, 2005 01:51 PM|LINK
If you want to PM me with information to login as host on your install I may be able to help.
CybrEnergy
Member
381 Points
94 Posts
Re: Betreft: Re: User Accounts is currently unavailable
Aug 27, 2005 12:48 AM|LINK
select * from aspnet_Users au left outer join Users u on au.UserName = U.UserName where U.UserName is null
I've upgraded to 3.1.1 tonight hoping that this would fix the problem and it hasn't. If anybody can give me some help here I'd greatly appreciate it. I've got so much invested in my current installation that it would be a nightmare to just up and start over. Fixing it is really the best option for me!
Metrocomm
Member
5 Points
1 Post
Re: Betreft: Re: User Accounts is currently unavailable
Sep 08, 2005 03:41 AM|LINK
I too am having this problem. I have tried to run the scripts and it does not return out of sync entries. I have had to use osql on a different machine. My enterprise manager is down right now. Does anyone have any ideas?
dave.may
Member
20 Points
4 Posts
Re: Betreft: Re: User Accounts is currently unavailable
Oct 10, 2005 02:39 AM|LINK
Is there a way to fix this even though I've already upgraded to 3.1.0? Any help would be greatly appreciated!!!
dave.may
Member
20 Points
4 Posts
Re: Betreft: Re: User Accounts is currently unavailable
Oct 11, 2005 02:48 AM|LINK
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModuleControls'. Cannot insert duplicate key in object 'ModuleControls'.
The upgrade to 3.00.13 on 9/21 had more problems (03.00.13.log):
System.Data.SqlClient.SqlException: 'FK_Profile_Users' is not a constraint.
Could not drop constraint. See previous errors.
...
ALTER TABLE dbo.Profile
DROP CONSTRAINT FK_Profile_Users
...
System.Data.SqlClient.SqlException: 'FK_UsersOnline_Users' is not a constraint.
Could not drop constraint. See previous errors.
...
ALTER TABLE dbo.UsersOnline
DROP CONSTRAINT FK_UsersOnline_Users
...
System.Data.SqlClient.SqlException: Invalid column name 'Email'.
...
create procedure dbo.AddUser
...
System.Data.SqlClient.SqlException: Invalid column name 'Email'.
...
create procedure dbo.UpdateUser
And finally 03.01.00.log had even more:
System.Data.SqlClient.SqlException: Invalid column name 'ModuleName'.
...
CREATE procedure dbo.AddDesktopModule
...
System.Data.SqlClient.SqlException: Invalid column name 'ModuleName'.
...
CREATE procedure dbo.UpdateDesktopModule
...
System.Data.SqlClient.SqlException: Invalid column name 'ModuleName'.
...
CREATE procedure dbo.GetDesktopModuleByModuleName
...
System.Data.SqlClient.SqlException: Invalid column name 'DefaultCacheTime'.
...
CREATE procedure dbo.AddModuleDefinition
...
System.Data.SqlClient.SqlException: Invalid column name 'DefaultCacheTime'.
...
CREATE procedure dbo.UpdateModuleDefinition
...
System.Data.SqlClient.SqlException: Invalid column name 'SupportedFeatures'.
...
CREATE PROCEDURE dbo.GetSearchModules
...
System.Data.SqlClient.SqlException: Invalid column name 'Servers'.
...
CREATE PROCEDURE dbo.GetSchedule
...
System.Data.SqlClient.SqlException: Invalid column name 'Servers'.
...
CREATE PROCEDURE dbo.AddSchedule
...
System.Data.SqlClient.SqlException: Invalid column name 'Servers'.
...
CREATE PROCEDURE dbo.GetScheduleNextTask
...
System.Data.SqlClient.SqlException: Invalid column name 'Servers'.
...
CREATE PROCEDURE dbo.GetScheduleByTypeFullName
...
Error: The stored procedure 'dbo.AddSchedule' doesn't exist.
I've just started helping my brother support this portal, it looks like we're in a world of hurt right now. Is there any way to save ourselves and fix this mess? I discovered and fixed a series of duplicated tables in his database that I believe might have been the root of it all -- there were 65 tables duplicated under two different object owners (the non dbo objects appear to be from a previous failed installation, they have all been deleted but are in a backup if they need to be restored).
Please, oh dotnetnuke gods, shine down upon me this evening! I've got extensive SQL DBA knowledge and previous ASP (couple of years have past) programming knowledge, but dotnetnuke is a new animal for me...
Thanks in advance!!!
Dave.
hooligannes9...
All-Star
16504 Points
2917 Posts
Re: Betreft: Re: User Accounts is currently unavailable
Oct 11, 2005 01:27 PM|LINK
As a general rule, you should start a new thread. Posting in an old thread, unless providing new information or an answer will usually "hide" your request for help, since it will only be seen by few people.
Onto your problem:
1 - The scripts in the folder are used by DNN for the install and upgrade routines. When problems exist, DNN creates a log. Some of the lines you posted are probabbly from those logs. And mostly they say that the could not drop certain contraints because of the described errors. Being an SQL DBA you should read them carefully to pinpoint the problemsand solve them
2 - What you say about the duplicated tables looks as if someone added a owner qualifier in the web.config in one of the installs or ran the scripts manually without it from the SQL module.
It will help to know a bit more about what exactly you did to upgrade DNN.
CybrEnergy
Member
381 Points
94 Posts
Re: Betreft: Re: User Accounts is currently unavailable
Oct 13, 2005 03:56 PM|LINK
System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'Email' in table 'dbo.Users' is specified more than once.
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
ALTER TABLE dbo.Users ADD
Email nvarchar(256) NULL
System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.AddUser', because it does not exist in the system catalog.
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
drop procedure dbo.AddUser
System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.UpdateUser', because it does not exist in the system catalog.
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
drop procedure dbo.UpdateUser