Leider habe ich das Problem mit dem Tracker und einem invaliden SQL Statement immer noch. Nach Aktivierung des Tracker Moduls kommt
Database error: 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 FROM egw_tracker WHERE tr_tracker=7 AND tr_status=-100 AND (tr_private=0 OR tr_creator=1 OR tr_assigned IN (1,)) ORDER BY bounties DESC,votes DESC
mysql Error: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) ORDER BY bounties DESC,votes DESC LIMIT 0,15' at line 1)
File: /usr/share/egroupware/etemplate/inc/class.so_sql.inc.php
Line: 734
Function: egw_db::select / so_sql::search / sotracker::search / botracker::get_rows / uitracker::get_rows / nextmatch_widget::pre_process / boetemplate::extensionPreProcess / etemplate::show_cell / etemplate::show_grid / etemplate::show_cell / etemplate::show / etemplate::exec / uitracker::index / ExecMethod(tracker.uitracker.index)
Session halted.
Wie kann ich das Problem lösen. Ich habe eGW 1.4004
Danke
