Error log assistence needed

I am currently running version: 3.4.0.3
We are about to publish a new version of our journal and I was going through our logs.

My error log is being flooded with the following errors and some assistance is welcome:

[04-Nov-2023 16:46:40 UTC] Database query
SELECT * FROM versions WHERE current = 1 AND product_type = ? AND product = ?
["core","ojs2"]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT * FROM sessions WHERE session_id = ?
["633782b3ccaa371867aa8f31250913c2"]
[04-Nov-2023 16:46:40 UTC] Database query
select * from `users` where `user_id` = ? limit 1
[1]
[04-Nov-2023 16:46:40 UTC] Database query
select * from `user_settings` where `user_id` = ?
[1]
[04-Nov-2023 16:46:40 UTC] Database query
DELETE FROM sessions WHERE (last_used < ? AND remember = 0) OR (last_used < ? AND remember = 1)
[1699030000,1696524400]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT * FROM journals WHERE path = ?
["journal"]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT * FROM journal_settings WHERE journal_id = ?
[1]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT v.*
            FROM versions v
            LEFT JOIN plugin_settings ps
                ON LOWER(v.product_class_name) = ps.plugin_name
                AND ps.setting_name = 'enabled'
                 AND (context_id = ? OR v.sitewide = 1) 
            WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
[1]
[04-Nov-2023 16:46:40 UTC] Exception: Plugin addThis expected to inherit from AddThisPlugin, actual type NULL in /home/public_html/lib/pkp/classes/plugins/PluginRegistry.php:203
Stack trace:
#0 /home/public_html/lib/pkp/classes/plugins/PluginRegistry.php(219): PKP\plugins\PluginRegistry::_instantiatePlugin('generic', 'addThis', 'AddThisPlugin')
#1 /home/public_html/lib/pkp/classes/plugins/PluginRegistry.php(112): PKP\plugins\PluginRegistry::_loadFromDatabase('generic', NULL)
#2 /home/public_html/lib/pkp/classes/core/Dispatcher.php(155): PKP\plugins\PluginRegistry::loadCategory('generic', true)
#3 /home/public_html/lib/pkp/classes/core/PKPApplication.php(387): PKP\core\Dispatcher->dispatch(Object(APP\core\Request))
#4 /home/public_html/index.php(21): PKP\core\PKPApplication->execute()
#5 {main}
[04-Nov-2023 16:46:40 UTC] Database query
SELECT * FROM journals WHERE path = ?
["journal"]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT * FROM journal_settings WHERE journal_id = ?
[1]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT * FROM site
[]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT * FROM site_settings
[]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT count(*) AS row_count FROM notifications WHERE user_id = ? AND date_read IS NULL AND level = ?
[1,3]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT * FROM journals WHERE path = ?
["journal"]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT * FROM journal_settings WHERE journal_id = ?
[1]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT	* FROM navigation_menu_items WHERE path = ? and context_id = ? and type= ?
["",1,"NMI_TYPE_CUSTOM"]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT last_run FROM scheduled_tasks WHERE class_name = ?
["APP\\plugins\\importexport\\doaj\\DOAJInfoSender"]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT last_run FROM scheduled_tasks WHERE class_name = ?
["PKP\\task\\ReviewReminder"]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT last_run FROM scheduled_tasks WHERE class_name = ?
["PKP\\task\\StatisticsReport"]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT last_run FROM scheduled_tasks WHERE class_name = ?
["APP\\tasks\\SubscriptionExpiryReminder"]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT last_run FROM scheduled_tasks WHERE class_name = ?
["PKP\\task\\DepositDois"]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT last_run FROM scheduled_tasks WHERE class_name = ?
["PKP\\task\\RemoveUnvalidatedExpiredUsers"]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT last_run FROM scheduled_tasks WHERE class_name = ?
["PKP\\task\\EditorialReminders"]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT last_run FROM scheduled_tasks WHERE class_name = ?
["PKP\\task\\UpdateIPGeoDB"]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT last_run FROM scheduled_tasks WHERE class_name = ?
["APP\\tasks\\UsageStatsLoader"]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT last_run FROM scheduled_tasks WHERE class_name = ?
["PKP\\task\\ProcessQueueJobs"]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT last_run FROM scheduled_tasks WHERE class_name = ?
["PKP\\task\\RemoveFailedJobs"]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT last_run FROM scheduled_tasks WHERE class_name = ?
["APP\\tasks\\OpenAccessNotification"]
[04-Nov-2023 16:46:40 UTC] Database query
select `ug`.* from `user_groups` as `ug` inner join `user_user_groups` as `uug` on `ug`.`user_group_id` = `uug`.`user_group_id` where `uug`.`user_id` in (?)
[1]
[04-Nov-2023 16:46:40 UTC] Database query
select * from `user_group_settings` where `user_group_id` = ?
[1]
[04-Nov-2023 16:46:40 UTC] Database query
select * from `user_group_settings` where `user_group_id` = ?
[2]
[04-Nov-2023 16:46:40 UTC] Database query
select * from `user_group_settings` where `user_group_id` = ?
[3]
[04-Nov-2023 16:46:40 UTC] Database query
select * from `user_group_settings` where `user_group_id` = ?
[14]
[04-Nov-2023 16:46:40 UTC] Database query
select * from `user_group_settings` where `user_group_id` = ?
[16]
[04-Nov-2023 16:46:40 UTC] Database query
select * from `user_group_settings` where `user_group_id` = ?
[17]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT * FROM journals WHERE journal_id = ?
[1]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT * FROM journal_settings WHERE journal_id = ?
[1]
[04-Nov-2023 16:46:40 UTC] Database query
select `a`.* from `announcements` as `a` where `a`.`assoc_id` in (?) and `a`.`assoc_type` = ? and (`date_expire` <= ? or `date_expire` is null) limit 1
[1,256,"2023-11-04 16:46:40"]
[04-Nov-2023 16:46:40 UTC] Database query
select * from `announcement_settings` where `announcement_id` = ?
[3]
[04-Nov-2023 16:46:40 UTC] Database query
select `ug`.* from `user_groups` as `ug` inner join `user_user_groups` as `uug` on `ug`.`user_group_id` = `uug`.`user_group_id` where `uug`.`user_id` in (?)
[1]
[04-Nov-2023 16:46:40 UTC] Database query
select * from `user_group_settings` where `user_group_id` = ?
[1]
[04-Nov-2023 16:46:40 UTC] Database query
select * from `user_group_settings` where `user_group_id` = ?
[2]
[04-Nov-2023 16:46:40 UTC] Database query
select * from `user_group_settings` where `user_group_id` = ?
[3]
[04-Nov-2023 16:46:40 UTC] Database query
select * from `user_group_settings` where `user_group_id` = ?
[14]
[04-Nov-2023 16:46:40 UTC] Database query
select * from `user_group_settings` where `user_group_id` = ?
[16]
[04-Nov-2023 16:46:40 UTC] Database query
select * from `user_group_settings` where `user_group_id` = ?
[17]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT * FROM journals WHERE journal_id = ?
[1]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT * FROM journal_settings WHERE journal_id = ?
[1]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = ? AND context_id = ?
["immersionthemeplugin",1]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT * FROM versions WHERE current = 1 AND product_type = ? AND product = ?
["core","ojs2"]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT * FROM navigation_menus WHERE area_name = ? and context_id = ?
["user",1]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT	DISTINCT ug.role_id AS role_id
			FROM	user_groups ug
				JOIN user_user_groups uug ON ug.user_group_id = uug.user_group_id
			WHERE	uug.user_id = ? AND ug.context_id = ?
