Hi all,
The error message…
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘at.assoc_type’ in ‘where clause’ (SQL: select distinct at.type_id from announcement_types as at left join journals as c on at.assoc_id = c.journal_id where c.journal_id is null or at.assoc_type <> 256)
…indicates that you are attempting to run an upgrade on a database where the announcement_types table does not have a column named assoc_type.
A valid 3.3.0-x database should always have an assoc_type column on the announcement_types table, so if you encounter this message, your database is not what the upgrade tool expects.
The most likely cause is that you attempted an upgrade, got partway through, then experienced a failure. If that happens, you’ll need to restore your database from backup before trying again.
Regards,
Alec Smecher
Public Knowledge Project Team