Reply To: DB upgrade errrors on new installation

#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.