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:
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.
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
I just installed this on a 4.8.2 install and received the following errors
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.
NOT using an pbject qualifer and running MS SQL 2005 Express
Bill, have you had a chance to take a look at this?
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.
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.
Website design by WESNet Designs, William SeveranceFor comments, link requests, etc. please contact webmaster@wesnetdesigns.com