Hi,

Could you explain a little bit more? I never told you to drop table!? What is your problem exactly?

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.

My problem is as mentioned before, that it is not possible to delete a categorie which did have some products (they are deleted now). I get following error:

This category cannot be removed! Possible causes: one or more sub categories are dependent. One or more products are dependent.
DotNetNuke.Services.Exceptions.ModuleLoadException: The DELETE statement conflicted with the REFERENCE constraint "FK_dnn_Store_Products_dnn_Store_Categories". The conflict occurred in database "C:\DOTNETNUKE\APP_DATA\DATABASE.MDF", table "dbo.dnn_Store_Products", column 'CategoryID'. The statement has been terminated. ---> System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK_dnn_Store_Products_dnn_Store_Categories". The conflict occurred in database "C:\DOTNETNUKE\APP_DATA\DATABASE.MDF", table "dbo.dnn_Store_Products", column 'CategoryID'. The statement has been terminated. 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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Store.Catalog.SqlDataProvider.DeleteCategory(Int32 CategoryID) at DotNetNuke.Modules.Store.Catalog.CategoryController.DeleteCategory(Int32 categoryID) at DotNetNuke.Modules.Store.WebControls.CategoryEdit.cmdDelete_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---

And in my opinion this isn't a small thing, it's a basic feature of a store function which has to work properly. Once again, please look for a solution

No order has been placed in my store, it's just for showing items purposes. Archieving the category does work, okay good for now. but i still would like to delete it. Since you know what the problem is and how it can be solved (code wise) i don't understand why you don't bring a patch or something like that.

How didn't you guys seen that bug while testing the module before releasing ?