Author Topic: FATAL ERROR SOFTACOLOUS UPDATE TO 3.1  (Read 2361 times)

cor277

  • Newbie
  • *
  • Posts: 1
    • View Profile
FATAL ERROR SOFTACOLOUS UPDATE TO 3.1
« on: February 27, 2015, 06:57:42 am »
Hi all,

Today i haved a bad idea ... Softacolous send me an email that it is ready the upgrade of feng office to 3.1 and i applyed that...

Result: i can log in, but the portal on the main screen can't show anything...

HELP ME!!!!


On the log i have:




Session "default" started at 2015-02-27T09:26:21+0000
#1 DEBUG: SQL ERROR: Query failed with message 'Unknown column 'order' in 'field list'' - SELECT `id`, `dimension_id`, `object_type_id`, `parent_member_id`, `depth`, `name`, `object_id`, `archived_on`, `archived_by_id`, `color`, `order` FROM `fo_members` WHERE `id` = '9'
#2 FATAL: exception 'DBQueryError' with message 'Query failed with message 'Unknown column 'order' in 'field list''' in /home/cor277/public_html/PM/environment/library/database/adapters/AbstractDBAdapter.class.php:392
    Stack trace:
    #0 /home/cor277/public_html/PM/environment/library/database/adapters/AbstractDBAdapter.class.php(291): AbstractDBAdapter->prepareAndExecute('SELECT `id`, `d...', NULL)
    #1 /home/cor277/public_html/PM/environment/library/database/DB.class.php(179): AbstractDBAdapter->executeOne('SELECT `id`, `d...', NULL)
    #2 /home/cor277/public_html/PM/environment/classes/dataaccess/DataManager.class.php(482): DB::executeOne('SELECT `id`, `d...')
    #3 /home/cor277/public_html/PM/environment/classes/dataaccess/DataManager.class.php(447): DataManager->loadRow('9')
    #4 /home/cor277/public_html/PM/environment/classes/dataaccess/DataManager.class.php(351): DataManager->load('9', false)
    #5 /home/cor277/public_html/PM/application/models/members/base/BaseMembers.class.php(158): DataManager->findById('9', false)
    #6 /home/cor277/public_html/PM/application/models/members/base/BaseMembers.class.php(160): BaseMembers->findById('9', false)
    #7 /home/cor277/public_html/PM/application/models/members/Members.class.php(56): BaseMembers::findById('9')
    #8 /home/cor277/public_html/PM/application/models/ContentDataObject.class.php(1838): Members::getMemberById('9')
    #9 /home/cor277/public_html/PM/application/widgets/overdue_upcoming/template.php(59): ContentDataObject->getMembersToDisplayPath()
    #10 /home/cor277/public_html/PM/application/widgets/overdue_upcoming/index.php(62): include_once('/home/cor277/pu...')
    #11 /home/cor277/public_html/PM/application/models/widgets/Widget.class.php(48): include('/home/cor277/pu...')
    #12 /home/cor277/public_html/PM/application/controllers/DashboardController.class.php(291): Widget->execute()
    #13 /home/cor277/public_html/PM/application/views/dashboard/main_dashboard.php(15): DashboardTools::renderSection('left')
    #14 /home/cor277/public_html/PM/environment/classes/template/Template.class.php(85): include('/home/cor277/pu...')
    #15 /home/cor277/public_html/PM/environment/classes/template/Template.class.php(56): Template->includeTemplate('/home/cor277/pu...')
    #16 /home/cor277/public_html/PM/environment/classes/template/template.php(35): Template->fetch('/home/cor277/pu...')
    #17 /home/cor277/public_html/PM/environment/classes/controller/PageController.class.php(123): tpl_fetch('/home/cor277/pu...')
    #18 /home/cor277/public_html/PM/environment/classes/Env.class.php(135): PageController->getContent()
    #19 /home/cor277/public_html/PM/init.php(174): Env::executeAction('dashboard', 'main_dashboard')
    #20 /home/cor277/public_html/PM/index.php(9): require('/home/cor277/pu...')
    #21 {main}
Time since start: 0.182388067245 seconds
-------------------------------------------------------------------------------

