bugphpGroupWare - Bugs: bug #6157, Accessing any project function...

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #6157: Accessing any project function results in different SQL errors

Submitted by:  Hsing-Foo Wang <pooh_>
Submitted on:  Sat 25 Oct 2003 04:51:11 AM UTC  
 
Item Group: 0.9.16RC1Category: projects
Severity: 3 - NormalPriority: 5 - Normal
Status: Works For MePrivacy: Public
Assigned to: Bettina Gille <ceb>Open/Closed: Closed
Component Version: SVNOperating System: GNU/Linux - RedHat/Fedora
Reproducibility: NonePlanned Release: None
Fixed Release: 

Tue 28 Oct 2003 11:09:28 AM UTC, comment #2:

no problems anymore with the new db. Closing.

Hsing-Foo Wang <pooh_>
Sat 25 Oct 2003 09:59:17 AM UTC, comment #1:

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?

Hsing-Foo Wang <pooh_>
Sat 25 Oct 2003 04:51:11 AM UTC, 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.

----------

Hsing-Foo Wang <pooh_>

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follow 2 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Tue 28 Oct 2003 11:09:28 AM UTCpooh_StatusNone=>(Error - Not Found)
  Open/ClosedOpen=>(Error - Not Found)

Back to the top


Powered by Savane 3.1-cleanup1