SimpleInvoices Group Forum › Forums › Fearless359 SimpleInvoices Discussion Group › moving from one PC to anther › Reply To: moving from one PC to anther
May 28, 2023 at 6:48 am
#1915
Participant
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, 3 months ago by
RRowley.
Recent Comments