A A
English French Español Hindi Punjabi Urdu Polish Gujarati Japanese Chinese

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

--------------------