Reply To: moving from one PC to anther


The sinqle quotes surrounding the strings in the values were converted to a different character. I’ll try again and see if it stores correctly.

INSERT INTO si_sql_patchmanager (sql_patch_ref, sql_patch, sql_release, sql_statement, source) VALUES
(330, 'Add invoice_item_id as a key for the invoice_item_tax table.', '20220926', 'ALTER TABLE si_invoice_item_tax MODIFY invoice_item_id INT(11) UNSIGNED NOT NULL, MODIFY tax_id INT(11) UNSIGNED NOT NULL; ALTER TABLE si_invoice_item_tax ADD KEY invoice_item_id (invoice_item_id);', 'fearless359');

This appears to work. Give it a try.

  • This reply was modified 1 year ago by RRowley.