Skip to content
Cydney Caldwell edited this page Mar 19, 2020 · 1 revision

An exception occurred while executing 'SELECT mod_settings.* FROM mod_settings WHERE (mod_settings.module = 'search') ':

This error occurs when there is a problem installing tables.

Since there is a BEGIN and COMMIT on the install file, if there is an error the transaction is aborted and it doesn't create any tables. Different versions of node, php, etc complain about different things so the only way to fix this is to remove the Begin and Commit and see what table it's complaining about. Example: An issue that happened before was having 'character varying' instead of VARCHAR on one of the tables.

With removing the Begin, the tables will be created on by one, so wherever it fails you have to delete all the tables it did install to try and reinstall again. To help the uninstall.sql should have all the drop table commands you need.