SimpleInvoices Group Forum › Forums › Fearless359 SimpleInvoices Discussion Group › DB upgrade errrors on new installation › Reply To: DB upgrade errrors on new installation
September 1, 2022 at 2:10 pm
#1801
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 2 years ago by
RRowley.
Recent Comments