Firefly III - new Docker installation won't start. "Could not poll the
database..."
reddit / selfhosted

----------------------------------------------------------------------
CincyTriGuy · 2023-12-27 18:34

I have a functioning instance of Firefly III running in a container on
a Raspberry Pi. I was just messing around with it to see if I like it,
which I do. But there's no data in that I need to preserve.

I'd like to start using it "for real" so I copied the docker-compose
file, firefly.db.env, and firefly.env from my functioning container on
the Pi and onto my Nuc. When I try to access it, I get a page with the
error below. Any idea what the issue could be? Like I said, this
configuration works fine on my Pi.

# [FireflyIII](http://10.118.97.7:8045/)

### Whoops! An error occurred.

Unfortunately, this error was not recoverable :(. Firefly III broke.
The error is:

Could not poll the database: SQLSTATE\[42S02\]: Base table or view not
found: 1146 Table 'firefly.configuration' doesn't exist (Connection:
mysql, SQL: select \`id\`, \`name\`, \`data\` from \`configuration\`
where \`name\` = is\_demo\_site and \`configuration\`.\`deleted\_at\`
is null limit 1)

This error occured in file /var/www/html/app/Support/FireflyConfig.php
on line 79 with code 0.

​

----------------------------------------------------------------------
vxLNX · 2023-12-27 20:01

I've had to migrate from a raspberry pi to an x86 system a few months
ago and I faced a similar issue. Having a database dump and restore
worked from me.

----------------------------------------------------------------------
CincyTriGuy · 2023-12-27 20:04

Hmm. That's good to know, but I don't want to restore the database. I
want to start fresh.

----------------------------------------------------------------------
Pvaleriano · 2023-12-27 20:17

Unless I'm missing something, which I might do because I don't know
this sw, for a fresh start, copy your docker-compose.yml and your .env
file in the new system and run `docker compose up -d` and that's all.
Docker should create every directory and file that firefly will need

----------------------------------------------------------------------
CincyTriGuy · 2023-12-27 20:19

That's exactly what I did. I copied the compose and .env files, which
I know work on the Pi, to my Nuc. When I start the container on my Nuc
I get the error listed in my OP.

----------------------------------------------------------------------
kickbut101 · 2023-12-28 15:59

I also had firefly setup issues a few weeks ago following the
instructions for the compose file (using portainer). I ended up giving
up after 2-3 errors. I think there are still some oddities to the
setup that aren't ironed out yet.

----------------------------------------------------------------------
HerusGunner · 2023-12-28 20:09

From yesterday I tried a couple of times (with many configurations) to
install firefly on my synology and everytime i have a problem with
DB.... It seems to be similar or same problem.


Could not poll the database: SQLSTATE\[42S02\]: Base table or view not
found: 1146 Table 'firefly.configuration' doesn't exist (Connection:
mysql, SQL: select \`id\`, \`name\`, \`data\` from \`configuration\`
where \`name\` = is\_demo\_site and \`configuration\`.\`deleted\_at\`
is null limit 1)

This error occured in file /var/www/html/app/Support/FireflyConfig.php
on line 65 with code 0.