Whoops, looks like something went wrong. Right after setup form - Azure VM

Self-Hosted | v4/Legacy
1

I’m getting this error right after the setup of the VM. I’ve added the info them on submit … BAM… here’s that LONG long long error…

Any solution out there ?

Whoops, looks like something went wrong.

2/2
QueryException in Connection.php line 669:
SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘all_pages_footer’ (SQL: alter table accounts add all_pages_footer tinyint(1) not null, add all_pages_header tinyint(1) not null, add show_currency_code tinyint(1) not null, add pro_plan_trial date null)
in Connection.php line 669
at Connection->runQueryCallback(‘alter table accounts add all_pages_footer tinyint(1) not null, add all_pages_header tinyint(1) not null, add show_currency_code tinyint(1) not null, add pro_plan_trial date null’, array(), object(Closure)) in Connection.php line 629
at Connection->run(‘alter table accounts add all_pages_footer tinyint(1) not null, add all_pages_header tinyint(1) not null, add show_currency_code tinyint(1) not null, add pro_plan_trial date null’, array(), object(Closure)) in Connection.php line 409
at Connection->statement(‘alter table accounts add all_pages_footer tinyint(1) not null, add all_pages_header tinyint(1) not null, add show_currency_code tinyint(1) not null, add pro_plan_trial date null’) in Blueprint.php line 83
at Blueprint->build(object(MySqlConnection), object(MySqlGrammar)) in Builder.php line 203
at Builder->build(object(Blueprint)) in Builder.php line 128
at Builder->table(‘accounts’, object(Closure)) in compiled.php line 6273
at Facade::__callStatic(‘table’, array(‘accounts’, object(Closure))) in 2016_01_27_173015_add_header_footer_option.php line 21
at Schema::table(‘accounts’, object(Closure)) in 2016_01_27_173015_add_header_footer_option.php line 21
at AddHeaderFooterOption->up() in Migrator.php line 147
at Migrator->runUp(‘2016_01_27_173015_add_header_footer_option’, ‘2’, false) in Migrator.php line 117
at Migrator->runMigrationList(array(‘2016_01_27_173015_add_header_footer_option’, ‘2016_02_01_135956_add_source_currency_to_expenses’, ‘2016_02_25_152948_add_client_password’, ‘2016_02_28_081424_add_custom_invoice_fields’, ‘2016_03_14_066181_add_user_permissions’, ‘2016_03_14_214710_add_support_three_decimal_taxes’), array(‘pretend’ => false, ‘step’ => false)) in Migrator.php line 86
at Migrator->run(’/var/www/html/ninja/database/migrations’, array(‘pretend’ => false, ‘step’ => false)) in MigrateCommand.php line 77
at MigrateCommand->fire()
at call_user_func_array(array(object(MigrateCommand), ‘fire’), array()) in compiled.php line 1235
at Container->call(array(object(MigrateCommand), ‘fire’)) in Command.php line 169
at Command->execute(object(ArrayInput), object(BufferedOutput)) in Command.php line 256
at Command->run(object(ArrayInput), object(BufferedOutput)) in Command.php line 155
at Command->run(object(ArrayInput), object(BufferedOutput)) in Application.php line 791
at Application->doRunCommand(object(MigrateCommand), object(ArrayInput), object(BufferedOutput)) in Application.php line 186
at Application->doRun(object(ArrayInput), object(BufferedOutput)) in Application.php line 117
at Application->run(object(ArrayInput), object(BufferedOutput)) in Application.php line 64
at Application->call(‘migrate’, array(’–force’ => true)) in Kernel.php line 159
at Kernel->call(‘migrate’, array(’–force’ => true)) in compiled.php line 6273
at Facade::__callStatic(‘call’, array(‘migrate’, array(’–force’ => true))) in AppController.php line 120
at Artisan::call(‘migrate’, array(’–force’ => true)) in AppController.php line 120
at AppController->doSetup()
at call_user_func_array(array(object(AppController), ‘doSetup’), array()) in compiled.php line 9333
at Controller->callAction(‘doSetup’, array()) in compiled.php line 9395
at ControllerDispatcher->call(object(AppController), object(Route), ‘doSetup’) in compiled.php line 9375
at ControllerDispatcher->Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
at Pipeline->Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in compiled.php line 9852
at Pipeline->then(object(Closure)) in compiled.php line 9376
at ControllerDispatcher->callWithinStack(object(AppController), object(Route), object(Request), ‘doSetup’) in compiled.php line 9363
at ControllerDispatcher->dispatch(object(Route), object(Request), ‘App\Http\Controllers\AppController’, ‘doSetup’) in compiled.php line 8450
at Route->runController(object(Request)) in compiled.php line 8437
at Route->run(object(Request)) in compiled.php line 8151
at Router->Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
at Pipeline->Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in compiled.php line 9852
at Pipeline->then(object(Closure)) in compiled.php line 8152
at Router->runRouteWithinStack(object(Route), object(Request)) in compiled.php line 8143
at Router->dispatchToRoute(object(Request)) in compiled.php line 8133
at Router->dispatch(object(Request)) in compiled.php line 2391
at Kernel->Illuminate\Foundation\Http{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
at Pipeline->Illuminate\Routing{closure}(object(Request)) in Debugbar.php line 49
at Debugbar->handle(object(Request), object(Closure))
at call_user_func_array(array(object(Debugbar), ‘handle’), array(object(Request), object(Closure))) in compiled.php line 9862
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in StartupCheck.php line 186
at StartupCheck->handle(object(Request), object(Closure))
at call_user_func_array(array(object(StartupCheck), ‘handle’), array(object(Request), object(Closure))) in compiled.php line 9862
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in DuplicateSubmissionCheck.php line 33
at DuplicateSubmissionCheck->handle(object(Request), object(Closure))
at call_user_func_array(array(object(DuplicateSubmissionCheck), ‘handle’), array(object(Request), object(Closure))) in compiled.php line 9862
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 3163
at VerifyCsrfToken->handle(object(Request), object(Closure)) in VerifyCsrfToken.php line 42
at VerifyCsrfToken->handle(object(Request), object(Closure))
at call_user_func_array(array(object(VerifyCsrfToken), ‘handle’), array(object(Request), object(Closure))) in compiled.php line 9862
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13290
at ShareErrorsFromSession->handle(object(Request), object(Closure))
at call_user_func_array(array(object(ShareErrorsFromSession), ‘handle’), array(object(Request), object(Closure))) in compiled.php line 9862
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 11846
at StartSession->handle(object(Request), object(Closure))
at call_user_func_array(array(object(StartSession), ‘handle’), array(object(Request), object(Closure))) in compiled.php line 9862
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13029
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
at call_user_func_array(array(object(AddQueuedCookiesToResponse), ‘handle’), array(object(Request), object(Closure))) in compiled.php line 9862
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 12966
at EncryptCookies->handle(object(Request), object(Closure))
at call_user_func_array(array(object(EncryptCookies), ‘handle’), array(object(Request), object(Closure))) in compiled.php line 9862
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 3224
at CheckForMaintenanceMode->handle(object(Request), object(Closure))
at call_user_func_array(array(object(CheckForMaintenanceMode), ‘handle’), array(object(Request), object(Closure))) in compiled.php line 9862
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in compiled.php line 9852
at Pipeline->then(object(Closure)) in compiled.php line 2338
at Kernel->sendRequestThroughRouter(object(Request)) in compiled.php line 2322
at Kernel->handle(object(Request)) in index.php line 53
1/2
PDOException in Connection.php line 408:
SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘all_pages_footer’
in Connection.php line 408
at PDOStatement->execute(array()) in Connection.php line 408
at Connection->Illuminate\Database{closure}(object(MySqlConnection), ‘alter table accounts add all_pages_footer tinyint(1) not null, add all_pages_header tinyint(1) not null, add show_currency_code tinyint(1) not null, add pro_plan_trial date null’, array()) in Connection.php line 662
at Connection->runQueryCallback(‘alter table accounts add all_pages_footer tinyint(1) not null, add all_pages_header tinyint(1) not null, add show_currency_code tinyint(1) not null, add pro_plan_trial date null’, array(), object(Closure)) in Connection.php line 629
at Connection->run(‘alter table accounts add all_pages_footer tinyint(1) not null, add all_pages_header tinyint(1) not null, add show_currency_code tinyint(1) not null, add pro_plan_trial date null’, array(), object(Closure)) in Connection.php line 409
at Connection->statement(‘alter table accounts add all_pages_footer tinyint(1) not null, add all_pages_header tinyint(1) not null, add show_currency_code tinyint(1) not null, add pro_plan_trial date null’) in Blueprint.php line 83
at Blueprint->build(object(MySqlConnection), object(MySqlGrammar)) in Builder.php line 203
at Builder->build(object(Blueprint)) in Builder.php line 128
at Builder->table(‘accounts’, object(Closure)) in compiled.php line 6273
at Facade::__callStatic(‘table’, array(‘accounts’, object(Closure))) in 2016_01_27_173015_add_header_footer_option.php line 21
at Schema::table(‘accounts’, object(Closure)) in 2016_01_27_173015_add_header_footer_option.php line 21
at AddHeaderFooterOption->up() in Migrator.php line 147
at Migrator->runUp(‘2016_01_27_173015_add_header_footer_option’, ‘2’, false) in Migrator.php line 117
at Migrator->runMigrationList(array(‘2016_01_27_173015_add_header_footer_option’, ‘2016_02_01_135956_add_source_currency_to_expenses’, ‘2016_02_25_152948_add_client_password’, ‘2016_02_28_081424_add_custom_invoice_fields’, ‘2016_03_14_066181_add_user_permissions’, ‘2016_03_14_214710_add_support_three_decimal_taxes’), array(‘pretend’ => false, ‘step’ => false)) in Migrator.php line 86
at Migrator->run(’/var/www/html/ninja/database/migrations’, array(‘pretend’ => false, ‘step’ => false)) in MigrateCommand.php line 77
at MigrateCommand->fire()
at call_user_func_array(array(object(MigrateCommand), ‘fire’), array()) in compiled.php line 1235
at Container->call(array(object(MigrateCommand), ‘fire’)) in Command.php line 169
at Command->execute(object(ArrayInput), object(BufferedOutput)) in Command.php line 256
at Command->run(object(ArrayInput), object(BufferedOutput)) in Command.php line 155
at Command->run(object(ArrayInput), object(BufferedOutput)) in Application.php line 791
at Application->doRunCommand(object(MigrateCommand), object(ArrayInput), object(BufferedOutput)) in Application.php line 186
at Application->doRun(object(ArrayInput), object(BufferedOutput)) in Application.php line 117
at Application->run(object(ArrayInput), object(BufferedOutput)) in Application.php line 64
at Application->call(‘migrate’, array(’–force’ => true)) in Kernel.php line 159
at Kernel->call(‘migrate’, array(’–force’ => true)) in compiled.php line 6273
at Facade::__callStatic(‘call’, array(‘migrate’, array(’–force’ => true))) in AppController.php line 120
at Artisan::call(‘migrate’, array(’–force’ => true)) in AppController.php line 120
at AppController->doSetup()
at call_user_func_array(array(object(AppController), ‘doSetup’), array()) in compiled.php line 9333
at Controller->callAction(‘doSetup’, array()) in compiled.php line 9395
at ControllerDispatcher->call(object(AppController), object(Route), ‘doSetup’) in compiled.php line 9375
at ControllerDispatcher->Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
at Pipeline->Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in compiled.php line 9852
at Pipeline->then(object(Closure)) in compiled.php line 9376
at ControllerDispatcher->callWithinStack(object(AppController), object(Route), object(Request), ‘doSetup’) in compiled.php line 9363
at ControllerDispatcher->dispatch(object(Route), object(Request), ‘App\Http\Controllers\AppController’, ‘doSetup’) in compiled.php line 8450
at Route->runController(object(Request)) in compiled.php line 8437
at Route->run(object(Request)) in compiled.php line 8151
at Router->Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
at Pipeline->Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in compiled.php line 9852
at Pipeline->then(object(Closure)) in compiled.php line 8152
at Router->runRouteWithinStack(object(Route), object(Request)) in compiled.php line 8143
at Router->dispatchToRoute(object(Request)) in compiled.php line 8133
at Router->dispatch(object(Request)) in compiled.php line 2391
at Kernel->Illuminate\Foundation\Http{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
at Pipeline->Illuminate\Routing{closure}(object(Request)) in Debugbar.php line 49
at Debugbar->handle(object(Request), object(Closure))
at call_user_func_array(array(object(Debugbar), ‘handle’), array(object(Request), object(Closure))) in compiled.php line 9862
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in StartupCheck.php line 186
at StartupCheck->handle(object(Request), object(Closure))
at call_user_func_array(array(object(StartupCheck), ‘handle’), array(object(Request), object(Closure))) in compiled.php line 9862
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in DuplicateSubmissionCheck.php line 33
at DuplicateSubmissionCheck->handle(object(Request), object(Closure))
at call_user_func_array(array(object(DuplicateSubmissionCheck), ‘handle’), array(object(Request), object(Closure))) in compiled.php line 9862
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 3163
at VerifyCsrfToken->handle(object(Request), object(Closure)) in VerifyCsrfToken.php line 42
at VerifyCsrfToken->handle(object(Request), object(Closure))
at call_user_func_array(array(object(VerifyCsrfToken), ‘handle’), array(object(Request), object(Closure))) in compiled.php line 9862
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13290
at ShareErrorsFromSession->handle(object(Request), object(Closure))
at call_user_func_array(array(object(ShareErrorsFromSession), ‘handle’), array(object(Request), object(Closure))) in compiled.php line 9862
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 11846
at StartSession->handle(object(Request), object(Closure))
at call_user_func_array(array(object(StartSession), ‘handle’), array(object(Request), object(Closure))) in compiled.php line 9862
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13029
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
at call_user_func_array(array(object(AddQueuedCookiesToResponse), ‘handle’), array(object(Request), object(Closure))) in compiled.php line 9862
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 12966
at EncryptCookies->handle(object(Request), object(Closure))
at call_user_func_array(array(object(EncryptCookies), ‘handle’), array(object(Request), object(Closure))) in compiled.php line 9862
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 3224
at CheckForMaintenanceMode->handle(object(Request), object(Closure))
at call_user_func_array(array(object(CheckForMaintenanceMode), ‘handle’), array(object(Request), object(Closure))) in compiled.php line 9862
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in compiled.php line 9852
at Pipeline->then(object(Closure)) in compiled.php line 2338
at Kernel->sendRequestThroughRouter(object(Request)) in compiled.php line 2322
at Kernel->handle(object(Request)) in index.php line 53
Messages1TimelineExceptions2Views0RouteQueries34MailsSessionRequest295.2ms12.5MBPOST setup

2

It looks like the database migration is failing however with our latest releases we now setup the app using a SQL file.

In the error I see “at Artisan::call(‘migrate’, array(‘–force’ => true)) in AppController.php line 120”, however the code in the master branch is different.

https://github.com/invoiceninja/invoiceninja/blob/master/app/Http/Controllers/AppController.php#L120

Which version of the app are you using?

3

I am using the one from microsoft.

Here’s there text off there web addin menu from Azure

Duno where to check for the version number it’s an all in one from there virtual machine system.

They have an error on there text to start with

  • /var/www/html/invoiceninja IS /var/www/html/ninja
    and
  • :8080 seams to only be port 80

/******************************************

  • Microsoft information off there website *
    ******************************************/

This Image is made specially for Enterprise Customers who are looking for deploying a secured Invoice Ninja installation instead of just putting up a vanilla install.

Disclaimer:The respective trademarks mentioned in the offering are owned by the respective companies.

For Stack specific support : Contact Stack Developer Team(Since we do not own the IP for the stack,Stack developers should be contacted for any support)

For Image related support: Contact SecureAnyCLoud Team

Installation Instructions for Ubuntu
1.Application URL: Access the application via a browser at “http://PublicDNS:8080”.

2.Default installation path: will be on your web root folder “/var/www/html/invoiceninja”.

3.Default ports:

Linux Machines: SSH Port – 22 or 2222
Http: 80 or 8080
Https: 443
Sql or Mysql ports: By default these are not open on Public Endpoints. Internally Sql server: 1433. Mysql :3306
4.Database Login Details : MYSQL Username : root || MYSQL Password : Passw@rd123

For more information on the Cognosys Secured Invoice Ninja on Ubuntu 14.04 LTS visit our website.

Professional License is permissive for 5 to 50 Users. It is ideal for small to mid-size organisations

Invoice Ninja is a solution for invoicing and billing customers. With Invoice Ninja, you can easily build and send beautiful invoices from any device that has access to the web. Your clients can print your invoices, download them as pdf files, and even pay you online from within the system.Invoice Ninja has been built from the ground up to keep your data safe.With Invoice Ninja, we’ve done away with the need for cumbersome multi-click invoice previewing after each save.

Invoice Ninja seamlessly integrates with all of the top internet payment processors and gateways so you can get paid for your work quickly and easily.

4

This is the first I’ve heard of this installer, you may want to follow up directly with the provider.

Alternatively, here are other methods to install the app.

http://docs.invoiceninja.com/en/latest/install.html

5

Will the pay as you go from microsoft works in alliance with you guys for the pro version ?

6

I’m not sure what you mean by ‘pay as you go from microsoft’, can you send me a link for more info?

All Pro and Enterprise features from the hosted app are included in the open-source code. We offer a $20 per year white-label license to remove our branding.

7

here’s a link to pricing and information.
https://azuremarketplace.microsoft.com/en-us/marketplace/apps/cognosys.secured-invoice-ninja-on-centos?tab=PlansAndPrice

8

Thanks for the link!

I’ve reached out to them asking to upgrade to our latest version.

9

been doin the procedure and now PHP is all messed up and nothing seams to work. i’ll remake the Virtual Machine.

10

Just to be shure we are on the same page where the error occure I started this thread with.

on the last step of this page (Create the administrative user information (A). Accept the Terms of Services (B) and click the Submit button ©.) :
Step6
http://blog.technerdservices.com/index.php/2015/04/techpop-how-to-install-invoice-ninja-on-ubuntu-14-04/

As I click the Submit button. that’s where the error occure and I should be seeing this but nop that’S not what i am seeing.
Done

11

From your original error I’d suggest using our latest version (v3.1.1).

12

I’ve moved the file of ninja to a backup location and added the new version insted. erro 500 now when trying to load.
moved back to what it was now i’m getting a new error…

is there a precise procedure to upgrade …
1- get package
2- backup old files
3- copy files overs the old one
4- hope it works …

13

Are you trying to update the version that failed to install, I don’t think that will work.

I’d suggest installing the app from scratch.

14

but it comes already installed on the virtual server with the version 2.5.1.3.

Can’t install from scratch if already built in.

… edited…
Ok got it back working to the setup page in 2.5.1.3 version…
so back to error 1.

15

If you want to use this server you’ll need to follow up with the provider for help, we aren’t able to provide support for their installer.

16

Would love but here’s the info from microsoft for help:

Invoice Ninja Setup

If you need help you can either post to our support forum or email us at contact@invoiceninja.com.

our support forum = here where i am atm

17

I’d suggest using the live chat here: http://secureanycloud.com/

18

i’ve manage to copy the newer version over the 2.5 one… once setup is done. i’m having the same problem again.

19

Try re-creating the database before using the setup page.

20

droping the table and re-creating it made it worked ! now to upgrade to 3.1 …