Author Topic: Error on overview tab after upgrade to 2.5.1.2  (Read 1860 times)

slingshot

  • Newbie
  • *
  • Posts: 1
    • View Profile
Error on overview tab after upgrade to 2.5.1.2
« on: March 28, 2014, 05:43:29 am »
Hello
We are now on 2.5.1.2 and after upgrading and updating the plugins we recieve error on the overview page.
Somehow it seems related to a SQL query that fails, but I don't know what to do to resolve thos error, it seems there is a column missing.


pastebin.com/9nqWtrkV


Session "default" started at 2014-03-28T08:30:17+0000
#1 DEBUG: SQL ERROR: Query failed with message 'Unknown column 'al.member_id' in 'where clause'' - SELECT al.id FROM fo_application_logs al INNER JOIN fo_contact_member_permissions cmp ON cmp.member_id=al.member_id
                                WHERE al.rel_object_id=0 AND al.member_id>0 AND cmp.permission_group_id IN (
                                        SELECT permission_group_id FROM fo_contact_permission_groups
                                        WHERE contact_id = 2
                                ) ORDER BY created_on DESC LIMIT 100
#2 FATAL: exception 'DBQueryError' with message 'Query failed with message 'Unknown column 'al.member_id' in 'where clause''' in /var/www/fengoffice/environment/library/database/adapters/AbstractDBAdapter.class.php:392
    Stack trace:
    #0 /var/www/fengoffice/environment/library/database/adapters/AbstractDBAdapter.class.php(310): AbstractDBAdapter->prepareAndExecute('SELECT al.id FR...', NULL)
    #1 /var/www/fengoffice/environment/library/database/DB.class.php(213): AbstractDBAdapter->executeAll('SELECT al.id FR...', NULL)
    #2 /var/www/fengoffice/application/models/application_logs/ApplicationLogs.class.php(256): DB::executeAll('SELECT al.id FR...')
    #3 /var/www/fengoffice/application/widgets/activity_feed/index.php(4): ApplicationLogs::getLastActivities()
    #4 /var/www/fengoffice/application/models/widgets/Widget.class.php(48): include('/var/www/fengof...')
    #5 /var/www/fengoffice/application/controllers/DashboardController.class.php(291): Widget->execute()
    #6 /var/www/fengoffice/application/views/dashboard/main_dashboard.php(15): DashboardTools::renderSection('left')
    #7 /var/www/fengoffice/environment/classes/template/Template.class.php(85): include('/var/www/fengof...')
    #8 /var/www/fengoffice/environment/classes/template/Template.class.php(56): Template->includeTemplate('/var/www/fengof...')
    #9 /var/www/fengoffice/environment/classes/template/template.php(35): Template->fetch('/var/www/fengof...')
    #10 /var/www/fengoffice/environment/classes/controller/PageController.class.php(115): tpl_fetch('/var/www/fengof...')
    #11 /var/www/fengoffice/environment/classes/Env.class.php(135): PageController->getContent()
    #12 /var/www/fengoffice/init.php(173): Env::executeAction('dashboard', 'main_dashboard')
    #13 /var/www/fengoffice/index.php(9): require('/var/www/fengof...')
    #14 {main}
Time since start: 0.14527106285095 seconds
-------------------------------------------------------------------------------


The plugins should be all upgraded and at latest versions:

sudo php plugin-console.php list
---------------------------------------------
NAME:           core_dimensions
VERSION:        7
STATUS:         Installed Activated
---------------------------------------------
NAME:           mail
VERSION:        6
STATUS:         Installed Activated
---------------------------------------------
NAME:           workspaces
VERSION:        9
STATUS:         Installed Activated