Thursday, November 20, 2008   Search Register  Login  
  • .NET Programming
  • ASP.NET Website Design
  • DotNetNuke Modules
  • Photography
  • Videography
  • Video Editing
Forum
WESNet Designs Discussion Forum Minimize
All visitors to this site may view forum posts. Only registered users may create new posts or reply to existing posts.
SearchForum Home
     
  WESNet Designs Projects  ePrayer Module  Updated Version...
 Updated Version 04.02.01 Now Available
 
 4/7/2008 3:13:55 PM
admin
17 posts
www.wesnetdesigns.com


Updated Version 04.02.01 Now Available
 (United States) Modified By admin  on 4/7/2008 7:23:45 PM)

As of April 7, 2008, an updated version of my ePrayer module is now available free to registered site users. This version 04.02.01 provides the following fixes and/or enhancements:

  • Reference to new ModuleController.SynchronizeModule method available in DNN versions 4.6.x and above has been replaced by the deprecated PortalModuleBase.SynchronizeModule method to allow compatibility with DNN versions 4.05.05 and above.
  • Posting stats are now stored in a custom table rather than ModuleSettings fixing several errors due to caching of module settings data which caused posting stats to inconsistantly update as posts were added or deleted.
  • Anonymous (unauthenticated) users may now be given post permissions in the module's permissions grid. In earlier versions, even though post permission could be granted to the anonymous user, an error would result when the anonymous user submitted the post.
  • Tightened up security checks to ensure that anonymous users cannot delete or edit posts, request that an e-mail of encouragement be sent to the post's subject, etc.
  • Corrected several bugs relating to moderation of posts, particularly with respect to approval/rejection of posts submitted by an anonymous user.
  • Added a minimize/maximize icon to allow collapse or expansion of the request filter section at the top of the module's main view. For registered users, their preference as to whether this section is expanded or collapsed will be retained across visits to the site.
  • In previous versions, only one set of e-mail templates were maintained across all portals of a single DNN installation. The e-mail templates could be modified by any portal administrator potentially resulting in conflicts in the multi-portal installation. Now, the host user can specify whether e-mail templates are stored on a per portal or per installation basis. The default is per portal allowing each portal to have its own e-mail templates that are editable by that portal's administrators without conflicting with those applied to other portals. If the host specifies that e-mail templates are applied per installation, the one and only one set of e-mail templates becomes editable only by the host user.
  • Added a new function available to administrators on the action menu of the main module control. Manage Expired Posts allows the administrator to view which posts have expired (or which are marked with a particular status such as Withdrawn or Answered and created before a specified date) and selectively or as a group delete them from the database.
  • Corrected a bug relating to the paging of the user's grid on the administrator's Manage Users control. In prior versions, paging beyond the first page of users would redirect to the main view.
  • Provided a work-around to the rich text editor control used in the e-mail template editor on the module settings page not properly saving changes when used with DNN versions 4.8.x. 
  • Corrected and/or approved a number of minor bugs relating to the user interface.

The new module version may be installed over existing versions without loss of data. If you have modified the module's e-mail templates, the modified templates will automatically be applied by all child portals until a child portal administrator edits them. From that point on, that child portal will have its own set of templates.

While I cannot commit to providing support for this free offering of the ePrayer module, I will try to address all questions you pose via e-mail or here in the forums.

 4/10/2008 3:32:44 PM
admin
17 posts
www.wesnetdesigns.com


Re: Updated Version 04.02.01 Now Available
 (United States)

For anyone having difficulties downloading the new version 04.02.01 of the ePrayer module, I just noticed that the download link was intermittantly throwing application errors - apparently the file itself had become corrupt in the upload process. As of a few minutes ago I have replaced the module install file - downloads seem to be working well again.

Bill

 4/18/2008 12:18:53 AM
jhoelz
5 posts


Re: Updated Version 04.02.01 Now Available
 (United States)

I just installed this on a 4.8.2 install and received the following errors

