Products

Solutions

Resources

Partners

Community

About

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsStoreStoreTwo Two 'Store Catalogs' installed when add module
Previous
 
Next
New Post
7/15/2011 10:30 AM
 
I upgraded to Store 3 (from ver. 1, I think) and have set up a new store.     When I add the Store Catalog module to a page, two copies of the module are added each time.   One is titled Catalog and the other Store Catalog.   
They appear to display the same information.   I've tried deleting one, moving one, or just changing the permissions to hide one.  but I'm wondering if there is something lingering from the original installed version, whether this is normal behavior and I just don't understand it, or something else.

Perhaps related to this, the dropdown list for selecting the default category for these stores is blank.  The values are there,  because if I count down the number of blank lines to the category I want, that is what gets displayed, but the name of the category doesn't appear.

Thanks for all the added features since the first version.  

Jill
 
New Post
7/15/2011 11:50 AM
 
Hi Jill,

Something is wrong in the Store Catalog module definitions, I have never tried to upgrade from the 1.0 version may be it's related. The right name of the Catalog module is "Store Catalog", then you can simply delete the "Catalog" one.
If your store do not contains critical data, may be the best way is to uninstall completely the module and reinstall it again. In this case, you will loose all Store data (Settings, Catalog, Orders, ...)!

Gilles

We (team members) are Humans offering their knowledge, their work and their spare time FOR FREE to benefit the community. It would be so particularly appreciated that your messages begin with "Hello" and end with "Thank you" or any other form of politeness. Ask yourself what your reaction would be, if you were approached by me (a total stranger) on the street to ask you something without saying "Hello" nor "Thank you"? After several years of services dedicated to the community, I begin to be tired to read requests without any form of politeness.
 
New Post
7/15/2011 1:50 PM
 
When I tried to uninstall, I got the following error messages......
I can't tell whether the uninstall was 'successful' in spite of the errors.   Or....whether proceeding to reinstall will fix things.   Can you tell if there might be some db remnants that might need to be manually deleted  

I don't have access to the database directly but I may be able to get the hosting service to try to delete something for me.


Info

Deleted - 02.01.46.SqlDataProvider

Info

Executing Uninstall.sqldataprovider

Info

Start Sql execution: Uninstall.sqldataprovider file

Failure

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Unclosed quotation mark after the character string 'ModuleControls WHERE (ControlKey = N'STORELINKS') AND (ControlType = - 2) '. Incorrect syntax near 'ModuleControls WHERE (ControlKey = N'STORELINKS') AND (ControlType = - 2) '. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF EXISTS (SELECT ModuleControlID FROM dbo.ModuleControls WHERE (ControlType = - 2) AND (ControlKey = N'STORELINKS')) DELETE FROM dbo.[ModuleControls WHERE (ControlKey = N'STORELINKS') AND (ControlType = - 2) System.Data.SqlClient.SqlException: Unclosed quotation mark after the character string 'ModuleControls WHERE (ControlKey = N'STOREMICROCART') AND (ControlType = - 2) '. Incorrect syntax near 'ModuleControls WHERE (ControlKey = N'STOREMICROCART') AND (ControlType = - 2) '. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF EXISTS (SELECT ModuleControlID FROM dbo.ModuleControls WHERE (ControlType = - 2) AND (ControlKey = N'STOREMICROCART')) DELETE FROM dbo.[ModuleControls WHERE (ControlKey = N'STOREMICROCART') AND (ControlType = - 2)

Info

End Sql execution: Uninstall.sqldataprovider file

Info

Deleted - Uninstall.sqldataprovider

Info

End Sql UnInstall

Info

Component uninstalled successfully - Script

Warning

Component Uninstalled with Warnings - Script

 

 

Starting Component Uninstall - Cleanup
.
..
.
.

Info Component uninstalled successfully - File
Info Component Uninstall Successful - File
Warning Uninstalled with Warnings - DotNetNuke.Store Admin
EndJob Uninstalled with Warnings

 
New Post
7/15/2011 2:07 PM
 
Hi Jill,

This is a know bug when uninstall the version 3.0. Login to your website as host, then go to Host > SQL, copy and past the following code into the text box check 'Run As Script' and clic on 'Execute'.

IF EXISTS (SELECT ModuleControlID FROM {databaseOwner}{objectQualifier}ModuleControls WHERE (ControlType = -2) AND (ControlKey = N'STORELINKS'))

DELETE FROM {databaseOwner}{objectQualifier}ModuleControls
WHERE     (ControlKey = N'STORELINKS') AND (ControlType = -2)

GO

IF EXISTS (SELECT ModuleControlID FROM {databaseOwner}{objectQualifier}ModuleControls WHERE (ControlType = -2) AND (ControlKey = N'STOREMICROCART'))

DELETE FROM {databaseOwner}{objectQualifier}ModuleControls
WHERE     (ControlKey = N'STOREMICROCART') AND (ControlType = -2)

GO

We (team members) are Humans offering their knowledge, their work and their spare time FOR FREE to benefit the community. It would be so particularly appreciated that your messages begin with "Hello" and end with "Thank you" or any other form of politeness. Ask yourself what your reaction would be, if you were approached by me (a total stranger) on the street to ask you something without saying "Hello" nor "Thank you"? After several years of services dedicated to the community, I begin to be tired to read requests without any form of politeness.
 
New Post
7/15/2011 3:49 PM
 
That fixed it!    New install resolved  the previous issues with duplicate modules and most other things.

Thanks so much for your help.  

I do have an image showing the (still) missing dropdown list items for selecting the default category for a catalog, but I am not sure how to upload it here or provide it by an alternate means.   After looking at some other posts,  perhaps others have also had this problem. 

Thanks again.
Jill
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsStoreStoreTwo Two 'Store Catalogs' installed when add module


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out