DB upgrade errrors on new installation

[navin]

Hi,

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

Please advise.

Regards

Attachments:

1. 

   Screenshot-2022-09-01-at-12-28-17-SimpleInvoices.png
   

1. phplog.txt

[RRowley]

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 2 years, 3 months ago by RRowley.

[navin]

Hi, this is resolved with the latest version from Mr Rowley.

Thank you.

[Author]

Posts