From: <tr...@eg...> - 2012-02-23 14:23:42
|
Ticket modified by Tony den haan at 2012/02/23 15:24: Tracking System: Bugs Category: Calendar Version: Version 1.8.002 Status: Open Resolution: None Completed: 0% Priority: 5 - medium Created by: Tony den haan Created on: 2012/02/23 15:15 Assigned to: Ralf Becker Summary: #3118 - sql error adding resource to participants When creating event, i select "resource" under "participants" tab, enter search string and search, resulting in: Invalid SQL: SELECT DISTINCT egw_resources.res_id AS res_id,name,short_description,bookable,useable FROM egw_resources LEFT JOIN egw_resources_extra ON egw_resources.res_id=egw_resources_extra.extra_id WHERE AND (name LIKE '%room%' OR short_description LIKE '%room%') ORDER BY name so a condition is missing between "WHERE" and "AND" ---------------------------------------------------------------- > : Comment by Tony den haan at 2012/02/23 15:24: errorlog shows: [Thu Feb 23 15:13:36 2012] [error] [client 10.0.0.71] #0 /shared/sites/egroupware/phpgwapi/inc/class.egw_db.inc.php(685): egw_db->halt('Invalid SQL: SE...', 1022, '/shared/sites/e...'), referer: http://egroupware.foo.com/index.php?menuaction=calendar.calendar_uiforms.edit&date=20120225&hour=13&minute=30 [Thu Feb 23 15:13:36 2012] [error] [client 10.0.0.71] #1 /shared/sites/egroupware/phpgwapi/inc/class.egw_db.inc.php(2018): egw_db->query('SELECT DISTINCT...', 1022, '/shared/sites/e...', false, -1, false, 2), referer: http://egroupware.foo.com/index.php?menuaction=calendar.calendar_uiforms.edit&date=20120225&hour=13&minute=30 [Thu Feb 23 15:13:36 2012] [error] [client 10.0.0.71] #2 /shared/sites/egroupware/etemplate/inc/class.so_sql.inc.php(1023): egw_db->select('egw_resources', 'DISTINCT egw_re...', Array, 1022, '/shared/sites/e...', false, 'ORDER BY name', 'resources', 0, ' LEFT JOIN egw_...'), referer: http://egroupware.foo.com/index.php?menuaction=calendar.calendar_uiforms.edit&date=20120225&hour=13&minute=30 [Thu Feb 23 15:13:36 2012] [error] [client 10.0.0.71] #3 /shared/sites/egroupware/etemplate/inc/class.so_sql_cf.inc.php(615): so_sql->search(Array, 'DISTINCT res_id...', 'name', '', '%', NULL, 'OR', false, Array, ' LEFT JOIN egw_...', false), referer: http://egroupware.foo.com/index.php?menuaction=calendar.calendar_uiforms.edit&date=20120225&hour=13&minute=30 [Thu Feb 23 15:13:36 2012] [error] [client 10.0.0.71] #4 /shared/sites/egroupware/resources/inc/class.resources_bo.inc.php(401): so_sql_cf->search(Array, 'res_id,name,sho...', 'name', '', '%', NULL, 'OR', false, Array), referer: http://egroupware.foo.com/index.php?menuaction=calendar.calendar_uiforms.edit&date=20120225&hour=13&minute=30 [Thu Feb 23 15:13:36 2012] [error] [client 10.0.0.71] #5 /shared/sites/egroupware/phpgwapi/inc/class.egw_link.inc.php(666): resources_bo->link_query('room', Array), referer: http://egroupware.foo.com/index.php?menuaction=calendar.calendar_uiforms.edit&date=20120225&hour=13&minute=30 [Thu Feb 23 15:13:36 2012] [error] [client 10.0.0.71] #6 /shared/sites/egroupware/etemplate/inc/class.link_widget.inc.php(769): egw_link::query('resources', 'room', Array), referer: http://egroupware.foo.com/index.php?menuaction=calendar.calendar_uiforms.edit&date=20120225&hour=13&minute=30 [Thu Feb 23 15:13:36 2012] [error] [client 10.0.0.71] #7 [internal function]: link_widget->ajax_search('resources', NULL, 'room', 'exec[participan...', 'exec[participan...', 'exec[participan...', 'exec[participan...', 'M2j06LmMRqe9Yof...'), referer: http://egroupware.foo.com/index.php?menuaction=calendar.calendar_uiforms.edit&date=20120225&hour=13&minute=30 [Thu Feb 23 15:13:36 2012] [error] [client 10.0.0.71] #8 /shared/sites/egroupware/phpgwapi/inc/class.egw_json.inc.php(149): call_user_func_array(Array, Array), referer: http://egroupware.foo.com/index.php?menuaction=calendar.calendar_uiforms.edit&date=20120225&hour=13&minute=30 [Thu Feb 23 15:13:36 2012] [error] [client 10.0.0.71] #9 /shared/sites/egroupware/phpgwapi/inc/class.egw_json.inc.php(67): egw_json_request->handleRequest('calendar.link_w...', Array), referer: http://egroupware.foo.com/index.php?menuaction=calendar.calendar_uiforms.edit&date=20120225&hour=13&minute=30 [Thu Feb 23 15:13:36 2012] [error] [client 10.0.0.71] #10 /shared/sites/egroupware/json.php(103): egw_json_request->parseRequest('calendar.link_w...', '{"request":{"pa...'), referer: http://egroupware.foo.com/index.php?menuaction=calendar.calendar_uiforms.edit&date=20120225&hour=13&minute=30 [Thu Feb 23 15:13:36 2012] [error] [client 10.0.0.71] #11 {main}, referer: http://egroupware.foo.com/index.php?menuaction=calendar.calendar_uiforms.edit&date=20120225&hour=13&minute=30 Linked entries: https://community.egroupware.org/egroupware/index.php?menuaction=tracker.tracker_ui.edit&tr_id=3118&no_popup=1 |