It would help to know more about your installation. For example:
- What version of AtoM are you trying to install?
- Are you installing from our downloadable tarball (Option 1 in our recommended installation documentation), or from our GitHub code repository (Option 2)?
- Is this a brand new installation, or are you upgrading from a previous version?
- I see you mention Apache, rather than Nginx as we recommend. What else have you changed?
- Does your installation server meet the recommended hardware minimums listed here?
A couple initial observations and suggestions are included below. If these don't work, then answering the questions above will help us provide better suggestions next time.
Unknown key error
First, the error shown in the browser in your second message is an Elasticsearch error. The only time I have seen this error in the user forum is when someone tried to install a later version - elasticsearch 7.x. See:
AtoM 2.6 requires Elasticsearch 5.6. There are breaking changes in Elasticsearch 6 and 7 that will require code changes in AtoM for us to be able to implement. Currently, trying to use ES 6 or ES 7 in AtoM will result in errors.
The other possible cause of this error is using capital letters, spaces, or special characters in your ES index name during configuration. There is a "configureSearch" page in the web installer - I can't remember if it is before or after the loadData page, but if you have the correct ES 5.6 version installed, you might want to check that your index name is lowercase and without special characters - in our documentation we recommend naming the ES index "atom":
If none of the above suggestions help, you will find many other suggestions for troubleshooting Elasticsearch in the user forum. First some basic commands:
- sudo systemctl status elasticsearch should tell you if Elasticsearch is running or not
- Use the following to restart it if it is not running: sudo systemctl restart elasticsearch
- If running, php symfony search:status will tell you about what is in your index currently.
- Running the following command will repopulate the search index: php symfony search:populate
- Elasticsearch has its own logs, which can sometimes provide further details to help with troubleshooting. These are typically located at: /var/log/elasticsearch/elasticsearch.log
- Finally, remember the recommended hardware minimums. I believe that by default, Elasticsearch wants to use 2GB for the JVM heap size - meaning if your AtoM server has less than 4GB available, this could be causing problems.
For further advanced suggestions, including how to increase the default JVM heap size, see:
Base table or view not found error
We most commonly see this error when someone is upgrading from a previous version, and they miss some of the steps of the upgrade process described in our documentation
. Are you upgrading?
You can try dropping and recreating the database, and then running the purge task, to see if that resolves the issue. If you are upgrading, make sure you have a copy of your sqldump outside of AtoM before proceeding, as the tasks we will run will purge all data! The following is for a 2.6 installation - check the documentation for other versions. It also assumes your database name is atom.
First, let's drop the database, and then recreate it:
- mysql -u username -p -e "DROP DATABASE IF EXISTS atom;"
- mysql -u username -p -e "CREATE DATABASE atom CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;"
Now we can run the tools:purge task to ensure that no previous remnants are left:
If you are upgrading, now is when you can load your sqldump backup, and run the upgrade task.
You can then try returning to the loadData configuration page to see if the issue has been resolved.
Hopefully that helps! If you are still having issues, please be sure to provide answers to the questions about your installation at the beginning of this message, so we can provide you with further suggestions.
he / him