Register   Login
     
  Latest Posts  
How can landlords login and see all their properties?
by jmolhava on 8/21/2008 8:10 PM
RE: e-mail subscriptions
by doggiedaddy1 on 8/21/2008 5:11 PM
RE: 5.xx to upgrade 6.xx broke syndication
by HectorSosaJr on 8/21/2008 2:59 PM
RE: Can Subscription Tools do this?
by jkurzner on 8/21/2008 2:20 PM
RE: Spirit of time
by brekkjen on 8/21/2008 2:20 PM
RE: How to Show Agent Details and Contact Form
by tmahmud on 8/21/2008 1:21 PM
Disable banner link
by pehu on 8/21/2008 1:17 PM
How do you allow?
by makkabokka on 8/21/2008 8:15 AM
RE: How to Show Agent Details and Contact Form
by smcculloch on 8/21/2008 6:31 AM
RE: 5.xx to upgrade 6.xx broke syndication
by smcculloch on 8/21/2008 6:17 AM
  Forums  
Subject: New Articles 6.8 error
Prev Next
You are not authorized to post a reply.

Author Messages
Lance LongUser is Offline
Gold Membership
Nuke Wiz
Nuke Wiz
Posts:123


6/10/2008 7:56 AM  

I get the following error anywhere a list of articles appears:

Error: Article List is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Ambiguous column name 'Title'. ---> System.Data.SqlClient.SqlException: Ambiguous column name 'Title'. 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 Ventrian.NewsArticles.SqlDataProvider.GetArticleListBySearchCriteria(Int32 moduleID, Int32[] categoryID, Boolean matchAll, Int32 maxCount, Int32 maxAge, Boolean isApproved, Boolean isDraft, DateTime startDate, String keywords, Boolean showPending, Boolean showExpired, Int32 authorID, Boolean showFeaturedOnly, Boolean showNotFeaturedOnly, String sortBy, String sortDirection, Int32 month, Int32 year) at Ventrian.NewsArticles.ArticleController.GetArticleList(Int32 moduleID, Int32[] categoryID, Boolean matchAll, Int32 maxCount, Int32 maxAge, Boolean isApproved, Boolean isDraft, DateTime startDate, String keywords, Boolean showPending, Boolean showExpired, Int32 authorID, Boolean showFeaturedOnly, Boolean showNotFeaturedOnly, String sortBy, String sortDirection, Int32 month, Int32 year) at Ventrian.NewsArticles.ucListing.BindListing() at Ventrian.NewsArticles.ucNewsListing.Page_Init(Object sender, EventArgs e) --- End of inner exception stack trace ---



Lance LongUser is Offline
Gold Membership
Nuke Wiz
Nuke Wiz
Posts:123


6/10/2008 7:58 AM  

I have updated my template for the new Summary/Details tokens but this appears related to the title.  I try pagetitle out of desperation but nothing.  Is there something I didn't see regarding the title of the new version?



Lance LongUser is Offline
Gold Membership
Nuke Wiz
Nuke Wiz
Posts:123


6/10/2008 8:03 AM  

I narrowed this issue to the 'sort by' feature.  It will display in publish date order but not in title order.



Scott McCullochUser is Offline
Administrators
Nuke Master
Nuke Master
Posts:11300


6/10/2008 8:10 AM  
I assume your running the latest, this was fixed in the latest build. Can you please check your version?

Scott McCulloch
Site Administrator
Scott McCullochUser is Offline
Administrators
Nuke Master
Nuke Master
Posts:11300


6/10/2008 8:11 AM  
The latest version is 00.06.08, I suspect your running 00.06.07

Scott McCulloch
Site Administrator
Lance LongUser is Offline
Gold Membership
Nuke Wiz
Nuke Wiz
Posts:123


6/10/2008 8:16 AM  
I have 6.8 running

"News Articles - Allows you to publish News Articles to your portal. - 00.06.08 "


Scott McCullochUser is Offline
Administrators
Nuke Master
Nuke Master
Posts:11300


6/10/2008 8:25 AM  
Can you send me the content of the following stored procedure:

DnnForge_NewsArticles_GetArticleListBySearchCriteria

to support@ventrian.com

Scott McCulloch
Site Administrator
Robert AxfordUser is Offline
Gold Membership
Nuke Master
Nuke Master
Posts:657

6/10/2008 4:29 PM  
Hi Scott,

I've just now upgraded to 608 and can confirm that the sort by title is still returning that exception.

I'm going to try and get the info out and send it through - if I can figure out how

Rob
Scott McCullochUser is Offline
Administrators
Nuke Master
Nuke Master
Posts:11300


6/10/2008 4:30 PM  
Hmm, OK, I'll look into it.

There was a switch in the sql to adjust title to Article.Title

Scott McCulloch
Site Administrator
Robert AxfordUser is Offline
Gold Membership
Nuke Master
Nuke Master
Posts:657

6/10/2008 4:39 PM  
ok I've emailed what I think is the correct data through to you just now.
Rob
Lance LongUser is Offline
Gold Membership
Nuke Wiz
Nuke Wiz
Posts:123


6/17/2008 10:24 AM  
Works for me now. Thank you


You are not authorized to post a reply.
Forums > General > Bugs & Problems > New Articles 6.8 error



ActiveForums 3.7