Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. Invoice Ninja
  3. INVOICE NINJA - [PDOException (42S01)] in In Connection.php line 485:

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

Scheduled Pinned Locked Moved Unsolved Invoice Ninja
invoice ninjapdo errorpdo
4 Posts 2 Posters 546 Views 2 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • T Offline
      T Offline
      Telos One
      wrote on last edited by
      #1

      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

      1 Reply Last reply
      0
      • nebulonN Offline
        nebulonN Offline
        nebulon
        Staff
        wrote on last edited by
        #2

        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.

        T 1 Reply Last reply
        0
        • nebulonN 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.

          T Offline
          T Offline
          Telos One
          wrote on last edited by Telos One
          #3

          @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?

          nebulonN 1 Reply Last reply
          0
          • girishG girish moved this topic from Support on
          • T 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?

            nebulonN Offline
            nebulonN Offline
            nebulon
            Staff
            wrote on last edited by
            #4

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

            1 Reply Last reply
            0
            Reply
            • Reply as topic
            Log in to reply
            • Oldest to Newest
            • Newest to Oldest
            • Most Votes


              • Login

              • Don't have an account? Register

              • Login or register to search.
              • First post
                Last post
              0
              • Categories
              • Recent
              • Tags
              • Popular
              • Bookmarks
              • Search