Re: regarding Calender Error

Dear Ramesh,

Thank you for the follow-up.

I have not been able to reproduce this bug, but it sounds indeed
like a SQL bug. I have fixed it in the CVS and I am sending an
updated PHP file (upd_app.php).

Mathieu Lutfy
LCM lead developer


Le 2007-01-18, à 10:54:31 -0000, Ramesh 
(rameshv_ms-QOiod4cnrWAN+BqQ9rBEUg@xxxxxxxxxxxxxxxx) écrit:
> Dear Lcm Developers,
> 
> i got the reply for the calendar error,
> thanks lot.
> 
> i had tried to enter values with the option
> 
> Enter a new activity
> 
> Am getting this error
> 
> 
> [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_app.php?time=2007-01-18
> Request: POST /legalcase/upd_app.php
> Error: Error in SQL database query.<br />
> INSERT INTO lcm_app 
> (id_author,type,title,description,start_time,end_time,reminder,date_creation) 
> VALUES (1,'court_session','mani','ramesh','2007-01-18 10:30:00','2007-01-18 
> 20:30:00','2007-01-18 10:30:00',NOW())<br />
> « ERROR:  null value in column "date_update" violates not-null constraint 
> »<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 />
> INSERT INTO lcm_app 
> (id_author,type,title,description,start_time,end_time,reminder,date_creation) 
> VALUES (1,'court_session','mani','ramesh','2007-01-18 10:30:00','2007-01-18 
> 20:30:00','2007-01-18 10:30:00',NOW())<br />
> « ERROR:  null value in column "date_update" violates not-null constraint 
> »<br />") # line   81, file: C:\wos\www\legalcase\inc\inc_db_pgsql.php
>    lcm_query_db("INSERT INTO lcm_app SET id_author = 1, type      = 
> 'court_session',
>               title       = 'mani',
>               description = 'ramesh',
>               start_time  = '2007-01-18 10:30:00',
>               end_time    = '2007-01-18 20:30:00',
>               reminder    = '2007-01-18 10:30:00'
>               , date_creation = NOW()", false) # line  431, file: 
> C:\wos\www\legalcase\inc\inc_version.php
> lcm_query("INSERT INTO lcm_app SET id_author = 1, type      = 'court_session',
>               title       = 'mani',
>               description = 'ramesh',
>               start_time  = '2007-01-18 10:30:00',
>               end_time    = '2007-01-18 20:30:00',
>               reminder    = '2007-01-18 10:30:00'
>               , date_creation = NOW()") # line  166, file: 
> C:\wos\www\legalcase\upd_app.php
> 
> END OF REPORT
> 
> Thanks,
> 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


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

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