[Pkg-owncloud-maintainers] Bug#717579: [owncloud] Upgrade to owncloud 5.0.9 fails for PostgreSQL backend

[Ingo Jürgensmann]

Am 22.07.2013 um 20:48 schrieb David Prévot <david at tilapin.org>:

>> Turned on maintenance mode
>> Failed to update database structure (MDB2 Error: syntax error […]
>> I guess this needs to be taken to upstream.
> Actually this one is Debian-specific: upstream “fixed” the
> php-mdb2-driver-pgsql they’re shipping, so we could ship their version
> in owncloud-pgsql (that will break and conflict php-mdb2-driver-pgsql).

So it's more likely a php problem? But isn't it so that the queries are constructed by the app and not by the mdb2 framework?

Although shipping the upstram mdb2 package might be possible, I'm not sure if that would violate the policy?

I downgraded to 5.0.8 in the meanwhile and OwnCloud works again (well, it doesn't run the upgrade scripts of course ;). 

> If I understood correctly, upstream is moving away from the MDB2
> backend, so I’d vote for this ugly, quick and dirty solution, knowing
> that should be properly fixed upstream later (and hopefully before Jessie).

I'm no PHP guy so I can't argue here what this kind of migration means for OC...

> An alternative would be to deactivate again the PostgreSQL backend…

... but I'm a PostgreSQL guy, more than a MySQL one. So I would prefer to keep PostgreSQL support, of course... ;-) 

> Any other idea or fix are welcome.


I can only offer to test packages and try to work on the SQL queries for PostgreSQL... 

-- 
Ciao...            //      Fon: 0381-2744150
      Ingo       \X/       http://blog.windfluechter.net


gpg pubkey:  http://www.juergensmann.de/ij_public_key.asc