[Midas] upgrade from 3.2.0 to 3.2.2

[Walsworth, Colby]

Mike,

Thanks very much for the help.

When we run the upgrade we get the following errors in the logs:
<b>Message: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'creator_id'</b>

Trace:
#0 /data/Midas-3.2.2/library/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /data/Midas-3.2.2/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /data/Midas-3.2.2/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('ALTER TABLE sch...', Array)
#3 /data/Midas-3.2.2/modules/scheduler/database/upgrade/1.0.3.php(31): Zend_Db_Adapter_Pdo_Abstract->query('ALTER TABLE sch...')
#4 /data/Midas-3.2.2/core/controllers/components/UpgradeComponent.php(269): Scheduler_Upgrade_1_0_3->mysql()
#5 /data/Midas-3.2.2/core/controllers/components/UpgradeComponent.php(169): UpgradeComponent->_processFile(Array)
#6 /data/Midas-3.2.2/core/controllers/AdminController.php(452): UpgradeComponent->upgrade('1.0.0')
#7 /data/Midas-3.2.2/library/Zend/Controller/Action.php(512): AdminController->upgradeAction()
#8 /data/Midas-3.2.2/library/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('upgradeAction')
#9 /data/Midas-3.2.2/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#10 /data/Midas-3.2.2/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#11 /data/Midas-3.2.2/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#12 /data/Midas-3.2.2/index.php(73): Zend_Application->run()
#13 {main}

Do you have any suggestions on how to get around this problem?

Thanks,

Colby

-----Original Message-----
From: Michael Grauer [mailto:michael.grauer at kitware.com] 
Sent: Friday, April 13, 2012 1:31 PM
To: Walsworth, Colby
Cc: midas at public.kitware.com
Subject: Re: [Midas] upgrade from 3.2.0 to 3.2.2

Hi Colby,

Assuming you got the updated code correctly, you should be able to go into the Administration menu as an Admin user of Midas through the web UI, there you will see an upgrade tab.  You can click on the upgrade button in that tab and you should be able to see your Midas version change.  This upgrade is not destructive, it won't lose any of your current data.

Let me know if you have further questions.

Thanks,
Mike

On Fri, Apr 13, 2012 at 4:16 PM, Walsworth, Colby <colby at sdsc.edu> wrote:
> Hi I was wondering if there is an easy way to upgrade Midas server 
> from
> 3.2.0 to 3.2.2 stable. I copied in the new code still using the old 
> database and most of it seems to work fine. The upload function breaks 
> with a internal server error and I find this in the logs:
>
>
>
> <b>Message: SQLSTATE[42S02]: Base table or view not found: 1146 Table 
> 'midas.license' doesn't exist</b>
>
>
>
> Is there a function to just bring the database up to current version? 
> We would like to upgrade without loosing all our current users and data.
>
>
>
> Thanks,
>
>
>
> Colby Walsworth
>
> SDSC IT Systems
>
> Unix Systems Administrator
>
> X25416
>
>
>
>
> _______________________________________________
> Midas mailing list
> Midas at public.kitware.com
> http://public.kitware.com/cgi-bin/mailman/listinfo/midas
>



--
Thanks,
Michael Grauer
R & D Engineer
Kitware, Inc.
919 969 6990 x322