SQL error while generating sitemap in OJS 3.5.0-0

Software Support
1

Describe the issue or problem
Error happens during sitemap generation

Steps I took leading up to the issue
Try to open sitemap page on your OJS site - http://my-ojs-site/index.php/myojssite/sitemap

Looks like after I’ve replaced announementId with announcement_id in
/var/www/h43916/data/www/test.inneco.org/lib/pkp/pages/sitemap/PKPSitemapHandler.php:112
Announcement::withContextIds([$context->getId()])->pluck('announcement_id')->toArray();
it started to generate the sitemap without errors

What application are you using?
OJS 3.5.0-0
It was upgraded from version 2.4.8-5

Additional information
Error message from log file:

Column not found: 1054 Unknown column ‘announcementId’ in ‘field list’ (Connection: mysql, SQL: select announcementId from announcements where assoc_type = 256 and assoc_id in (1))

[Fri Jul 04 18:21:48.679320 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: PHP Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'announcementId' in 'field list' in /var/www/h43916/data/www/my-ojs-site/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:407 [Fri Jul 04 18:21:48.679356 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: Stack trace: [Fri Jul 04 18:21:48.679361 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #0 /var/www/h43916/data/www/my-ojs-site/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(407): PDO->prepare('selectannounc…')
[Fri Jul 04 18:21:48.679365 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #1 /var/www/h43916/data/www/my-ojs-site/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(812): Illuminate\Database\Connection->Illuminate\Database\{closure}(‘select announc...', Array) [Fri Jul 04 18:21:48.679370 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #2 /var/www/h43916/data/www/my-ojs-site/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\\Database\\Connection->runQueryCallback('select announc…’, Array, Object(Closure))
[Fri Jul 04 18:21:48.679374 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #3 /var/www/h43916/data/www/my-ojs-site/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\Database\Connection->run(‘select announc...', Array, Object(Closure)) [Fri Jul 04 18:21:48.679378 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #4 /var/www/h43916/data/www/my-ojs-site/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3106): Illuminate\\Database\\Connection->select('select announc…’, Array, true)
[Fri Jul 04 18:21:48.679383 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #5 /var/www/h43916/data/www/my-ojs-site/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3362): Illuminate\Database\Query\Builder->runSelect()
[Fri Jul 04 18:21:48.679387 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #6 /var/www/h43916/data/www/my-ojs-site/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3676): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
[Fri Jul 04 18:21:48.679391 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #7 /var/www/h43916/data/www/my-ojs-site/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3358): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
[Fri Jul 04 18:21:48.679395 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #8 /var/www/h43916/data/www/my-ojs-site/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(991): Illuminate\Database\Query\Builder->pluck(‘announcementId’, NULL)
[Fri Jul 04 18:21:48.679399 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #9 /var/www/h43916/data/www/my-ojs-site/lib/pkp/pages/sitemap/PKPSitemapHandler.php(112): Illuminate\Database\Eloquent\Builder->pluck(‘announcementId’)
[Fri Jul 04 18:21:48.679403 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #10 /var/www/h43916/data/www/my-ojs-site/pages/sitemap/SitemapHandler.php(34): PKP\pages\sitemap\PKPSitemapHandler->_createContextSitemap(Object(APP\core\Request))
[Fri Jul 04 18:21:48.679407 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #11 /var/www/h43916/data/www/my-ojs-site/lib/pkp/pages/sitemap/PKPSitemapHandler.php(50): APP\pages\sitemap\SitemapHandler->_createContextSitemap(Object(APP\core\Request))
[Fri Jul 04 18:21:48.679419 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #12 [internal function]: PKP\pages\sitemap\PKPSitemapHandler->index(Array, Object(APP\core\Request))
[Fri Jul 04 18:21:48.679424 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #13 /var/www/h43916/data/www/my-ojs-site/lib/pkp/classes/core/PKPRouter.php(327): call_user_func(Array, Array, Object(APP\core\Request))
[Fri Jul 04 18:21:48.679428 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #14 /var/www/h43916/data/www/my-ojs-site/lib/pkp/classes/core/PKPPageRouter.php(249): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(APP\core\Request), Array, false)
[Fri Jul 04 18:21:48.679432 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #15 /var/www/h43916/data/www/my-ojs-site/lib/pkp/classes/core/Dispatcher.php(157): PKP\core\PKPPageRouter->route(Object(APP\core\Request))
[Fri Jul 04 18:21:48.679436 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #16 /var/www/h43916/data/www/my-ojs-site/lib/pkp/classes/core/PKPApplication.php(426): PKP\core\Dispatcher->dispatch(Object(APP\core\Request))
[Fri Jul 04 18:21:48.679440 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #17 /var/www/h43916/data/www/my-ojs-site/index.php(21): PKP\core\PKPApplication->execute()
[Fri Jul 04 18:21:48.679444 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #18 {main}
[Fri Jul 04 18:21:48.679448 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘announcementId’ in ‘field list’ (Connection: mysql, SQL: select announcementId from announcements where assoc_type = 256 and assoc_id in (1)) in /var/www/h43916/data/www/my-ojs-site/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825
[Fri Jul 04 18:21:48.679453 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: Stack trace:
[Fri Jul 04 18:21:48.679457 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #0 /var/www/h43916/data/www/my-ojs-site/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\Database\Connection->runQueryCallback(‘select announc...', Array, Object(Closure)) [Fri Jul 04 18:21:48.679462 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #1 /var/www/h43916/data/www/my-ojs-site/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\\Database\\Connection->run('select announc…’, Array, Object(Closure))
[Fri Jul 04 18:21:48.679466 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #2 /var/www/h43916/data/www/my-ojs-site/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3106): Illuminate\Database\Connection->select(‘select `announc…’, Array, true)
[Fri Jul 04 18:21:48.679471 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #3 /var/www/h43916/data/www/my-ojs-site/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3362): Illuminate\Database\Query\Builder->runSelect()
[Fri Jul 04 18:21:48.679475 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #4 /var/www/h43916/data/www/my-ojs-site/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3676): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
[Fri Jul 04 18:21:48.679488 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #5 /var/www/h43916/data/www/my-ojs-site/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3358): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
[Fri Jul 04 18:21:48.679492 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #6 /var/www/h43916/data/www/my-ojs-site/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(991): Illuminate\Database\Query\Builder->pluck(‘announcementId’, NULL)
[Fri Jul 04 18:21:48.679497 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #7 /var/www/h43916/data/www/my-ojs-site/lib/pkp/pages/sitemap/PKPSitemapHandler.php(112): Illuminate\Database\Eloquent\Builder->pluck(‘announcementId’)
[Fri Jul 04 18:21:48.679501 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #8 /var/www/h43916/data/www/my-ojs-site/pages/sitemap/SitemapHandler.php(34): PKP\pages\sitemap\PKPSitemapHandler->_createContextSitemap(Object(APP\core\Request))
[Fri Jul 04 18:21:48.679505 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #9 /var/www/h43916/data/www/my-ojs-site/lib/pkp/pages/sitemap/PKPSitemapHandler.php(50): APP\pages\sitemap\SitemapHandler->_createContextSitemap(Object(APP\core\Request))
[Fri Jul 04 18:21:48.679509 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #10 [internal function]: PKP\pages\sitemap\PKPSitemapHandler->index(Array, Object(APP\core\Request))
[Fri Jul 04 18:21:48.679514 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #11 /var/www/h43916/data/www/my-ojs-site/lib/pkp/classes/core/PKPRouter.php(327): call_user_func(Array, Array, Object(APP\core\Request))
[Fri Jul 04 18:21:48.679518 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #12 /var/www/h43916/data/www/my-ojs-site/lib/pkp/classes/core/PKPPageRouter.php(249): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(APP\core\Request), Array, false)
[Fri Jul 04 18:21:48.679522 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #13 /var/www/h43916/data/www/my-ojs-site/lib/pkp/classes/core/Dispatcher.php(157): PKP\core\PKPPageRouter->route(Object(APP\core\Request))
[Fri Jul 04 18:21:48.679527 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #14 /var/www/h43916/data/www/my-ojs-site/lib/pkp/classes/core/PKPApplication.php(426): PKP\core\Dispatcher->dispatch(Object(APP\core\Request))
[Fri Jul 04 18:21:48.679531 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #15 /var/www/h43916/data/www/my-ojs-site/index.php(21): PKP\core\PKPApplication->execute()
[Fri Jul 04 18:21:48.679535 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: #16 {main}
[Fri Jul 04 18:21:48.679539 2025] [fcgid:warn] [pid 4113519:tid 140385737225792] [client 10.20.30.40:0] mod_fcgid: stderr: thrown in /var/www/h43916/data/www/my-ojs-site/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 825

`

2

Hi @yup,

This is already filed for attention in the next release; watch [Site Wide] | Sitemap - Announcement id error when upgrade to 3.5.0 · Issue #11548 · pkp/pkp-lib · GitHub for updates.

Thanks,
Alec Smecher
Public Knowledge Project Team

1 Like
4

This topic was automatically closed after 9 days. New replies are no longer allowed.