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

Software Support
,
1

I just upgraded OJS from 3.2.1.3 to 3.3.0.6, 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?

2

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.

Best
Jason

1 Like
3

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