[Midas] upgrade from 3.2.0 to 3.2.2

Walsworth, Colby colby at sdsc.edu
Mon Apr 16 14:10:13 EDT 2012


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>

#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?



-----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.


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

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

More information about the Midas mailing list