Problem Creating Task (Self Hosted)

Self-Hosted | v4/Legacy
1

Hi

I am having problems creating a task on my Self Hosted installation. When I attempt it I get ‘Whoops, looks like something went wrong’. This happens on Timer and Manual.

Any advice appreciated.

Thanks
Will

2

Can you check the log in storage/log/laravel.log for any details about the error.

If you’ve recently updated your code make sure you’ve updated the database by loading /update.

3

Hi

I updated via Softaculous so i’m not sure if everything was completed correctly or not. See todays log below:

[2015-07-28 08:46:44] production.ERROR: Illuminate\Database\QueryException [42S22] : /home/flexiweb/public_html/invoicing/vendor/laravel/framework/src/Illuminate/Database/Connection.php [Line 624] => SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘is_running’ in ‘field list’ (SQL: insert intotasks(user_id,account_id,public_id,client_id,description,start_time,is_running,duration,break_duration,time_log,updated_at,created_at) values (1, 1, 1, 29, adding waistcoats to online store, 2015-07-28 08:46:44, 1, , , [[1438073204,false]], 2015-07-28 08:46:44, 2015-07-28 08:46:44)) {"context":"PHP","user_id":1,"user_name":"System Administrator","url":"http://invoicing.flexiweb.ie/public/tasks","user_agent":"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/44.0.2403.107 Safari/537.36","ip":"193.1.212.60","count":1} [2015-07-28 08:47:00] production.ERROR: ***Illuminate\Database\QueryException*** [42S22] : /home/flexiweb/public_html/invoicing/vendor/laravel/framework/src/Illuminate/Database/Connection.php [Line 624] =&gt; SQLSTATE[42S22]: Column not found: 1054 Unknown column 'is_running' in 'field list' (SQL: insert into <code>tasks</code> (<code>user_id</code>, <code>account_id</code>, <code>public_id</code>, <code>client_id</code>, <code>description</code>, <code>start_time</code>, <code>is_running</code>, <code>duration</code>, <code>break_duration</code>, <code>time_log</code>, <code>updated_at</code>, <code>created_at</code>) values (1, 1, 1, 29, adding waistcoats to online store, 2015-07-28 08:47:00, 1, , , [[1438073220,false]], 2015-07-28 08:47:00, 2015-07-28 08:47:00)) {"context":"PHP","user_id":1,"user_name":"System Administrator","url":"http://invoicing.flexiweb.ie/public/tasks","user_agent":"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/44.0.2403.107 Safari/537.36","ip":"193.1.212.60","count":2} [2015-07-28 08:51:33] production.ERROR: ***Illuminate\Database\QueryException*** [42S22] : /home/flexiweb/public_html/invoicing/vendor/laravel/framework/src/Illuminate/Database/Connection.php [Line 624] =&gt; SQLSTATE[42S22]: Column not found: 1054 Unknown column 'is_running' in 'field list' (SQL: insert into <code>tasks</code> (<code>user_id</code>, <code>account_id</code>, <code>public_id</code>, <code>client_id</code>, <code>description</code>, <code>start_time</code>, <code>is_running</code>, <code>duration</code>, <code>break_duration</code>, <code>time_log</code>, <code>updated_at</code>, <code>created_at</code>) values (1, 1, 1, 29, adding waistcoats to online store, 2015-07-28 08:51:33, 1, , , [[1438073493,false]], 2015-07-28 08:51:33, 2015-07-28 08:51:33)) {"context":"PHP","user_id":1,"user_name":"System Administrator","url":"http://invoicing.flexiweb.ie/public/tasks","user_agent":"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/44.0.2403.107 Safari/537.36","ip":"193.1.212.60","count":3} [2015-07-28 08:52:43] production.ERROR: ***Illuminate\Database\QueryException*** [42S22] : /home/flexiweb/public_html/invoicing/vendor/laravel/framework/src/Illuminate/Database/Connection.php [Line 624] =&gt; SQLSTATE[42S22]: Column not found: 1054 Unknown column 'break_duration' in 'field list' (SQL: insert into <code>tasks</code> (<code>user_id</code>, <code>account_id</code>, <code>public_id</code>, <code>client_id</code>, <code>description</code>, <code>start_time</code>, <code>duration</code>, <code>break_duration</code>, <code>time_log</code>, <code>updated_at</code>, <code>created_at</code>) values (1, 1, 1, 29, adding waistcoats to online store, 2015-07-28 08:51:49, 3600, 0, [], 2015-07-28 08:52:43, 2015-07-28 08:52:43)) {"context":"PHP","user_id":1,"user_name":"System Administrator","url":"http://invoicing.flexiweb.ie/public/tasks","user_agent":"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/44.0.2403.107 Safari/537.36","ip":"193.1.212.60","count":4}

4

Try loading http://invoicing.flexiweb.ie/public/update and then trying again.

5

I had a look via FTP and that folder doesnt exist.

6

It’s not a folder, it’s a route. The application uses mod_rewrite to convert paths to areas of the app.

https://github.com/hillelcoren/invoice-ninja/blob/master/app/Http/routes.php

7

Bingo thanks!