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: 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: 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: UARR
as i understant i haven’t in database table called “s.series_position”
maybe somebody can give me a dump for this table?