 |
|
|
 |
www.printon.me.uk
Joined: 4/1/2003
Posts: 99
|
|
|
hi guys
Just a quickie, is it possible to run the DNN store along side catalook store?
Thanks
Pat
|
| |
|
|
 | |
|
|
 |
Joined: 10/11/2003
Posts: 1966
|
|
|
Hi Pat,
Of course you can! They use completly different name space and tables names.
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.
|
| |
|
|
| |
|
|
|
www.printon.me.uk
Joined: 4/1/2003
Posts: 99
|
|
|
Hi Gilles
I thought that should be the case, when testing on an older version of dnn it loaded without any issues
but when loading on version 4.05.05 of dnn with SQL2005 express without catalook i hhad the following errors
any suggestions
thanks
Pat
| StartJob |
Start Sql execution: 01.00.00.sqldataprovider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: There is already an object named 'Store_Administration_GetShippingFee' in the database. 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.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) CREATE PROCEDURE dbo.Store_Administration_GetShippingFee @PortalID int AS SET NOCOUNT ON SELECT isnull(DefaultShippingFee, 0) Fee FROM dbo.Store_Administration WHERE PortalID = @PortalID System.Data.SqlClient.SqlException: There is already an object named 'Store_Administration_UpdateShippingFee' in the database. 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.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) CREATE PROCEDURE dbo.Store_Administration_UpdateShippingFee @PortalID int, @Fee money AS SET NOCOUNT ON UPDATE dbo.Store_Administration SET DefaultShippingFee = @Fee WHERE PortalID = @PortalID System.Data.SqlClient.SqlException: There is already an object named 'Store_Administration_GetTaxRates' in the database. 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.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) CREATE PROCEDURE dbo.Store_Administration_GetTaxRates @PortalID int AS SET NOCOUNT ON SELECT isnull(DefaultTaxRates, ' ') DefaultTaxRates FROM dbo.Store_Administration WHERE PortalID = @PortalID System.Data.SqlClient.SqlException: There is already an object named 'Store_Administration_UpdateTaxRates' in the database. 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.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) CREATE PROCEDURE dbo.Store_Administration_UpdateTaxRates @PortalID int, @Rates ntext AS SET NOCOUNT ON UPDATE dbo.Store_Administration SET DefaultTaxRates = @Rates WHERE PortalID = @PortalID |
| EndJob |
End Sql execution: 01.00.00.sqldataprovider file |
|
| |
|
|
| |
|
|
|
Joined: 10/11/2003
Posts: 1966
|
|
|
Hi Pat,
This is NOT a problem with Catalook because every tables and stored procedures use the prefix: CAT_
I think you have previously installed the Store module on this DNN instance. Because the current Store module do NOT clean tables and stored procedures when you uninstall it, you have to delete it "by hand" before re-install the module. By security make a backup of your database BEFORE apply!
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.
|
| |
|
|
| |