Reply To: moving from one PC to anther


After pasting the above into the Run SQL query/queries box on table simpleinvoices.si_sql_patchmanager:

There is a red “X” on the side of the query box, when you hover over it the message is “unexpected token (near ALTER)
I’m by no means even an amateur at this but I’m trying LOL

Here’s what I got:

SQL query: Copy

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;
MySQL said: Documentation

#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘invoice_item_id as a key for the invoice_item_tax table.’, ‘20220926’, ‘’ at line 2