Plugin uninstall then install problem in nopCommerce 4.20

I added a row directly into the database, table Customer, in way to have system acocunt 'BackgroundTask' and
'SearchEngine'

Hi Massimo

I’m having the same problem. Can you provide a screenshot of the customer you added in the Customer table please ?

Thanks so much

experiencedance wrote:
Check error log. There will be an error log with below error message.
Table 'TableName' already exists
Go to database and delete that table manually.

If the error message is something else, put it here.

Run this script to insert the customers listed previously.
This fix worked for me.
This is in create_required_data.sql

Thanks for the help.

INSERT [Customer] ([CustomerGuid], [Username], [Email], [EmailToRevalidate], [AdminComment], [IsTaxExempt], [AffiliateId], [VendorId], [HasShoppingCartItems], [RequireReLogin], [FailedLoginAttempts], [CannotLoginUntilDateUtc], [Active], [Deleted], [IsSystemAccount], [SystemName], [LastIpAddress], [CreatedOnUtc], [LastLoginDateUtc], [LastActivityDateUtc], [RegisteredInStoreId], [BillingAddress_Id], [ShippingAddress_Id]) VALUES (N'a8fce858-7e76-4169-aa48-3e39f0d9412f', NULL, N'builtin@search_engine_record.com', NULL, N'Built-in system guest record used for requests from search engines.', 0, 0, 0, 0, 0, 0, NULL, 1, 0, 1, N'SearchEngine', NULL, CAST(N'2019-05-27T15:28:27.9219565' AS DateTime2), NULL, CAST(N'2019-05-27T15:28:27.9219565' AS DateTime2), 1, NULL, NULL)


INSERT [Customer] ([CustomerGuid], [Username], [Email], [EmailToRevalidate], [AdminComment], [IsTaxExempt], [AffiliateId], [VendorId], [HasShoppingCartItems], [RequireReLogin], [FailedLoginAttempts], [CannotLoginUntilDateUtc], [Active], [Deleted], [IsSystemAccount], [SystemName], [LastIpAddress], [CreatedOnUtc], [LastLoginDateUtc], [LastActivityDateUtc], [RegisteredInStoreId], [BillingAddress_Id], [ShippingAddress_Id]) VALUES (N'b72cba5f-86cf-483b-8987-74c0f2f05495', NULL, N'[email protected]', NULL, N'Built-in system record used for background tasks.', 0, 0, 0, 0, 0, 0, NULL, 1, 0, 1, N'BackgroundTask', NULL, CAST(N'2019-05-27T15:28:27.9386273' AS DateTime2), NULL, CAST(N'2019-05-27T15:28:27.9386273' AS DateTime2), 1, NULL, NULL)

Hi,
Sorry for this late answer: I have now these two email into Customer Table and it worked:
[email protected]
builtin@search_engine_record.com

I hope it helps

BR
Massimo

Vect wrote:


This post saved my lots of time from being wasted for fixing this issue..Thank you so much.

Before you add new background customer, see if that is your problem:  Use SSMS or similar SQL tool:

SELECT *
  FROM [dbo].[Customer]
WHERE SystemName = 'BackgroundTask'

Do you get a row returned?

Hi all
I have upgraded from nopcommerce 4.0 to 4.3.  now I am facing the same issue.  when I am trying to add any new plugin it is stuck in PluginNamesToInstall. for example

"PluginNamesToUninstall": [],
  "PluginNamesToDelete": [],
  "PluginNamesToInstall": [
    {
      "Item1": "ExternalAuth.Facebook",
      "Item2": "4e075dfe-48ff-408d-8b6d-5cd2eaf8cd8b"
    }
  ]

I have restart my application so many times but still, it is not installing a plugin.

Check the System > Log for any error messages.
Make sure the nopCommerce version of the plugin you are installing matches your current nopCommerce version - look inside the plugin folder for file plugin.json.  Open/edit the file and check the  "SupportedVersions".