Unsolved INVOICE NINJA - [PDOException (42S01)] in In Connection.php line 485:

[Telos One]

App went to not responding and I have tried everything to get it back via the GUI. Nothing works.

Any help DEEPLY appreciated here. Our whole business is ridin on this one. If we don't get this back we will effectively be toast, as unravelling it will cost too much.

This is the full error from the logs. This sequence just keeps repeating:

In Connection.php line 485:
Sep 28 15:08:38
Sep 28 15:08:38 [PDOException (42S01)]
Sep 28 15:08:38 SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'recurring_e
Sep 28 15:08:38 xpenses' already exists
Sep 28 15:08:38
Sep 28 15:08:38
Sep 28 15:08:38 Exception trace:
Sep 28 15:08:38 at /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php:485
Sep 28 15:08:38 PDOStatement->execute() at /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php:485
Sep 28 15:08:38 Illuminate\Database\Connection->Illuminate\Database{closure}() at /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php:685
Sep 28 15:08:38 Illuminate\Database\Connection->runQueryCallback() at /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php:652
Sep 28 15:08:38 Illuminate\Database\Connection->run() at /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php:486
Sep 28 15:08:38 Illuminate\Database\Connection->statement() at /app/code/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php:109
Sep 28 15:08:38 Illuminate\Database\Schema\Blueprint->build() at /app/code/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php:365
Sep 28 15:08:38 Illuminate\Database\Schema\Builder->build() at /app/code/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php:228
Sep 28 15:08:38 Illuminate\Database\Schema\Builder->create() at /app/code/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261
Sep 28 15:08:38 Illuminate\Support\Facades\Facade::__callStatic() at /app/code/database/migrations/2021_08_23_101529_recurring_expenses_schema.php:79
Sep 28 15:08:38 RecurringExpensesSchema->up() at /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:394
Sep 28 15:08:38 Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations{closure}() at /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:403
Sep 28 15:08:38 Illuminate\Database\Migrations\Migrator->runMigration() at /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:202
Sep 28 15:08:38 Illuminate\Database\Migrations\Migrator->runUp() at /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:167
Sep 28 15:08:38 Illuminate\Database\Migrations\Migrator->runPending() at /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:112
Sep 28 15:08:38 Illuminate\Database\Migrations\Migrator->run() at /app/code/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php:85
Sep 28 15:08:38 Illuminate\Database\Console\Migrations\MigrateCommand->Illuminate\Database\Console\Migrations{closure}() at /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:585
Sep 28 15:08:38 Illuminate\Database\Migrations\Migrator->usingConnection() at /app/code/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php:94
Sep 28 15:08:38 Illuminate\Database\Console\Migrations\MigrateCommand->handle() at /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
Sep 28 15:08:38 Illuminate\Container\BoundMethod::Illuminate\Container{closure}() at /app/code/vendor/laravel/framework/src/Illuminate/Container/Util.php:40
Sep 28 15:08:38 Illuminate\Container\Util::unwrapIfClosure() at /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
Sep 28 15:08:38 Illuminate\Container\BoundMethod::callBoundMethod() at /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:37
Sep 28 15:08:38 Illuminate\Container\BoundMethod::call() at /app/code/vendor/laravel/framework/src/Illuminate/Container/Container.php:651
Sep 28 15:08:38 Illuminate\Container\Container->call() at /app/code/vendor/laravel/framework/src/Illuminate/Console/Command.php:136
Sep 28 15:08:38 Illuminate\Console\Command->execute() at /app/code/vendor/symfony/console/Command/Command.php:299
Sep 28 15:08:38 Symfony\Component\Console\Command\Command->run() at /app/code/vendor/laravel/framework/src/Illuminate/Console/Command.php:121
Sep 28 15:08:38 Illuminate\Console\Command->run() at /app/code/vendor/symfony/console/Application.php:978
Sep 28 15:08:38 Symfony\Component\Console\Application->doRunCommand() at /app/code/vendor/symfony/console/Application.php:295
Sep 28 15:08:38 Symfony\Component\Console\Application->doRun() at /app/code/vendor/symfony/console/Application.php:167
Sep 28 15:08:38 Symfony\Component\Console\Application->run() at /app/code/vendor/laravel/framework/src/Illuminate/Console/Application.php:92
Sep 28 15:08:38 Illuminate\Console\Application->run() at /app/code/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php:129
Sep 28 15:08:38 Illuminate\Foundation\Console\Kernel->handle() at /app/code/artisan:37

[nebulon]

Is this happening after the last app update? In this case to get back up, have you tried to restore to the previous version?
It kind of looks like a database migration issue and thus seems to be a migration script bug, which should be reported upstream then.

[Telos One]

@nebulon - Sorry for the late reply, its been chaos here. It's possible it could have been an update, we don't actually bill very often, so it may have been down for days with no one noticing.

We have gone to backup, and the site is responding, but now none of our logins work. Says 401: bad credentials.

If we try to password reset we get 500: Server Error.

We tried restores both from Digital Ocean and from inside Cloudron. Now that it is back up, can someone walk me through hacking a set of creds via MySQL or something to back in?

[nebulon]

@telos-one on which package version are you now? You can see this in the update section of the app in your Cloudron dashboard.