Forum

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

New Discussion

akaunting /income/revenue/add new (***ERROR***)

Zeeshan Javed   ( User )

Commented 3 years ago

hello,

we are using Akaunting Version 1.3.17 . everything was working fine and smooth , just from yesterday we started getting the following error while adding new entry in income/revenue . kindly suggest whats the cause for this error and how to fix it. anybody.... thanks :)

https://accounts.esoftware.pk/incomes/revenues

Whoops, looks like something went wrong.
(3/3) QueryException

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'account_id' cannot be null (SQL: insert into `akmo_double_entry_ledger` (`company_id`, `account_id`, `ledgerable_id`, `ledgerable_type`, `issued_at`, `entry_type`, `debit`, `updated_at`, `created_at`) values (3, , 3726, App\Models\Expense\Payment, 2020-08-17 11:30:50, item, 328785, 2020-11-12 11:30:50, 2020-11-12 11:30:50))
in Connection.php line 647
at Connection->runQueryCallback('insert into `akmo_double_entry_ledger` (`company_id`, `account_id`, `ledgerable_id`, `ledgerable_type`, `issued_at`, `entry_type`, `debit`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array(3, null, 3726, 'App\\Models\\Expense\\Payment', object(Carbon), 'item', 328785.0, '2020-11-12 11:30:50', '2020-11-12 11:30:50'), object(Closure))in Connection.php line 607
at Connection->run('insert into `akmo_double_entry_ledger` (`company_id`, `account_id`, `ledgerable_id`, `ledgerable_type`, `issued_at`, `entry_type`, `debit`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array(3, null, 3726, 'App\\Models\\Expense\\Payment', object(Carbon), 'item', 328785.0, '2020-11-12 11:30:50', '2020-11-12 11:30:50'), object(Closure))in Connection.php line 450
at Connection->statement('insert into `akmo_double_entry_ledger` (`company_id`, `account_id`, `ledgerable_id`, `ledgerable_type`, `issued_at`, `entry_type`, `debit`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array(3, null, 3726, 'App\\Models\\Expense\\Payment', object(Carbon), 'item', 328785.0, '2020-11-12 11:30:50', '2020-11-12 11:30:50'))in Connection.php line 404
at Connection->insert('insert into `akmo_double_entry_ledger` (`company_id`, `account_id`, `ledgerable_id`, `ledgerable_type`, `issued_at`, `entry_type`, `debit`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array(3, null, 3726, 'App\\Models\\Expense\\Payment', object(Carbon), 'item', 328785.0, '2020-11-12 11:30:50', '2020-11-12 11:30:50'))in Processor.php line 32
at Processor->processInsertGetId(object(Builder), 'insert into `akmo_double_entry_ledger` (`company_id`, `account_id`, `ledgerable_id`, `ledgerable_type`, `issued_at`, `entry_type`, `debit`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array(3, null, 3726, 'App\\Models\\Expense\\Payment', object(Carbon), 'item', 328785.0, '2020-11-12 11:30:50', '2020-11-12 11:30:50'), 'id')in Builder.php line 2133
at Builder->insertGetId(array(3, null, 3726, 'App\\Models\\Expense\\Payment', object(Carbon), 'item', 328785.0, '2020-11-12 11:30:50', '2020-11-12 11:30:50'), 'id')in Builder.php line 1251
at Builder->__call('insertGetId', array(array('company_id' => 3, 'account_id' => null, 'ledgerable_id' => 3726, 'ledgerable_type' => 'App\\Models\\Expense\\Payment', 'issued_at' => object(Carbon), 'entry_type' => 'item', 'debit' => 328785.0, 'updated_at' => '2020-11-12 11:30:50', 'created_at' => '2020-11-12 11:30:50'), 'id'))in Model.php line 688
at Model->insertAndSetId(object(Builder), array('company_id' => 3, 'account_id' => null, 'ledgerable_id' => 3726, 'ledgerable_type' => 'App\\Models\\Expense\\Payment', 'issued_at' => object(Carbon), 'entry_type' => 'item', 'debit' => 328785.0, 'updated_at' => '2020-11-12 11:30:50', 'created_at' => '2020-11-12 11:30:50'))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(Ledger))in helpers.php line 964
at tap(object(Ledger), object(Closure))in Builder.php line 735
at Builder->create(array('company_id' => 3, 'account_id' => null, 'ledgerable_id' => 3726, 'ledgerable_type' => 'App\\Models\\Expense\\Payment', 'issued_at' => object(Carbon), 'entry_type' => 'item', 'debit' => 328785.0))in Model.php line 1374
at Model->__call('create', array(array('company_id' => 3, 'account_id' => null, 'ledgerable_id' => 3726, 'ledgerable_type' => 'App\\Models\\Expense\\Payment', 'issued_at' => object(Carbon), 'entry_type' => 'item', 'debit' => 328785.0)))in Model.php line 1386
at Model::__callStatic('create', array(array('company_id' => 3, 'account_id' => null, 'ledgerable_id' => 3726, 'ledgerable_type' => 'App\\Models\\Expense\\Payment', 'issued_at' => object(Carbon), 'entry_type' => 'item', 'debit' => 328785.0)))in Payment.php line 48
at Payment->created(object(Payment))
at call_user_func_array(array(object(Payment), 'created'), array(object(Payment)))in Dispatcher.php line 367
at Dispatcher->Illuminate\Events\{closure}('eloquent.created: App\\Models\\Expense\\Payment', array(object(Payment)))in Dispatcher.php line 199
at Dispatcher->dispatch('eloquent.created: App\\Models\\Expense\\Payment', array(object(Payment)), false)in Dispatcher.php line 172
at Dispatcher->fire('eloquent.created: App\\Models\\Expense\\Payment', object(Payment))in HasEvents.php line 148
at Model->fireModelEvent('created', false)in Model.php line 674
at Model->performInsert(object(Builder))in Model.php line 522
at Model->save(array())in Hookable.php line 125
at Payment->save()in Builder.php line 734
at Builder->Illuminate\Database\Eloquent\{closure}(object(Payment))in helpers.php line 964
at tap(object(Payment), object(Closure))in Builder.php line 735
at Builder->create(array('_token' => '56qsEqPSpj4hhALppcGjlzILtBCsoMamz9cVw9Kq', 'paid_at' => '2020-08-17 11:30:50', 'currency_code' => 'PKR', 'currency_rate' => '1', 'amount' => 328785.0, 'account_id' => '14', 'vendor_id' => '372', 'description' => 'C1/OM/Apr.2020', 'category_id' => '76', 'recurring_frequency' => 'no', 'recurring_interval' => '1', 'recurring_custom_frequency' => 'monthly', 'recurring_count' => '0', 'payment_method' => 'offlinepayment.bank_transfer.2', 'reference' => null, 'company_id' => 3))in Model.php line 1374
at Model->__call('create', array(array('_token' => '56qsEqPSpj4hhALppcGjlzILtBCsoMamz9cVw9Kq', 'paid_at' => '2020-08-17 11:30:50', 'currency_code' => 'PKR', 'currency_rate' => '1', 'amount' => 328785.0, 'account_id' => '14', 'vendor_id' => '372', 'description' => 'C1/OM/Apr.2020', 'category_id' => '76', 'recurring_frequency' => 'no', 'recurring_interval' => '1', 'recurring_custom_frequency' => 'monthly', 'recurring_count' => '0', 'payment_method' => 'offlinepayment.bank_transfer.2', 'reference' => null, 'company_id' => 3)))in Model.php line 1386
at Model::__callStatic('create', array(array('_token' => '56qsEqPSpj4hhALppcGjlzILtBCsoMamz9cVw9Kq', 'paid_at' => '2020-08-17 11:30:50', 'currency_code' => 'PKR', 'currency_rate' => '1', 'amount' => 328785.0, 'account_id' => '14', 'vendor_id' => '372', 'description' => 'C1/OM/Apr.2020', 'category_id' => '76', 'recurring_frequency' => 'no', 'recurring_interval' => '1', 'recurring_custom_frequency' => 'monthly', 'recurring_count' => '0', 'payment_method' => 'offlinepayment.bank_transfer.2', 'reference' => null, 'company_id' => 3)))in Payments.php line 84
at Payments->store(object(Payment))
at call_user_func_array(array(object(Payments), 'store'), array(object(Payment)))in Controller.php line 55
at Controller->callAction('store', array(object(Payment)))in ControllerDispatcher.php line 44
at ControllerDispatcher->dispatch(object(Route), object(Payments), '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 LaratrustPermission.php line 56
at LaratrustPermission->handle(object(Request), object(Closure), array('create-expenses-payments'))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 Money.php line 77
at Money->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 DateFormat.php line 35
at DateFormat->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 LaratrustPermission.php line 56
at LaratrustPermission->handle(object(Request), object(Closure), array('read-admin-panel'))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 AdminMenu.php line 209
at AdminMenu->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 93
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 RedirectIfWizardCompleted.php line 20
at RedirectIfWizardCompleted->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 27
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 27
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 Authenticate.php line 43
at Authenticate->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

Denis Dulici   ( Admin )

Commented 3 years ago

Can't say anything about the error but you should definitely update to the latest version.

Please login or register to leave a response.

Showing 1 to 2 of 2 discussions