[Phpgroupware-tracker] [Bug #3268] Error when selecting a category in Notes, ToDo & Projects

[nobody]

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

Submitted by: franz_kafka             Project: phpGroupWare                 
Submitted on: Fri 04/18/03 at 14:43
Category:  API - phpGWapi             Bug Group:  0.9.14.002 release        
Severity:  5 - Major                  Priority:  Normal                     
Resolution:  None                     Assigned to:  None                    
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




No Followups Have Been Posted


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