[TUTORIAL] PERBAIKI BUGS OJS 3.2.1.0 (TIDAK BISA PUBLISH ISSUE)

All About OJS 3
Post Reply
dwifajar
Posts: 6
Joined: 20 Mar 2020, 13:06

[TUTORIAL] PERBAIKI BUGS OJS 3.2.1.0 (TIDAK BISA PUBLISH ISSUE)

Post by dwifajar »

Kondisi ini sedang dialami ketika bantu upgrade OJS 3 dari Jurnal UMMI.
Dari OJS 3.2.0.3 ke 3.2.1.0. Proses upgrade berhasil dilakukan namun ada bugs, yang mana tidak bisa menerbitkan issue. Seperti gambar dibawah ini :
WhatsApp Image 2020-08-13 at 17.22.41.jpeg
Setelah dicek pada error log, ada masalah di :

[php7:error] [pid 26753] [client XXXXXXX.137:54254] PHP Fatal error: Uncaught Exception: DB Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '=' Query: SELECT\ti.*\n\t\t\tFROM\tissues i,\n\t\t\t\tsubmissions a\n\t\t\tLEFT JOIN publications p ON (p.publication_id = a.current_publication_id)\n\t\t\tLEFT JOIN publication_settingsps ON (ps.publication_id = p.publication_id)\n\t\t\tWHERE\tps.setting_name = ? AND ps.setting_value = CAST(i.issue_id as CHAR) AND\n\t\t\t\ta.submission_id = ? AND\n\t\t\t\ta.context_id = i.journal_id in /var/www/html/ojs/lib/pkp/classes/db/DAO.inc.php:703\nStack trace:\n#0 /var/www/html/ojs/lib/pkp/classes/db/DAO.inc.php(103): DAO->handleError()\n#1 /var/www/html/ojs/classes/issue/IssueDAO.inc.php(560): DAO->retrieve()\n#2 /var/www/html/ojs/classes/submission/Submission.inc.php

Cara solvingnya spt ini :

1. Setting “collation = utf8_general_ci”pada file setting.inc.php
2. Setting pada file lib/pkp/classes/services/queryBuilders/BaseQueryBuilder.inc.php
3. Ubah tipe colallation relasi tabel publications dan publications_settings menjadi “utf_general_ci”

Alhamdulillah metode itu berhasil dan dapat published issue. Good advice from Yusac

Smg bermanfaat

Post Reply