UI > projView > Bug (approved)

Active Projects not displayed / #2784

MoveBookmark

Summary

v0.08
approved
Nov 1, 2006
100%
Nov 1, 2006 / guest
Feb 5, 2007 / pixtur
View previous 10 versions
burger
 

Attached files

No files uploaded
Install Streber:
  • Type: mySQLi
  • localhost
  • root
  • no password
  • streber
  • admin
  • no password
---Install OK----------------
  • log in as admin with no password
  • Create a new project e.g. TestPro
  • go to view Your Active Projects
    • no projects are displayed
  • go to view People
    • under column Active PRojects is TestPro correct displayed

4 Comments

pixtur

Nov 7, 2006
Confirmed...
This is caused by an incorrect SQL statement which does not work if no company has been created yet:
SELECT DISTINCT i.*, p.* from project p, company c, item i 
WHERE p.status <= 3 
AND p.status >= 1 
AND p.state = 1 
AND i.id = p.id 
AND (p.company = c.id OR p.company = 0) 
ORDER BY prio, name

I am not firm enough in SQL to see, why this query only works, if there is at least one row in the company table.

Burger? Binder? Any idea?


paro

Nov 7, 2006
Reply to Confirmed...
Please check:

SELECT DISTINCT i.*, p.* from streber.item i, streber.project p left join streber.company c on p.company = c.id
WHERE p.status <= 3
AND p.status >= 1
AND p.state = 1
AND i.id = p.id
ORDER BY prio, name;

pixtur

Nov 7, 2006
Very cool!
It seems to work excellently. Maybe I should invest some time in figuring out the difference ;-)

pixtur

Feb 5, 2007
Somehow this bug wasn't fixed in v0.078...
Is not done in v0.079
 
 

Comment / Update