Hi at all, I had an error during upgrading 3.3.0.19 to 3.4.0.9
Errors occurred during installation:
2025-07-08 10:49:00 [error while downgrading “APP\migration\upgrade\v3_4_0\I3573_AddPrimaryKeys”: SQLSTATE[HY000]: General error: 1553 Cannot drop index ‘review_form_responses_unique’: needed in a foreign key constraint (SQL: alter table review_form_responses drop index review_form_responses_unique)]
ERROR: Upgrade failed: DB: SQLSTATE[HY000]: General error: 1005 Can’t create table confinia_db.publications (errno: 150 “Foreign key constraint is incorrectly formed”) (SQL: alter table publications add constraint publications_section_id foreign key (section_id) references sections (section_id) on delete set null)
[confinia_ftp@server site]$
Reading through the various similar threads they recommend checking that the tables are InnoDB, but in my case they are all already so.
Do you have any suggestions how to proceed?
Thanks for the support
Bye
Tiziano
Hi @Tiziano,
After the upgrade fails, run the following queries:
SHOW CREATE TABLE sections;
SHOW CREATE TABLE publications;
These should help indicate the problem.
Regards,
Alec Smecher
Public Knowledge Project Team
1 Like
Hi @asmecher ! Thanks for reply, I runned the query and this is the result:
How can I proceed?
Thanks
Bye
Tiziano
Hi @Tiziano,
That’s only part of the information I need; follow these instructions to get the full output.
Thanks,
Alec Smecher
Public Knowledge Project Team
Hi @asmecher I followed your advice I’ll copy what it displayed to me:
Table
Create Table
sections
CREATE TABLE sections (
section_id bigint(20) NOT NULL AUTO_INCREMENT,
journal_id bigint(20) NOT NULL,
review_form_id bigint(20) DEFAULT NULL,
seq double NOT NULL DEFAULT 0,
editor_restricted tinyint(4) NOT NULL DEFAULT 0,
meta_indexed tinyint(4) NOT NULL DEFAULT 0,
meta_reviewed tinyint(4) NOT NULL DEFAULT 1,
abstracts_not_required tinyint(4) NOT NULL DEFAULT 0,
hide_title tinyint(4) NOT NULL DEFAULT 0,
hide_author tinyint(4) NOT NULL DEFAULT 0,
abstract_word_count bigint(20) DEFAULT NULL,
is_inactive smallint(6) NOT NULL DEFAULT 0,
PRIMARY KEY (section_id),
KEY sections_journal_id (journal_id),
KEY sections_review_form_id (review_form_id),
CONSTRAINT sections_journal_id FOREIGN KEY (journal_id) REFERENCES journals (journal_id) ON DELETE CASCADE,
CONSTRAINT sections_review_form_id FOREIGN KEY (review_form_id) REFERENCES review_forms (review_form_id) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=509 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci
Table
Create Table
publications
CREATE TABLE publications (
publication_id bigint(20) NOT NULL AUTO_INCREMENT,
access_status bigint(20) DEFAULT 0,
date_published date DEFAULT NULL,
last_modified datetime DEFAULT NULL,
primary_contact_id bigint(20) DEFAULT NULL,
section_id bigint(20) NOT NULL DEFAULT 3,
seq double NOT NULL DEFAULT 0,
submission_id bigint(20) NOT NULL,
status tinyint(4) NOT NULL DEFAULT 1,
url_path varchar(64) DEFAULT NULL,
version bigint(20) DEFAULT NULL,
PRIMARY KEY (publication_id),
KEY publications_submission_id (submission_id),
KEY publications_section_id (section_id),
KEY publications_url_path (url_path)
) ENGINE=InnoDB AUTO_INCREMENT=20484 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci
Thanks
Bye
Tiziano
Hi, any suggestion about the question?!
Thanks!
Bye
Tiziano
