mysql "You have an error in your SQL syntax"
I am trying to make the database work with mysql for the homarr v1 version running with docker compose but I am encountering the error " Application error: a server-side exception has occurred (see the server logs for more information).
Digest: 2374504417 "
The logs are as follows.
3 Replies
Thank you for submitting a support request.
Depending on the volume of requests, our team should get in contact with you shortly.
⚠️ Please include the following details in your post or we may reject your request without further comment: - Log (See https://homarr.dev/docs/community/faq#how-do-i-open-the-console--log) - Operating system (Unraid, TrueNAS, Ubuntu, ...) - Exact Homarr version (eg. 0.15.0, not latest) - Configuration (eg. docker-compose, screenshot or similar. Use ``your-text`` to format) - Other relevant information (eg. your devices, your browser, ...)
Frequently Asked Questions | Homarr documentation
Can I install Homarr on a Raspberry Pi?
I had the same issue and was scratching my head for a while. I had to do two things to get it going right.
1. Use the MySQL database (container) instead of MariaDB. Apparently MariaDB is not supported at this stage.
2. On first run of the Homarr V1 container, makes sure the database has been fully set up and able to accept connections before the Homarr container starts. The initial database script doesn't seem to wait for the connection to be established and just runs, and sets some flag so it won't run again and expects a bunch of tables to exist already.
Thank you. I will try it when I have time.