Error updating INNODB table OJS to OJS 3.3.0-13

Hi Everyone,

we are stuck on upgrading our OJS server to 3.3.0-13 (

(system is Ubuntu Linux 20.04 )

  • Apache/2.4.41 (Ubuntu)
  • Database client version: libmysql - mysqlnd 7.4.3
  • PHP extension: mysqli
  • PHP version: 7.4.3
  • Server version: 8.0.31-0ubuntu0.20.04.1 - (Ubuntu)

upgrade procedure starts OK but after a few second we get:

A database error has occurred: SQLSTATE[HY000] [2002] No such file or directory (SQL: ALTER TABLE submission_files ADD INDEX submission_files_stage_assoc (file_stage, assoc_type, assoc_id))

submission fils is a big table with about 15.000 records

googling we found that issue could be related to table ENGINE when not = INNODB… but database has been converted to INNODB and utf8mb4_general_ci without problem…

any ideas or suggestions?

many thanks!

Stefano Mosca

What is your database default storage engine?


it seems ok…

ScreenCap 2022-11-12 at 23.55.38

1. Are your database tables as follows before attempting an update?

2. Can you try updating to a different version (eg Will you get the same error?

ScreenCap 2022-11-14 at 10.32.11

all tables are like that.

I’ll try to change it and to make an “intermediate” update

thanks a lot!

ScreenCap 2022-11-14 at 12.15.18

same error…

Are PDFs of your articles accessible before updating?

Yes of course

they are more than 2000 but I checked them for ownership and permissions…