Skip to content

Instantly share code, notes, and snippets.

@mlncn
Created July 25, 2018 01:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mlncn/0cd18395d00b68d8c68737fdfe6a87ae to your computer and use it in GitHub Desktop.
Save mlncn/0cd18395d00b68d8c68737fdfe6a87ae to your computer and use it in GitHub Desktop.
Akaunting with SQLite install error
(1/1) SchemaException
There is no column with name 'attachment' on table 'bill_payments'.
in SchemaException.php line 86
at SchemaException::columnDoesNotExist('attachment', 'bill_payments')in Table.php line 671
at Table->getColumn('attachment')in Connection.php line 844
at Connection->getDoctrineColumn('bill_payments', 'attachment')in SQLiteGrammar.php line 225
at SQLiteGrammar->compileDropColumn(object(Blueprint), object(Fluent), object(SQLiteConnection))in Blueprint.php line 110
at Blueprint->toSql(object(SQLiteConnection), object(SQLiteGrammar))in Blueprint.php line 85
at Blueprint->build(object(SQLiteConnection), object(SQLiteGrammar))in Builder.php line 239
at Builder->build(object(Blueprint))in Builder.php line 148
at Builder->table('bill_payments', object(Closure))in Facade.php line 221
at Facade::__callStatic('table', array('bill_payments', object(Closure)))in 2018_01_03_000000_drop_attachment_column_bill_payments_table.php line 18
at DropAttachmentColumnBillPaymentsTable->up()in Migrator.php line 359
at Migrator->Illuminate\Database\Migrations\{closure}()in Migrator.php line 365
at Migrator->runMigration(object(DropAttachmentColumnBillPaymentsTable), 'up')in Migrator.php line 177
at Migrator->runUp('/home/mlncn/SoftwareApplications/akaunting/database/migrations/2018_01_03_000000_drop_attachment_column_bill_payments_table.php', 1, false)in Migrator.php line 146
at Migrator->runPending(array('/home/mlncn/SoftwareApplications/akaunting/database/migrations/2017_09_01_000000_create_accounts_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2017_09_01_000000_create_bills_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2017_09_01_000000_create_categories_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2017_09_01_000000_create_companies_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2017_09_01_000000_create_currencies_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2017_09_01_000000_create_customers_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2017_09_01_000000_create_invoices_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2017_09_01_000000_create_items_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2017_09_01_000000_create_jobs_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2017_09_01_000000_create_modules_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2017_09_01_000000_create_notifications_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2017_09_01_000000_create_password_resets_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2017_09_01_000000_create_payments_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2017_09_01_000000_create_revenues_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2017_09_01_000000_create_roles_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2017_09_01_000000_create_sessions_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2017_09_01_000000_create_settings_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2017_09_01_000000_create_taxes_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2017_09_01_000000_create_transfers_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2017_09_01_000000_create_users_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2017_09_01_000000_create_vendors_table.php', '/home/mlncn/SoftwareApplications/akaunting/modules/OfflinePayment/Providers/../Database/Migrations/2017_09_19_delete_offline_file.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2017_10_11_000000_create_bill_totals_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2017_10_11_000000_create_invoice_totals_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2017_11_16_000000_create_failed_jobs_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2017_12_09_000000_add_currency_columns.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2017_12_30_000000_create_mediable_tables.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2018_01_03_000000_drop_attachment_column_bill_payments_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2018_01_03_000000_drop_attachment_column_bills_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2018_01_03_000000_drop_attachment_column_invoice_payments_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2018_01_03_000000_drop_attachment_column_invoices_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2018_01_03_000000_drop_attachment_column_payments_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2018_01_03_000000_drop_attachment_column_revenues_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2018_01_03_000000_drop_picture_column_items_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2018_01_03_000000_drop_picture_column_users_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2018_04_23_000000_add_category_column_invoices_bills.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2018_04_26_000000_create_recurring_table.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2018_04_30_000000_add_parent_column.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2018_06_23_000000_modify_email_column.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2018_06_30_000000_modify_enabled_column.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2018_07_07_000000_modify_date_column.php', '/home/mlncn/SoftwareApplications/akaunting/database/migrations/2020_01_01_000000_add_locale_column.php'), array('pretend' => false, 'step' => false))in Migrator.php line 95
at Migrator->run(array('/home/mlncn/SoftwareApplications/akaunting/database/migrations', '/home/mlncn/SoftwareApplications/akaunting/modules/OfflinePayment/Providers/../Database/Migrations', '/home/mlncn/SoftwareApplications/akaunting/modules/PaypalStandard/Providers/../Database/Migrations'), array('pretend' => false, 'step' => false))in MigrateCommand.php line 69
at MigrateCommand->fire()
at call_user_func_array(array(object(MigrateCommand), 'fire'), array())in BoundMethod.php line 29
at BoundMethod::Illuminate\Container\{closure}()in BoundMethod.php line 87
at BoundMethod::callBoundMethod(object(Application), array(object(MigrateCommand), 'fire'), object(Closure))in BoundMethod.php line 31
at BoundMethod::call(object(Application), array(object(MigrateCommand), 'fire'), array(), null)in Container.php line 539
at Container->call(array(object(MigrateCommand), 'fire'))in Command.php line 182
at Command->execute(object(ArrayInput), object(OutputStyle))in Command.php line 251
at Command->run(object(ArrayInput), object(OutputStyle))in Command.php line 167
at Command->run(object(ArrayInput), object(BufferedOutput))in Application.php line 946
at Application->doRunCommand(object(MigrateCommand), object(ArrayInput), object(BufferedOutput))in Application.php line 248
at Application->doRun(object(ArrayInput), object(BufferedOutput))in Application.php line 148
at Application->run(object(ArrayInput), object(BufferedOutput))in Application.php line 141
at Application->call('migrate', object(Collection), null)in Kernel.php line 220
at Kernel->call('migrate', array('--force' => true))in Facade.php line 221
at Facade::__callStatic('call', array('migrate', array('--force' => true)))in Installer.php line 125
at Installer::createDbTables('localhost', '3306', 'akaunting.db', 'heh', null)in Database.php line 38
at Database->store(object(Database))
at call_user_func_array(array(object(Database), 'store'), array(object(Database)))in Controller.php line 55
at Controller->callAction('store', array(object(Database)))in ControllerDispatcher.php line 44
at ControllerDispatcher->dispatch(object(Route), object(Database), 'store')in Route.php line 203
at Route->runController()in Route.php line 160
at Route->run()in Router.php line 572
at Router->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 30
at Pipeline->Illuminate\Routing\{closure}(object(Request))in CanInstall.php line 20
at CanInstall->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in RedirectIfAuthenticated.php line 28
at RedirectIfAuthenticated->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in SetLocale.php line 94
at SetLocale->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in LoadCurrencies.php line 22
at LoadCurrencies->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in LoadSettings.php line 22
at LoadSettings->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in AddXHeader.php line 18
at AddXHeader->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in RedirectIfNotInstalled.php line 21
at RedirectIfNotInstalled->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in SubstituteBindings.php line 41
at SubstituteBindings->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in VerifyCsrfToken.php line 65
at VerifyCsrfToken->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in ShareErrorsFromSession.php line 49
at ShareErrorsFromSession->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in StartSession.php line 64
at StartSession->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in AddQueuedCookiesToResponse.php line 37
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in EncryptCookies.php line 59
at EncryptCookies->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 102
at Pipeline->then(object(Closure))in Router.php line 574
at Router->runRouteWithinStack(object(Route), object(Request))in Router.php line 533
at Router->dispatchToRoute(object(Request))in Router.php line 511
at Router->dispatch(object(Request))in Kernel.php line 176
at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))in Pipeline.php line 30
at Pipeline->Illuminate\Routing\{closure}(object(Request))in TrustProxies.php line 56
at TrustProxies->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in TransformsRequest.php line 30
at TransformsRequest->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in TransformsRequest.php line 30
at TransformsRequest->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in ValidatePostSize.php line 27
at ValidatePostSize->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in CheckForMaintenanceMode.php line 46
at CheckForMaintenanceMode->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in Request.php line 111
at Request->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 102
at Pipeline->then(object(Closure))in Kernel.php line 151
at Kernel->sendRequestThroughRouter(object(Request))in Kernel.php line 116
at Kernel->handle(object(Request))in index.php line 27
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment