Regarding Calendar error

Dear Developers ,
am using LCM with postgres sql in win 2000 wile clicking calendar am getting this error. pls send me how can i rectify this problem

error coding

[INTERNAL] (v0.721-db51, PHP v4.4.4)
Server: Apache/2.2.3 (Win32) PHP/4.4.4
SQL server: PostgreSQL
Referer: http://localhost/legalcase/edit_case.php?case=0
Request: GET /legalcase/calendar.php?type=jour&jour=12&mois=01&annee=2007
Error: Error in SQL database query.<br />
SELECT a.*                     FROM lcm_app as a, lcm_author_app as ap                     WHERE (ap.id_author = 1                     AND a.id_app = ap.id_app                     AND ((a.end_time &gt;= '2007-01-11' OR a.start_time &gt;= '2007-01-11') AND a.start_time &lt;= '2007-01-11 23:59:59'))                     GROUP BY a.id_app                     ORDER BY a.start_time<br />
&laquo; ERROR:  column &quot;a.id_case&quot; must appear in the GROUP BY clause or be used in an aggregate function &raquo;<br />
Version-DB: 51 (in cache)
inc_meta_cache: exists (43471 bytes)
safe_mode: n/a
safe_mode_gid: n/a
safe_mode_include_dir: n/a
safe_mode_exec_dir: n/a
open_basedir: n/a
disable_functions: n/a


                    lcm_panic("Error in SQL database query.<br />
SELECT a.*                     FROM lcm_app as a, lcm_author_app as ap                     WHERE (ap.id_author = 1                     AND a.id_app = ap.id_app                     AND ((a.end_time &gt;= '2007-01-11' OR a.start_time &gt;= '2007-01-11') AND a.start_time &lt;= '2007-01-11 23:59:59'))                     GROUP BY a.id_app                     ORDER BY a.start_time<br />
&laquo; ERROR:  column &quot;a.id_case&quot; must appear in the GROUP BY clause or be used in an aggregate function &raquo;<br />") # line  81, file: C:\wos\www\legalcase\inc\inc_db_pgsql.php
                  lcm_query_db("SELECT a.*
                    FROM lcm_app as a, lcm_author_app as ap
                    WHERE (ap.id_author = 1
                    AND a.id_app = ap.id_app
                    AND ((a.end_time >= '2007-01-11' OR a.start_time >= '2007-01-11') AND a.start_time <= '2007-01-11 23:59:59'))
                    GROUP BY a.id_app
                    ORDER BY a.start_time", false) # line  431, file: C:\wos\www\legalcase\inc\inc_version.php
              lcm_query("SELECT a.*
                    FROM lcm_app as a, lcm_author_app as ap
                    WHERE (ap.id_author = 1
                    AND a.id_app = ap.id_app
                    AND ((a.end_time >= '2007-01-11' OR a.start_time >= '2007-01-11') AND a.start_time <= '2007-01-11 23:59:59'))
                    GROUP BY a.id_app
                    ORDER BY a.start_time") # line 1803, file: C:\wos\www\legalcase\inc\inc_calendar.php
            sql_calendrier_interval_rv("'2007-01-11'", "'2007-01-11 23:59:59'") # line 1688, file: C:\wos\www\legalcase\inc\inc_calendar.php
        sql_calendrier_interval_jour("2007", "01", "11") # line 1455, file: C:\wos\www\legalcase\inc\inc_calendar.php
      http_calendrier_jour("11", "01", "2007", "col", null, "", "0", "/legalcase/calendar.php?") # line 1345, file: C:\wos\www\legalcase\inc\inc_calendar.php
  http_calendrier_init_jour("2007-01-12", "", null, "/legalcase/calendar.php?") # line  100, file: C:\wos\www\legalcase\inc\inc_calendar.php
http_calendrier_init("", "jour") # line  19, file: C:\wos\www\legalcase\calendar.php

END OF REPORT

-------------------------------------------------------------------------
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_______________________________________________
Legalcase-devel mailing list
Legalcase-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@xxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/legalcase-devel