[johnanastasio]

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

[johnanastasio]

Forgot to add, none of the items use/add on tax

[johnanastasio]

Here you go, thank you in advance!!

Attachments:

1. si_invoice_item_tax.zip

[johnanastasio]

Think I solved my own problem, changed si_system_default in the actual database.

[Author]

Posts