DB upgrade errrors on new installation

SimpleInvoices Group Forum Forums Fearless359 SimpleInvoices Discussion Group DB upgrade errrors on new installation

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #1798
    navin
    Participant

    Hi,

    Using the simpleinvoices-master_2020.zip for a new installation and getting errors in the database update phase.

    Please advise.

    Regards

    #1801
    RRowley
    Participant

    Need to check if you have a database table named si_products_values. The error says you don’t. Now check if you have a table named si_products_attributes_values.

    If you don’t have either table, create the si_products_values table and try SI again.

    If you have the si_products_attributes_values table then insert the following to the si_sql_patchmanager table:

    FIELD NAME           VALUE
    sql_patch_ref        324
    sql_patch            Rename si_products_values table to si_products_attributes_values
    sql_release          20210527
    sql_statement        ALTER TABLE si_products_values RENAME TO si_products_attributes_values;
    source               fearless359
    

    Adding this to the patch table will tell SI that this patch has been applied.

    Let me know what you find and how this works out.

    • This reply was modified 3 months ago by RRowley.
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.