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

[nobody]

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

Changes by: Hsing-Foo Wang <address@hidden>
Date: Sat 10/25/2003 at 09:59 (GMT)

------------------ Additional Follow-up Comments ----------------------------
hmmm,



I created a new db and the errors are gone. Maybe something went wrong during 
update of the tables? dunno.



I'll play around and if it doesn't pop up anymore this one will silently closed 
ok?



=================== BUG #6157: FULL BUG SNAPSHOT ===================


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.



----------

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

-------------------------------------------------------
Date: Sat 10/25/2003 at 09:59       By: pooh_
hmmm,



I created a new db and the errors are gone. Maybe something went wrong during 
update of the tables? dunno.



I'll play around and if it doesn't pop up anymore this one will silently closed 
ok?


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/