Just installed EPESI on Debian 7.8 32-bit w/XFCE. PostgreSQL 9.4.
Install ran fine, w/no apparent errors. Start Epesi fine, no apparent errors. Clicking around on "Menu/My Settings" and it starts spitting out errors. Might do the same on other menu items, did not test.
Thank you for your help!
Dave
Here is the error when clicking on "Menu/My Settings":
= = = = =
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()
File: /var/www/epesi/include/module_manager.php
line 898
function called: call_user_func_array(Array ("Utils_CurrencyFieldCommon", "user_settings"), Array ())
File: /var/www/epesi/modules/Base/User/Settings/Settings_0.php
line 164
function called: call_common_methods("user_settings")
File: /var/www/epesi/modules/Base/User/Settings/Settings_0.php
line 51
function called: main_page()
[PHP core called function]
function called: body()
File: /var/www/epesi/include/module.php
line 793
function called: call_user_func_array(Array (Object (Base_User_Settings), "body"), Array ())
File: /var/www/epesi/include/module.php
line 713
function called: get_html_of_module(Object (Base_User_Settings), null, null)
File: /var/www/epesi/modules/Base/Box/Box_0.php
line 151
function called: display_module("Object (Base_User_Settings)")
File: /var/www/epesi/include/epesi.php
line 241
function called: body()
File: /var/www/epesi/include/epesi.php
line 286
function called: go(Object (Base_Box))
File: /var/www/epesi/process.php
line 35
function called: process("box_main_href=a0f5d94b47014240030faa77b2d8aefb", false)
= = = = =
##end##
