Feng Forum
Support => Feng Office 3 => : asiams March 01, 2015, 09:55:42 PM
-
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.
-
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
-
Same error here ..
-
I have the same error.
How we can fix the issue..?
Thanks.
-
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
-
Dear,
I think is in interface that are selected group by in some user.
Try Reset interface in configuration.
Thanks
Mauro
-
Now working, but not showing substask, when the task is assingned to other.
-
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?
-
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.
:-\
-
Registering the same problem from a fresh install - immediately after install could not use tasks. No idea what to reset! :-[
-
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;
-
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. :D
-
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
-
Thank you! That fix did it!
-
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
-
Hello all,
This issue is happening to me yet again on Feng Office 3.1.5.1 - however the above posted fix doesn't work anymore.
Looking at the log, it gives me the message attached.
Any ideas on how to overcome this?
-
Quik Delivery Of Vermox cialis coupon (http://buycialikonline.com)
-
twins with clomid (http://clomida.com) Mutations, polymorphisms, and alternatively spliced variants in FSHR have varied effects on receptor function.
-
Ramon GRyQzMYIkzZGZYn 6 26 2022 cheap cialis online pharmacy (https://bestcialis20mg.com) All experimental mice were maintained on a pure C57BL 6 background on a 12 h light dark cycle and provided with rodent chow Barastoc Products and water ad libitum
-
In follicular lymphomas, gene expression analyses have shown that genes associated with infiltrating inflammatory cells are more important than the tumour cells themselves for predicting outcome 5 how much potassium for 20 mg lasix (http://lasix.one)
-
So they stop the production of estrogen, which can be increased when testosterone levels drop accutane cream for acne (https://accutane.one) Dental pain ibuprofen is used to manage acute and chronic orofacial pain