# DB Error: 'fkn_unsa_omp.s.locale' isn't in GROUP BY

Software Support Open Monograph Press
1

After installing the OMP on the server, only when trying to access dashboard or submissions I receive this error.

DB Error: ‘fkn_unsa_omp.s.locale’ isn’t in GROUP BY

2

Hi @Nadiaca,

What version of OMP are you working with? (Please include this in your posts.) Also, what version of MySQL/MariaDB or PostgreSQL are you using?

Regards,
Alec Smecher
Public Knowledge Project Team

3

Hello,

I installed the latest version of OMP 3.1.2-4 and then did a fresh install of OMP 3.1.2-3 to make sure it wasn’t a version issue. (3.1.2-3 is the active version now) but the issue persists.
Database driver: mysqliand db server version is 10.1.12-MariaDB.

Thank you

4

Hi @Nadiaca,

Could you turn on the show_stacktrace option in config.inc.php, reload the page, and paste the results here (making sure to remove any database credentials or identifying information in the trace)?

Regards,
Alec Smecher
Public Knowledge Project Team

5

DB Error: ‘ojs2.s.locale’ isn’t in GROUP BY

Stack Trace:

File: C:\xampp\htdocs\ojs2\lib\pkp\classes\services\PKPSubmissionService.inc.php line 65
Function: DAO->retrieveRange(“select distinct s.*, COALESCE(stl.setting_value, stpl.setting_…”, Array(2), Object(DBResultRange))

File: C:\xampp\htdocs\ojs2\lib\pkp\controllers\list\submissions\PKPSubmissionsListHandler.inc.php line 211
Function: PKP\Services\PKPSubmissionService->getSubmissions(“1”, Array(4))

File: C:\xampp\htdocs\ojs2\lib\pkp\controllers\list\submissions\PKPSubmissionsListHandler.inc.php line 52
Function: PKPSubmissionsListHandler->getItems()

File: C:\xampp\htdocs\ojs2\controllers\list\submissions\SubmissionsListHandler.inc.php line 24
Function: PKPSubmissionsListHandler->getConfig()

File: C:\xampp\htdocs\ojs2\lib\pkp\pages\dashboard\DashboardHandler.inc.php line 62
Function: SubmissionsListHandler->getConfig()

File: C:\xampp\htdocs\ojs2\lib\pkp\classes\core\PKPRouter.inc.php line 390
Function: DashboardHandler->index(Array(0), Object(Request))

File: C:\xampp\htdocs\ojs2\lib\pkp\classes\core\PKPPageRouter.inc.php line 231
Function: PKPRouter->_authorizeInitializeAndCallRequest(Array(2), Object(Request), Array(0), False)

File: C:\xampp\htdocs\ojs2\lib\pkp\classes\core\Dispatcher.inc.php line 134
Function: PKPPageRouter->route(Object(Request))

File: C:\xampp\htdocs\ojs2\lib\pkp\classes\core\PKPApplication.inc.php line 252
Function: Dispatcher->dispatch(Object(Request))

File: C:\xampp\htdocs\ojs2\index.php line 68
Function: PKPApplication->execute()