can not install Shipping.FixedByWeightByTotal on V4.2

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
4 years ago
As per the message " There is already an object named 'ShippingByWeightByTotalRecord' in the database."
The plugin seems to be already installed, but the plugins.json table does seem to have it.

You could edit this \App_Data\plugins.json, and add this
    "Shipping.FixedByWeightByTotal",
after this line
  "InstalledPluginNames": [

But, it might be safer for you to use a SQL client tool like SSMS, and delete/drop table ShippingByWeightByTotalRecord
And then try the Install again.
4 years ago
Drop this table from database "ShippingByWeightByTotalRecord" before install the plugin


dg2333 wrote:
This is the full error message logged in system/logs section of nopCommerce:


System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'ShippingByWeightByTotalRecord' in the database.
   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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite, String methodName)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues)
   at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues)
   at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.ExecuteSqlCommand(DatabaseFacade databaseFacade, RawSqlString sql, IEnumerable`1 parameters)
   at Nop.Plugin.Shipping.FixedByWeightByTotal.Data.ShippingByWeightByTotalObjectContext.ExecuteSqlCommand(RawSqlString sql, Boolean doNotEnsureTransaction, Nullable`1 timeout, Object[] parameters)
   at Nop.Data.Extensions.DbContextExtensions.ExecuteSqlScript(IDbContext context, String sql) in C:\andrei\nopcommerce\sources\src\Libraries\Nop.Data\Extensions\DbContextExtensions.cs:line 286
   at Nop.Plugin.Shipping.FixedByWeightByTotal.FixedByWeightByTotalComputationMethod.Install()
   at Nop.Services.Plugins.PluginService.InstallPlugins() in C:\andrei\nopcommerce\sources\src\Libraries\Nop.Services\Plugins\PluginService.cs:line 422
ClientConnectionId:9a6a7264-75b7-4dd3-bb9f-43cc593347cf
Error Number:2714,State:6,Class:16
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.