Regading Calender & Agenda Error

Dear Developers,

Thanks lot for ur reply for the bug i had sent

i had tested with the upd_app.php file its working

then am getting this error while using Agenda
while clicking that icon


[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/author_det.php?tab=appointments&author=1&submit=submit&date_start_day=19&date_start_month=12&date_start_year=2006&date_end_day=31&date_end_month=1&date_end_year=&submit=submit
Request: GET /legalcase/author_det.php?tab=appointments&author=1&submit=submit&date_start_day=19&date_start_month=12&date_start_year=2006&date_end_day=31&date_end_month=1&date_end_year=&submit=submit
Error: Error in SQL database query.<br />
SELECT ap.*                          FROM lcm_author_app as aa, lcm_app as ap                          WHERE aa.id_app = ap.id_app                               AND UNIX_TIMESTAMP(start_time) &gt;= UNIX_TIMESTAMP('2006-12-19 00:00:00')  AND UNIX_TIMESTAMP(end_time) &lt;= UNIX_TIMESTAMP('0000-01-31 23:59:59')  AND aa.id_author = 1 ORDER BY start_time DESC<br />
&laquo; ERROR:  function unix_timestamp(timestamp without time zone) does not exist at character 102
HINT:  No function matches the given name and argument types. You may need to add explicit type casts. &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 ap.*                          FROM lcm_author_app as aa, lcm_app as ap                          WHERE aa.id_app = ap.id_app                               AND UNIX_TIMESTAMP(start_time) &gt;= UNIX_TIMESTAMP('2006-12-19 00:00:00')  AND UNIX_TIMESTAMP(end_time) &lt;= UNIX_TIMESTAMP('0000-01-31 23:59:59')  AND aa.id_author = 1 ORDER BY start_time DESC<br />
&laquo; ERROR:  function unix_timestamp(timestamp without time zone) does not exist at character 102
HINT:  No function matches the given name and argument types. You may need to add explicit type casts. &raquo;<br />") # line  81, file: C:\wos\www\legalcase\inc\inc_db_pgsql.php
  lcm_query_db("SELECT ap.*
                         FROM lcm_author_app as aa, lcm_app as ap
                         WHERE aa.id_app = ap.id_app
                              AND UNIX_TIMESTAMP(start_time) >= UNIX_TIMESTAMP('2006-12-19 00:00:00')  AND UNIX_TIMESTAMP(end_time) <= UNIX_TIMESTAMP('0000-01-31 23:59:59')  AND aa.id_author = 1 ORDER BY start_time DESC", false) # line  431, file: C:\wos\www\legalcase\inc\inc_version.php
lcm_query("SELECT ap.*
                         FROM lcm_author_app as aa, lcm_app as ap
                         WHERE aa.id_app = ap.id_app
                              AND UNIX_TIMESTAMP(start_time) >= UNIX_TIMESTAMP('2006-12-19 00:00:00')  AND UNIX_TIMESTAMP(end_time) <= UNIX_TIMESTAMP('0000-01-31 23:59:59')  AND aa.id_author = 1 ORDER BY start_time DESC") # line  444, file: C:\wos\www\legalcase\author_det.php

END OF REPORT

Thanks & Regards
RameshV

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