Forum

Ask, reply and learn. Join the community of Akaunting.

New Discussion

1.3.9 now broken

Andy McBride   ( User )

Commented 5 years ago

Upgraded today to 1.3.9. When I try and save an invoice I get:


 





Whoops, looks like something went wrong.
 










(3/3) QueryException

SQLSTATE[HY000]: General error: 1364 Field 'tax_id' doesn't have a default value (SQL: insert into `akuy_invoice_items` (`company_id`, `invoice_id`, `item_id`, `name`, `sku`, `quantity`, `price`, `tax`, `total`, `updated_at`, `created_at`) values (1, 555, 18, Loops, Neon Blue, 6 inch, 100 / pack, LoopNBL, 2, 6.95, 0, 13.9, 2019-01-11 00:24:17, 2019-01-11 00:24:17))







in Connection.php line 647


at Connection->runQueryCallback('insert into `akuy_invoice_items` (`company_id`, `invoice_id`, `item_id`, `name`, `sku`, `quantity`, `price`, `tax`, `total`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)', array('1', 555, '18', 'Loops, Neon Blue, 6 inch, 100 / pack', 'LoopNBL', 2, 6.95000000000000017763568394002504646778106689453125, 0, 13.9000000000000003552713678800500929355621337890625, '2019-01-11 00:24:17', '2019-01-11 00:24:17'), object(Closure))in Connection.php line 607


at Connection->run('insert into `akuy_invoice_items` (`company_id`, `invoice_id`, `item_id`, `name`, `sku`, `quantity`, `price`, `tax`, `total`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)', array('1', 555, '18', 'Loops, Neon Blue, 6 inch, 100 / pack', 'LoopNBL', 2, 6.95000000000000017763568394002504646778106689453125, 0, 13.9000000000000003552713678800500929355621337890625, '2019-01-11 00:24:17', '2019-01-11 00:24:17'), object(Closure))in Connection.php line 450


at Connection->statement('insert into `akuy_invoice_items` (`company_id`, `invoice_id`, `item_id`, `name`, `sku`, `quantity`, `price`, `tax`, `total`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)', array('1', 555, '18', 'Loops, Neon Blue, 6 inch, 100 / pack', 'LoopNBL', 2, 6.95000000000000017763568394002504646778106689453125, 0, 13.9000000000000003552713678800500929355621337890625, '2019-01-11 00:24:17', '2019-01-11 00:24:17'))in Connection.php line 404


at Connection->insert('insert into `akuy_invoice_items` (`company_id`, `invoice_id`, `item_id`, `name`, `sku`, `quantity`, `price`, `tax`, `total`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)', array('1', 555, '18', 'Loops, Neon Blue, 6 inch, 100 / pack', 'LoopNBL', 2, 6.95000000000000017763568394002504646778106689453125, 0, 13.9000000000000003552713678800500929355621337890625, '2019-01-11 00:24:17', '2019-01-11 00:24:17'))in Processor.php line 32


at Processor->processInsertGetId(object(Builder), 'insert into `akuy_invoice_items` (`company_id`, `invoice_id`, `item_id`, `name`, `sku`, `quantity`, `price`, `tax`, `total`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)', array('1', 555, '18', 'Loops, Neon Blue, 6 inch, 100 / pack', 'LoopNBL', 2, 6.95000000000000017763568394002504646778106689453125, 0, 13.9000000000000003552713678800500929355621337890625, '2019-01-11 00:24:17', '2019-01-11 00:24:17'), 'id')in Builder.php line 2133


at Builder->insertGetId(array('company_id' => '1', 'invoice_id' => 555, 'item_id' => '18', 'name' => 'Loops, Neon Blue, 6 inch, 100 / pack', 'sku' => 'LoopNBL', 'quantity' => 2, 'price' => 6.95000000000000017763568394002504646778106689453125, 'tax' => 0, 'total' => 13.9000000000000003552713678800500929355621337890625, 'updated_at' => '2019-01-11 00:24:17', 'created_at' => '2019-01-11 00:24:17'), 'id')in Builder.php line 1251


