Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: DAViCal: General
Re: Error while upgrading to 0.9.9.6-1
 

Index | Next | Previous | View Flat


mir at datanom

Sep 28, 2011, 9:14 AM


Views: 2158
Permalink
Re: Error while upgrading to 0.9.9.6-1 [In reply to]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, 28 Sep 2011 07:43:55 +0200
Ingo Belka <ingo_belka [at] grimmen> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi Michael,
>
> sorry I was to fast. I did overseen these error messages while
> applying the 1.2.10b.sql, because someone disturbed me:
>
What out does the following query give?
select schema_major, schema_minor, schema_patch, schema_name from
awl_db_revision;

Before applying 1.2.10b you should see:
schema_major | schema_minor | schema_patch | schema_name
- --------------+--------------+--------------+-------------
1 | 1 | 0 | Dawn
1 | 2 | 7 | Juillet
1 | 2 | 8 | Août
1 | 2 | 9 | Septembre
1 | 2 | 10 | Octobre

After applying 1.2.10b you should see:
schema_major | schema_minor | schema_patch | schema_name
- --------------+--------------+--------------+-------------
1 | 1 | 0 | Dawn
1 | 2 | 7 | Juillet
1 | 2 | 8 | Août
1 | 2 | 9 | Septembre
1 | 2 | 10 | Octobre
1 | 2 | 10 | Octobre

But none the less the following set of commands should solve your issue:
(use attached patch instead)

ALTER TABLE dav_binding ADD UNIQUE( dav_name );

ALTER TABLE principal ADD CONSTRAINT unique_user UNIQUE (user_no);

- -- Ensure we don't refer to any newer, duplicated collections
UPDATE caldav_data SET collection_id = (SELECT min(c2.collection_id)
FROM collection c1, collection c2 WHERE c1.dav_name = c2.dav_name AND
c1.collection_id = caldav_data.collection_id) WHERE collection_id >
(SELECT min(c2.collection_id) FROM collection c1, collection c2 WHERE
c1.dav_name = c2.dav_name AND c1.collection_id =
caldav_data.collection_id); -- Ensure the newer duplicated collections
don't exist any longer DELETE FROM collection WHERE collection_id >
(SELECT min(collection_id) FROM collection c2 WHERE c2.dav_name =
collection.dav_name); -- Ensure we can't add more duplicates in the
future ALTER TABLE collection ADD CONSTRAINT unique_path UNIQUE
(dav_name);

SELECT new_db_revision(1,2,10, 'Octobre' );

- --
Hilsen/Regards
Michael Rasmussen

Get my public GnuPG keys:
michael <at> rasmussen <dot> cc
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xD3C9A00E
mir <at> datanom <dot> net
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xE501F51C
mir <at> miras <dot> org
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xE3E80917
- --------------------------------------------------------------
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)

iEYEARECAAYFAk6DR+4ACgkQQQOPluUB9RyplwCgy5YAuBWYAG08z1pbHH+WHq/K
3lkAoLsUyksMLRCydB99aJeqHThTNnzg
=Ii+S
-----END PGP SIGNATURE-----
Attachments: 1.2.10c.sql (1.21 KB)

Subject User Time
Error while upgrading to 0.9.9.6-1 ingo_belka at grimmen Sep 26, 2011, 11:43 PM
    Re: Error while upgrading to 0.9.9.6-1 vvh at synergylaw Sep 27, 2011, 12:31 AM
        Re: Error while upgrading to 0.9.9.6-1 ingo_belka at grimmen Sep 27, 2011, 6:59 AM
            Re: Error while upgrading to 0.9.9.6-1 wogri at wogri Sep 27, 2011, 7:27 AM
                Re: Error while upgrading to 0.9.9.6-1 ingo_belka at grimmen Sep 27, 2011, 8:44 AM
                    Re: Error while upgrading to 0.9.9.6-1 jon at azrider Sep 27, 2011, 9:45 AM
                    Re: Error while upgrading to 0.9.9.6-1 michael at lackhoff Sep 27, 2011, 9:56 AM
                        Re: Error while upgrading to 0.9.9.6-1 mir at datanom Sep 27, 2011, 10:41 AM
                            Re: Error while upgrading to 0.9.9.6-1 michael at lackhoff Sep 27, 2011, 11:17 AM
                        Re: Error while upgrading to 0.9.9.6-1 mir at datanom Sep 27, 2011, 10:48 AM
                            Re: Error while upgrading to 0.9.9.6-1 michael at lackhoff Sep 27, 2011, 2:40 PM
                                Re: Error while upgrading to 0.9.9.6-1 mir at datanom Sep 27, 2011, 3:22 PM
                                    Re: Error while upgrading to 0.9.9.6-1 ingo_belka at grimmen Sep 27, 2011, 10:30 PM
                                    Re: Error while upgrading to 0.9.9.6-1 ingo_belka at grimmen Sep 27, 2011, 10:43 PM
                                        Re: Error while upgrading to 0.9.9.6-1 mir at datanom Sep 28, 2011, 9:14 AM
                                            Re: Error while upgrading to 0.9.9.6-1 davical at awayand Sep 28, 2011, 9:31 AM
                                            Re: Error while upgrading to 0.9.9.6-1 jon at azrider Sep 28, 2011, 9:36 AM
                                    Re: Error while upgrading to 0.9.9.6-1 michael at lackhoff Sep 27, 2011, 11:07 PM
                                        Re: Error while upgrading to 0.9.9.6-1 andrew at morphoss Sep 29, 2011, 5:10 AM
                    Re: Error while upgrading to 0.9.9.6-1 mihaic at gmail Sep 27, 2011, 10:39 AM
    Re: Error while upgrading to 0.9.9.6-1 mir at datanom Sep 27, 2011, 1:53 PM
    Re: Error while upgrading to 0.9.9.6-1 mir at datanom Sep 27, 2011, 1:55 PM
    Re: Error while upgrading to 0.9.9.6-1 mir at datanom Sep 28, 2011, 1:27 PM
    Re: Error while upgrading to 0.9.9.6-1 andrew at morphoss Sep 28, 2011, 3:05 PM
        Re: Error while upgrading to 0.9.9.6-1 ingo_belka at grimmen Sep 28, 2011, 10:09 PM
            Re: Error while upgrading to 0.9.9.6-1 andrew at morphoss Sep 29, 2011, 4:38 AM
        Re: Error while upgrading to 0.9.9.6-1 ingo_belka at grimmen Sep 28, 2011, 11:29 PM

  Index | Next | Previous | View Flat
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.