New ticket submitted by Stefan Roder at 2010/09/30 20:15
Tracking System: Bugs
Category: Projectmanager
Version: Trunk
Status: Open
Completed: 0%
Priority: 5 - medium
Created By: Stefan Roder
Assigned to: Ralf Becker
Summary: #2736 - SQL-Error in actual trunk
I get the following error by clicking on the ganntcharticon or the project in order to show it’s content:
Database error
Invalid SQL: (SELECT c.,b.link_app1 AS app3,b.link_id1 AS id3,b.link_id AS link3 FROM egw_links a
JOIN egw_links b ON a.link_id2=b.link_id1 AND a.link_app2=b.link_app1
JOIN egw_links c ON a.link_id1=c.link_id1 AND a.link_app1=c.link_app1 AND a.link_id!=c.link_id AND c.link_app2=b.link_app2 AND c.link_id2=b.link_id2 WHERE a.link_app1=‘timesheet’ AND c.link_app2=‘projectmanager’ AND c.link_id2=‘40’)
UNION
(SELECT b.link_id, b.link_app2 as app1, b.link_id2 as id1, b.link_app1 as app2, b.link_id1 as id2, b.link_remark,b.link_lastmod,b.link_owner,c.link_app1 AS app3,c.link_id1 AS id3,c.link_id AS link3 FROM egw_links a
JOIN egw_links b ON a.link_id1=b.link_id2 AND a.link_app1=b.link_app2
JOIN egw_links c ON a.link_id2=c.link_id1 AND a.link_app2=c.link_app1 AND a.link_id!=c.link_id AND c.link_app2=b.link_app1 AND c.link_id2=b.link_id1 WHERE a.link_app1=‘timesheet’ AND b.link_app1=‘projectmanager’ AND b.link_id1=‘40’)
UNION
(SELECT a.,c.link_app1 AS app3,c.link_id1 AS id3,c.link_id AS link3 FROM egw_links a
JOIN egw_links b ON a.link_id1=b.link_id2 AND a.link_app1=b.link_app2
JOIN egw_links c ON a.link_id2=c.link_id2 AND a.link_app2=c.link_app2 AND a.link_id!=c.link_id AND c.link_app1=b.link_app1 AND c.link_id1=b.link_id1 WHERE a.link_app1=‘timesheet’ AND a.link_app2=‘projectmanager’ AND a.link_id2=‘40’):
The used SELECT statements have a different number of columns
Regards
Stefan
linked entries:
http://www.egroupware.org/egroupware/index.php?menuaction=tracker.tracker_ui.edit&tr_id=2736&no_popup=1