Session "default" started at 2015-02-27T09:26:31+0000
#1 DEBUG: SQL ERROR: Query failed with message 'Unknown column 'order' in 'field list'' - SELECT `id`, `dimension_id`, `object_type_id`, `parent_member_id`, `depth`, `name`, `object_id`, `archived_on`, `archived_by_id`, `color`, `order` FROM `fo_members` WHERE `id` = '13'
#2 FATAL: exception 'DBQueryError' with message 'Query failed with message 'Unknown column 'order' in 'field list''' in /home/cor277/public_html/PM/environment/library/database/adapters/AbstractDBAdapter.class.php:392
    Stack trace:
    #0 /home/cor277/public_html/PM/environment/library/database/adapters/AbstractDBAdapter.class.php(291): AbstractDBAdapter->prepareAndExecute('SELECT `id`, `d...', NULL)
    #1 /home/cor277/public_html/PM/environment/library/database/DB.class.php(179): AbstractDBAdapter->executeOne('SELECT `id`, `d...', NULL)
    #2 /home/cor277/public_html/PM/environment/classes/dataaccess/DataManager.class.php(482): DB::executeOne('SELECT `id`, `d...')
    #3 /home/cor277/public_html/PM/environment/classes/dataaccess/DataManager.class.php(447): DataManager->loadRow('13')
    #4 /home/cor277/public_html/PM/environment/classes/dataaccess/DataManager.class.php(351): DataManager->load('13', false)
    #5 /home/cor277/public_html/PM/application/models/members/base/BaseMembers.class.php(158): DataManager->findById('13', false)
    #6 /home/cor277/public_html/PM/application/models/members/base/BaseMembers.class.php(160): BaseMembers->findById('13', false)
    #7 /home/cor277/public_html/PM/application/models/members/Members.class.php(56): BaseMembers::findById('13')
    #8 /home/cor277/public_html/PM/application/controllers/DimensionController.class.php(578): Members::getMemberById('13')
    #9 /home/cor277/public_html/PM/environment/classes/controller/Controller.class.php(76): DimensionController->get_members()
    #10 /home/cor277/public_html/PM/environment/classes/controller/PageController.class.php(62): Controller->execute('get_members')
    #11 /home/cor277/public_html/PM/environment/classes/Env.class.php(129): PageController->execute('get_members')
    #12 /home/cor277/public_html/PM/init.php(174): Env::executeAction('dimension', 'get_members')
    #13 /home/cor277/public_html/PM/index.php(9): require('/home/cor277/pu...')
    #14 {main}
Time since start: 0.0785238742828 seconds
-------------------------------------------------------------------------------

Session "default" started at 2015-02-27T09:26:32+0000
#1 DEBUG: SQL ERROR: Query failed with message 'Unknown column 'order' in 'field list'' - SELECT `id`, `dimension_id`, `object_type_id`, `parent_member_id`, `depth`, `name`, `object_id`, `archived_on`, `archived_by_id`, `color`, `order` FROM `fo_members` WHERE `id` = '13'
#2 FATAL: exception 'DBQueryError' with message 'Query failed with message 'Unknown column 'order' in 'field list''' in /home/cor277/public_html/PM/environment/library/database/adapters/AbstractDBAdapter.class.php:392
    Stack trace:
    #0 /home/cor277/public_html/PM/environment/library/database/adapters/AbstractDBAdapter.class.php(291): AbstractDBAdapter->prepareAndExecute('SELECT `id`, `d...', NULL)
    #1 /home/cor277/public_html/PM/environment/library/database/DB.class.php(179): AbstractDBAdapter->executeOne('SELECT `id`, `d...', NULL)
    #2 /home/cor277/public_html/PM/environment/classes/dataaccess/DataManager.class.php(482): DB::executeOne('SELECT `id`, `d...')
    #3 /home/cor277/public_html/PM/environment/classes/dataaccess/DataManager.class.php(447): DataManager->loadRow('13')
    #4 /home/cor277/public_html/PM/environment/classes/dataaccess/DataManager.class.php(351): DataManager->load('13', false)
    #5 /home/cor277/public_html/PM/application/models/members/base/BaseMembers.class.php(158): DataManager->findById('13', false)
    #6 /home/cor277/public_html/PM/application/models/members/base/BaseMembers.class.php(160): BaseMembers->findById('13', false)
    #7 /home/cor277/public_html/PM/application/models/members/Members.class.php(56): BaseMembers::findById('13')
    #8 /home/cor277/public_html/PM/application/controllers/DimensionController.class.php(554): Members::getMemberById('13')
    #9 /home/cor277/public_html/PM/environment/classes/controller/Controller.class.php(76): DimensionController->get_member_parents()
    #10 /home/cor277/public_html/PM/environment/classes/controller/PageController.class.php(62): Controller->execute('get_member_pare...')
    #11 /home/cor277/public_html/PM/environment/classes/Env.class.php(129): PageController->execute('get_member_pare...')
    #12 /home/cor277/public_html/PM/init.php(174): Env::executeAction('dimension', 'get_member_pare...')
    #13 /home/cor277/public_html/PM/index.php(9): require('/home/cor277/pu...')
    #14 {main}
