Upgrade ojs 3.0.2 error classes/db/DAO.inc.php and classes/core/DataObject.inc.php on line 133

Hi @bozana, I did a dump and I left this field empty(“customAboutItems”) and I went back to upgrade, but I had other problem.

(mysql): ALTER TABLE submission_files ADD uploader_user_id BIGINT

-----



-----

(mysql): ALTER TABLE submission_files ADD assoc_type BIGINT

-----



-----

(mysql): ALTER TABLE submission_files MODIFY COLUMN assoc_id BIGINT

-----



-----

(mysql): ALTER TABLE submission_files ADD INDEX submission_files_submission_id (submission_id)

-----



-----

(mysql): CREATE TABLE submission_file_settings (
file_id BIGINT NOT NULL,
locale VARCHAR(5) NOT NULL DEFAULT ‘’,
setting_name VARCHAR(255) NOT NULL,
setting_value TEXT,
setting_type VARCHAR(6) NOT NULL
)

-----



-----

(mysql): ALTER TABLE submission_file_settings ADD INDEX submission_file_settings_id (file_id)

-----



-----

(mysql): ALTER TABLE submission_file_settings ADD UNIQUE INDEX submission_file_settings_pkey (file_id, locale, setting_name)

-----



1071: Specified key was too long; max key length is 767 bytes
ADOConnection._Execute(ALTER TABLE submission_file_settings ADD UNIQUE INDEX submission_file_settings_pkey (file_id, locale, setting_name), false)% line 1051, file: /ojs/lib/pkp/lib/adodb/adodb.inc.php
ADOConnection.Execute(ALTER TABLE submission_file_settings ADD UNIQUE INDEX submission_file_settings_pkey (file_id, locale, setting_name))% line 440, file: /ojs/lib/pkp/classes/install/Installer.inc.php
Installer.executeSQL(ALTER TABLE submission_file_settings ADD UNIQUE INDEX submission_file_settings_pkey (file_id, locale, setting_name))% line 435, file: /ojs/lib/pkp/classes/install/Installer.inc.php
Installer.executeSQL(Array[28])% line 375, file: /ojs/lib/pkp/classes/install/Installer.inc.php
Installer.executeAction(Array[3])% line 265, file: /ojs/lib/pkp/classes/install/Installer.inc.php
ERROR: Upgrade failed: DB: Specified key was too long; max key length is 767 bytes