david coulter
skipping stones Posts:13
|
06-08-2010 08:28 AM |
|
I received the following error when updating the Renewal module from 1.2 to 1.3 [DNN5.2].
Is this a bug or is there a patch?
Cheers
Dave
<!--[if gte mso 9]>
fficeDocumentSettings>
fficeDocumentSettings>
<!--[if gte mso 9]>
Normal
0
unctuationKerning />
false
false
false
oNotPromoteQF />
EN-US
X-NONE
X-NONE
ontGrowAutofit />
ontVertAlignCellWithSp />
ontBreakConstrainedForcedTables />
ontVertAlignInTxbx />
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:0;
mso-generic-font-family:roman;
mso-font-pitch:variable;
mso-font-signature:-1610611985 1107304683 0 0 159 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-1610611985 1073750139 0 0 159 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin-top:0in;
margin-right:0in;
margin-bottom:10.0pt;
margin-left:0in;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
.MsoPapDefault
{mso-style-type:export-only;
margin-bottom:10.0pt;
line-height:115%;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
<!--[if gte mso 10]>
Package Installation Report
See below for the results of the package installation
|
StartJob
|
Starting Installation
|
Info
|
Starting Installation - Renewal Reminder
|
Info
|
Starting Installation - Script
|
Info
|
Begin Sql execution
|
Info
|
Created - 01.10.00.SqlDataProvider
|
Info
|
Executing 01.10.00.SqlDataProvider
|
Info
|
Start Sql execution: 01.10.00.SqlDataProvider file
|
Warning
|
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'RRID'. Invalid column name 'RRID'. Invalid column name 'RRID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER PROCEDURE dbo.[DataSprings_RoleReminderGetAllWhoMatchCriteriaByRRID] (@RRID INT) AS BEGIN -- generate ##tempRR table -- drop table ##tempRR if exists IF object_id('tempdb..##tempRR') IS NOT NULL BEGIN DROP TABLE ##tempRR END -- drop table ##tempRR2 if exists IF object_id('tempdb..##tempRR2') is not null BEGIN DROP TABLE ##tempRR2 END declare @days int set @days = (select days from datasprings_rolereminder where id = @RRID) -- if positive days, remind user number of days before expirydate (role has not expired) IF (@days > 0) BEGIN SELECT u.userid , u.firstname , u.lastname , ur.roleid , u.username AS Username , u.email AS UserEmail , r.rolename , ur.expirydate , rr.days , rr.EmailFrom , rr.EmailTo , rr.CC , rr.BCC , rr.EmailSubject , CAST(rr.EmailMessage AS nvarchar(MAX)) AS EmailMessage , rr.LogVerificationDelay , MAX(ISNULL(rrlog.datetimesent, '1900-01-01T00:00:00.000')) AS DateTimeSent, r.portalid INTO ##tempRR FROM users u INNER JOIN userroles ur ON u.userid = ur.userid INNER JOIN roles r ON r.roleid = ur.roleid INNER JOIN datasprings_rolereminder rr ON ur.roleid = rr.roleid LEFT OUTER JOIN datasprings_rolereminderlog rrlog ON u.userid = rrlog.userid WHERE -- make sure user role expiration date >= today's date ( ur.expirydate >= GETDATE() ) -- make sure difference between user role expiration date and today is <= rr.days AND ( DATEDIFF(DAY,GETDATE(),ur.expirydate) <= rr.days ) -- check if difference between logs datetimesent and today's date is >= log verification delay AND ( u.userid = rrlog.userid and r.roleID=rrlog.roleID and rr.ID = rrlog.RRID OR rrlog.UserID IS NULL ) -- and equal to @RRID AND rr.id = @RRID GROUP BY u.userid , u.firstname , u.lastname , ur.roleid , u.username , u.email , r.rolename , ur.expirydate , rr.days , rr.EmailFrom , rr.EmailTo , rr.CC , rr.BCC , rr.EmailSubject , CAST(rr.EmailMessage AS nvarchar(MAX)) , rr.LogVerificationDelay , r.portalid HAVING ( DATEDIFF(DAY, MAX(ISNULL(rrlog.datetimesent, '1900-01-01T00:00:00.000')), GETDATE()) >= rr.logverificationdelay ) -- now select the distinct userid from the newly created ##tempRR table SELECT * FROM ##tempRR AS A WHERE datetimesent = (SELECT MAX(B.datetimesent) FROM ##tempRR AS B WHERE A.userid = B.userid ) END -- if negative days, remind user number of days after due date (role already has expired) IF (@days < 0) BEGIN SELECT u.userid , u.firstname , u.lastname , ur.roleid , u.username AS Username , u.email AS UserEmail , r.rolename , ur.expirydate , rr.days , rr.EmailFrom , rr.EmailTo , rr.CC , rr.BCC , rr.EmailSubject , CAST(rr.EmailMessage AS nvarchar(MAX)) AS EmailMessage , rr.LogVerificationDelay , MAX(ISNULL(rrlog.datetimesent, '1900-01-01T00:00:00.000')) AS DateTimeSent, r.portalid INTO ##tempRR2 FROM users u INNER JOIN userroles ur ON u.userid = ur.userid INNER JOIN roles r ON r.roleid = ur.roleid INNER JOIN datasprings_rolereminder rr ON ur.roleid = rr.roleid LEFT OUTER JOIN datasprings_rolereminderlog rrlog ON u.userid = rrlog.userid WHERE -- make sure user role expiration date + reminder days >= today's date ( DATEADD(DAY,ABS(rr.days),ur.expirydate) >= GETDATE() ) AND -- make sure role has already expired ( GETDATE() >= ur.expirydate ) -- make sure difference between user role expiration date and today is <= rr.days AND ( DATEDIFF(DAY,GETDATE(),ur.expirydate) <= ABS(rr.days) ) -- check if difference between logs datetimesent and today's date is >= log verification delay AND ( u.userid = rrlog.userid and r.roleID=rrlog.roleID and rr.ID = rrlog.RRID OR rrlog.UserID IS NULL ) -- and equal to @RRID AND rr.id = @RRID GROUP BY u.userid , u.firstname , u.lastname , ur.roleid , u.username , u.email , r.rolename , ur.expirydate , rr.days , rr.EmailFrom , rr.EmailTo , rr.CC , rr.BCC , rr.EmailSubject , CAST(rr.EmailMessage AS nvarchar(MAX)) , rr.LogVerificationDelay , r.portalid HAVING ( DATEDIFF(DAY, MAX(ISNULL(rrlog.datetimesent, '1900-01-01T00:00:00.000')), GETDATE()) >= rr.logverificationdelay ) -- now select the distinct userid from the newly created ##tempRR2 table SELECT * FROM ##tempRR2 AS A WHERE datetimesent = (SELECT MAX(B.datetimesent) FROM ##tempRR2 AS B WHERE A.userid = B.userid ) END -- if @days = 0 IF (@days = 0) BEGIN SELECT u.userid , u.firstname , u.lastname , ur.roleid , u.username AS Username , u.email AS UserEmail , r.rolename , ur.expirydate , rr.days , rr.EmailFrom , rr.EmailTo , rr.CC , rr.BCC , rr.EmailSubject , CAST(rr.EmailMessage AS nvarchar(MAX)) AS EmailMessage , rr.LogVerificationDelay , MAX(ISNULL(rrlog.datetimesent, '1900-01-01T00:00:00.000')) AS DateTimeSent, r.portalid INTO ##tempRR3 FROM users u INNER JOIN userroles ur ON u.userid = ur.userid INNER JOIN roles r ON r.roleid = ur.roleid INNER JOIN datasprings_rolereminder rr ON ur.roleid = rr.roleid LEFT OUTER JOIN datasprings_rolereminderlog rrlog ON u.userid = rrlog.userid WHERE -- make sure user role expiration date = today's date ( convert(varchar,ur.expirydate,101) = convert(varchar,GETDATE(),101) ) -- make sure difference between user role expiration date and today is <= rr.days AND ( DATEDIFF(DAY,GETDATE(),ur.expirydate) <= rr.days ) -- check if difference between logs datetimesent and today's date is >= log verification delay AND ( u.userid = rrlog.userid and r.roleID=rrlog.roleID and rr.ID = rrlog.RRID OR rrlog.UserID IS NULL ) -- and equal to @RRID AND rr.id = @RRID GROUP BY u.userid , u.firstname , u.lastname , ur.roleid , u.username , u.email , r.rolename , ur.expirydate , rr.days , rr.EmailFrom , rr.EmailTo , rr.CC , rr.BCC , rr.EmailSubject , CAST(rr.EmailMessage AS nvarchar(MAX)) , rr.LogVerificationDelay , r.portalid HAVING ( DATEDIFF(DAY, MAX(ISNULL(rrlog.datetimesent, '1900-01-01T00:00:00.000')), GETDATE()) >= rr.logverificationdelay ) -- now select the distinct userid from the newly created ##tempRR3 table SELECT * FROM ##tempRR3 AS A WHERE datetimesent = (SELECT MAX(B.datetimesent) FROM ##tempRR3 AS B WHERE A.userid = B.userid ) END END
|
Info
|
End Sql execution: 01.10.00.SqlDataProvider file
|
Info
|
Created - 01.20.00.SqlDataProvider
|
Info
|
Executing 01.20.00.SqlDataProvider
|
Info
|
Start Sql execution: 01.20.00.SqlDataProvider file
|
Warning
|
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'RRID'. Invalid column name 'RRID'. Invalid column name 'RRID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER PROCEDURE dbo.[DataSprings_RoleReminderGetAllWhoMatchCriteriaByRRID] (@RRID INT) AS BEGIN -- generate ##tempRR table -- drop table ##tempRR if exists IF object_id('tempdb..##tempRR') IS NOT NULL BEGIN DROP TABLE ##tempRR END -- drop table ##tempRR2 if exists IF object_id('tempdb..##tempRR2') is not null BEGIN DROP TABLE ##tempRR2 END -- drop table ##tempRR3 if exists IF object_id('tempdb..##tempRR3') is not null BEGIN DROP TABLE ##tempRR3 END declare @days int set @days = (select days from datasprings_rolereminder where id = @RRID) -- if positive days, remind user number of days before expirydate (role has not expired) IF (@days > 0) BEGIN SELECT u.userid , u.firstname , u.lastname , ur.roleid , u.username AS Username , u.email AS UserEmail , r.rolename , ur.expirydate , rr.days , rr.EmailFrom , rr.EmailTo , rr.CC , rr.BCC , rr.EmailSubject , CAST(rr.EmailMessage AS nvarchar(MAX)) AS EmailMessage , rr.LogVerificationDelay , MAX(ISNULL(rrlog.datetimesent, '1900-01-01T00:00:00.000')) AS DateTimeSent, r.portalid INTO ##tempRR FROM users u INNER JOIN userroles ur ON u.userid = ur.userid INNER JOIN roles r ON r.roleid = ur.roleid INNER JOIN datasprings_rolereminder rr ON ur.roleid = rr.roleid LEFT OUTER JOIN datasprings_rolereminderlog rrlog ON u.userid = rrlog.userid and r.roleID=rrlog.roleID and rr.ID=rrlog.RRID WHERE -- make sure user role expiration date >= today's date ( ur.expirydate >= GETDATE() ) -- make sure difference between user role expiration date and today is <= rr.days AND ( DATEDIFF(DAY,GETDATE(),ur.expirydate) <= rr.days ) -- and equal to @RRID AND rr.id = @RRID GROUP BY u.userid , u.firstname , u.lastname , ur.roleid , u.username , u.email , r.rolename , ur.expirydate , rr.days , rr.EmailFrom , rr.EmailTo , rr.CC , rr.BCC , rr.EmailSubject , CAST(rr.EmailMessage AS nvarchar(MAX)) , rr.LogVerificationDelay , r.portalid HAVING ( DATEDIFF(DAY, MAX(ISNULL(rrlog.datetimesent, '1900-01-01T00:00:00.000')), GETDATE()) >= rr.logverificationdelay ) -- now select the distinct userid from the newly created ##tempRR table SELECT * FROM ##tempRR AS A WHERE datetimesent = (SELECT MAX(B.datetimesent) FROM ##tempRR AS B WHERE A.userid = B.userid ) END -- if negative days, remind user number of days after due date (role already has expired) IF (@days < 0) BEGIN SELECT u.userid , u.firstname , u.lastname , ur.roleid , u.username AS Username , u.email AS UserEmail , r.rolename , ur.expirydate , rr.days , rr.EmailFrom , rr.EmailTo , rr.CC , rr.BCC , rr.EmailSubject , CAST(rr.EmailMessage AS nvarchar(MAX)) AS EmailMessage , rr.LogVerificationDelay , MAX(ISNULL(rrlog.datetimesent, '1900-01-01T00:00:00.000')) AS DateTimeSent, r.portalid INTO ##tempRR2 FROM users u INNER JOIN userroles ur ON u.userid = ur.userid INNER JOIN roles r ON r.roleid = ur.roleid INNER JOIN datasprings_rolereminder rr ON ur.roleid = rr.roleid LEFT OUTER JOIN datasprings_rolereminderlog rrlog ON u.userid = rrlog.userid and r.roleID=rrlog.roleID and rr.ID=rrlog.RRID WHERE -- make sure user role expiration date + reminder days >= today's date ( DATEADD(DAY,ABS(rr.days),ur.expirydate) >= GETDATE() ) AND -- make sure role has already expired ( GETDATE() >= ur.expirydate ) -- make sure difference between user role expiration date and today is <= rr.days AND ( DATEDIFF(DAY,GETDATE(),ur.expirydate) <= ABS(rr.days) ) -- and equal to @RRID AND rr.id = @RRID GROUP BY u.userid , u.firstname , u.lastname , ur.roleid , u.username , u.email , r.rolename , ur.expirydate , rr.days , rr.EmailFrom , rr.EmailTo , rr.CC , rr.BCC , rr.EmailSubject , CAST(rr.EmailMessage AS nvarchar(MAX)) , rr.LogVerificationDelay , r.portalid HAVING ( DATEDIFF(DAY, MAX(ISNULL(rrlog.datetimesent, '1900-01-01T00:00:00.000')), GETDATE()) >= rr.logverificationdelay ) -- now select the distinct userid from the newly created ##tempRR2 table SELECT * FROM ##tempRR2 AS A WHERE datetimesent = (SELECT MAX(B.datetimesent) FROM ##tempRR2 AS B WHERE A.userid = B.userid ) END -- if @days = 0 IF (@days = 0) BEGIN SELECT u.userid , u.firstname , u.lastname , ur.roleid , u.username AS Username , u.email AS UserEmail , r.rolename , ur.expirydate , rr.days , rr.EmailFrom , rr.EmailTo , rr.CC , rr.BCC , rr.EmailSubject , CAST(rr.EmailMessage AS nvarchar(MAX)) AS EmailMessage , rr.LogVerificationDelay , MAX(ISNULL(rrlog.datetimesent, '1900-01-01T00:00:00.000')) AS DateTimeSent, r.portalid INTO ##tempRR3 FROM users u INNER JOIN userroles ur ON u.userid = ur.userid INNER JOIN roles r ON r.roleid = ur.roleid INNER JOIN datasprings_rolereminder rr ON ur.roleid = rr.roleid LEFT OUTER JOIN datasprings_rolereminderlog rrlog ON u.userid = rrlog.userid and r.roleID=rrlog.roleID and rr.ID=rrlog.RRID WHERE -- make sure user role expiration date = today's date ( convert(varchar,ur.expirydate,101) = convert(varchar,GETDATE(),101) ) -- and equal to @RRID AND rr.id = @RRID GROUP BY u.userid , u.firstname , u.lastname , ur.roleid , u.username , u.email , r.rolename , ur.expirydate , rr.days , rr.EmailFrom , rr.EmailTo , rr.CC , rr.BCC , rr.EmailSubject , CAST(rr.EmailMessage AS nvarchar(MAX)) , rr.LogVerificationDelay , r.portalid HAVING ( DATEDIFF(DAY, MAX(ISNULL(rrlog.datetimesent, '1900-01-01T00:00:00.000')), GETDATE()) >= rr.logverificationdelay ) -- now select the distinct userid from the newly created ##tempRR3 table SELECT * FROM ##tempRR3 AS A WHERE datetimesent = (SELECT MAX(B.datetimesent) FROM ##tempRR3 AS B WHERE A.userid = B.userid ) END END
|
Info
|
End Sql execution: 01.20.00.SqlDataProvider file
|
Info
|
Creating backup of previous version - Uninstall.SqlDataProvider
|
Info
|
Created - Uninstall.SqlDataProvider
|
Info
|
Finished Sql execution
|
Info
|
Component installed successfully - Script
|
Info
|
Starting Installation - Module
|
Info
|
Module registered successfully - Renewal Reminder
|
Info
|
Component installed successfully - Module
|
Info
|
Starting Installation - Assembly
|
Info
|
Assembly updated - bin\DataSprings.DNN.RoleReminder.SqlDataProvider.dll
|
Info
|
Creating backup of previous version - bin\DataSprings.DNN.RoleReminder.SqlDataProvider.dll
|
Info
|
Created - bin\DataSprings.DNN.RoleReminder.SqlDataProvider.dll
|
Info
|
Assembly updated - bin\DataSprings.DNN.RoleReminder.dll
|
Info
|
Creating backup of previous version - bin\DataSprings.DNN.RoleReminder.dll
|
Info
|
Created - bin\DataSprings.DNN.RoleReminder.dll
|
Info
|
Component installed successfully - Assembly
|
Info
|
Starting Installation - File
|
Info
|
Creating backup of previous version - RoleReminderManage.ascx
|
Info
|
Created - RoleReminderManage.ascx
|
Info
|
Creating backup of previous version - RoleReminderLog.ascx
|
Info
|
Created - RoleReminderLog.ascx
|
Info
|
Creating backup of previous version - App_LocalResources\RoleReminderManage.ascx.resx
|
Info
|
Created - App_LocalResources\RoleReminderManage.ascx.resx
|
Info
|
Creating backup of previous version - App_LocalResources\RoleReminderLog.ascx.resx
|
Info
|
Created - App_LocalResources\RoleReminderLog.ascx.resx
|
Info
|
Component installed successfully - File
|
Info
|
Installation committed
|
Info
|
Installation successful. - Renewal Reminder
|
Info
|
Deleted temporary install folder
|
EndJob
|
Installation successful.
|
|
|
|
|
|
|
|
|