Hallo Christoph,
only explenation I have: it has something to do with the broken or
missing table, that sql runs flawless on my install. tr_tracker exists
on in egw_tracker and not in the joined egw_tracker_assignee.
Ralf
Christoph Kaulich schrieb:
Hello,
setup from tracker complains about broken or missing tables, starting
tracker gives:
Invalid SQL: SELECT SQL_CALC_FOUND_ROWS ,(SELECT COUNT() FROM
egw_tracker_votes WHERE egw_tracker.tr_id=egw_tracker_votes.tr_id) AS
votes,(SELECT SUM(bounty_amount) FROM egw_tracker_bounties WHERE
egw_tracker.tr_id=egw_tracker_bounties.tr_id AND bounty_confirmed IS NOT
NULL) AS bounties,egw_tracker.tr_id AS tr_id FROM egw_tracker LEFT JOIN
egw_tracker_assignee ON egw_tracker.tr_id=egw_tracker_assignee.tr_id
WHERE tr_tracker=7 AND (tr_private=0 OR tr_creator=1126 OR tr_assigned
IN (1126,-4,-1000,-1003,-1004,-100)) AND (tr_status != ‘-101’ AND
tr_status != ‘-102’) GROUP BY egw_tracker.tr_id ORDER BY bounties
DESC,votes DESC:
Column ‘tr_tracker’ in where clause is ambiguous
Christoph
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
–
Ralf Becker
eGroupWare Training & Support ==> http://www.egroupware-support.de
Outdoor Unlimited Training GmbH [www.outdoor-training.de]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 (0)631 31657-0
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