StartJob Begin Sql execution
Info Executing 04.00.00.SqlDataProvider
StartJob Start Sql execution: 04.00.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near 'Rq'. 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) CREATE PROCEDURE dbo.[WESNet_EPrayer_GetPost] @PostID int as select P.*, Case EPU.IdentifyBy When 0 Then UC.Username When 1 Then UC.DisplayName When 2 Then EPU.Alias Else IsNull(UC.DisplayName, 'Anonymous') End As CreatedByUser, EPU.Signature, EU.DisplayName As EditedByUser, Rl.Relationship, Rq.IsPraise, Rq.Subject, C.Category from dbo.[WESNet_EPrayer_Posts] P join dbo.[WESNet_EPrayer_Requests] (nolock) Rq on P.RequestID=Rq.RequestID left outer join dbo.[Users] (nolock) UC on UC.UserID = P.CreatedByUserID left outer join dbo.[WESNet_EPrayer_Users] (nolock) EPU on EPU.UserID=P.CreatedByUserID AND EPU.ModuleID=Rq.ModuleID left outer join dbo.[Users] (nolock) EU on EU.UserID = P.EditedByUserID left outer join dbo.[WESNet_EPrayer_Relationships] (noLock) Rl on Rl.RelationshipID=P.RelationshipID left outer join dbo.[WESNet_EPrayer_Categories] (nolock) C on Rq.CategoryID = C.CategoryID where @PostID=P.PostID System.Data.SqlClient.SqlException: Incorrect syntax near 'Rq'. 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) CREATE PROCEDURE dbo.[WESNet_EPrayer_GetPosts] @RequestID int, @Distributions int, @GetUpdatesOnly bit = 0 as select P.*, Case EPU.IdentifyBy When 0 Then UC.Username When 1 Then UC.DisplayName When 2 Then EPU.Alias Else IsNull(UC.DisplayName, 'Anonymous') End As CreatedByUser, EPU.Signature, EU.DisplayName As EditedByUser, R.Relationship, Rq.IsPraise, Rq.Subject, C.Category from dbo.[WESNet_EPrayer_Posts] P join dbo.[WESNet_EPrayer_Requests] (nolock) Rq on P.RequestID=Rq.RequestID left outer join dbo.[Users] (nolock) UC on UC.UserID = P.CreatedByUserID left outer join dbo.[WESNet_EPrayer_Users] (nolock) EPU on EPU.UserID=P.CreatedByUserID AND EPU.ModuleID=Rq.ModuleID left outer join dbo.[Users] (nolock) EU on EU.UserID = P.EditedByUserID left outer join dbo.[WESNet_EPrayer_Relationships] (nolock) R on R.RelationshipID=P.RelationshipID left outer join dbo.[WESNet_EPrayer_Categories] (nolock) C on Rq.CategoryID = C.CategoryID where @RequestID=P.RequestID AND P.IsApproved = 1 AND ((P.Distribution & @Distributions)<>0) AND (@GetUpdatesOnly <> 1 OR (P.PostID <> P.RequestID)) order by P.CreatedDate; select COUNT(*) - @GetUpdatesOnly As 'TotalPosts' from dbo.[WESNet_EPrayer_Posts] (nolock) where @RequestID=RequestID AND IsApproved=1 AND ((Distribution & @Distributions)<>0) System.Data.SqlClient.SqlException: Incorrect syntax near 'EPU'. 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) CREATE PROCEDURE dbo.[WESNet_EPrayer_GetPostsToModerate] @ModuleID int AS SELECT P.*, CU.DisplayName As 'CreatedByUser', EPU.Signature, EU.DisplayName As 'EditedByUser', R.Relationship, Rq.IsPraise, Rq.Subject, C.Category, (SELECT Count(RequestID) FROM WESNet_EPrayer_Posts (nolock) WHERE RequestID=Rq.RequestID AND PostID <> Rq.RequestID) As 'Updates' FROM WESNet_EPrayer_Posts P (nolock) JOIN WESNet_EPrayer_Requests Rq (nolock) on P.RequestID=Rq.RequestID LEFT OUTER JOIN WESNet_EPrayer_Categories C (nolock) on C.CategoryID=Rq.CategoryID LEFT OUTER JOIN Users CU (nolock) on CU.UserID = P.CreatedByUserID LEFT OUTER JOIN WESNet_EPrayer_Users (nolock) EPU on EPU.UserID=P.CreatedByUserID AND EPU.ModuleID=Rq.ModuleID LEFT OUTER JOIN Users EU (nolock) on EU.UserID = P.EditedByUserID LEFT OUTER JOIN WESNet_EPrayer_Relationships R (nolock) on R.RelationshipID = P.RelationshipID WHERE Rq.ModuleID = @ModuleID AND P.IsApproved = 0 ORDER BY P.CreatedDate System.Data.SqlClient.SqlException: Incorrect syntax near 'P'. 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) CREATE PROCEDURE dbo.[WESNet_EPrayer_PostsToModerate] @ModuleID int AS SELECT Count(PostID) FROM WESNet_EPrayer_Posts (nolock) P, WESNet_EPrayer_Requests (nolock) R WHERE R.RequestID = P.RequestID AND R.ModuleID=@ModuleID and P.IsApproved=0 System.Data.SqlClient.SqlException: Incorrect syntax near 'R'. Incorrect syntax near 'P'. Incorrect syntax near 'P'. Incorrect syntax near 'P'. 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) CREATE PROCEDURE dbo.[WESNet_EPrayer_RefreshStats] @ModuleID int AS DECLARE @Requests int DECLARE @Updates int DECLARE @MostRecentRequestID int DECLARE @MostRecentPostID int DECLARE @MostRecentAuthorID int DECLARE @MostRecentPostDate datetime DECLARE @PostsToModerate int SELECT @Requests = Count(R.RequestID), @MostRecentRequestID = Max(R.RequestID) FROM WESNet_EPrayer_Requests (nolock) R, WESNet_EPrayer_Posts (nolock) P WHERE P.PostID = R.RequestID AND R.ModuleID = @ModuleID AND P.IsApproved = 1 SELECT @Updates = Count(PostID) FROM WESNet_EPrayer_Posts (nolock) P, WESNet_EPrayer_Requests (nolock) R WHERE P.RequestID = R.RequestID AND P.PostID <> R.RequestID AND R.ModuleID = @ModuleID AND P.IsApproved = 1 SELECT @MostRecentPostID = Max (PostID) FROM WESNet_EPrayer_Posts (nolock) P, WESNet_EPrayer_Requests (nolock) R WHERE P.RequestID = R.RequestID AND R.ModuleID = @ModuleID AND P.IsApproved=1 SELECT @MostRecentAuthorID = CreatedByUserID, @MostRecentPostDate = CreatedDate FROM WESNet_EPrayer_Posts (nolock) WHERE PostID = @MostRecentPostID SELECT @PostsToModerate = Count(PostID) FROM WESNet_EPrayer_Posts (nolock) P, WESNet_EPrayer_Requests (nolock) R WHERE R.RequestID = P.RequestID AND R.ModuleID=@ModuleID and P.IsApproved=0 EXEC WESNet_SaveModuleSetting @ModuleID, 'Requests', @Requests EXEC WESNet_SaveModuleSetting @ModuleID, 'Updates', @Updates EXEC WESNet_SaveModuleSetting @ModuleID, 'MostRecentRequestID', @MostRecentRequestID EXEC WESNet_SaveModuleSetting @ModuleID, 'MostRecentPostID', @MostRecentPostID EXEC WESNet_SaveModuleSetting @ModuleID, 'MostRecentAuthorID', @MostRecentAuthorID EXEC WESNet_SaveModuleSetting @ModuleID, 'MostRecentPostDate', @MostRecentPostDate EXEC WESNet_SaveModuleSetting @ModuleID, 'PostsToModerate', @PostsToModerate
EndJob End Sql execution: 04.00.00.SqlDataProvider file
 
