Hi
After a few hours of testing possibilities of tasks, the tasks have suddenly stopped working with the following message: "We are sorry, but Feng Office is not currently able to execute your request. An Error Report has been sent to the administrator."
Please note that the error only shows for my current user (admin) and tasks work fine for other users.
I have tried deleting browser cookies, cache files, copying installation files again but to no avail.
How to reproduce the error:
The error occurred after I was trying to filter tasks. I chose to filter using object type (subtask) but didn't select any subtask type from the next dropdown list. Then I chose status as Pending, and the error occurred.
The error only occurred only for the user who performed filtering as mentioned above. For the rest, tasks kept working. However, I was able to reproduce the error for other users as well after performing the filtering.
Error Log:
#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 ':1 AND `completed_on` = '0000-00-00 00:00:00' AND ( ( `created_by_id` = 1)
O' at line 1' - SELECT * FROM `og_project_tasks` WHERE `trashed_on` = '0000-00-00 00:00:00' AND (`is_template` = 0 AND `object_subtype` = 1:1 AND `completed_on` = '0000-00-00 00:00:00' AND ( ( `created_by_id` = 1)
OR ( EXISTS ( SELECT * FROM `og_object_user_permissions` `xx_oup`
WHERE `xx_oup`.`rel_object_id` = og_project_tasks.id
AND `xx_oup`.`rel_object_manager` = 'ProjectTasks'
AND `xx_oup`.`user_id` IN (1,10000000)
AND `xx_oup`.can_read = true) )
OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo`
WHERE `xx_pu`.`user_id` IN (1,10000000)
AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id`
AND `xx_wo`.`object_id` = og_project_tasks.id
AND `xx_wo`.`object_manager` = 'ProjectTasks'
AND `xx_pu`.can_read_tasks = true ) ) ) 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 ':1 AND `completed_on` = '0000-00-00 00:00:00' AND ( ( `created_by_id` = 1)
O' at line 1'' in E:\Projects\Personal\Web\feng_community\environment\library\database\adapters\AbstractDBAdapter.class.php:386
Stack trace:
#0 E:\Projects\Personal\Web\feng_community\environment\library\database\adapters\AbstractDBAdapter.class.php(304): AbstractDBAdapter->prepareAndExecute('SELECT * FROM `...', NULL)
#1 E:\Projects\Personal\Web\feng_community\environment\library\database\DB.class.php(211): AbstractDBAdapter->executeAll('SELECT * FROM `...', NULL)
#2 E:\Projects\Personal\Web\feng_community\environment\classes\dataaccess\DataManager.class.php(262): DB::executeAll('SELECT * FROM `...')
#3 E:\Projects\Personal\Web\feng_community\application\models\ProjectDataObjects.class.php(31): DataManager->find(Array)
#4 E:\Projects\Personal\Web\feng_community\application\models\project_tasks\base\BaseProjectTasks.class.php(205): ProjectDataObjects->find(Array)
#5 E:\Projects\Personal\Web\feng_community\environment\classes\dataaccess\DataManager.class.php(299): BaseProjectTasks->find(Array)
#6 E:\Projects\Personal\Web\feng_community\application\models\project_tasks\base\BaseProjectTasks.class.php(222): DataManager->findAll(Array)
#7 E:\Projects\Personal\Web\feng_community\application\models\project_tasks\base\BaseProjectTasks.class.php(224): BaseProjectTasks->findAll(Array)
#8 E:\Projects\Personal\Web\feng_community\application\controllers\TaskController.class.php(651): BaseProjectTasks->findAll(Array)
#9 E:\Projects\Personal\Web\feng_community\environment\classes\controller\Controller.class.php(76): TaskController->new_list_tasks()
#10 E:\Projects\Personal\Web\feng_community\environment\classes\controller\PageController.class.php(62): Controller->execute('new_list_tasks')
#11 E:\Projects\Personal\Web\feng_community\environment\classes\Env.class.php(133): PageController->execute('new_list_tasks')
#12 E:\Projects\Personal\Web\feng_community\init.php(163): Env::executeAction('task', 'new_list_tasks')
#13 E:\Projects\Personal\Web\feng_community\index.php(9): require('E:\Projects\Per...')
#14 {main}
Time since start: 0.2699658870697 seconds
I think that my particular way of filtering is producing illegal mysql output. But there must be a way to reset or clear the filter back to the original "unfiltered" state.
One solution could be recreating the user but its not the best or convenient solution IMHO.
Any help is greatly appreciated!
Robin