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