[horde] upgrading / scripts folder?

[Michael J Rubinsky]

Please keep discussion on the mailing list.

Quoting Joe @ 3ZZZ <joe at 3zzz.net>:

> Quoting Michael J Rubinsky <mrubinsk at horde.org>:
>
>> Quoting Joe at 3zzz.net:
>>
>>> On 10/6/2014 7:33 AM, Michael J Rubinsky wrote:
>>>>
>>>> Quoting Joe @ 3ZZZ <joe at 3zzz.net>:
>>>>
>>>>> Hello -
>>>>>
>>>>> I've been trying to upgrade from Horde 3 to 5, but seem to be  
>>>>> stuck. My new installation of Horde doesn't have a scripts  
>>>>> directory - is that where I'd find any SQL upgrade scripts?  
>>>>> Haven't been able to find that anywhere.  Do I need to look on  
>>>>> Git?
>>>>
>>>> Starting with Horde 4, we moved to a "migrations" system that is  
>>>> responsible for maintaining the db schema between versions. The  
>>>> migration system assumes that any existing database schema that  
>>>> hasn't been migrated is in the same state it would have been as  
>>>> of the last stable version of Horde 3. It sounds to me like at  
>>>> least some of your applications were not fully up to date with H3  
>>>> when you decided to move to H5.
>>>>
>>>>
>>>>> Below is a summary of the issues I'm seeing on the new system.   
>>>>> Thank you in advance for any advice or suggestions,
>>>>> Joe
>>>>>
>>>>>
>>>>> installed horde with pear and it did not seem to come with a  
>>>>> scripts directory?
>>>>>
>>>>> "At least one database schema is outdated"
>>>>> mnemo is coming from H3 (2.2.3)
>>>>> when i try to update the schema for mnemo, this is the error:
>>>>> QUERY FAILED: Unknown column 'share_parents' in 'mnemo_shares'  
>>>>> ALTER TABLE `mnemo_shares` CHANGE `share_parents`  
>>>>> `share_parents` varchar(4000)
>>>>
>>>> See above.
>>>>
>>>
>>> Hello -
>>>
>>> I brought up a copy of the old Horde 3 server and upgraded all  
>>> items to the latest H3 versions.  They were all minor updates and  
>>> didn't require any database updates.  The setup page shows they're  
>>> all ready yet mnemo_shares table still doesn't have a  
>>> share_parents column, so I don't think upgrading mnemo from 2.2.3  
>>> to 2.2.5 was enough to make this work.
>>> I looked in scripts/upgrade and there's nothing new for my  
>>> versions.  I looked at sharesng.sql, but I can see it won't add  
>>> that column...
>>> upgrades]# grep share_parents * --> no output...
>>>
>>> Is upgrading to H5 on this copy going to work?  What provides this column?
>>
>> It's added in the "5" migration for Mnemo. See  
>> mnemo/migration/5_mnemo_upgrade_sqlnghierarchal.php
>>
>
> Thank you!  I see the script - is there any documentation about the  
> migration folders?  I haven't been able to find anything yet.  This  
> is what I have, Is it best to run everything in there, or is it  
> something that should have happened through the web Administration?

These are the files that are executed when you upgrade the schema via  
the web administration. Alternatively, you can run them manually using  
the horde-db-migration script.


>
> 1_mnemo_base_tables.php             
> 4_mnemo_upgrade_sqlhierarchical.php    7_mnemo_upgrade_parents.php
> 2_mnemo_upgrade_autoincrement.php  5_mnemo_upgrade_sqlnghierarchical.php
> 3_mnemo_upgrade_sqlng.php          6_mnemo_upgrade_categoriestotags.php


-- 
mike
The Horde Project
http://www.horde.org
https://www.facebook.com/hordeproject
https://www.twitter.com/hordeproject
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5869 bytes
Desc: S/MIME Signature
URL: <http://lists.horde.org/archives/horde/attachments/20141011/a3d37d70/attachment.bin>