Open user settings on Postgresql to get following error.
Type: E_USER_ERROR (256)
Message: postgres8 error: [-1: ERROR: column "utils_currency.id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT id, decimal_sign FROM utils_currency WHERE active=1 G... ^] in EXECUTE("SELECT id, decimal_sign FROM utils_currency WHERE active=1 GROUP BY decimal_sign")
File: /var/www/epesi/libs/adodb/adodb-errorhandler.inc.php
Line=77
error backtrace:
[PHP core called function]
function called: handle_epesi_error(256, "postgres8 error: [-1: ERROR: column \"utils_currency.id\" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT id, decimal_sign FROM utils_currency WHERE active=1 G... ^] in EXECUTE(\"SELECT id, decimal_sign FROM utils_currency WHERE active=1 GROUP BY decimal_sign\") ", "/var/www/epesi/libs/adodb/adodb-errorhandler.inc.php", 77, Array ("postgres8", "EXECUTE", -1, "ERROR: column \"utils_currency.id\" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT id, decimal_sign FROM utils_currency WHERE active=1 G... ^", "SELECT id, decimal_sign FROM utils_currency WHERE active=1 GROUP BY decimal_sign", Array (#0), Object (ADODB_postgres8), "SELECT id, decimal_sign FROM utils_currency WHERE active=1 GROUP BY decimal_sign", Array (#0), "postgres8 error: [-1: ERROR: column \"utils_currency.id\" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT id, decimal_sign FROM utils_currency WHERE active=1 G... ^] in EXECUTE(\"SELECT id, decimal_sign FROM utils_currency WHERE active=1 GROUP BY decimal_sign\") "))
File: /var/www/epesi/libs/adodb/adodb-errorhandler.inc.php
line 77
function called: trigger_error("postgres8 error: [-1: ERROR: column \"utils_currency.id\" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT id, decimal_sign FROM utils_currency WHERE active=1 G... ^] in EXECUTE(\"SELECT id, decimal_sign FROM utils_currency WHERE active=1 GROUP BY decimal_sign\") ", 256)
File: /var/www/epesi/libs/adodb/adodb.inc.php
line 1071
function called: ADODB_Error_Handler("postgres8", "EXECUTE", -1, "ERROR: column \"utils_currency.id\" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT id, decimal_sign FROM utils_currency WHERE active=1 G... ^", "SELECT id, decimal_sign FROM utils_currency WHERE active=1 GROUP BY decimal_sign", Array (), "Object (ADODB_postgres8)")
File: /var/www/epesi/libs/adodb/adodb.inc.php
line 1042
function called: _Execute("SELECT id, decimal_sign FROM utils_currency WHERE active=1 GROUP BY decimal_sign", Array ())
File: /var/www/epesi/libs/adodb/adodb.inc.php
line 1420
function called: Execute("SELECT id, decimal_sign FROM utils_currency WHERE active=1 GROUP BY decimal_sign", Array ())
[PHP core called function]
function called: GetAssoc("SELECT id, decimal_sign FROM utils_currency WHERE active=1 GROUP BY decimal_sign", Array ())
File: /var/www/epesi/include/database.php
line 483
function called: call_user_func_array(Array (Object (ADODB_postgres8), "GetAssoc"), Array ("SELECT id, decimal_sign FROM utils_currency WHERE active=1 GROUP BY decimal_sign", Array (#0)))
File: /var/www/epesi/modules/Utils/CurrencyField/CurrencyFieldCommon_0.php
line 64
function called: GetAssoc("SELECT id, decimal_sign FROM utils_currency WHERE active=1 GROUP BY decimal_sign")
[PHP core called function]
function called: user_settings()
[color=#FF0000:2mkufias]Edit:
Please use code block to quote errors and write some short description how to generate an error. Adam[/color:2mkufias]
