Messages

31

How To's / Cannot View/Edit/Add Tasks anymore!

« on: January 23, 2011, 12:34:32 pm »

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

32

How To's / Archiving Workspaces?

« on: January 23, 2011, 09:17:51 am »

Hi all!

Is there a way to "archive" a complete workspace? We have encountered the following situation that needs workspace archiving:

We have created individual workspaces for each individual client (this seemed like a natural transition coming from folder analogy). If a client no longer exists and we want to archive everything related to this client (i.e. client's workspace), how do we go about achieving this?

Please note that we have just been testing feng office for a few days, so any suggestions would be appreciated to achieve similar tasks, i.e. having logical storage blocks for individual clients and be able to archive a client's stuff if needed.

Best Regards
Robin