Messages

1

Older versions / Re: Error trying to open tasks tab while logged in as administator

« on: September 17, 2009, 03:07:18 pm »

Awesome! You were right, if I set it to no filter my tasks show up. Thank a million, at least someone is on here helping people!

2

Older versions / Re: Error trying to open tasks tab while logged in as administator

« on: September 17, 2009, 05:59:17 am »

Sorry did not see your reply until right now! Ok tried your suggestion...commented out the line so it was "blank" and when I clicked on the tasks tab IT WORKED!!!......BUT it was blank showing that there were no tasks....doh. Any other ideas?

My issue comes when I click on the tasks tab in general, not when I try to organize them. fyi.

3

Older versions / Re: Error trying to open tasks tab while logged in as administator

« on: September 16, 2009, 10:32:13 pm »

Right sorry, I forgot to mention that I was logged in as administrator as well. I logged in from the same computer under a test user and the tasks tab worked just fine, it also works for my employees. So the issue only seems to be effecting my administrator login....

4

Older versions / Error trying to open tasks tab while logged in as administator

« on: September 15, 2009, 04:00:56 pm »

I ahve been using opengoo for about a  week now and it is pretty cool. All of a sudden today I go to check on my tasks, click on the tasks tab and get this error:

We are sorry, but OpenGoo is not currently able to execute your request. An Error Report has been sent to the administrator.

so I looked around the net and could not find a solution, but I did see to post the log file description so here it is, does anyone know how I can fix this?


Error from log file:


#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_by_id` = 0  AND  `id` IN (SELECT `object_id` FROM `og_workspa' at line 1' - SELECT * FROM `og_project_tasks` WHERE `trashed_by_id` = 0 AND (`is_template` = 0  AND  `completed_by_id` = 1:1  AND `completed_by_id` = 0  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` 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 `trashed_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_by_id` = 0  AND  `id` IN (SELECT `object_id` FROM `og_workspa' at line 1'' in /home/(edited out for security)/public_html/(edited out)/base/environment/library/database/adapters/AbstractDBAdapter.class.php:386

    Stack trace:

    #0 /home/(edited out for security)/public_html/(edited out)/base/environment/library/database/adapters/AbstractDBAdapter.class.php(304): AbstractDBAdapter->prepareAndExecute('SELECT * FROM `...', NULL)

    #1 /home/(edited out for security)/public_html/(edited out)/base/environment/library/database/DB.class.php(209): AbstractDBAdapter->executeAll('SELECT * FROM `...', NULL)

    #2 /home/(edited out for security)/public_html/(edited out)/base/environment/classes/dataaccess/DataManager.class.php(253): DB::executeAll('SELECT * FROM `...')

    #3 /home/(edited out for security)/public_html/(edited out)/base/application/models/ProjectDataObjects.class.php(31): DataManager->find(Array)

    #4 /home/(edited out for security)/public_html/(edited out)/base/application/models/project_tasks/base/BaseProjectTasks.class.php(201): ProjectDataObjects->find(Array)

    #5 /home/(edited out for security)/public_html/(edited out)/base/environment/classes/dataaccess/DataManager.class.php(281): BaseProjectTasks->find(Array)

    #6 /home/(edited out for security)/public_html/(edited out)/base/application/models/project_tasks/base/BaseProjectTasks.class.php(218): DataManager->findAll(Array)

    #7 /home/(edited out for security)/public_html/(edited out)/base/application/models/project_tasks/base/BaseProjectTasks.class.php(220): BaseProjectTasks->findAll(Array)

    #8 /home/(edited out for security)/public_html/(edited out)/base/application/controllers/TaskController.class.php(540): BaseProjectTasks->findAll(Array)

    #9 /home/(edited out for security)/public_html/(edited out)/base/environment/classes/controller/Controller.class.php(76): TaskController->new_list_tasks()

    #10 /home/(edited out for security)/public_html/(edited out)/base/environment/classes/controller/PageController.class.php(62): Controller->execute('new_list_tasks')

    #11 /home/(edited out for security)/public_html/(edited out)/base/environment/classes/Env.class.php(133): PageController->execute('new_list_tasks')

    #12 /home/(edited out for security)/public_html/(edited out)/base/init.php(149): Env::executeAction('task', 'new_list_tasks')

    #13 /home/(edited out for security)/public_html/(edited out)/base/index.php(9): require('/home/(edited out for security)/pu...')

    #14 {main}