johnanastasio

Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • in reply to: moving from one PC to anther #1914
    johnanastasio
    Participant

    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

    in reply to: moving from one PC to anther #1911
    johnanastasio
    Participant

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

    in reply to: moving from one PC to anther #1909
    johnanastasio
    Participant

    Here you go, thank you in advance!!

    in reply to: Maximum number of lines on invoice? #1620
    johnanastasio
    Participant

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

Viewing 4 posts - 1 through 4 (of 4 total)