Author Topic: 1.1 - upgrade - db query error  (Read 6480 times)

Nuno Zimas

  • Full Member
  • ***
  • Posts: 127
    • View Profile
1.1 - upgrade - db query error
« on: January 11, 2009, 08:29:29 pm »
Upgrading from 1.0 to 1.1 using the upgrade script has ended up in tragedy.

Code: [Select]
uery failed with message 'Unknown column 'project_id' in 'where clause''
Error params:
File: /var/www/path_to/opengoo/environment/library/database/adapters/AbstractDBAdapter.class.php
Line: 371
Sql: SELECT * FROM `og_application_logs` WHERE `is_private` <= '1' AND `is_silent` <= '1' AND `project_id` IN ('1', '2') ORDER BY `created_on` DESC LIMIT 0, 15
Error number: 1054
Error message: Unknown column 'project_id' in 'where clause'
Backtrace:
#0 /var/www/path_to/opengoo/environment/library/database/adapters/AbstractDBAdapter.class.php(289): AbstractDBAdapter->prepareAndExecute('SELECT * FROM `...', NULL)
#1 /var/www/path_to/opengoo/environment/library/database/DB.class.php(194): AbstractDBAdapter->executeAll('SELECT * FROM `...', NULL)
#2 /var/www/path_to/opengoo/environment/classes/dataaccess/DataManager.class.php(182): DB::executeAll('SELECT * FROM `...')
#3 /var/www/path_to/opengoo/application/models/application_logs/base/BaseApplicationLogs.class.php(101): DataManager->find(Array)
#4 /var/www/path_to/opengoo/environment/classes/dataaccess/DataManager.class.php(210): BaseApplicationLogs->find(Array)
#5 /var/www/path_to/opengoo/application/models/application_logs/base/BaseApplicationLogs.class.php(118): DataManager->findAll(Array)
#6 /var/www/path_to/opengoo/application/models/application_logs/base/BaseApplicationLogs.class.php(120): BaseApplicationLogs->findAll(Array)
#7 /var/www/path_to/opengoo/application/models/application_logs/ApplicationLogs.class.php(174): BaseApplicationLogs::findAll(Array)
#8 /var/www/path_to/opengoo/application/controllers/DashboardController.class.php(52): ApplicationLogs::getOverallLogs(true, true, Array, 15)
#9 /var/www/path_to/opengoo/environment/classes/controller/Controller.class.php(69): DashboardController->index()
#10 /var/www/path_to/opengoo/environment/classes/controller/PageController.class.php(62): Controller->execute('index')
#11 /var/www/path_to/opengoo/environment/classes/Env.class.php(157): PageController->execute('index')
#12 /var/www/path_to/opengoo/init.php(151): Env::executeAction('dashboard', 'index')
#13 /var/www/path_to/opengoo/index.php(9): require('/var/www/egw.re...')
#14 {main}
Autoglobal varibles:
$_GET:
$_POST:
$_COOKIE: Array (
  ['id'] => (string) '1'
  ['token'] => (string) '797045cbe4075a5bf7773a0fcd8b71c2ac4016b0'
  ['remember'] => (string) '1'
  ['PHPSESSID'] => (string) '2291ec16fe25a70c11823e9a89dbf81c'
)
$_SESSION: Array (
  ['cal_version'] => true
  ['month'] => (string) '1'
  ['year'] => (string) '2009'
  ['day'] => (string) '11'
)
Execution time:
Total execution time: 0.078031 seconds
OS: GNU/Linux (PCLinuxOS) | Browser: Firefox 3.6.x and Chromium 5.0.x | FengOffice 1.7 RC

ignacio

  • Hero Member
  • *****
  • Posts: 1703
    • View Profile
Re: 1.1 - upgrade - db query error
« Reply #1 on: January 12, 2009, 11:14:17 am »
Did you run the upgrade process from version 1.0 to 1.1 by going to <your_opengoo>/public/upgrade? Did it give any errors? Were you using version 1.0?

Nuno Zimas

  • Full Member
  • ***
  • Posts: 127
    • View Profile
Re: 1.1 - upgrade - db query error
« Reply #2 on: January 12, 2009, 08:53:50 pm »
Did you run the upgrade process from version 1.0 to 1.1 by going to <your_opengoo>/public/upgrade? Did it give any errors? Were you using version 1.0?

Precisely. It was a 1.0 -> 1.1 upgrade.

I have downloaded 1.1, copied the files from public/upgrade over to the previous 1.0 installation and then ran the script.
Am i supposed to do anything else?

Thanks.
OS: GNU/Linux (PCLinuxOS) | Browser: Firefox 3.6.x and Chromium 5.0.x | FengOffice 1.7 RC

ignacio

  • Hero Member
  • *****
  • Posts: 1703
    • View Profile
Re: 1.1 - upgrade - db query error
« Reply #3 on: January 14, 2009, 11:41:47 am »
Hi, you have to copy all files from the 1.1 zip into the 1.0 installation. Extract everything inside the opengoo folder into your installation. This should fix the problem, without needing to run the upgrade process again.

Also, we recommend to always backup your installation before upgrading, this means backup you files (especially the config file, the upload directory and the /public/files dir) as well as the database.