Reply To: going from version 2018.1.3 to 2019.1.1 (database issue)

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)

September 22, 2019 at 1:54 am #569
ppmt
Participant

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.

  • This reply was modified 4 years, 10 months ago by ppmt.
  • This reply was modified 4 years, 10 months ago by ppmt.
  • This reply was modified 4 years, 10 months ago by ppmt.
  • This reply was modified 4 years, 10 months ago by ppmt.