DB Error di OJS Ver. 2

Saya mempunyai jurnal Ojs versi 2 namun ada masalah di fitur dewan redaksi, ketika klik dewan redaksi ada pesan “db error: you have an error in your sql syntax; check the manual that corresponds to your mysql server version for the right syntax to use near ‘groups where assoc_type = 256 and assoc_id = 4 and context = 2 order by context,’ at line 1”
Tapi fitur yang lainnya aman dapat di akses.

Apa yg harus saya lakukan ?

Hello @Sri_Rahayu,

Please note that the version of OJS that you’re using is no longer maintained or supported by PKP. I recommend that you upgrade to the newest version of OJS. However, other community members may wish to offer assistance with your question.

You may find the following resources helpful in preparing for and performing the upgrade:

These resources will introduce you to OJS 3 and how it is different from OJS 2:

You may need to seek professional support to upgrade your installation. This can usually be acquired from the service provider that hosts or maintains your software, such as the technical support team at your institution or a third-party hosting provider.

Best regards,

PKP Team

Hi @Sri_Rahayu,

In recent releases of MySQL, groups is a reserved keyword and is not allowed for e.g. database table names. In OJS 2.x, there was also a table named groups, and the two are in conflict. If you want to continue using OJS 2.x, you’ll need to stay with an older version of MySQL that allows the use of groups as a table name. But as @mfelczak recommended, I would upgrade to a newer release of OJS.

Alec Smecher
Public Knowledge Project Team

Thank you for your recomended…

Versi Myql di penyedia hosting nya atau cpanel nya ? saya kurang mengerti…

This topic was automatically closed after 11 days. New replies are no longer allowed.