at Builder->__call('insertGetId', array(array('company_id' => '1', 'invoice_id' => 555, 'item_id' => '18', 'name' => 'Loops, Neon Blue, 6 inch, 100 / pack', 'sku' => 'LoopNBL', 'quantity' => 2, 'price' => 6.95000000000000017763568394002504646778106689453125, 'tax' => 0, 'total' => 13.9000000000000003552713678800500929355621337890625, 'updated_at' => '2019-01-11 00:24:17', 'created_at' => '2019-01-11 00:24:17'), 'id'))in Model.php line 688


at Builder->insertGetId(array('company_id' => '1', 'invoice_id' => 555, 'item_id' => '18', 'name' => 'Loops, Neon Blue, 6 inch, 100 / pack', 'sku' => 'LoopNBL', 'quantity' => 2, 'price' => 6.95000000000000017763568394002504646778106689453125, 'tax' => 0, 'total' => 13.9000000000000003552713678800500929355621337890625, 'updated_at' => '2019-01-11 00:24:17', 'created_at' => '2019-01-11 00:24:17'), 'id')in Model.php line 688


at Model->insertAndSetId(object(Builder), array('company_id' => '1', 'invoice_id' => 555, 'item_id' => '18', 'name' => 'Loops, Neon Blue, 6 inch, 100 / pack', 'sku' => 'LoopNBL', 'quantity' => 2, 'price' => 6.95000000000000017763568394002504646778106689453125, 'tax' => 0, 'total' => 13.9000000000000003552713678800500929355621337890625, 'updated_at' => '2019-01-11 00:24:17', 'created_at' => '2019-01-11 00:24:17'))in Model.php line 653


at Model->performInsert(object(Builder))in Model.php line 522


at Model->save()in Builder.php line 734


at Builder->Illuminate\Database\Eloquent\{closure}(object(InvoiceItem))in helpers.php line 964


at tap(object(InvoiceItem), object(Closure))in Builder.php line 735


at Builder->create(array('company_id' => '1', 'invoice_id' => 555, 'item_id' => '18', 'name' => 'Loops, Neon Blue, 6 inch, 100 / pack', 'sku' => 'LoopNBL', 'quantity' => 2, 'price' => 6.95000000000000017763568394002504646778106689453125, 'tax' => 0, 'total' => 13.9000000000000003552713678800500929355621337890625))in Model.php line 1374


at Model->__call('create', array(array('company_id' => '1', 'invoice_id' => 555, 'item_id' => '18', 'name' => 'Loops, Neon Blue, 6 inch, 100 / pack', 'sku' => 'LoopNBL', 'quantity' => 2, 'price' => 6.95000000000000017763568394002504646778106689453125, 'tax' => 0, 'total' => 13.9000000000000003552713678800500929355621337890625)))in Model.php line 1386


at InvoiceItem->create(array('company_id' => '1', 'invoice_id' => 555, 'item_id' => '18', 'name' => 'Loops, Neon Blue, 6 inch, 100 / pack', 'sku' => 'LoopNBL', 'quantity' => 2, 'price' => 6.95000000000000017763568394002504646778106689453125, 'tax' => 0, 'total' => 13.9000000000000003552713678800500929355621337890625))in Model.php line 1386


at Model::__callStatic('create', array(array('company_id' => '1', 'invoice_id' => 555, 'item_id' => '18', 'name' => 'Loops, Neon Blue, 6 inch, 100 / pack', 'sku' => 'LoopNBL', 'quantity' => 2, 'price' => 6.95000000000000017763568394002504646778106689453125, 'tax' => 0, 'total' => 13.9000000000000003552713678800500929355621337890625)))in CreateInvoiceItem.php line 207


