Error OMP 3.1.1 function manageCatalog

Software Support Open Monograph Press
1

HI,

Information about my installation

PHP: 5.6.25
Apache: Apache/2.4.27
Data base: PostgreSQL 9.2.23
OS platform: Linux Red Hat 7

image

When I click on the catalog function, I get the following error.

image

Any solution to this problem?

Thanks

David R.

2

I have the same problem and looking for a solution. Thank you in advance.

3

Hello @madileweb

you can inform me, when you find the solution

Thanks

Daviid

4

Hi,

I send the output, when I enable the logs.

  1. URL: http://ediciones.uis.edu.co/index.php/publicacionesuis/manageCatalog

DB Error: ERROR: column “ps.pub_id” must appear in the GROUP BY clause or be used in an aggregate function LÍNEA 1: select “s”., “ps”., COALESCE(stl.setting_value, stpl.setti… ^
Stack Trace:
File: /var/www/html/ompuis/lib/pkp/classes/services/PKPSubmissionService.inc.php line 67
Function: DAO->retrieveRange(“select “s”., “ps”., COALESCE(stl.setting_value, stpl.setting_v…”, Array(2), Object(DBResultRange))

File: /var/www/html/ompuis/pages/catalog/CatalogHandler.inc.php line 102
Function: PKP\Services\PKPSubmissionService->getSubmissions(“1”, Array(7))

File: /var/www/html/ompuis/pages/catalog/CatalogHandler.inc.php line 54
Function: CatalogHandler->page(Array(0), Object(Request), True)

File: (unknown) line (unknown)
Function: CatalogHandler->index(Array(0), Object(Request))

File: /var/www/html/ompuis/lib/pkp/classes/core/PKPRouter.inc.php line 372
Function: call_user_func(Array(2), Array(0), Object(Request))

File: /var/www/html/ompuis/lib/pkp/classes/core/PKPPageRouter.inc.php line 233
Function: PKPRouter->_authorizeInitializeAndCallRequest(Array(2), Object(Request), Array(0), False)

File: /var/www/html/ompuis/lib/pkp/classes/core/Dispatcher.inc.php line 134
Function: PKPPageRouter->route(Object(Request))

File: /var/www/html/ompuis/lib/pkp/classes/core/PKPApplication.inc.php line 247
Function: Dispatcher->dispatch(Object(Request))

File: /var/www/html/ompuis/index.php line 64
Function: PKPApplication->execute()

  1. log output /var/log/error_log

[Tue Jun 19 16:09:56.523773 2018] [:error] [pid 20357] [client 181.58.205.46:63489] PHP Notice: Deprecated call without request object. in /var/www/html/ompuis/lib/pkp/classes/template/PKPTemplateManager.inc.php on line 901, referer: http://ediciones.uis.edu.co/index.php/publicacionesuis/submissions
[Tue Jun 19 16:09:56.524256 2018] [:error] [pid 20357] [client 181.58.205.46:63489] PHP Notice: Deprecated call without request object. in /var/www/html/ompuis/lib/pkp/classes/template/PKPTemplateManager.inc.php on line 901, referer: http://ediciones.uis.edu.co/index.php/publicacionesuis/submissions
[Tue Jun 19 16:09:56.525869 2018] [:error] [pid 20357] [client 181.58.205.46:63489] PHP Notice: Deprecated call without request object. in /var/www/html/ompuis/lib/pkp/classes/template/PKPTemplateManager.inc.php on line 901, referer: http://ediciones.uis.edu.co/index.php/publicacionesuis/submissions
[Tue Jun 19 16:09:56.526319 2018] [:error] [pid 20357] [client 181.58.205.46:63489] PHP Notice: Deprecated call without request object. in /var/www/html/ompuis/lib/pkp/classes/template/PKPTemplateManager.inc.php on line 901, referer: http://ediciones.uis.edu.co/index.php/publicacionesuis/submissions
[Tue Jun 19 16:09:56.527752 2018] [:error] [pid 20357] [client 181.58.205.46:63489] PHP Notice: Deprecated call without request object. in /var/www/html/ompuis/lib/pkp/classes/template/PKPTemplateManager.inc.php on line 901, referer: http://ediciones.uis.edu.co/index.php/publicacionesuis/submissions
[Tue Jun 19 16:09:56.529029 2018] [:error] [pid 20357] [client 181.58.205.46:63489] PHP Notice: Deprecated call without request object. in /var/www/html/ompuis/lib/pkp/classes/template/PKPTemplateManager.inc.php on line 901, referer: http://ediciones.uis.edu.co/index.php/publicacionesuis/submissions
[Tue Jun 19 16:09:56.530648 2018] [:error] [pid 20357] [client 181.58.205.46:63489] PHP Notice: Deprecated call without request object. in /var/www/html/ompuis/lib/pkp/classes/template/PKPTemplateManager.inc.php on line 901, referer: http://ediciones.uis.edu.co/index.php/publicacionesuis/submissions
[Tue Jun 19 16:09:56.585205 2018] [:error] [pid 20357] [client 181.58.205.46:63489] omp: DB Error: ERROR: column “psf.seq” must appear in the GROUP BY clause or be used in an aggregate function\nLINE 1: …ing_value, stpl.setting_value) order by case when psf.seq is…\n ^, referer: http://ediciones.uis.edu.co/index.php/publicacionesuis/submissions

Any solution?

Thanks

David

5

Hi, @asmecher

I need urgent help, you can help me, to solve this problem.

Thank you

6

Hi @madileweb

Did you find any solution to this problem?

Thanks

David.

7

Hi all,

I’ve filed this for attention at Fix SQL error in Catalog Management with PostgreSQL · Issue #3824 · pkp/pkp-lib · GitHub. Watch for a fix there.

Regards,
Alec Smecher
Public Knowledge Project Team

8

HI @asmecher

I already made the change, and it works partially

  1. In the Dashboard it works
    image

  2. but the website does not work
    image
    image

Is it necessary to apply the patch in another file?

Thanks

David.

9

Hi @drueda,

Ah, I see – this is a similar problem in another part of the code. There’s a patch to be applied in lib/pkp in this bug entry: Resolve missing GROUP BY in submission list fetch · Issue #3826 · pkp/pkp-lib · GitHub

Regards,
Alec Smecher
Public Knowledge Project Team

10

Hi @asmecher

Checking Resolve missing GROUP BY in submission list fetch · Issue #3826 · pkp/pkp-lib · GitHub I do not see which patch, it should be applied

I do not understand:
(All the attached patches are equivalent, just applied to different branches.)

Thanks

David.

11

Hi @drueda,

Any of those patches will do – they’re all the same.

Regards,
Alec Smecher
Public Knowledge Project Team

12

Hi @asmecher

Everything is solved, thank you very much.

David.