Author Topic: upgrade from 0.92 to 1.0RC1 problem  (Read 5599 times)

woland255

  • Freshman
  • *
  • Posts: 39
    • View Profile
upgrade from 0.92 to 1.0RC1 problem
« on: October 31, 2008, 07:45:59 am »
Good day to all.

After upgrade when i click on any object i see:

Query failed with message 'Table 'opengoo.og_object_subscriptions' doesn't exist'
Error params:
File:    /var/www/apache2/html/opengoo/environment/library/database/adapters/AbstractDBAdapter.class.php
Line:    371
Sql:    SELECT `object_id`, `object_manager`, `user_id` FROM `og_object_subscriptions` WHERE `object_id` = '20' AND `object_manager` = 'ProjectTasks' AND `user_id` = '1'
Error number:    1146
Error message:    Table 'opengoo.og_object_subscriptions' doesn't exist
Backtrace:
#0 /var/www/apache2/html/opengoo/environment/library/database/adapters/AbstractDBAdapter.class.php(270): AbstractDBAdapter->prepareAndExecute('SELECT `object_...', NULL)
#1 /var/www/apache2/html/opengoo/environment/library/database/DB.class.php(168): AbstractDBAdapter->executeOne('SELECT `object_...', NULL)
#2 /var/www/apache2/html/opengoo/environment/classes/dataaccess/DataManager.class.php(361): DB::executeOne('SELECT `object_...')
#3 /var/www/apache2/html/opengoo/environment/classes/dataaccess/DataManager.class.php(331): DataManager->loadRow(Array)
#4 /var/www/apache2/html/opengoo/environment/classes/dataaccess/DataManager.class.php(236): DataManager->load(Array, false)
#5 /var/www/apache2/html/opengoo/application/models/object_subscriptions/base/BaseObjectSubscriptions.class.php(160): DataManager->findById(Array, false)
#6 /var/www/apache2/html/opengoo/application/models/object_subscriptions/base/BaseObjectSubscriptions.class.php(162): BaseObjectSubscriptions->findById(Array, false)
#7 /var/www/apache2/html/opengoo/application/models/ProjectDataObject.class.php(1185): BaseObjectSubscriptions->findById(Array)
#8 /var/www/apache2/html/opengoo/application/views/object/list_subscribers.php(8): ProjectDataObject->isSubscriber(Object(User))
#9 /var/www/apache2/html/opengoo/environment/classes/template/Template.class.php(74): include('/var/www/apache...')
#10 /var/www/apache2/html/opengoo/environment/classes/template/Template.class.php(46): Template->includeTemplate('/var/www/apache...')
#11 /var/www/apache2/html/opengoo/environment/classes/template/template.php(35): Template->fetch('/var/www/apache...')
#12 /var/www/apache2/html/opengoo/application/helpers/application.php(746): tpl_fetch('/var/www/apache...')
#13 /var/www/apache2/html/opengoo/application/views/co/view.php(143): render_object_subscribers(Object(ProjectTask))
#14 /var/www/apache2/html/opengoo/environment/classes/template/Template.class.php(74): include('/var/www/apache...')
#15 /var/www/apache2/html/opengoo/application/views/task/view_list.php(106): Template->includeTemplate('/var/www/apache...')
#16 /var/www/apache2/html/opengoo/environment/classes/template/Template.class.php(74): include('/var/www/apache...')
#17 /var/www/apache2/html/opengoo/environment/classes/template/Template.class.php(46): Template->includeTemplate('/var/www/apache...')
#18 /var/www/apache2/html/opengoo/environment/classes/template/template.php(35): Template->fetch('/var/www/apache...')
#19 /var/www/apache2/html/opengoo/environment/classes/controller/PageController.class.php(111): tpl_fetch('/var/www/apache...')
#20 /var/www/apache2/html/opengoo/environment/classes/Env.class.php(129): PageController->getContent()
#21 /var/www/apache2/html/opengoo/init.php(151): Env::executeAction('task', 'view_task')
#22 /var/www/apache2/html/opengoo/index.php(9): require('/var/www/apache...')
#23 {main}
Autoglobal varibles:
$_GET:    Array (
  ['undefined'] => (string) ''
  ['ajax'] => (string) 'true'
  ['c'] => (string) 'task'
  ['a'] => (string) 'view_task'
  ['id'] => (string) '20'
  ['active_project'] => (string) '12'
  ['view'] => (string) 'week'
  ['current'] => (string) 'calendar-panel'
)
$_POST:    
$_COOKIE:    Array (
  ['PHPSESSID'] => (string) 'rqaqt516kgh0b5loa83n9cpccfqhgt8s'
  ['id'] => (string) '1'
  ['token'] => (string) '515e83cdabd402b504dd6a4fb9cf3b84810c9605'
)
$_SESSION:    Array (
  ['cal_version'] => true
  ['cal_month'] => (string) '10'
  ['cal_year'] => (string) '2008'
  ['cal_day'] => (string) '31'
  ['cal_loginfailed'] => (int)0
  ['cal_user'] => (string) 'admin'
  ['cal_userid'] => (int)1
  ['active_calendar_view'] => (string) 'viewweek'
  ['year'] => (string) '2008'
  ['month'] => (string) '10'
  ['day'] => (string) '31'
)
Execution time:
Total execution time: 0.197324 seconds\

Am I miss table creation in upgrade instructions??
Thanks

ignacio

  • Hero Member
  • *****
  • Posts: 1703
    • View Profile
Re: upgrade from 0.92 to 1.0RC1 problem
« Reply #1 on: October 31, 2008, 09:59:20 am »
Hi woland,

The readme.txt file is missing one step in the upgrade instructions.

To upgrade form 0.9.X to 1.0 RC1 you have to overwrite your installation with OpenGoo 1.0 minus the config and upload folders, and then, in your browser, go to <your_opengoo_root>/public/upgrade. There choose to upgrade from 0.9 to 1.0 and if there aren't any errors the database will be updated.

Sorry for that mistake!

woland255

  • Freshman
  • *
  • Posts: 39
    • View Profile
Re: upgrade from 0.92 to 1.0RC1 problem
« Reply #2 on: October 31, 2008, 10:47:16 am »
Now it works! Thanks!

hardsoft

  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: upgrade from 0.92 to 1.0RC1 problem
« Reply #3 on: October 31, 2008, 09:07:31 pm »
I am receiving the following error when trying to upgrade.  Any ideas why



    * Config file found and loaded.
    * File '/config/config.php' exists and is writable
    * Folder '/public/files' 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.
    * Failed to execute DB schema transformations. MySQL said: Table 'focuseds_main.og_user_ws_config_options' doesn't exist


ignacio

  • Hero Member
  • *****
  • Posts: 1703
    • View Profile
Re: upgrade from 0.92 to 1.0RC1 problem
« Reply #4 on: November 01, 2008, 09:52:16 am »
Maybe you forgot to run the upgrade from 0.8 to 0.9?

hardsoft

  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: upgrade from 0.92 to 1.0RC1 problem
« Reply #5 on: November 01, 2008, 05:54:08 pm »
Many thanks and yes you were correct I had forgot to do that upgrade.

I must say OpenGoo is one of the easiest web apps I have ever upgraded.

Would be nice on the upgrade screen to display the current version you are running to make it idoit proof for people like me.