UPGRADE 3.0 to 3.2 - Unknown column 'setting_type' in 'where clause' Query: DELETE FROM submission_settings

Software Support
,
3

Hi @geniusdesign,

Debugging your error message on attempting to upgrade to 3.3.0-15: does your submission_settings table in OJS 3.0.0-0 have a setting_type column before you attempt to run the upgrade?

Debugging your attempt to upgrade to 3.1.2-4: It looks like you have some incomplete data. Look in your submission_files table for entries with a user_id that doesn’t exist in the users table. The following query will identify these:

SELECT sf.* FROM submission_files sf LEFT JOIN users u ON (sf.uploader_user_id = u.user_id) WHERE u.user_id IS NULL;

Hopefully you will just have a few of these that can be updated to existing user IDs.

Regards,
Alec Smecher
Public Knowledge Project Team