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?
