I was using Invoiceninja 3.3.0 self hosted. Everything was working great until my product table suddenly got empty for no reason. So i updated to 3.5.1 but it is still the same, the table is empty. I tried creating a new product which I did successfully but it does not appear in the table. Still empty… What can I do to debug that ?
I’m referring to the UI. I didn’t checked the mysql table.
In the UI, all my products disapear but they are still in the drop-down list on Quote page.
Back to products page, if I change the filter from active to something else, I have this error :
DataTables warning: table id=DataTables_Table_0 - Ajax error. For more information about this error, please see http://datatables.net/tn/7
I think I know what happened. I have added a product with text after the number, like “50 CHF”. When I saved, InvoiceNinja removed the text “CHF” but since that moment my list is empty. Maybe I should check the mysql table…
I find the mistake by opening the mysql database. I did a wrong copy/past and put some text inside a product comment.
You can reproduce the problem by adding this text inside one of your product comment :