SimpleInvoices Group Forum › Forums › Fearless359 SimpleInvoices Discussion Group › moving from one PC to anther › 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:
Error
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
Recent Comments