Error upgrading OJS 3.2.1.3 to 3.3.0.10

Dear @asmecher,
We are having trouble upgrading OJS 3.2.1.3 to OJS 3.3.0.10.
The following error occurred:

A database error has occurred: SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘files’ already exists (SQL: create table files (file_id bigint unsigned not null auto_increment primary key, path varchar(255) not null, mimetype varchar(255) not null) default character set utf8 collate ‘utf8_general_ci’)

The we cahnge database tables form InnoDB to MyISAM and encountered the following error.

  • A database error has occurred: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘url’ in ‘field list’ (SQL: select url, navigation_menu_item_id from navigation_menu_items where context_id = 1)

Please guide.
Regards

Hello @manimughal,

As a starting point you may wish to have a look at some other posts where the same error is reporting, such as these ones: Upgrading 3.2.1.2 to 3.3.0.7 or 3.3.0.0 - #6 by jnugent

-Roger
PKP Team

1 Like

Dear Sir,
I have changed all the tables to MyISAM. The tables were changed successfully, but the installation was not completed and gave the error.