Message: Illuminate\Database\QueryException

[memo-567]

Support guidelines

• I've read the support guidelines

I've found a bug and checked that ...

• ... the documentation does not mention anything about my problem
• ... there are no open or closed issues that are related to my problem
• ... it's definitely a Firefly III issue, not me

Description

Updating Firefly iii to 6.01. and 6.0.2 also, causes an error with no discernible effects.

composer create-project grumpydictator/firefly-iii --no-dev --prefer-dist firefly-iii-updated <version>

Despite the message, Firefly works fine as far as I can verify.

Debug information

Illuminate\Database\QueryException

SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo for db failed: Name or service not known (Connection: mysql, SQL: delete from configuration where name = upgrade_security_message)

at vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
756▕ // If an exception occurs when attempting to run a query, we'll format the error
757▕ // message to include the bindings with SQL, which will make this exception a
758▕ // lot more helpful to the developer instead of just the database's errors.
759▕ catch (Exception $e) {
➜ 760▕ throw new QueryException(
761▕ $this->getName(), $query, $this->prepareBindings($bindings), $e
762▕ );
763▕ }
764▕ }

  +17 vendor frames

18 app/Support/FireflyConfig.php:49
Illuminate\Database\Eloquent\Builder::forceDelete()

19 app/Console/Commands/VerifySecurityAlerts.php:59
FireflyIII\Support\FireflyConfig::delete()

Script @php artisan firefly-iii:verify-security-alerts handling the post-install-cmd event returned with error code 1

Expected behaviour

No response

Steps to reproduce

No response

Additional info

No response

[JC5]

It seems to lose the connection to the database and errors out. That's not a bug per se, but perhaps a configuration issue. Is your database reporting issues?

[memo-567]

I haven't noticed any errors so far.

I also thought that with this first SSH update entry, no database is called, since the .env file is not in the new directory yet, and only the new version is installed.

[JC5]

Good point, I hadn't actually thought of that. I'll check it out!

[memo-567]

The update to version 6.0.3 works without an error message again 👍

[JC5]

Thanks for the quick feedback, I'm glad to hear it!