Bug (approved)

Active Projects not displayed

Summary

approved
Nov 1, 2006
100%
Nov 1, 2006 / guest
May 24, 2009 / rocker606
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:Confirmed...

6 years ago

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:Reply to Confirmed...

6 years ago

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:Very cool!

6 years ago

It seems to work excellently. Maybe I should invest some time in figuring out the difference ;-)

pixtur:Somehow this bug wasn't fixed in v0.078...

6 years ago

Is not done in v0.079