|
|
|
|
Joined: 10/23/2022
Posts: 4
|
|
|
My database has a custom object qualifier and I had an issue just installing the latest version where i had to fix the SQL 4.0 provider because a line did not have the object qualifier variable added to it. Now after installation however the store is not showing and I'm getting this error:
Error: Cart Viper Menu is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid object name 'CVStore_ProductAttributes'. ---> System.Data.SqlClient.SqlException: Invalid object name 'CVStore_ProductAttributes'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at CartViper.Modules.Store.External.SubSonic.DataProviders.DbDataProvider.ExecuteScalar(QueryCommand qry) at CartViper.Modules.Store.External.SubSonic.Query.CodingHorror.ExecuteScalar[TResult]() at CartViper.Modules.Store.Catalog.ProductRestrictions.ProductRestrictionImpl.FilterProducts(Int32 portalId, IList`1 products, UserInfo user, Boolean checkForCategoryRestrictionOverride, Nullable`1 categoryId) at CartViper.Modules.Store.Catalog.ProductRestrictions.ProductRestriction.FilterProducts(Int32 portalId, IList`1 products, UserInfo user, Boolean checkForCategoryRestrictionOverride) at CartViper.Modules.Store.Catalog.ProductRestrictions.ProductRestriction.FilterProducts(Int32 portalId, IList`1 products, UserInfo user) at CartViper.Modules.Store.WebControls.CategoryMenu.CountProductsInCategory(List`1& productsCounted, Int32 categoryId, StoreInfo storeSettings) at CartViper.Modules.Store.WebControls.CategoryMenu.CalculateProductCount(StoreInfo storeSettings, CategoryInfo currentCategory, IEnumerable`1 categories) at CartViper.Modules.Store.WebControls.CategoryMenu.rpNavigationMenu_ItemDataBound(Object sender, RepeaterItemEventArgs e) at System.Web.UI.WebControls.Repeater.OnItemDataBound(RepeaterItemEventArgs e) at System.Web.UI.WebControls.Repeater.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem) at System.Web.UI.WebControls.Repeater.AddDataItemsIntoItemsArray(IEnumerable dataSource, Boolean useDataSource) at System.Web.UI.WebControls.Repeater.PostGetDataAction(IEnumerable dataSource) at System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) at CartViper.Modules.Store.WebControls.CategoryMenu.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
I have not been able to find a stored procedure missing the object qualifier statement for this table so I'm needing assistance in getting this store working again.
|
|
|
|
| |
|
|
|
|
Joined: 7/27/2010
Posts: 789
|
|
|
Hi,
Can you download and install version 4.2.4 , that should hopefully correct the issue you're seeing:
https://www.cartviper.com/free-trial
|
|
|
|
| |
|
|
|
Joined: 10/23/2022
Posts: 4
|
|
|
Getting error (after install of that version), but does appear now to have the qualifier infront of the name. Yes the qualifier is "dbo_" i screwed up during the initial install it was dumb and i wish i could fix it but haven't been able to yet:
Error: Cart Viper Catalog is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid object name 'dbo_CVStore_ProductAttributes'. ---> System.Data.SqlClient.SqlException: Invalid object name 'dbo_CVStore_ProductAttributes'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at CartViper.Modules.Store.External.SubSonic.DataProviders.DbDataProvider.ExecuteScalar(QueryCommand qry) at CartViper.Modules.Store.External.SubSonic.Query.CodingHorror.ExecuteScalar[TResult]() at CartViper.Modules.Store.Catalog.ProductRestrictions.ProductRestrictionImpl.FilterProducts(Int32 portalId, IList`1 products, UserInfo user, Boolean checkForCategoryRestrictionOverride, Nullable`1 categoryId) at CartViper.Modules.Store.Catalog.ProductRestrictions.ProductRestriction.FilterProducts(Int32 portalId, IList`1 products, UserInfo user, Boolean checkForCategoryRestrictionOverride) at CartViper.Modules.Store.Catalog.ProductRestrictions.ProductRestriction.FilterProducts(Int32 portalId, IList`1 products, UserInfo user) at CartViper.Modules.Store.WebControls.Catalog.processToken(String tokenName) at CartViper.Modules.Store.Catalog.Templates.TemplateController.ParseTemplate(TemplateInfo templateInfo, Object processTokenDelegate, ProductInfo product, CategoryInfo category, Object[] data, IModuleControl parentModule, String sourceFilePath) at CartViper.Modules.Store.Catalog.Templates.TemplateController.ParseTemplate(TemplateInfo templateInfo, ProcessTokenDelegate processTokenDelegate, ProductInfo product, CategoryInfo category, IModuleControl parentModule, String sourceFilePath) at CartViper.Modules.Store.WebControls.Catalog.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
|
|
|
|
| |
|
|
|
Joined: 10/23/2022
Posts: 4
|
|
|
And i verified in the database the table "dbo_CVStore_ProductAttributes" does exist and it has data in it.
It has columns:
- attributeid
- parentid
- name
- value
|
|
|
|
| |
|
|
|
|
Joined: 7/27/2010
Posts: 789
|
|
|
Hi,
Can you email me a host username / password so I can login and see your install?
nigel@cartviper.com
Regards
|
|
|
|
| |