Time since start: 0.0580229759216 seconds
-------------------------------------------------------------------------------

Session "default" started at 2015-02-27T09:26:47+0000
#1 DEBUG: SQL ERROR: Query failed with message 'Unknown column 'order' in 'field list'' - SELECT `id`, `dimension_id`, `object_type_id`, `parent_member_id`, `depth`, `name`, `object_id`, `archived_on`, `archived_by_id`, `color`, `order` FROM `fo_members` WHERE `id` = '9'
#2 FATAL: exception 'DBQueryError' with message 'Query failed with message 'Unknown column 'order' in 'field list''' in /home/cor277/public_html/PM/environment/library/database/adapters/AbstractDBAdapter.class.php:392
    Stack trace:
    #0 /home/cor277/public_html/PM/environment/library/database/adapters/AbstractDBAdapter.class.php(291): AbstractDBAdapter->prepareAndExecute('SELECT `id`, `d...', NULL)
    #1 /home/cor277/public_html/PM/environment/library/database/DB.class.php(179): AbstractDBAdapter->executeOne('SELECT `id`, `d...', NULL)
    #2 /home/cor277/public_html/PM/environment/classes/dataaccess/DataManager.class.php(482): DB::executeOne('SELECT `id`, `d...')
    #3 /home/cor277/public_html/PM/environment/classes/dataaccess/DataManager.class.php(447): DataManager->loadRow('9')
    #4 /home/cor277/public_html/PM/environment/classes/dataaccess/DataManager.class.php(351): DataManager->load('9', false)
    #5 /home/cor277/public_html/PM/application/models/members/base/BaseMembers.class.php(158): DataManager->findById('9', false)
    #6 /home/cor277/public_html/PM/application/models/members/base/BaseMembers.class.php(160): BaseMembers->findById('9', false)
    #7 /home/cor277/public_html/PM/application/models/members/Members.class.php(56): BaseMembers::findById('9')
    #8 /home/cor277/public_html/PM/application/models/ContentDataObject.class.php(1838): Members::getMemberById('9')
    #9 /home/cor277/public_html/PM/application/widgets/overdue_upcoming/template.php(59): ContentDataObject->getMembersToDisplayPath()
    #10 /home/cor277/public_html/PM/application/widgets/overdue_upcoming/index.php(62): include_once('/home/cor277/pu...')
    #11 /home/cor277/public_html/PM/application/models/widgets/Widget.class.php(48): include('/home/cor277/pu...')
    #12 /home/cor277/public_html/PM/application/controllers/DashboardController.class.php(291): Widget->execute()
    #13 /home/cor277/public_html/PM/application/views/dashboard/main_dashboard.php(15): DashboardTools::renderSection('left')
    #14 /home/cor277/public_html/PM/environment/classes/template/Template.class.php(85): include('/home/cor277/pu...')
    #15 /home/cor277/public_html/PM/environment/classes/template/Template.class.php(56): Template->includeTemplate('/home/cor277/pu...')
    #16 /home/cor277/public_html/PM/environment/classes/template/template.php(35): Template->fetch('/home/cor277/pu...')
    #17 /home/cor277/public_html/PM/environment/classes/controller/PageController.class.php(123): tpl_fetch('/home/cor277/pu...')
    #18 /home/cor277/public_html/PM/environment/classes/Env.class.php(135): PageController->getContent()
    #19 /home/cor277/public_html/PM/init.php(174): Env::executeAction('dashboard', 'main_dashboard')
    #20 /home/cor277/public_html/PM/index.php(9): require('/home/cor277/pu...')
    #21 {main}
