HomeHome Product Discus... Product Discus...SmithCartSmithCartDiscounts in Store Admin gives critical error (v 2.97)Discounts in Store Admin gives critical error (v 2.97)
Previous
 
Next
New Post
7/12/2010 2:31 PM
 

When I click on Discounts in Store Admin, I get a critical error. Here is the event log:

AssemblyVersion: 5.4.4
PortalID: 14
PortalName: FireFly Trading Co.
UserID: 1
UserName: jolhava-su
ActiveTabID: 451
ActiveTabName: Store
RawURL: /Store/tabid/451/ctl/OrderDiscounts/mid/1084/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://fireflytc.com/Store/tabid/451/ctl/StoreAdminMenu/mid/1084/Default.aspx
UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; InfoPath.2)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: a566f597-6a6c-41be-9d8f-60536c337f9b
InnerException: Invalid object name 'dnn_Roles'.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Invalid object name 'dnn_Roles'. ---> System.Data.SqlClient.SqlException: Invalid object name 'dnn_Roles'.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.ExecuteDbDataReader(CommandBehavior behavior)at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, String spName, Object[] parameterValues)at Smith.DNN.Modules.BuyNow.SqlDataProvider.ListOrderDiscount(Int32 PortalID)at Smith.DNN.Modules.BuyNow.SmithController.ListOrderDiscount(Int32 PortalID)at Smith.DNN.Modules.BuyNow.OrderDiscounts.BindGridDiscount()at Smith.DNN.Modules.BuyNow.OrderDiscounts.Page_Load(Object sender, EventArgs e)at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)at System.Web.UI.Control.OnLoad(EventArgs e)at System.Web.UI.Control.LoadRecursive()at System.Web.UI.Control.LoadRecursive()at System.Web.UI.Control.LoadRecursive()at System.Web.UI.Control.LoadRecursive()at System.Web.UI.Control.LoadRecursive()at System.Web.UI.Control.LoadRecursive()at System.Web.UI.Control.LoadRecursive()at System.Web.UI.Control.LoadRecursive()at System.Web.UI.Control.LoadRecursive()at System.Web.UI.Control.LoadRecursive()at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)--- End of inner exception stack trace ---
Source:
Server Name: VISION

 
New Post
7/12/2010 2:45 PM
Accepted Answer 

On the following sproc please remove the object qualifier highlighted below. We just fixed this in the 2.97 sqlprovider script:

CREATE PROCEDURE Smith_Smith_ListOrderDiscount
@PortalID int
AS

SELECT od.*, R.RoleName FROM Smith_OrderDiscounts od
left outer join dnn_Roles R on
od.roleid = r.roleid
WHERE od.PortalID = @PortalID




Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
7/13/2010 1:28 AM
 

That worked, thanks!

 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartDiscounts in Store Admin gives critical error (v 2.97)Discounts in Store Admin gives critical error (v 2.97)