Pessoal, Estou com o seguinte problema:
Acabei de instalar o egw e em alguns 'programas' (Tarefas, Projetos, Planilha de Tempo) quando eu clico no botão adicionar ocorreo seguinte erro: Database error: Invalid SQL: SELECT *,pm_id,pl_validsince,pl_price,pl_customertitle,pl_modifier,pl_modified,pl_billable FROM egw_pm_pricelist JOIN egw_pm_prices p ON egw_pm_pricelist.pl_id=p.pl_id WHERE pm_id=0 HAVING pl_validsince=(select max(t.pl_validsince) FROM egw_pm_prices t where p.pl_id=t.pl_id and p.pm_id=t.pm_id and t.pl_validsince <= 1158866125) ORDER BY pl_title pgsql Error: -1 (ERRO: coluna "egw_pm_pricelist.pl_id" deve aparecer na cláusula GROUP BY ou ser utilizada em uma função de agregação) File: /usr/local/egroupware/etemplate/inc/class.so_sql.inc.php Line: 611 Function: egw_db::select / so_sql::search / sopricelist::search / bopricelist::search / bopricelist::pricelist / projectmanager_widget::pre_process / boetemplate::extensionPreProcess / etemplate::show_cell / etemplate::show_cell / etemplate::show_grid / etemplate::show_cell / etemplate::show / etemplate::exec / uitimesheet::edit / ExecMethod(timesheet.uitimesheet.edit) Session halted. Pelo que eu pude observar, este é um erro de sintaxe do PostgreSQL... Alguém já passou por tal situação. EGW esta instalado numa máquina com a seguinte configuração: Fedora Core 5 PostgreSQL 8.1.4 PHP 5.14 EgW 1.2.105 []´s Éder Machado. -- View this message in context: http://www.nabble.com/Urgente----Erro-ao-adicionar-registros----Urgente-tf2313987s3741.html#a6435046 Sent from the egroupware-portuguese mailing list archive at Nabble.com. ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ egroupware-portuguese mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/egroupware-portuguese