Time since start: 0.129314899445 seconds
-------------------------------------------------------------------------------

Session "default" started at 2015-02-27T09:27:30+0000
#1 DEBUG: SQL ERROR: Query failed with message 'Unknown column 'order' in 'field list'' - SELECT `id`, `dimension_id`, `object_type_id`, `parent_member_id`, `depth`, `name`, `object_id`, `archived_on`, `archived_by_id`, `color`, `order` FROM `fo_members` WHERE `id` = '9'
#2 FATAL: exception 'DBQueryError' with message 'Query failed with message 'Unknown column 'order' in 'field list''' in /home/cor277/public_html/PM/environment/library/database/adapters/AbstractDBAdapter.class.php:392
    Stack trace:
    #0 /home/cor277/public_html/PM/environment/library/database/adapters/AbstractDBAdapter.class.php(291): AbstractDBAdapter->prepareAndExecute('SELECT `id`, `d...', NULL)
    #1 /home/cor277/public_html/PM/environment/library/database/DB.class.php(179): AbstractDBAdapter->executeOne('SELECT `id`, `d...', NULL)
    #2 /home/cor277/public_html/PM/environment/classes/dataaccess/DataManager.class.php(482): DB::executeOne('SELECT `id`, `d...')
    #3 /home/cor277/public_html/PM/environment/classes/dataaccess/DataManager.class.php(447): DataManager->loadRow('9')
    #4 /home/cor277/public_html/PM/environment/classes/dataaccess/DataManager.class.php(351): DataManager->load('9', false)
    #5 /home/cor277/public_html/PM/application/models/members/base/BaseMembers.class.php(158): DataManager->findById('9', false)
    #6 /home/cor277/public_html/PM/application/models/members/base/BaseMembers.class.php(160): BaseMembers->findById('9', false)
    #7 /home/cor277/public_html/PM/application/models/members/Members.class.php(56): BaseMembers::findById('9')
    #8 /home/cor277/public_html/PM/application/models/ContentDataObject.class.php(1838): Members::getMemberById('9')
    #9 /home/cor277/public_html/PM/application/widgets/overdue_upcoming/template.php(59): ContentDataObject->getMembersToDisplayPath()
    #10 /home/cor277/public_html/PM/application/widgets/overdue_upcoming/index.php(62): include_once('/home/cor277/pu...')
    #11 /home/cor277/public_html/PM/application/models/widgets/Widget.class.php(48): include('/home/cor277/pu...')
    #12 /home/cor277/public_html/PM/application/controllers/DashboardController.class.php(291): Widget->execute()
    #13 /home/cor277/public_html/PM/application/views/dashboard/main_dashboard.php(15): DashboardTools::renderSection('left')
    #14 /home/cor277/public_html/PM/environment/classes/template/Template.class.php(85): include('/home/cor277/pu...')
    #15 /home/cor277/public_html/PM/environment/classes/template/Template.class.php(56): Template->includeTemplate('/home/cor277/pu...')
    #16 /home/cor277/public_html/PM/environment/classes/template/template.php(35): Template->fetch('/home/cor277/pu...')
    #17 /home/cor277/public_html/PM/environment/classes/controller/PageController.class.php(123): tpl_fetch('/home/cor277/pu...')
    #18 /home/cor277/public_html/PM/environment/classes/Env.class.php(135): PageController->getContent()
    #19 /home/cor277/public_html/PM/init.php(174): Env::executeAction('dashboard', 'main_dashboard')
    #20 /home/cor277/public_html/PM/index.php(9): require('/home/cor277/pu...')
    #21 {main}
Time since start: 0.113476991653 seconds
-------------------------------------------------------------------------------

Session "default" started at 2015-02-27T09:27:44+0000
#1 ERROR: Error: Undefined variable: image in '/home/cor277/public_html/PM/application/views/contact/card.php' on line 22 (error code: 8)
Time since start: 0.112060070038 seconds
-------------------------------------------------------------------------------