[1,1]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT	DISTINCT ug.role_id AS role_id
			FROM	user_groups ug
				JOIN user_user_groups uug ON ug.user_group_id = uug.user_group_id
			WHERE	uug.user_id = ? AND ug.context_id = ?
[1,0]
[04-Nov-2023 16:46:40 UTC] Database query
SELECT * FROM navigation_menus WHERE area_name = ? and context_id = ?
["primary",1]
[04-Nov-2023 16:46:41 UTC] Database query
SELECT * FROM versions WHERE current = 1 AND product_type = ? AND product = ?
["core","ojs2"]
[04-Nov-2023 16:46:41 UTC] PHP Deprecated:  Function mhash() is deprecated in /home/public_html/lib/pkp/classes/statistics/PKPStatisticsHelper.php on line 144

Hi @Zarevac,

Turn off the debug option in config.inc.php.

Regards,
Alec Smecher
Public Knowledge Project Team

Hi @asmecher

Thats the thing, its turned off :-s

Hi @Zarevac,

Hmm, that’s very odd – can you copy/paste that line (and the surrounding few lines) from the configuration file?

Regards,
Alec Smecher
Public Knowledge Project Team

; Database collation
; collation = utf8_general_ci

; Enable database debug output (very verbose!)
debug = Off

;;;;;;;;;;;;;;;;;;
; Debug Settings ;
;;;;;;;;;;;;;;;;;;

[debug]

; Display a stack trace when a fatal error occurs.
; Note that this may expose private information and should be disabled
; for any production system.
show_stacktrace = Off

; Display an error message when something goes wrong.
display_errors = Off

; Display deprecation warnings
deprecation_warnings = Off

; Log web service request information for debugging
log_web_service_info = Off

; declare a cainfo path if a certificate other than PHP’s default should be used for curl calls.
; This setting overrides the ‘curl.cainfo’ parameter of the php.ini configuration file.
[curl]
; cainfo = “”

Hi @Zarevac,

Were you able to resolve this? I’m sure you’ve thought of this, but just in case, some very basic suggestions:

  • Make sure you’re editing config.inc.php, not config.TEMPLATE.inc.php
  • Make sure you’re editing the configuration file in the right directory

Thanks,
Alec Smecher
Public Knowledge Project Team

Hi @asmecher ,

Nope, yea I looked at that already and a lack of tea to keep me awake but alas no.
The error file is still being generated and becomes larger in size.
Any other clues are welcome.

Hi @Zarevac,

The code that generates the messages you’re seeing is here (in lib/pkp/classes/core in your installation):

Short of that line being modified to exclude the check on Config::getVar, or a plugin or something else intervening to modify the Config object’s stored data, I’m not sure what else could cause this to be executed with debug set to Off in config.inc.php.

Regards,
Alec Smecher
Public Knowledge Project Team