Ask, reply and learn. Join the community of Akaunting.
I get the below error trying to create an invoice:
SQLSTATEP3000J: Integrity constraint violation: 1048
Column 'account_id' cannot be null (SQL: insert into
( 'company_id
account_id', 'ledgerable_id', 'ledgerable_type',
'issued_at', 'entry_type', 'debit', 'updated_at',
' created_at4) values (71095, ?, 328135, App\Models\sale\lnvoice, 2020-05-11 22:12:28, total, 0,2020-05-11
22:12:32, 2020-05-11 22:12:31))
Were you able to resolve this? I have been running into the same issue when trying to create an invoice or enter a payment. I put in a ticket about 5 hours ago but haven't heard back yet.
I abandoned the whole thing after waiting for a response and struggling with other issues in the software , but this was their response later:
'Hello,
We're not able to reproduce such an issue so please, provide us an admin account of your Akaunting installation so we could see what's going wrong there.'
I was debating the same thing... I just purchased the double entry, spent a few hours setting up the chart of accounts and then had no way to enter anything. Not a good feeling trying to weigh the decision on which platform to use...
I did find that when running the site in another window in incognito mode, I didn’t get the error. I’m assuming it’s an issue if you have multiple tabs open to the site. There’s probably multiple versions of the cache and the browser doesn’t know what to do as it still doesn’t see something like a vendor you set up in another tab. Closing all tabs and doing a hard refresh (control + F5) on the site may work too, but I’ll try it next time.
Thanks for the reply.
Goodluck.
Hi all,
I just ran into this issue too. I cannot post invoices and I get same error above. What is the best resolution to this ?
Regards
Hey folks. you are exactly correct. When i went into private window I could work with the invoices and not get this SQL error. This is weird and unfortunately but I must say that after it started working I was quite impressed. But this bug needs fast attention indeed ! I've filed a ticket with them. Hopefully their speed will be faster than the reports online ....
Showing 1 to 6 of 6 discussions