If you run into any SQL table related errors while installing Tagalys plugin in your Magento 2 platform, please follow these steps to solve them:
Note: Please note that you should only do this if you are installing Tagalys for the 1st time and not while updating from a previous version. Doing otherwise will lead to data loss.
- Make sure you have installed the Tagalys plugin via composer as per the instruction given in this link.
- Drop the following tables if they are present in your Magento database: tagalys_config, tagalys_category and tagalys_queue
- Check the "setup_module" table for a row containing "Tagalys_Sync" in the module column and delete the row if it is found.
- run bin/magento setup:upgrade from your Magento root directory.