May 28, 2023 at 6:48 am #1915
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 3 months, 3 weeks ago by RRowley.