Register   Login
     
  Latest Posts  
custom field type:url
by aviavia on 11/23/2008 7:13 PM
Module Development Techniques
by hchattaway on 11/23/2008 5:14 PM
Customizing the URL a little further
by tmahmud on 11/23/2008 4:11 PM
RE: Google Maps
by smcculloch on 11/23/2008 10:29 AM
RE: I cant get rss feeds to work correctly
by smcculloch on 11/23/2008 10:27 AM
captcha still proken
by StatisticsIO on 11/23/2008 6:11 AM
RE: Comments RSS feeds
by StatisticsIO on 11/23/2008 6:09 AM
Regions and Copuntry List scripts for Location Types
by rodneyjoyce on 11/23/2008 4:56 AM
RE: BUG: Sort by: Price
by usheen on 11/23/2008 1:23 AM
RE: News Articles 301 Redirect
by mcox on 11/22/2008 11:16 PM
  Forums  
Subject: News Article DNN4
Prev Next
You are not authorized to post a reply.

Author Messages
Aaron CrowUser is Offline
Registered Users
Nuke Newbie
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 McCullochUser is Offline
Administrators
Nuke Master
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 CorpuzUser is Offline
Registered Users
Nuke Newbie
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 McCullochUser is Offline
Administrators
Nuke Master
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 CorpuzUser is Offline
Registered Users
Nuke Newbie
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 McCullochUser is Offline
Administrators
Nuke Master
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.
Forums > General > Bugs & Problems > News Article DNN4



ActiveForums 3.7