Author Topic: 1.7 beta 2 upgrade error - resolved  (Read 3733 times)

eugm

  • Newbie
  • *
  • Posts: 3
    • View Profile
1.7 beta 2 upgrade error - resolved
« on: April 19, 2010, 08:45:39 am »
I try to upgrade my 1.6.2 installation to 1.7 beta 2
but after upgrage I get fatal error.
in log.php:

Session "default" started at 2010-04-19T11:23:55+0000
#1 DEBUG: SQL ERROR: Query failed with message 'Unknown column 'type' in 'field list'' - SELECT `id`, `company_id`, `username`, `email`, `type`, `token`, `salt`, `twister`, `display_name`, `title`, `avatar_file`, `timezone`, `created_on`, `created_by_id`, `updated_on`, `updated_by_id`, `last_login`, `last_visit`, `last_activity`, `can_edit_company_data`, `can_manage_workspaces`, `can_manage_security`, `can_manage_configuration`, `auto_assign`, `personal_project_id`, `can_manage_contacts`, `can_manage_templates`, `can_manage_reports`, `can_manage_time`, `can_add_mail_accounts`, `default_billing_id` FROM `og_users` WHERE `id` = '1'
#2 FATAL: exception 'DBQueryError' with message 'Query failed with message 'Unknown column 'type' in 'field list''' in /environment/library/database/adapters/AbstractDBAdapter.class.php:386
    Stack trace:
    #0 /environment/library/database/adapters/AbstractDBAdapter.class.php(285): AbstractDBAdapter->prepareAndExecute('SELECT `id`, `c...', NULL)
    #1
/environment/library/database/DB.class.php(179): AbstractDBAdapter->executeOne('SELECT `id`, `c...', NULL)
    #2
/environment/classes/dataaccess/DataManager.class.php(456): DB::executeOne('SELECT `id`, `c...')
    #3
/environment/classes/dataaccess/DataManager.class.php(426): DataManager->loadRow(1)
    #4
/environment/classes/dataaccess/DataManager.class.php(330): DataManager->load(1, false)
    #5 /application/models/users/base/BaseUsers.class.php(233): DataManager->findById(1, false)
    #6
/application/models/users/base/BaseUsers.class.php(235): BaseUsers->findById(1, false)
    #7
/application/models/ApplicationDataObject.class.php(357): BaseUsers->findById(1)
    #8
/application/models/CompanyWebsite.class.php(67): ApplicationDataObject->getCreatedBy()
    #9
/application/models/CompanyWebsite.class.php(45): CompanyWebsite->initCompany()
    #10
/application/models/CompanyWebsite.class.php(49): CompanyWebsite->init()
    #11
/application/application.php(19): CompanyWebsite::init()
    #12 /init.php(139): require_once('/...')
    #13
/index.php(9): require('/...')
    #14 {main}
Time since start: 0.037616014480591 seconds
« Last Edit: April 20, 2010, 06:08:10 am by eugm »

eugm

  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: 1.7 beta 2 upgrade error
« Reply #1 on: April 20, 2010, 04:51:02 am »
I restore my old database, try uprade one more time, but I get same error.
Can anybody help me?

eugm

  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: 1.7 beta 2 upgrade error - resolved
« Reply #2 on: April 20, 2010, 06:09:11 am »
I found script in ugrade folder and run SQL manually, after it all works correctly

brg

  • Freshman
  • *
  • Posts: 22
    • View Profile
Re: 1.7 beta 2 upgrade error - resolved
« Reply #3 on: April 22, 2010, 06:49:17 am »
Confirm this.
Today upgrade from 1.6.2 to 1.7 beta and get same error.
Run script from db_migration folder manual too.