Great Ideas. Always Flowing.

We are not happy until you are happy. Client satisfaction guaranteed. Whatever your needs and requirements, we have the skills and resources for the job!

Quick login...


Or... now make it easy with Facebook Integration
Connect via Facebook



Top Sellers

Frustrated over the lack of customization for your user's registration fields? Dynamically setup your DNN Portal with custom registration fields, layout, questions, and other core integration options......

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to upload videos in various format and automatically encode them to flv or H264 format, you also can add videos from internet or record live videos from your webcam.

Build high performance, completely customizable data-entry forms and views driven by your DNN and external databases. New built-in tools make it a snap to quickly create data entry forms, data views, and even database tables. Plus, add your own HTML, CSS, Javascript, SQL commands, stored procedures,

The most advanced DotNetNuke shopping cart on the planet. Easy to use e-Commerce, Secure Shopping Cart Software and SEO friendly. B2C / B2B Ecommerce Sites.

One stop solution for events calendar and events registration! FREE DOWNLOAD is available now!

Upgrade Error
Last Post 06-10-2010 02:34 PM by Chad Nash. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
david coulterUser is Offline
skipping stones
skipping stones
Posts:13
Avatar

--
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.

     

     

     

    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    06-10-2010 02:34 PM
    Hi David,

    Do you have Renewal Reminder already configured? I am wondering if you can do a full uninstall/reinstall and this could be an upgrade issue. If you already have it configured though I can dig in further to find out what happened during the upgrade.

    -Chad
    You are not authorized to post a reply.


     
     

    Join our mailing list...

    Get current news and events the easy way
     
     
       
    Subscribe Me

    Recent Blogs...

     
    Copyright 2005 - 2011 by Data Springs, Inc.
     
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi