Errors occurred during installation: A database error has occurred: SQLSTATE[42S22]: Column not found:

Software Support
1

Hi!
During the upgrade process from 3.3.0-8 to 3.4.0.1, after I click on “Upgrade Open Journal Systems” in the browser, I get the following error:

  • A database error has occurred: 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)

Running PHP 8.1.20
Mysql 8.0.33
Apache 2.4.57
Ubuntu 20.04 lts

Apache logs have same message as above:
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), referer: https://myserver/index/install/upgrade

Any suggestions would be greatly appreciated.
Many thanks.

2

Hi @jules

Your issue sounds similar to one that @marc has identified on this thread (with solution):

Could you please have a look into it?

Best,
Israel

3

I will check it out this morning! Thanks so much for pointing me to this.

4

Unfortunately, that solution did not work for me

I started my install over and used the newly provided config.inc.php file using mysql instead of mysqli in the database section, (in addition to adding all my personal server data), but I still get the same error upon running the Upgrade.

Next, I tried using the Patch mentioned here:
Unsupported assoc_type in the event log: 515 · Issue #9121 · pkp/pkp-lib · GitHub, but still no joy.

I rolled my server back and will wait for the next release.