Hello,
I attempt to upgrade installations of Feng Office 2.4 to the latest stable 2.5 or 2.5.0.1 however even after testing clean installation of 2.4 and following the upgrade process, I have an error on the Overview tab after upgrading and logging in: "We are sorry, but Feng Office is not currently able to execute your request. An Error Report has been sent to the administrator.".
When upgrading I unpack the new version, set required permissions and copy config.php and upload/*/ from old to new installation. Then I run:
php fengoffice/public/upgrade/console.php 2.4 2.5.0.1
Config file found and loaded.
File '/config/config.php' exists and is writable
Folder '/config' exists and is writable
Folder '/cache' exists and is writable
Folder '/tmp' exists and is writable
Folder '/upload' exists and is writable
Extension 'mysql' is loaded
Extension 'gd' is loaded
Extension 'simplexml' is loaded
Upgrade script has connected to the database.
Test query has been executed. Its safe to proceed with database migration.
2014-01-25 15:59:12 - Starting upgrade to 2.5.0.1
Database schema transformations executed (total queries:
Feng Office has been upgraded. You are now running Feng Office 2.5.0.1 Enjoy!
2014-01-25 15:59:12 - Finished upgrade to 2.5.0.1
2014-01-25 15:59:12 - Updating plugins...
2014-01-25 15:59:36 - Finished plugins update.
Reported error:
<?php die(); ?>
Session "default" started at 2014-01-25T16:00:26+0000
#1 DEBUG: SQL ERROR: Query failed with message 'Subquery returns more than 1 row' - SELECT * FROM `fo_application_logs` WHERE action <> 'login' AND action <> 'logout' AND action <> 'subscribe' AND created_by_id > '0'AND action <> 'open' AND action <> 'close' AND ((action <> 'add' OR action <> 'edit' OR action <> 'delete') AND object_name NOT LIKE 'Time%') AND IF((SELECT o.object_type_id FROM fo_objects o WHERE o.id=rel_object_id)=(SELECT ot.id FROM fo_object_types ot WHERE ot.name='template_task'),
false,
true)AND(
(EXISTS
(SELECT object_id
FROM fo_sharing_table sh
WHERE rel_object_id = sh.object_id
AND sh.group_id IN (
SELECT permission_group_id FROM fo_contact_permission_groups WHERE contact_id = 2
)
)
)
OR
(
(rel_object_id = 0 AND member_id <> 0)
AND (EXISTS
(SELECT cmp.member_id
FROM fo_contact_member_permissions cmp
WHERE fo_application_logs.member_id = cmp.member_id
AND cmp.permission_group_id IN (
SELECT permission_group_id FROM fo_contact_permission_groups
WHERE contact_id = 2
)
AND cmp.member_id = fo_application_logs.member_id
)
)
)
) ORDER BY created_on DESC LIMIT 0, 100
#2 FATAL: exception 'DBQueryError' with message 'Query failed with message 'Subquery returns more than 1 row'' in /volume1/web/fengoffice/environment/library/database/adapters/AbstractDBAdapter.class.php:389
Stack trace:
#0 /volume1/web/fengoffice/environment/library/database/adapters/AbstractDBAdapter.class.php(307): AbstractDBAdapter->prepareAndExecute('SELECT * FROM `...', NULL)
#1 /volume1/web/fengoffice/environment/library/database/DB.class.php(213): AbstractDBAdapter->executeAll('SELECT * FROM `...', NULL)
#2 /volume1/web/fengoffice/environment/classes/dataaccess/DataManager.class.php(282): DB::executeAll('SELECT * FROM `...')
#3 /volume1/web/fengoffice/application/models/application_logs/base/BaseApplicationLogs.class.php(114): DataManager->find(Array)
#4 /volume1/web/fengoffice/environment/classes/dataaccess/DataManager.class.php(320): BaseApplicationLogs->find(Array)
#5 /volume1/web/fengoffice/application/models/application_logs/base/BaseApplicationLogs.class.php(131): DataManager->findAll(Array)
#6 /volume1/web/fengoffice/application/models/application_logs/base/BaseApplicationLogs.class.php(133): BaseApplicationLogs->findAll(Array)
#7 /volume1/web/fengoffice/application/models/application_logs/ApplicationLogs.class.php(278): BaseApplicationLogs::findAll(Array)
#8 /volume1/web/fengoffice/application/widgets/activity_feed/index.php(4): ApplicationLogs::getLastActivities()
#9 /volume1/web/fengoffice/application/models/widgets/Widget.class.php(58): include('/volume1/web/fe...')
#10 /volume1/web/fengoffice/application/controllers/DashboardController.class.php(292): Widget->execute()
#11 /volume1/web/fengoffice/application/views/dashboard/main_dashboard.php(15): DashboardTools::renderSection('left')
#12 /volume1/web/fengoffice/environment/classes/template/Template.class.php(85): include('/volume1/web/fe...')
#13 /volume1/web/fengoffice/environment/classes/template/Template.class.php(56): Template->includeTemplate('/volume1/web/fe...')
#14 /volume1/web/fengoffice/environment/classes/template/template.php(35): Template->fetch('/volume1/web/fe...')
#15 /volume1/web/fengoffice/environment/classes/controller/PageController.class.php(115): tpl_fetch('/volume1/web/fe...')
#16 /volume1/web/fengoffice/environment/classes/Env.class.php(135): PageController->getContent()
#17 /volume1/web/fengoffice/init.php(173): Env::executeAction('dashboard', 'main_dashboard')
#18 /volume1/web/fengoffice/index.php(9): require('/volume1/web/fe...')
#19 {main}
Time since start: 1.7513608932495 seconds
-------------------------------------------------------------------------------
Any help on what could be wrong?