[Midas] upgrade from 3.2.0 to 3.2.2

[Michael Grauer]

It looks like we are going to have to go back and forth a bit to get
it figured out.



Can you describe in more detail your initial Midas setup, and then how
you got an updated source tree for the upgrade?



Then looking at your

 /data/Midas-3.2.2/core/configs/database.local.ini

what this says for version?

Also for the version in

 /data/Midas-3.2.2/core/configs/scheduler.local.ini

Are you using mysql?  If so, could you send me the output of the
following command:

describe scheduler_log;

And can you tell me if you have a license table, and if so, what is
the output of

select count(*) from license;




On Mon, Apr 16, 2012 at 2:10 PM, Walsworth, Colby <colby at sdsc.edu> wrote:
> 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



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