On OJS version 3.1.2.X or higher version, when you access the article detail page you may encounter the error “DB Error: Unknown column ‘Array’ in ‘where clause’.
This error is not caused by the theme as many of our customers ask us about this issue. This error is caused by the RecommendedByAuthor plugin or a bug on that plugin. This plugin tries to query and search on the database for any of the submission data that have the same article written by the selected author.
When you activate the Stack Trace error, you will find this error trace :
How to solve this :
To solve this issue you need to take these steps :
1. Open the submission metadata based on the Article Details you have selected.
2. Hover the author edit
3. See the URL on the left bottom of your screen that shows the author id on that link as for example the author id is :
keep that number which is 6622 as the author id.
4. Login to your database control panel, for example, you can use the PHPMyAdmin.
open the table: author_settings on your ojs database and run this query :
SELECT * FROM `author_settings` where author_id = 6622
as you can see we use 6622 as the author_id parameter. After running that query you will find the list of author settings and will find the author setting with some JSON encoded string on the affiliation.
You need to edit and update that to the string only for the right University name only and remove the JSON encoded style for example :
Done.
You now can access the article page and try again to see that the problem is resolved.
