1
How To's / Tasks not showing
« on: July 18, 2010, 05:33:27 pm »
Hi, I have successfully been using the Tasks part of the Opengoo app' for a while but for some reason I now get an error instead. I wonder if the problem started when I started using the filters? Which are no longer visible.
I have done some searching and found answers that seem close to my problem but nothing that helps me, maybe someone here can?
The output on the Tasks page now I have enabled error reports is as follows;
I am using Ubuntu 10.04 and Firefox 3.6.6 the app' is running on my home server; Ubuntu Server 9.04 with ISPConfig. All systems are right up to date.
I hope someone can help, thanks, Peter
I have done some searching and found answers that seem close to my problem but nothing that helps me, maybe someone here can?
The output on the Tasks page now I have enabled error reports is as follows;
Quote
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 `id` IN (SELECT `object_id`' at line 1'
Error params:
File: /var/www/web2/web/opengoo/environment/library/database/adapters/AbstractDBAdapter.class.php
Line: 386
Sql: SELECT * FROM `og_project_tasks` WHERE `trashed_by_id` = 0 AND (`is_template` = 0 AND `priority` = -1:-1 AND `completed_on` = '0000-00-00 00:00:00' 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` = '1') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '1'))) 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
Error number: 1064
Error 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 `id` IN (SELECT `object_id`' at line 1
Backtrace:
#0 /var/www/web2/web/opengoo/environment/library/database/adapters/AbstractDBAdapter.class.php(304): AbstractDBAdapter->prepareAndExecute('SELECT * FROM `...', NULL)
#1 /var/www/web2/web/opengoo/environment/library/database/DB.class.php(211): AbstractDBAdapter->executeAll('SELECT * FROM `...', NULL)
#2 /var/www/web2/web/opengoo/environment/classes/dataaccess/DataManager.class.php(262): DB::executeAll('SELECT * FROM `...')
#3 /var/www/web2/web/opengoo/application/models/ProjectDataObjects.class.php(31): DataManager->find(Array)
#4 /var/www/web2/web/opengoo/application/models/project_tasks/base/BaseProjectTasks.class.php(205): ProjectDataObjects->find(Array)
#5 /var/www/web2/web/opengoo/environment/classes/dataaccess/DataManager.class.php(299): BaseProjectTasks->find(Array)
#6 /var/www/web2/web/opengoo/application/models/project_tasks/base/BaseProjectTasks.class.php(222): DataManager->findAll(Array)
#7 /var/www/web2/web/opengoo/application/models/project_tasks/base/BaseProjectTasks.class.php(224): BaseProjectTasks->findAll(Array)
#8 /var/www/web2/web/opengoo/application/controllers/TaskController.class.php(588): BaseProjectTasks->findAll(Array)
#9 /var/www/web2/web/opengoo/environment/classes/controller/Controller.class.php(76): TaskController->new_list_tasks()
#10 /var/www/web2/web/opengoo/environment/classes/controller/PageController.class.php(62): Controller->execute('new_list_tasks')
#11 /var/www/web2/web/opengoo/environment/classes/Env.class.php(133): PageController->execute('new_list_tasks')
#12 /var/www/web2/web/opengoo/init.php(149): Env::executeAction('task', 'new_list_tasks')
#13 /var/www/web2/web/opengoo/index.php(9): require('/var/www/web2/w...')
#14 {main}
Autoglobal varibles:
$_GET: Array (
['active_project'] => (string) '0'
['ajax'] => (string) 'true'
['c'] => (string) 'task'
['a'] => (string) 'new_list_tasks'
['current'] => (string) 'tasks-panel'
['_dc'] => (string) '1279484641601'
)
$_POST:
$_COOKIE: Array (
['PHPSESSID'] => (string) 'a670ddc92cf9b7458cce94c43d5fa720'
['id'] => (string) '1'
['token'] => (string) '60b241064cc1b6f8f0fe1d0b9ff6d380d674fe9e'
)
$_SESSION:
Execution time:
Total execution time: 0.570864 seconds
I am using Ubuntu 10.04 and Firefox 3.6.6 the app' is running on my home server; Ubuntu Server 9.04 with ISPConfig. All systems are right up to date.
I hope someone can help, thanks, Peter