Pessoal, Desculpe a mensagem em branco .... :(
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 []´s Éder Machado. Eder Machado wrote: > > > -- > Datacoper Software Ltda. > Éder Magalhães Machado - Analista de Sistemas > Desenvolvimento do Cooperate Business Core > > Cascavel - PR (CAC) > ------------------------------------------------------------------------------- > Frase da vez: > Se você conseguir falar com Chuck Norris, é uma oração. Se ele responder, > é um milagre. > ------------------------------------------------------------------------------- > > Powered by Mozilla Thunderbird 1.5.0.7 > > > > > --- > avast! Antivirus: Outbound message clean. > Virus Database (VPS): 0637-0, 11/09/2006 > Tested on: 21/9/2006 15:35:32 > avast! - copyright (c) 1988-2006 ALWIL Software. > http://www.avast.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 > > -- View this message in context: http://www.nabble.com/%28assunto-em-branco%29-tf2313666s3741.html#a6434780 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
