SQLSTATE[42S22]: Column not found after upgrade OJS to

I just upgraded OJS from to, but during the upgrade process an error occurred

Errors occurred during installation:

A database error has occurred: SQLSTATE [42S22]: Column not found: 1054 Unknown column ‘setting_type’ in ‘where clause’ (SQL: select * from pma__designer_settings where setting_type = object)

I have tried to re-import the database, and repeated the upgrade process several times, the result always shows an error like that.

is there a solution to this problem?

Hi @Adam_Faturahman

pma__designer_settings is not a table that has ever been part of OJS. That’d be something in PHPMyAdmin, I think. I don’t think this is an OJS problem.


1 Like

Thanks Jason, I tried to delete the Pma table and other tables that look suspicious. And now I’ve successfully upgraded to version