Hi,
i get the following error only at one user, all other works fine:
The user login and clicks at the "Tasks" Tab. This throws the Error:
"We are sorry, but OpenGoo is not currently able to execute your request. An Error Report has been sent to the administrator."
The Log then shows me:
-----------------
Session "default" started at 2010-01-07T13:31:52+0000
#1 DEBUG: SQL ERROR: Query failed with message '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 ':4 AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_m' at line 1' - SELECT * FROM `og_project_tasks` WHERE `trashed_by_id` = 0 AND (`is_template` = 0 AND `milestone_id` = 1:4 AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'ProjectTasks' AND `workspace_id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users`, `og_projects` WHERE ((`og_project_users`.`user_id` = '5') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '5'))) AND (`og_project_users`.`project_id` = `og_projects`.`id` AND `og_projects`.`completed_on` = '0000-00-00 00:00:00'))) AND `trashed_by_id` = 0 AND `archived_by_id` = 0) ORDER BY created_on DESC LIMIT 0, 501
#2 FATAL: exception 'DBQueryError' with message 'Query failed with message '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 ':4 AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_m' at line 1'' in /kunden/94890_93059/intern/opengoo/environment/library/database/adapters/AbstractDBAdapter.class.php:386
Stack trace:
#0 /kunden/94890_93059/intern/opengoo/environment/library/database/adapters/AbstractDBAdapter.class.php(304): AbstractDBAdapter->prepareAndExecute('SELECT * FROM `...', NULL)
#1 /kunden/94890_93059/intern/opengoo/environment/library/database/DB.class.php(211): AbstractDBAdapter->executeAll('SELECT * FROM `...', NULL)
#2 /kunden/94890_93059/intern/opengoo/environment/classes/dataaccess/DataManager.class.php(262): DB::executeAll('SELECT * FROM `...')
#3 /kunden/94890_93059/intern/opengoo/application/models/ProjectDataObjects.class.php(31): DataManager->find(Array)
#4 /kunden/94890_93059/intern/opengoo/application/models/project_tasks/base/BaseProjectTasks.class.php(205): ProjectDataObjects->find(Array)
#5 /kunden/94890_93059/intern/opengoo/environment/classes/dataaccess/DataManager.class.php(299): BaseProjectTasks->find(Array)
#6 /kunden/94890_93059/intern/opengoo/application/models/project_tasks/base/BaseProjectTasks.class.php(222): DataManager->findAll(Array)
#7 /kunden/94890_93059/intern/opengoo/application/models/project_tasks/base/BaseProjectTasks.class.php(224): BaseProjectTasks->findAll(Array)
#8 /kunden/94890_93059/intern/opengoo/application/controllers/TaskController.class.php(588): BaseProjectTasks->findAll(Array)
#9 /kunden/94890_93059/intern/opengoo/environment/classes/controller/Controller.class.php(76): TaskController->new_list_tasks()
#10 /kunden/94890_93059/intern/opengoo/environment/classes/controller/PageController.class.php(62): Controller->execute('new_list_tasks')
#11 /kunden/94890_93059/intern/opengoo/environment/classes/Env.class.php(133): PageController->execute('new_list_tasks')
#12 /kunden/94890_93059/intern/opengoo/init.php(149): Env::executeAction('task', 'new_list_tasks')
#13 /kunden/94890_93059/intern/opengoo/index.php(9): require('/kunden/94890_9...')
#14 {main}
Time since start: 0.091124057769775 seconds
-----------------
Opengoo Version 1.6 is used, PHP Version 5.2.9
What could be the problem, any clue?
Thanks a lot,
Hartmut