We understand that your ecommerce site is crucial to the success of your business, from time to time issues and questions can arise and you need to have the assurance there will be someone on hand to help resolve these in a timely fashion so you can spend your time driving your own business forward.

So if you are looking for faster responses to your questions or would like the assurance there is someone on hand for you to contact, fear not we have a number of paid support options that are available to you that can give your organisation the peace of mind knowing a member from the Cart Viper team will always be available to assist!

Purchase a Support Plan

Community Support

HomeHomeIssues and Supp...Issues and Supp...Installation & ...Installation & ...Issue after installation with custom object qualifierIssue after installation with custom object qualifier
Previous
 
Next
New Post
10/23/2022 3:36 AM
 

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.

 
New Post
10/24/2022 11:02 AM
 

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

 
New Post
10/24/2022 2:56 PM
 

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 ---

 
New Post
10/24/2022 2:59 PM
 

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

 

 
New Post
10/24/2022 8:36 PM
 

Hi,

Can you email me a host username / password so I can login and see your install? 

nigel@cartviper.com

Regards

 
Previous
 
Next
HomeHomeIssues and Supp...Issues and Supp...Installation & ...Installation & ...Issue after installation with custom object qualifierIssue after installation with custom object qualifier


 

We use cookies on our website to improve our service to you, by continuing you agree to our use of cookies. However you are able to update your settings at any time.

Cookie Policy

A cookie, also known as an HTTP cookie, web cookie, or browser cookie, is a piece of data stored by a website within a browser, and then subsequently sent back to the same website by the browser. Cookies were designed to be a reliable mechanism for websites to remember things that a browser had done there in the past, which can include having clicked particular buttons, logging in, or having read pages on that site months or years ago.

Strictly Necessary Cookies

These cookies cannot be disabled

These cookies are necessary for the website to function and cannot be switched off. They are normally set in response to your interactions on the website e.g. logging in etc.

Cookies:
  • .ASPXANONYMOUS
  • .DOTNETNUKE
  • __RequestVerificationToken
  • authentication
  • CV_Portal
  • CV_Store_Portal_Cart_0
  • CV_USER
  • dnn_IsMobile
  • language
  • LastPageId
  • NADevGDPRCookieConsent_portal_0
  • userBrowsingCookie

Performance Cookies

These cookies allow us to monitor traffic to our website so we can improve the performance and content of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not know when you have visited or how you navigated around our website.

Cookies:
  • _ga
  • _gat
  • _gid

Functional Cookies

These cookies enable the website to provide enhanced functionality and content. They may be set by the website or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.

Cookies:

Currently we are not utilizing these types of cookies on our site.

Targeting Cookies

These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.

Cookies:

Currently we are not utilizing these types of cookies on our site.

Feedback