|
|
| Author |
Messages |
|
Aaron Crow Registered Users
 Nuke Newbie Posts:1

 |
| 12/29/2005 11:59 AM |
|
Does News Article work with DNN 4? I can install successfully but adding the module generates this error.
Unhandled error loading module. DotNetNuke.Services.Exceptions.ModuleLoadException: Unhandled Error Adding Module to ContentPane ---> System.Data.SqlClient.SqlException: The query uses non-ANSI outer join operators ("*=" or "=*" . To run this query without modification, please set the compatibility level for current database to 80 or lower, using stored procedure sp_dbcmptlevel. It is strongly recommended to rewrite the query using ANSI outer join operators (LEFT OUTER JOIN, RIGHT OUTER JOIN). In the future versions of SQL Server, non-ANSI join operators will not be supported even in backward-compatibility modes. 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.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DnnForge.NewsArticles.SqlDataProvider.GetArticleListBySearchCriteria(Int32 moduleID, Int32[] categoryID, Int32 maxCount, Int32 maxAge, Boolean isApproved, DateTime startDate, String keywords, Boolean showHiddenAndExpired, Int32 authorID, Boolean showFeaturedOnly, String sortBy, Int32 month, Int32 year) at DnnForge.NewsArticles.ArticleController.GetArticleList(Int32 moduleID, Int32[] categoryID, Int32 maxCount, Int32 maxAge, Boolean isApproved, DateTime startDate, String keywords, Boolean showHiddenAndExpired, Int32 authorID, Boolean showFeaturedOnly, String sortBy, Int32 month, Int32 year) at DnnForge.NewsArticles.ucListing.BindListing() at DnnForge.NewsArticles.ucNewsListing.Page_Init(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.UserControl.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.AddedControl(Control control, Int32 index) at System.Web.UI.ControlCollection.Add(Control child) at DnnForge.NewsArticles.NewsArticles.LoadControlType() at DnnForge.NewsArticles.NewsArticles.Page_Init(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.UserControl.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.AddedControl(Control control, Int32 index) at System.Web.UI.ControlCollection.Add(Control child) at DotNetNuke.UI.Skins.Skin.InjectModule(Control objPane, ModuleInfo objModule, PortalSettings PortalSettings) --- End of inner exception stack trace --- |
|
|
|
|
Scott McCulloch Administrators
 Nuke Master Posts:12450


 |
| 12/30/2005 4:00 AM |
|
| If you set sql compatibility to 80, it should work, the fix is coming out in a few days. SQL 2005 is causing the problem.. |
|
Scott McCulloch Site Administrator |
|
|
Oliver Corpuz Registered Users
 Nuke Newbie Posts:2

 |
| 1/31/2006 9:26 AM |
|
I'm getting module load errors running News Articles 00.05.14 on DNN 4.0.02 and SQL Server 2000.
Odd thing is sometimes I get an error loading the page with the module and sometimes I don't. I can't push this into production until it is resolved.
 |
Unhandled error loading module. DotNetNuke.Services.Exceptions.ModuleLoadException: Unhandled Error Adding Module to ContentPane ---> System.NullReferenceException: Object reference not set to an instance of an object. at DnnForge.NewsArticles.ucListing.LoadTemplates() at DnnForge.NewsArticles.ucListing.BindListing() at DnnForge.NewsArticles.ucNewsListing.Page_Init(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.UserControl.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.AddedControl(Control control, Int32 index) at System.Web.UI.ControlCollection.Add(Control child) at DnnForge.NewsArticles.NewsArticles.LoadControlType() at DnnForge.NewsArticles.NewsArticles.Page_Init(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.UserControl.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.AddedControl(Control control, Int32 index) at System.Web.UI.ControlCollection.Add(Control child) at DotNetNuke.UI.Skins.Skin.InjectModule(Control objPane, ModuleInfo objModule, PortalSettings PortalSettings) --- End of inner exception stack trace --- |
|
|
|
|
|
Scott McCulloch Administrators
 Nuke Master Posts:12450


 |
| 1/31/2006 3:33 PM |
|
Hmm, this looks like an error when loading the templates, have you modified the templates? Do you have the correct permissions set to view the templates? Who is your webhost? (I've heard of this happening when server loads are high) |
|
Scott McCulloch Site Administrator |
|
|
Oliver Corpuz Registered Users
 Nuke Newbie Posts:2

 |
| 2/01/2006 7:08 AM |
|
Scott,
First off, I just want to let you know you rock. You're on your honeymoon and you'll still providing incredibly responsive support. That is truly amazing.
As for my problem, you were right, it was a template problem. I just threw the new template files into the "Default" folder, and overwrote what was there. Probably not a good idea. When I created a new directory in the templates directory of the module and selected the new template from the module's admin menu, it all started working correctly.
To help support this site and your work, I want to upgrade my membership to "Gold", what's the best way to do that?
Thanks so much.
Oliver
|
|
|
|
|
Scott McCulloch Administrators
 Nuke Master Posts:12450


 |
| 2/01/2006 3:54 PM |
|
Posted By ocorpuz on 2/01/2006 7:08 AM
Scott,
First off, I just want to let you know you rock. You're on your honeymoon and you'll still providing incredibly responsive support. That is truly amazing.
As for my problem, you were right, it was a template problem. I just threw the new template files into the "Default" folder, and overwrote what was there. Probably not a good idea. When I created a new directory in the templates directory of the module and selected the new template from the module's admin menu, it all started working correctly.
To help support this site and your work, I want to upgrade my membership to "Gold", what's the best way to do that?
Thanks so much.
Oliver
Hi Oliver,
I'm able to quickly sneak on the internet computers here after breakfast. 
I'm planning on better handling some of errors that might be caused out of template malfunctions, (which is something that happened here I think).
If you are a active silver subscriber, you can send the extra $15 dollars via paypal, and i'll upgrade with the additional 9 months access (manual process so may take up to a day). Subscription tools is coming this month, which will automate this process.
|
|
Scott McCulloch Site Administrator |
|
|
|
| You are not authorized to post a reply. |
|
|
|
ActiveForums 3.7
|
|