Show Posts

1

Feng Office 3 / Re: Switching back to default view from list view in overview section

« on: June 20, 2015, 10:34:37 pm »

Thank you for the phpmyadmin solution.

When I checked this, there has been some changes:

1) look into the fo_contacts table and get the object_id for your user (This is correct):

2) look into the fo_contact_config_option table, and try to find "overviewAsList" in name column. You need to find the id for this. When I checked, the id was 133.

3) in the fo_contact_config_option_values table, change the value for option_id 133 from 1 to the default value of 0 for the userid from step 1)

yep, this took care of the problem.

Developer should include on view as list with a button to go back to the summary view.

Abraham

2

Feng Office 3 / Re: Internal Server Error

« on: June 19, 2015, 01:39:18 am »

I was able to figure out what was the cause of the problem:

1. .htaccess on the main directory had to correctly point php.ini file that should be in use. When this was corrected, all of the errors I mentioned went away.

2. The hosting provider's suggested .htaccess contents were commented out, and I changed to uncomment them all. This caused the right connection to right php.ini file.

Thank you.

3

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.

4

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.

5