You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.