SimpleInvoices Group Forum › Forums › Fearless359 SimpleInvoices Discussion Group › going from version 2018.1.3 to 2019.1.1 (database issue) › Reply To: going from version 2018.1.3 to 2019.1.1 (database issue)
I found out the problem in the end. I backed up the database and when I tried to import it again restored it I originally “ignored” a error (don’t ask!)
ERROR 1366 (22007) at line 3982: Incorrect integer value: '' for column 'fear_invoices\’.’si_products’.’default_tax_id_2′ at row 1`
when I checked the database I could see that a few of the products (about 8) had been loaded but the rest (about 20) were not. All the culprit had their ‘default_tax_id_2’ field set to ” while the loaded had ‘0’
I fixed the file to and reimport it again and after that all was good.
So I guess you are right the database did import fully and then SI assumed it wasn’t not installed!
What I don’t get is why some of the product where not set correctly. And how do you set that Tax_2 field?
Anyway the problem is solved on my side. Now I need to check that all still work as expected before switching over.