Error upgrading OJS to

Dear @asmecher,
We are having trouble upgrading OJS to OJS
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.

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 to or - #6 by jnugent

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.