Error updating INNODB table OJS 3.1.2.4 to OJS 3.3.0-13

Software Support
,
1

Hi Everyone,

we are stuck on upgrading our OJS server to 3.3.0-13 (www.jpmh.org)

(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

2

What is your database default storage engine?

image

3

it seems ok…

ScreenCap 2022-11-12 at 23.55.38

4

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

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

5

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!

6

ScreenCap 2022-11-14 at 12.15.18

same error…

7

Are PDFs of your articles accessible before updating?

8

Yes of course

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