Info Executing 04.01.00.SqlDataProvider
StartJob Start Sql execution: 04.01.00.SqlDataProvider file
EndJob End Sql execution: 04.01.00.SqlDataProvider file
 
Info Executing 04.01.01.SqlDataProvider
StartJob Start Sql execution: 04.01.01.SqlDataProvider file
EndJob End Sql execution: 04.01.01.SqlDataProvider file
 
Info Executing 04.02.00.SqlDataProvider
StartJob Start Sql execution: 04.02.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near 'Rq'. 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) CREATE PROCEDURE dbo.[WESNet_EPrayer_GetPost] @PostID int AS SELECT P.*, Case EPU.IdentifyBy When 0 Then UC.Username When 1 Then UC.DisplayName When 2 Then EPU.Alias Else IsNull(UC.DisplayName, '') End As CreatedByUser, EPU.Signature, EU.DisplayName As EditedByUser, Rl.Relationship, Rq.IsPraise, Rq.Subject, C.Category FROM dbo.[WESNet_EPrayer_Posts] P join dbo.[WESNet_EPrayer_Requests] (nolock) Rq on P.RequestID=Rq.RequestID left outer join dbo.[Users] (nolock) UC on UC.UserID = P.CreatedByUserID left outer join dbo.[WESNet_EPrayer_Users] (nolock) EPU on EPU.UserID=P.CreatedByUserID AND EPU.ModuleID=Rq.ModuleID left outer join dbo.[Users] (nolock) EU on EU.UserID = P.EditedByUserID left outer join dbo.[WESNet_EPrayer_Relationships] (noLock) Rl on Rl.RelationshipID=P.RelationshipID left outer join dbo.[WESNet_EPrayer_Categories] (nolock) C on Rq.CategoryID = C.CategoryID where @PostID=P.PostID System.Data.SqlClient.SqlException: Incorrect syntax near 'Rq'. 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) CREATE PROCEDURE dbo.[WESNet_EPrayer_GetPosts] @RequestID int, @Distributions int, @GetUpdatesOnly bit = 0 as select P.*, Case EPU.IdentifyBy When 0 Then UC.Username When 1 Then UC.DisplayName When 2 Then EPU.Alias Else IsNull(UC.DisplayName, '') End As CreatedByUser, EPU.Signature, EU.DisplayName As EditedByUser, R.Relationship, Rq.IsPraise, Rq.Subject, C.Category from dbo.[WESNet_EPrayer_Posts] P join dbo.[WESNet_EPrayer_Requests] (nolock) Rq on P.RequestID=Rq.RequestID left outer join dbo.[Users] (nolock) UC on UC.UserID = P.CreatedByUserID left outer join dbo.[WESNet_EPrayer_Users] (nolock) EPU on EPU.UserID=P.CreatedByUserID AND EPU.ModuleID=Rq.ModuleID left outer join dbo.[Users] (nolock) EU on EU.UserID = P.EditedByUserID left outer join dbo.[WESNet_EPrayer_Relationships] (nolock) R on R.RelationshipID=P.RelationshipID left outer join dbo.[WESNet_EPrayer_Categories] (nolock) C on Rq.CategoryID = C.CategoryID where @RequestID=P.RequestID AND (P.IsApproved = 1) AND ((P.Distribution & @Distributions)<>0) AND (@GetUpdatesOnly <> 1 OR (P.PostID <> P.RequestID)) order by P.CreatedDate; select COUNT(*) - @GetUpdatesOnly As 'TotalPosts' from dbo.[WESNet_EPrayer_Posts] (nolock) where @RequestID=RequestID AND IsApproved=1 AND ((Distribution & @Distributions)<>0) System.Data.SqlClient.SqlException: Incorrect syntax near 'R'. Incorrect syntax near 'P'. Incorrect syntax near 'P'. Incorrect syntax near 'P'. 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) CREATE PROCEDURE dbo.[WESNet_EPrayer_RefreshStats] @ModuleID int AS DECLARE @Requests int DECLARE @Updates int DECLARE @MostRecentRequestID int DECLARE @MostRecentPostID int DECLARE @MostRecentAuthorID int DECLARE @MostRecentPostDate datetime DECLARE @PostsToModerate int SELECT @Requests = Count(R.RequestID), @MostRecentRequestID = Max(R.RequestID) FROM WESNet_EPrayer_Requests (nolock) R, WESNet_EPrayer_Posts (nolock) P WHERE P.PostID = R.RequestID AND R.ModuleID = @ModuleID AND P.IsApproved = 1 SELECT @Updates = Count(PostID) FROM WESNet_EPrayer_Posts (nolock) P, WESNet_EPrayer_Requests (nolock) R WHERE P.RequestID = R.RequestID AND P.PostID <> R.RequestID AND R.ModuleID = @ModuleID AND P.IsApproved = 1 SELECT @MostRecentPostID = Max (PostID) FROM WESNet_EPrayer_Posts (nolock) P, WESNet_EPrayer_Requests (nolock) R WHERE P.RequestID = R.RequestID AND R.ModuleID = @ModuleID AND P.IsApproved=1 SELECT @MostRecentAuthorID = CreatedByUserID, @MostRecentPostDate = CreatedDate FROM WESNet_EPrayer_Posts (nolock) WHERE PostID = @MostRecentPostID SELECT @PostsToModerate = Count(PostID) FROM WESNet_EPrayer_Posts (nolock) P, WESNet_EPrayer_Requests (nolock) R WHERE R.RequestID = P.RequestID AND R.ModuleID=@ModuleID and P.IsApproved=0 EXEC WESNet_EPrayer_UpdateStats @ModuleId, @Requests, @Updates, @MostRecentRequestID, @MostRecentPostID, @MostRecentAuthorID, @MostRecentPostDate, @PostsToModerate
EndJob End Sql execution: 04.02.00.SqlDataProvider file
 4/18/2008 9:44:16 AM
