Halo teman-teman, kali ini saya ingin share terkait upgrade OJS (Open Journal System). Detail error dan solusinya seperti di bawah ini:
error: upgrade failed: db: sqlstate[hy000]: general error: 1215 cannot add foreign key constraint (sql: alter table `submission_file_revisions` add constraint `submission_file_revisions_submission_file_id_foreign` foreign key (`submission_file_id`) references `submission_files` (`submission_file_id`))Solusi, ganti enginenya ke InnoDB
ALTER TABLE submission_files ENGINE = InnoDB;Kemudian ulangi langkah upgrade dari awal.
Selesai, semoga bermanfaat.
Jika teman-teman kesulitan bisa langsung order jasa upgarde OJS 3.3 LTS melalui kontak WhatsApp 081235008433.