3.2.0.3|3.2.0.2 catalog listing error

i have fresh installed 3.2.0.2 after adding monograph, i tried to go to catalog, but i have receive an error.
after updating to 3.2.0.3 it still present.

[Mon May 04 16:30:12.040506 2020] [proxy_fcgi:error] [pid 89542:tid 140681274705664] [client 192.168.2.20:47064] AH01071: Got error ‘PHP message: PHP Fatal error: Uncaught Exception: DB Error: Unknown column ‘s.series_position’ in ‘order clause’ Query: select s., sf.seq, case when sf.seq is null then 1 else 0 end from submissions as s left join features as sf on s.submission_id = sf.submission_id and sf.assoc_type = 512 and sf.assoc_id = 1 where s.context_id = ? and s.status in (?) group by s.submission_id, sf.seq order by case when sf.seq is null then 1 else 0 end, sf.seq ASC, s.series_position asc in /var/www/lib.uars/lib/pkp/classes/db/DAO.inc.php:703\nStack trace:\n#0 /var/www/lib.uars/lib/pkp/classes/db/DAO.inc.php(197): DAO->handleError(Object(ADODB_mysqli), 'select s., ...')\n#1 /var/www/lib.uars/lib/pkp/classes/services/PKPSubmissionService.inc.php(103): DAO->retrieveRange('select s.*, …’, Array, Object(DBResultRange))\n#2 /var/www/lib.uars/pages/catalog/CatalogHandler.inc.php(77): PKP\Services\PKPSubmissionService->getMany(Array)\n#3 /var/www/lib.uars/pages/catalo…’, referer: https://library.uars.info/index.php/uarr/
[Mon May 04 16:30:21.693010 2020] [proxy_fcgi:error] [pid 89542:tid 140680479356672] [client 192.168.2.20:47086] AH01071: Got error ‘PHP message: PHP Fatal error: Uncaught Exception: DB Error: Unknown column ‘s.series_position’ in ‘order clause’ Query: select s., sf.seq, case when sf.seq is null then 1 else 0 end from submissions as s left join features as sf on s.submission_id = sf.submission_id and sf.assoc_type = 512 and sf.assoc_id = 1 where s.context_id = ? and s.status in (?) group by s.submission_id, sf.seq order by case when sf.seq is null then 1 else 0 end, sf.seq ASC, s.series_position asc in /var/www/lib.uars/lib/pkp/classes/db/DAO.inc.php:703\nStack trace:\n#0 /var/www/lib.uars/lib/pkp/classes/db/DAO.inc.php(197): DAO->handleError(Object(ADODB_mysqli), 'select s., ...')\n#1 /var/www/lib.uars/lib/pkp/classes/services/PKPSubmissionService.inc.php(103): DAO->retrieveRange('select s.*, …’, Array, Object(DBResultRange))\n#2 /var/www/lib.uars/pages/catalog/CatalogHandler.inc.php(77): PKP\Services\PKPSubmissionService->getMany(Array)\n#3 /var/www/lib.uars/pages/catalo…’, referer: https://library.uars.info/index.php/uarr/
[Mon May 04 16:30:23.432467 2020] [proxy_fcgi:error] [pid 89542:tid 140681266312960] [client 192.168.2.20:47090] AH01071: Got error ‘PHP message: PHP Fatal error: Uncaught Exception: DB Error: Unknown column ‘s.series_position’ in ‘order clause’ Query: select s., sf.seq, case when sf.seq is null then 1 else 0 end from submissions as s left join features as sf on s.submission_id = sf.submission_id and sf.assoc_type = 512 and sf.assoc_id = 1 where s.context_id = ? and s.status in (?) group by s.submission_id, sf.seq order by case when sf.seq is null then 1 else 0 end, sf.seq ASC, s.series_position asc in /var/www/lib.uars/lib/pkp/classes/db/DAO.inc.php:703\nStack trace:\n#0 /var/www/lib.uars/lib/pkp/classes/db/DAO.inc.php(197): DAO->handleError(Object(ADODB_mysqli), 'select s., ...')\n#1 /var/www/lib.uars/lib/pkp/classes/services/PKPSubmissionService.inc.php(103): DAO->retrieveRange('select s.*, …’, Array, Object(DBResultRange))\n#2 /var/www/lib.uars/pages/catalog/CatalogHandler.inc.php(77): PKP\Services\PKPSubmissionService->getMany(Array)\n#3 /var/www/lib.uars/pages/catalo…’, referer: https://library.uars.info/index.php/uarr/

as i understant i haven’t in database table called “s.series_position”

maybe somebody can give me a dump for this table?
%D0%91%D0%B5%D0%B7%20%D1%96%D0%BC%D0%B5%D0%BD%D1%96

after i delete my PRESS and create NEW, error have dissapeared

this error appears again when in website setting i try to choose

Series position (lowest first)
Series position (highest first)

Hi @redukr,

Thanks for reporting; I’ve filed this here: https://github.com/pkp/pkp-lib/issues/5833

Please watch that entry for a resolution, including a patch to fix the problem. Meanwhile, I’d suggest configuring your press to order the homepage by another one of the options.

Regards,
Alec Smecher
Public Knowledge Project Team

@asmecher, thank’s a lot. i choose “Title (A-Z)” for sorting, and page with catalog work’s fine.