Topics

1

Feng Office 3 / Internal Server Error

« on: June 18, 2015, 09:29:01 pm »

Hello

I have upgraded to 3.1.5.1 from previous version.

There are some complications:

1. Error 500: internal server error

2. All of the tags were not showing.

It was upgraded from Softaculous on Cpanel.

My server:

Apache:2.2.29
MySQL:5.5.42-cll
PHP:5.4.38
Operating Systemlinux
Kernel:2.6.32-431.20.3.el6.x86_64
cPanel:11.48.4

I updated the plug-ins by command at shell: update_all several times.

I wonder above multiple commands would affect the operation of fengOffice.

Please advise me on how to correct this problem.

Thanks.

2

Feng Office 3 / FO3.1 Task showing problem

« on: 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.