FO3.1 Task showing problem

[asiams]

When I try to show the tasks, it shows this error:

We are sorry, an error prevented Feng Office from executing your request.
Please contact your Feng Office administrator.

To request official support, please contact Feng Office

--------------------------

The log file says:

Session "default" started at 2015-03-01T23:28:34+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 'parent_id` = 0' at line 13' -

                SELECT  COUNT(o.id) AS total  FROM fo_objects o

                 INNER JOIN  fo_project_tasks e ON e.object_id = o.id

                

                WHERE

                   true

                   AND   (EXISTS (SELECT om.object_id

                   FROM  fo_object_members om

                   WHERE   om.member_id IN (9) AND o.id = om.object_id

                   GROUP BY object_id

                   HAVING count(member_id) = 1

             ))

                   AND o.object_type_id = 5

                   AND `o`.`trashed_on` = '0000-00-00 00:00:00' AND `o`.`archived_on` = '0000-00-00 00:00:00' AND `e`.`is_template` = 0      AND ` AND `parent_id` = 0

                

                

                

#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 'parent_id` = 0' at line 13'' in /home/bibletod/public_html/office/environment/library/database/adapters/AbstractDBAdapter.class.php:392

    Stack trace:

    #0 /home/bibletod/public_html/office/environment/library/database/adapters/AbstractDBAdapter.class.php(310): AbstractDBAdapter->prepareAndExecute('???SELECT  C...', NULL)

    #1 /home/bibletod/public_html/office/environment/library/database/DB.class.php(213): AbstractDBAdapter->executeAll('???SELECT  C...', NULL)

    #2 /home/bibletod/public_html/office/application/models/ContentDataObjects.class.php(543): DB::executeAll('???SELECT  C...')

    #3 /home/bibletod/public_html/office/application/controllers/TaskController.class.php(1046): ContentDataObjects->listing(Array)

    #4 /home/bibletod/public_html/office/application/controllers/TaskController.class.php(1732): TaskController->getDateGroups('due_date', 'AND `e`.`is_tem...', Array, ' AND `parent_id...')

    #5 /home/bibletod/public_html/office/application/controllers/TaskController.class.php(1787): TaskController->getGroups('due_date', 'AND `e`.`is_tem...', Array)

    #6 /home/bibletod/public_html/office/environment/classes/controller/Controller.class.php(76): TaskController->get_tasks_groups_list()

    #7 /home/bibletod/public_html/office/environment/classes/controller/PageController.class.php(62): Controller->execute('get_tasks_group...')

    #8 /home/bibletod/public_html/office/environment/classes/Env.class.php(129): PageController->execute('get_tasks_group...')

    #9 /home/bibletod/public_html/office/init.php(174): Env::executeAction('task', 'get_tasks_group...')

    #10 /home/bibletod/public_html/office/index.php(9): require('/home/bibletod/...')

    #11 {main}

Time since start: 0.296859025955 seconds

-------------------------------------------------------------------------------

Is this a mysql error? If so, how can I fix this? Just upgrade? Or should I wait for the next version?

Thanks.

[bir_manis]

I have the same error and I'm trying to trace this error too. I still don't know is this bug or about our server configuration or something else..

Hope this fixed, please someone who have fixing this error share to us. Thanks.

Regards,
Jabir

[franskh]

Same error here ..

[fad]

I have the same error.
How we can fix the issue..?

Thanks.

[mauroagr]

Dear,
The problem is at the end of sql "..........'0000-00-00 00:00:00' AND `o`.`archived_on` = '0000-00-00 00:00:00' AND `e`.`is_template` = 0      AND ` AND `parent_id` = 0"........' have two AND.
I dont find where solve it.
I am try it now.
Thanks
Mauro

[mauroagr]

Dear,
I think is in interface that are selected group by in some user.
Try Reset interface in configuration.
Thanks
Mauro

[mauroagr]

Now working, but not showing substask, when the task is assingned to other.

[Nuno Zimas]

Try Reset interface in configuration.

Where exactly is that "reset interface" option?
Each section under Configuration can be reset, that's why I'm wondering...


[EDIT]

Got it.
It is under Account > Edit preferences > General.

Still, it did not solve the issue for me.
Any other ideas?

[bukbr]

Same problem here, Tasks Module is not working. Version 3.0.7

Error message:

We are sorry, an error prevented Feng Office from executing your request.
Please contact your Feng Office administrator.

 

[kevinharding]

Registering the same problem from a fresh install - immediately after install could not use tasks. No idea what to reset!

[ghostyzx]

I found a fix for version 3.1:

look for line number 1119 in the file application/controllers/TaskController.class.php

change:
$date_groups['conditions'] = $condition;

to:
$group_2['conditions'] = $condition;

[bukbr]

I found a fix for version 3.1:

look for line number 1119 in the file application/controllers/TaskController.class.php

change:
$date_groups['conditions'] = $condition;

to:
$group_2['conditions'] = $condition;

Worked great on 3.0.7, thank you very much. 

[bir_manis]

I found a fix for version 3.1:

look for line number 1119 in the file application/controllers/TaskController.class.php

change:
$date_groups['conditions'] = $condition;

to:
$group_2['conditions'] = $condition;

Great... It Works

Thanks

[okapi]

Thank you! That fix did it!

[franponce87]

Thanks everyone for the report!
Looks like it was an issue that happened sometimes with certain filters back in the 3.1.0
But this should have been fixed for the latest one available.

Best,
Francisco