Re: Regarding Calendar error

Hello,

Thank you for reporting the bug. It has been reproduced and fixed in the
LCM 0.7.x branch. The attached file (inc_calendar.php) should allow you 
to test on your current installation (install the file in your folder
C:\wos\www\legalcase\inc\).

Please note that PostgreSQL support is still beta. Do not hesitate to
report any similar bugs you may encouter.

Mathieu Lutfy
LCM lead developer

Le 2007-01-12, à 10:51:29 -0000, Ramesh 
(rameshv_ms-QOiod4cnrWAN+BqQ9rBEUg@xxxxxxxxxxxxxxxx) écrit:
> 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
[zap]
> _______________________________________________
> Legalcase-devel mailing list
> Legalcase-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@xxxxxxxxxxxxxxxx
> https://lists.sourceforge.net/lists/listinfo/legalcase-devel

-- 
Mathieu Lutfy        <mathieu-jgIWuTNmrII@xxxxxxxxxxxxxxxx>       
http://www.bidon.ca
GPG 0x5F5BCEB4 0D3B 1AEE EF9B FB34 2FE7  80EC 8E8D F00A 5F5B CEB4

inc_calendar.php
Description: application/httpd-php

signature.asc
Description: Digital signature

-------------------------------------------------------------------------
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