at InvoiceItem::create(array('company_id' => '1', 'invoice_id' => 555, 'item_id' => '18', 'name' => 'Loops, Neon Blue, 6 inch, 100 / pack', 'sku' => 'LoopNBL', 'quantity' => 2, 'price' => 6.95000000000000017763568394002504646778106689453125, 'tax' => 0, 'total' => 13.9000000000000003552713678800500929355621337890625))in CreateInvoiceItem.php line 207


at CreateInvoiceItem->handle()


at call_user_func_array(array(object(CreateInvoiceItem), 'handle'), array())in BoundMethod.php line 30


at BoundMethod::Illuminate\Container\{closure}()in BoundMethod.php line 87


at BoundMethod::callBoundMethod(object(Application), array(object(CreateInvoiceItem), 'handle'), object(Closure))in BoundMethod.php line 31


at BoundMethod::call(object(Application), array(object(CreateInvoiceItem), 'handle'), array(), null)in Container.php line 539


at Container->call(array(object(CreateInvoiceItem), 'handle'))in Dispatcher.php line 94


at Dispatcher->Illuminate\Bus\{closure}(object(CreateInvoiceItem))in Pipeline.php line 114


at Pipeline->Illuminate\Pipeline\{closure}(object(CreateInvoiceItem))in Pipeline.php line 102


at Pipeline->then(object(Closure))in Dispatcher.php line 98


at Dispatcher->dispatchNow(object(CreateInvoiceItem))in Dispatcher.php line 75


at Dispatcher->dispatch(object(CreateInvoiceItem))in helpers.php line 378


at dispatch(object(CreateInvoiceItem))in UpdateInvoice.php line 76


at UpdateInvoice->handle()


at call_user_func_array(array(object(UpdateInvoice), 'handle'), array())in BoundMethod.php line 30


at BoundMethod::Illuminate\Container\{closure}()in BoundMethod.php line 87


at BoundMethod::callBoundMethod(object(Application), array(object(UpdateInvoice), 'handle'), object(Closure))in BoundMethod.php line 31


at BoundMethod::call(object(Application), array(object(UpdateInvoice), 'handle'), array(), null)in Container.php line 539


at Container->call(array(object(UpdateInvoice), 'handle'))in Dispatcher.php line 94


at Dispatcher->Illuminate\Bus\{closure}(object(UpdateInvoice))in Pipeline.php line 114


at Pipeline->Illuminate\Pipeline\{closure}(object(UpdateInvoice))in Pipeline.php line 102


at Pipeline->then(object(Closure))in Dispatcher.php line 98


at Dispatcher->dispatchNow(object(UpdateInvoice))in Dispatcher.php line 75






 




 






Denis Dulici   ( Admin )

Commented 5 years ago

Andy, from which version did you update? What happened during the update? Have you done any customization to the code?

Andy McBride   ( User )

Commented 5 years ago

Denis,


Upgraded from 1.3.8. Upgraded using upgrade feature in Akaunting. Nothing abnormal occured during the upgrade. I noted that the version at the bottom of the page was at 1.3.9 and I could use the system with the exception that I could not save an invoice.


I have not made any moditications other than installing the latetest version of Custom Fields (also broken see emails to support) and turning on logging.


From the loggs it looked like the issue was being caused by the Custom Field app so this morning I decided to uninstalled Custom Fields app (as my system is unusable at this point). I used the uninstall feature in the Apps menu. The uninstall loooks like it did not work and now my system is completely useless as when I try and access the application I get this:


 






(1/1) FileNotFoundException



File does not exist at path /module.json





Andy McBride   ( User )

Commented 5 years ago

Was able to get Akaunting functional again by deleting storage/framework/cache for Custom Field. Then reinstalled the App. Seems to be working OK now. Still working on some asks for Custom Fields.

Please login or register to leave a response.

Showing 1 to 4 of 4 discussions