Register   Login
     
  Latest Posts  
RE: thumbnails and W3C validation
by greenflash on 3/17/2010 10:38 PM
RE: Dual PA modues on site for different levels of access?
by robax on 3/17/2010 9:38 PM
RE: Where is the NA Latest Article Module setting stored?
by ray-isc on 3/17/2010 9:10 PM
RE: Where is the NA Latest Article Module setting stored?
by Declic Video on 3/17/2010 8:46 PM
RE: News Article Detail and Lightbox
by ray-isc on 3/17/2010 6:57 PM
News Article Detail and Lightbox
by spirit on 3/17/2010 6:09 PM
Gallery Upload control not showing
by rward on 3/17/2010 6:07 PM
RE: Is there a way to add image, based on x of DATE
by ray-isc on 3/17/2010 5:25 PM
Tags and Related Articles
by spirit on 3/17/2010 4:34 PM
Tags and Filtering
by spirit on 3/17/2010 4:29 PM
  Forums  
Subject: Subscriptions Active Report Error
Prev Next
You are not authorized to post a reply.

Author Messages
Richard EdwardsUser is Offline
Registered Users
Ventrian Super Newbie
Ventrian Super Newbie
Posts:15

1/21/2007 9:47 AM  
Hi Scott,

I'm getting the following error with the 'Subscriptions Active' report:

Error: View Reports is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: ALTER TABLE DROP COLUMN failed because 'RowText' is the only data column in table '#Rows'. A table must have at least one data column. ---> System.Data.SqlClient.SqlException: ALTER TABLE DROP COLUMN failed because 'RowText' is the only data column in table '#Rows'. A table must have at least one data column. 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.SubscriptionTools.SqlDataProvider.ListReport(Int32 portalID, Int32 moduleID, ReportType reportType, DateTime dateStart, DateTime dateEnd) at DnnForge.SubscriptionTools.Entities.ReportController.List(Int32 portalID, Int32 moduleID, ReportType reportType, DateTime dateStart, DateTime dateEnd) at DnnForge.SubscriptionTools.Reports.cmdDisplay_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---

Richard Edwards
www.dnnstuff.com
Scott McCullochUser is Offline
Administrators
Ventrian Master
Ventrian Master
Posts:17191


1/22/2007 4:22 AM  
Thanks for reporting this, I think it occurs when there are no receipts.

Scott McCulloch
Site Administrator
Marc DrescherUser is Offline
Registered Users
Ventrian Newbie
Ventrian Newbie
Posts:6

1/23/2007 10:11 PM  
I recieved the same error after installing and was guessing it is because there are no records.
anna tarrantUser is Offline
Gold Membership
Ventrian Addict
Ventrian Addict
Posts:82

1/29/2008 2:20 PM  
Hi,

Is there a fix for this yet?

Anna Tarrant | Website Design Hampshire, Web Design Hampshire UK | www.meoncreative.com
You are not authorized to post a reply.
Forums > Modules > Subscription Tools > Subscriptions Active Report Error



ActiveForums 3.7