DB Error: ERROR: operator does not exist

i have error oai ( ListIdentifiers, ListRecords, Identify), my log

Sat Mar 09 12:02:39.616915 2019] [php7:warn] [pid 13038] [client 140.213.56.24:37636] PHP Warning: Declaration of OpenAIREDAO::setOAI(&$oai) should be compatible with PKPOAIDAO::setOAI($oai) in /home/unisbablitar/web/ejournal.unisbablitar.ac.id/public_html/plugins/generic/openAIRE/OpenAIREDAO.inc.php on line 19, referer: https://ejournal.unisbablitar.ac.id/index.php/josar/oai

[Sat Mar 09 12:02:39.623752 2019] [php7:warn] [pid 13038] [client 140.213.56.24:37636] PHP Warning: Declaration of DRIVERDAO::setOAI(&$oai) should be compatible with PKPOAIDAO::setOAI($oai) in /home/unisbablitar/web/ejournal.unisbablitar.ac.id/public_html/plugins/generic/driver/DRIVERDAO.inc.php on line 65, referer: https://ejournal.unisbablitar.ac.id/index.php/josar/oai

[Sat Mar 09 12:02:39.626098 2019] [php7:warn] [pid 13038] [client 140.213.56.24:37636] PHP Warning: Declaration of CustomBlockPlugin::getBlockContext() should be compatible with BlockPlugin::getBlockContext($contextId = NULL) in /home/unisbablitar/web/ejournal.unisbablitar.ac.id/public_html/plugins/generic/customBlockManager/CustomBlockPlugin.inc.php on line 19, referer: https://ejournal.unisbablitar.ac.id/index.php/josar/oai

[Sat Mar 09 12:02:39.634004 2019] [php7:warn] [pid 13038] [client 140.213.56.24:37636] PHP Warning: Declaration of JournalOAI::sets($offset, $limit, &$total) should be compatible with OAI::sets($offset, &$total) in /home/unisbablitar/web/ejournal.unisbablitar.ac.id/public_html/classes/oai/ojs/JournalOAI.inc.php on line 230, referer: https://ejournal.unisbablitar.ac.id/index.php/josar/oai

[Sat Mar 09 12:02:39.639715 2019] [php7:notice] [pid 13038] [client 140.213.56.24:37636] ojs2: DB Error: ERROR: operator does not exist: text = integer\nLINE 15: …nal_id AND jsoai.setting_name= $1 AND jsoai.setting_value=1)\n ^\nHINT: No operator matches the given name and argument type(s). You might need to add explicit type casts., referer: https://ejournal.unisbablitar.ac.id/index.php/josar/oai

Have to change line 241 of ./classes/oai/ojs/OAIDAO.inc.php file. That’s PostgreSQL Rule.

JOIN journal_settings jsoai ON (jsoai.journal_id = j.journal_id AND jsoai.setting_name=? AND cast(jsoai.setting_value as integer)=1)

Best,
Seongho

1 Like