admin
17 posts
www.wesnetdesigns.com


Re: Updated Version 04.02.01 Now Available
 (United States)

Jack,

Thanks for posting about that error. I'll check it out immediately. Please advise if you are running MS SQL Server 2000 or 2005 and confirm that you are NOT using an objectQualifier in your web.config.

Bill

 4/28/2008 8:19:44 AM
jhoelz
5 posts


Re: Updated Version 04.02.01 Now Available
 (United States)

NOT using an pbject qualifer and running MS SQL 2005 Express

 5/5/2008 10:09:59 AM
jhoelz
5 posts


Re: Updated Version 04.02.01 Now Available
 (United States)

Bill, have you had a chance to take a look at this?

 5/5/2008 10:45:29 AM
admin
17 posts
www.wesnetdesigns.com


Re: Updated Version 04.02.01 Now Available
 (United States)

I'm afraid I have not had any success finding why this and one other install that was reported to me failed when running the SQL scripts. At first I thought it was due to having a blank objectQualifier as that was the only common factor between the two failures. I have since tried several test installs with a blank objectQualifier with no problems.

Could you check to see which if any tables having a WESNet_EPrayer_ prefix were created during the install. If table creation had failed for the WESNet_EPrayer_Posts, WESNet_EPrayer_Requests, and WESNet_EPrayer_Users tables, the errors in table alias syntax generated during stored procedure creation may have resulted. In the other reported failure, only one out of twelve tables had been created but I'm not sure why.

 6/25/2008 10:15:43 PM
