spotweb: Docker container using SQlite gives error "HY000: 1: no such table: settings"
Describe the bug/issue I attempt to maintain a Docker container with Spotweb / Apache that supports all the databases. Unfortunately I have done some troubleshooting to fix another issue and found out that I receive the following error when trying to set up the container with sqlite and try to retrieve spots.
Fatal error occured retrieving reports:
HY000: 1: no such table: settings
#0 /var/www/spotweb/lib/dbeng/dbeng_pdo.php(186): dbeng_pdo->exec()
#1 /var/www/spotweb/lib/dao/Base/Dao_Base_Setting.php(25): dbeng_pdo->arrayQuery()
#2 /var/www/spotweb/lib/services/Settings/Services_Settings_DbContainer.php(29): Dao_Base_Setting->getAllSettings()
#3 /var/www/spotweb/lib/Bootstrap.php(217): Services_Settings_DbContainer->initialize()
#4 /var/www/spotweb/lib/Bootstrap.php(43): Bootstrap->getSettings()
#5 /var/www/spotweb/retrieve.php(12): Bootstrap->boot()
#6 {main}
PHP Notice: Undefined variable: retriever in /var/www/spotweb/retrieve.php on line 296
PHP Fatal error: Uncaught Error: Call to a member function quit() on null in /var/www/spotweb/retrieve.php:296
Stack trace:
#0 {main}
thrown in /var/www/spotweb/retrieve.php on line 296
Have you searched the internet or Github for an answer? Yes, didn’t find anything that helped me out.
To Reproduce Steps to reproduce the behavior:
- Install fresh spotweb with PHP7 and apache
- Go to http://[host]/install.php
- Check if all requirements are met for SQLite installation
- Configure SQLite
- Configure spotnet account/server
- Finish installation
- Attempt to retrieve spots
Expected behavior Successfully retrieving spots.
Platform
- OS: Alpine
- Image: https://hub.docker.com/r/jerheij/spotweb
- Spotweb Version: master branch
- PHP version: 7.4.25
Additional context When I do the exact same setup but with mysql/mariadb database it works completely fine.
About this issue
- Original URL
- State: closed
- Created 3 years ago
- Comments: 26
I am the creator of the container image. I know it has worked before and it works perfectly fine with mariadb. It’s literally a container with apache, php7 + required modules and either sqlite/mariadb/postgre support.