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:

  1. Install fresh spotweb with PHP7 and apache
  2. Go to http://[host]/install.php
  3. Check if all requirements are met for SQLite installation
  4. Configure SQLite
  5. Configure spotnet account/server
  6. Finish installation
  7. Attempt to retrieve spots

Expected behavior Successfully retrieving spots.

Platform

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

Most upvoted comments

Not sure, i am not a huge docker fan or know much about it…

Maybe the creator might be able to assist.

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.