[bug #3268] Error when selecting a category in Notes, ToDo & Projects

=================== BUG #3268: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=3268&group_id=509

Changes by: Hsing-Foo Wang <phpgw@xxxxxxxxxxxxxxxx>
Date: Tue 10/28/2003 at 11:46 (GMT)

            What     | Removed                   | Added
---------------------------------------------------------------------------
            Category | API - phpGWapi            | projects
         Assigned to | None                      | ceb


------------------ Additional Follow-up Comments ----------------------------
ceb: could you take a look at this one please?



=================== BUG #3268: FULL BUG SNAPSHOT ===================


Submitted by: franz_kafka             Project: phpGroupWare                 
Submitted on: Fri 04/18/2003 at 14:43
Category:  projects                   Bug Group:  0.9.14.002 release        
Severity:  5 - Major                  Priority:  Normal                     
Resolution:  None                     Assigned to:  ceb                     
Status:  Open                         Component Version:  RPM               
Platform Version:  Linux - RedHat     Reproducibility:  Every Time          

Summary:  Error when selecting a category in Notes, ToDo & Projects

Original Submission:  When I try to select a category in Notes, ToDo or 
Projects I get the following error:



Database error: Invalid SQL: SELECT * from phpgw_p_projects WHERE ( 
coordinator='7' OR (access='public' AND coordinator in(7))) AND 
category='15cat_id=15' AND parent = '0' AND status = 'active' order by 
start_date asc LIMIT 15

PostgreSQL Error: 1 (ERROR: pg_atoi: error in "15cat_id=15": can't parse 
"cat_id=15" )

File: /var/www/html/phpgroupware/projects/inc/class.soprojects.inc.php

Line: 150

Session halted. 



Offcourse category='15cat_id=15' should be category='15'. My guess is that 
phpgroupware gets the value 15 from the variable cat_id. But I really can't 
find where the data goes wrong.



My configuration is: Redhat 8.0 with Apache 2.0.40, HP 

4.2.2 and Postgresql 7.2.3 + the latest cvs updates



Follow-up Comments
*******************

-------------------------------------------------------
Date: Tue 10/28/2003 at 11:46       By: pooh_
ceb: could you take a look at this one please?


CC list is empty


No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=3268&group_id=509

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/