[Phpgroupware-tracker] [bug #6157] Accessing any project function results in different SQL errors

[nobody]

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

Submitted by: pooh_                   Project: phpGroupWare                 
Submitted on: Sat 10/25/2003 at 04:51
Category:  projects                   Bug Group:  0.9.16RC1                 
Severity:  5 - Major                  Priority:  High                       
Resolution:  None                     Assigned to:  ceb                     
Status:  Open                         Component Version:  CVS               
Platform Version:  Linux - RedHat     Reproducibility:  None                

Summary:  Accessing any project function results in different SQL errors

Original Submission:  Latest cvs, setup update performed.



clicking projects/jobs/archive/statistics/budget results in:



Database error: Invalid SQL: SELECT * from phpgw_p_projects WHERE ( 
coordinator=7 OR (access != 'private' AND coordinator in(7)) ) AND status != 
'archive' AND parent=0 order by start_date asc LIMIT

MySQL Error: 1064 (You have an error in your SQL syntax near '' at line 1)



File: /home/e-smith/files/ibays/test/html/projects/inc/class.soprojects.inc.php

Line: 203



Session halted.





-----------------



Accessing work hours results in:



Database error: Invalid SQL: SELECT * FROM phpgw_p_hours WHERE project_id =0 
order by start_date asc LIMIT

MySQL Error: 1064 (You have an error in your SQL syntax near '' at line 1)



File: 
/home/e-smith/files/ibays/test/html/projects/inc/class.soprojecthours.inc.php

Line: 73



Session halted.



----------



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=6157&group_id=509

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