I'm getting the following error: SQLSTATE[23000]: Integrity constraint violation.

Next time please disable the compilation before uploading the extension files to your server.

This time please

• Open app/etc/local.xml
• Replace
  
  <disable_local_modules>false</disable_local_modules>
  
  with 

           <disable_local_modules>true</disable_local_modules>

• Log in to admin panel and disable the compilation.
• Revert the changes in the local.xml
• Clear the cache.

Helpful tip: One of the ways to ease the process of admin registration is to use Google Account Login. It is an easy way to access your store backend without memorizing complex passwords.

Try the Elasticsearch Extension

Enhance your Magento 2 store's search capabilities with Amasty's Elasticsearch Extension. This powerful tool improves search accuracy and speed, helping your customers find products more easily. Experience seamless integration and increased conversion rates by upgrading your store's search functionality today!