Describe the issue or problem
I followed the UPGRADE steps for OJS 3.4, removing all old files and configuring the config.inc.php file properly, but after reloading the url in a browser, and clicking on “Upgrade open journal system”, I get the following errors:
Errors occurred during installation:
- A database error has occurred: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s.assoc_type’ in ‘on clause’ (SQL: DELETE s FROM user_settings s – Locates all duplicated settings (same key fields, except the assoc_type/assoc_id) INNER JOIN user_settings duplicated ON s.setting_name = duplicated.setting_name AND s.user_id = duplicated.user_id AND s.locale = duplicated.locale AND ( COALESCE(s.assoc_type, -999999) <> COALESCE(duplicated.assoc_type, -999999) OR COALESCE(s.assoc_id, -999999) <> COALESCE(duplicated.assoc_id, -999999) ) – Attempts to find a better fitting record among the duplicates (preference is given to the smaller assoc_id/assoc_type values) LEFT JOIN user_settings best ON best.setting_name = duplicated.setting_name AND best.user_id = duplicated.user_id AND best.locale = duplicated.locale AND ( COALESCE(best.assoc_id, 999999) < COALESCE(duplicated.assoc_id, 999999) OR ( COALESCE(best.assoc_id, 999999) = COALESCE(duplicated.assoc_id, 999999) AND COALESCE(best.assoc_type, 999999) < COALESCE(duplicated.assoc_type, 999999) ) ) – Ensures a better record was found (if not found, it means the current duplicated record is the best and shouldn’t be removed) WHERE best.user_id IS NOT NULL)
Any help in solving this problem is highly appreciated.
What application are you using?
For example, OJS 3.3.0-4