[TUTORIAL] PERBAIKI BUGS OJS 3.2.1.0 (TIDAK BISA PUBLISH ISSUE)
Posted: 16 Aug 2020, 11:18
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 :
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
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 :
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