[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-tracker] [bug #6157] Accessing any project function result
From: |
nobody |
Subject: |
[Phpgroupware-tracker] [bug #6157] Accessing any project function results in different SQL errors |
Date: |
Sat, 25 Oct 2003 05:59:17 -0400 |
User-agent: |
Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.5a) Gecko/20031010 Mozilla Firebird/0.6.1 |
=================== 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/