Reply To: Update SI from an old version

#2013
fearless359
Keymaster

Via phpMyAdmin, access the si_invoice_items table and execute the following SQL command:

ALTER TABLE si_invoice_items MODIFY id INT(11) UNSIGNED NOT NULL;

Had to dig, but issue is that the invoice_item_id field in the si_invoice_item_tax table is configured differently than the id field in the si_invoice_items table. This command corrects the issue.

  • This reply was modified 8 months, 3 weeks ago by fearless359.
  • This reply was modified 8 months, 3 weeks ago by fearless359.