admin
17 posts
www.wesnetdesigns.com


Re: Updated Version 04.02.01 Now Available
 (United States)

Thanks to user "njuaire" we finally figured out the cause of several failed installs - the SqlDataProvider scripts for versions 04.00.00, 04.01.00, and 04.02.00 were not fully compatible with MS SQL Server 2000. These have been now modified and tested against MS SQL Server 2000 on his website. I have also found that even if one's DNN site is currently running on MS SQL Server 2005 but has the database's Compatibility Mode set to 80 (that is MS SQL Server 2000) rather than 90, while there would have been fewer errors raised, there would have been syntax errors in 6 stored procedures due to ordering of the (nolock) hint when an alias was also being applied to a table name in the FROM clause. Note that if you had upgraded your MS SQL Server installation from 2000 to 2005 or had transfered a database from 2000 to 2005, the Compatability Mode will be set to 80 not 90, effectively causing the module install to fail even though you may have reported that you were running against MS SQL Server 2005.

A new package for WESNet_EPrayer_04.02.01_Install.zip has been created and is now available in the downloads section. I have not incremented the version number as none of the prior versions would have had successful installs against MS SQL Server 2000. If you are running your site against MS SQL Server 2005 with Compatibility Mode set to 90 and have had a successful install of this version, do not upgrade the module.

  WESNet Designs Projects  ePrayer Module  Updated Version...
SearchSearch  Forum HomeForum Home     
  Minimize

Website design by WESNet Designs, William Severance
For comments, link requests, etc. please contact webmaster@wesnetdesigns.com

 Print   
Home  |  About Us  |  Forum  |  Downloads  |  Bill's Blog  |  Contact Us
Copyright 2005-2007 by WESNet Designs   |  Privacy Statement  |  Terms Of Use