Session "default" started at 2015-02-27T09:27:53+0000
#1 DEBUG: SQL ERROR: Query failed with message 'Unknown column 'can_update_other_users_invitations' in 'field list'' - SELECT `permission_group_id`, `can_manage_security`, `can_manage_configuration`, `can_manage_templates`, `can_manage_time`, `can_add_mail_accounts`, `can_manage_dimensions`, `can_manage_dimension_members`, `can_manage_tasks`, `can_task_assignee`, `can_manage_billing`, `can_view_billing`, `can_see_assigned_to_other_tasks`, `can_update_other_users_invitations` FROM `fo_system_permissions` WHERE `permission_group_id` = '14'
#2 FATAL: exception 'DBQueryError' with message 'Query failed with message 'Unknown column 'can_update_other_users_invitations' in 'field list''' in /home/cor277/public_html/PM/environment/library/database/adapters/AbstractDBAdapter.class.php:392
    Stack trace:
    #0 /home/cor277/public_html/PM/environment/library/database/adapters/AbstractDBAdapter.class.php(291): AbstractDBAdapter->prepareAndExecute('SELECT `permiss...', NULL)
    #1 /home/cor277/public_html/PM/environment/library/database/DB.class.php(179): AbstractDBAdapter->executeOne('SELECT `permiss...', NULL)
    #2 /home/cor277/public_html/PM/environment/classes/dataaccess/DataManager.class.php(482): DB::executeOne('SELECT `permiss...')
    #3 /home/cor277/public_html/PM/environment/classes/dataaccess/DataManager.class.php(447): DataManager->loadRow(14)
    #4 /home/cor277/public_html/PM/environment/classes/dataaccess/DataManager.class.php(351): DataManager->load(14, false)
    #5 /home/cor277/public_html/PM/application/models/system_permissions/base/BaseSystemPermissions.class.php(163): DataManager->findById(14, false)
    #6 /home/cor277/public_html/PM/application/models/system_permissions/base/BaseSystemPermissions.class.php(165): BaseSystemPermissions->findById(14, false)
    #7 /home/cor277/public_html/PM/application/views/contact/edit_contact.php(200): BaseSystemPermissions->findById(14)
    #8 /home/cor277/public_html/PM/environment/classes/template/Template.class.php(85): include('/home/cor277/pu...')
    #9 /home/cor277/public_html/PM/environment/classes/template/Template.class.php(56): Template->includeTemplate('/home/cor277/pu...')
    #10 /home/cor277/public_html/PM/environment/classes/template/template.php(35): Template->fetch('/home/cor277/pu...')
    #11 /home/cor277/public_html/PM/environment/classes/controller/PageController.class.php(123): tpl_fetch('/home/cor277/pu...')
    #12 /home/cor277/public_html/PM/environment/classes/Env.class.php(135): PageController->getContent()
    #13 /home/cor277/public_html/PM/init.php(174): Env::executeAction('contact', 'edit')
    #14 /home/cor277/public_html/PM/index.php(9): require('/home/cor277/pu...')
    #15 {main}
Time since start: 0.112334012985 seconds
-------------------------------------------------------------------------------

Session "default" started at 2015-02-27T09:27:58+0000
#1 ERROR: Error: Undefined variable: image in '/home/cor277/public_html/PM/application/views/contact/card.php' on line 22 (error code: 8)
Time since start: 0.150257825851 seconds
-------------------------------------------------------------------------------

Session "default" started at 2015-02-27T09:28:08+0000
#1 ERROR: Error: Undefined variable: image in '/home/cor277/public_html/PM/application/views/contact/card.php' on line 22 (error code: 8)
Time since start: 0.107188224792 seconds
-------------------------------------------------------------------------------

franponce87

  • Administrator
  • Hero Member
  • *****
  • Posts: 1819
    • View Profile
    • Email
Re: FATAL ERROR SOFTACOLOUS UPDATE TO 3.1
« Reply #1 on: March 19, 2015, 05:22:53 pm »
That looks like a failed upgrade. May be they can help you upgrading it correctly?

Just for the record: we currently have no contract nor partnership with Softaculous.
If you want to use it in a cloud, I'd strongly suggest using ours.

Best,
Francisco
Would you like to install Feng Office Professional or Enterprise Edition in your servers? No problem! Read this article!