[OJS 3.1.2.4] DB Error: Unknown column 'Array' in 'where clause'

Software Support
1

There are five articles, but only this one show an error, OJS Version 3.1.2.4

https://lenteradua.net/jurnal/index.php/jnanaloka/article/view/12

DB Error: Unknown column ‘Array’ in ‘where clause’

Stack Trace:

File: /home/u119764351/domains/lenteradua.net/public_html/ojs-3.1.2-4/classes/article/AuthorDAO.inc.php line 91
Function: DAO->retrieve(“SELECT DISTINCT a.submission_id FROM authors a LEFT J…”, Array(7))

File: /home/u119764351/domains/lenteradua.net/public_html/ojs-3.1.2-4/plugins/generic/recommendByAuthor/RecommendByAuthorPlugin.inc.php line 77
Function: AuthorDAO->getPublishedArticlesForAuthor(Null, “M Didik R Wahyudi”, “Wahyudi”, Array(1), “ID”)

File: /home/u119764351/domains/lenteradua.net/public_html/ojs-3.1.2-4/lib/pkp/classes/plugins/HookRegistry.inc.php line 107
Function: RecommendByAuthorPlugin->callbackTemplateArticlePageFooter(“Templates::Article::Footer::PageFooter”, Array(3))

File: /home/u119764351/domains/lenteradua.net/public_html/ojs-3.1.2-4/lib/pkp/classes/template/PKPTemplateManager.inc.php line 1116
Function: HookRegistry::call(“Templates::Article::Footer::PageFooter”, Array(3))

Before you post your question, check out the user guides and video tutorials at PKP Docs and search the forum to see if someone else had the same question.

2

I think it was caused by a permission problem, give 755 access for all your journal directory .

Regards
Ghazi

3

The errors show on database queries, not on directories permission. All directories permission acces are fine

4

Fixed

There was weird value in table author_setting, field affiliation on one of users, I don’t know who this value (‘a:1:{s:5:“en_US”;s:18:“UIN Sunan Kalijaga”;}’) can be inserted. After I removed “the encode” value and just become text only → “UIN Sunan Kalijaga”, now everything is OK.

Thanks for All

regards

wa2nlinux

case closed

1 Like
5

Hi, Please help me, I am facing same issue not able to resolve.

https://indianjournalofclinicaldentistry.in/index.php/clinicaldentistry/article/view/8

6

Hi @Altechmind_Official,

I’ve responded to your other post here: DB Error: Unknown column 'Array' in 'where clause'

Please don’t post the same question in multiple places, at it clutters the forum.

Regards,
Alec Smecher
Public Knowledge Project Team