Forum

1.3.9 now broken

Posted in CategoryGeneral
  • Andy McBride    ( User ) 5 months 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 Duliçi    ( Admin ) 5 months ago

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

  • Andy McBride    ( User ) 5 months 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 ) 4 months 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.