OUR PUBLICATIONS
PDOException Object
(
[message:protected] => SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'Nehemiah2018.PC.PubCatID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
[string:Exception:private] =>
[code:protected] => 42000
[file:protected] => /home/nehemiahuc/domains/nehemiah-ucha.co.uk/application/libraries/database.lib.php
[line:protected] => 148
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /home/nehemiahuc/domains/nehemiah-ucha.co.uk/application/libraries/database.lib.php
[line] => 148
[function] => prepare
[class] => PDO
[type] => ->
[args] => Array
(
[0] => SELECT PC.*, COUNT(P.PUBID) AS PUBRESS FROM PublicationCategory PC LEFT JOIN Publications P ON P.PubCatID = PC.PubCatID GROUP BY P.PubCatID
)
)
[1] => Array
(
[file] => /home/nehemiahuc/domains/nehemiah-ucha.co.uk/public_html/publications.php
[line] => 17
[function] => Run
[class] => Database
[type] => ->
[args] => Array
(
[0] => SELECT PC.*, COUNT(P.PUBID) AS PUBRESS FROM PublicationCategory PC LEFT JOIN Publications P ON P.PubCatID = PC.PubCatID GROUP BY P.PubCatID
)
)
[2] => Array
(
[file] => /home/nehemiahuc/domains/nehemiah-ucha.co.uk/public_html/index.php
[line] => 71
[args] => Array
(
[0] => /home/nehemiahuc/domains/nehemiah-ucha.co.uk/public_html/publications.php
)
[function] => require_once
)
)
[previous:Exception:private] =>
[errorInfo] => Array
(
[0] => 42000
[1] => 1055
[2] => Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'Nehemiah2018.PC.PubCatID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
)
)
ERROR
--------------------
An error has occurred on Nehemiah portal.
Timestamp: 23/01/2022 09:20:15
Error Level: [256]Run-time Fatal Error!
File: /home/nehemiahuc/domains/nehemiah-ucha.co.uk/application/libraries/database.lib.php [Line 55]
(SQL)
Trace:
#0 [internal function]: log_error(256, '(SQL)', '/home/nehemiahu...', 55, Array)
#1 /home/nehemiahuc/domains/nehemiah-ucha.co.uk/application/libraries/database.lib.php(55): trigger_error('(SQL)', 256)
#2 /home/nehemiahuc/domains/nehemiah-ucha.co.uk/application/libraries/database.lib.php(164): Database->Error('SQLSTATE[42000]...', 'SELECT PC.*, CO...', '/home/nehemiahu...', 148, '#0 /home/nehemi...')
#3 /home/nehemiahuc/domains/nehemiah-ucha.co.uk/public_html/publications.php(17): Database->Run('SELECT PC.*, CO...')
#4 /home/nehemiahuc/domains/nehemiah-ucha.co.uk/public_html/index.php(71): require_once('/home/nehemiahu...')
#5 {main}
Additional information can be found in the error log ERR-2022-01-23 referencing ERR-2022-01-23-09:20:15.1642929615324
--------------------
