Reply To: Update from 2019 to 2026

[altaphista]

I’ve been diving into your SqlPatchManager code trying to retrieve the error. After some time debugging I saw that this query threw an error: ALTER TABLE 'si_invoice_item_tax' ADD CONSTRAINT 'si_invoice_item_tax_ibfk_2' FOREIGN KEY ('invoice_item_id') REFERENCES 'si_invoice_items'('id') ON DELETE NO ACTION ON UPDATE CASCADE; .

Digging further into the database buildup I stumbled upon the error: invoice_items.id did not have the attritbute ‘UNSIGNED’.

The fix: ALTER TABLE 'si_invoice_items' CHANGE 'id' 'id' INT(11) UNSIGNED NOT NULL AUTO_INCREMENT;

Thanks again for your time and efforts Fearless!

• This reply was modified 3 months ago by altaphista. Reason: typo
• This reply was modified 3 months ago by altaphista.