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

[Ingo Juergensmann]

Package: owncloud
Severity: normal

--- Please enter the report below this line. ---

Hi!

Today I upgraded my Owncloud 5.0.8 VM to 5.0.9. The upgrade went well 
for apt-get, but when accessing the website I get an error, when the 
system detects that it needs to upgrade:

Updating ownCloud to version 5.0.9, this may take a while.

Turned on maintenance mode
Failed to update database structure (MDB2 Error: syntax error, _doQuery: 
[Error message: Could not execute statement] [Last executed query: ALTER 
TABLE "oc_locks" ALTER "id" TYPE SERIAL PRIMARY KEY USING CAST("id" AS 
SERIAL PRIMARY KEY)] [Native message: ERROR: syntax error at or near 
"PRIMARY" LINE 1: ALTER TABLE "oc_locks" ALTER "id" TYPE SERIAL PRIMARY 
KEY US... ^] )

The update was unsuccessful. Please report this issue to the ownCloud 
community.

When looking at the PostgreSQL log, I see this:

2013-07-22 16:41:37.605 CEST owncloud owncloud ERROR:  syntax error at 
or near "PRIMARY" at character 47
2013-07-22 16:41:37.605 CEST owncloud owncloud STATEMENT:  ALTER TABLE 
"oc_locks" ALTER "id" TYPE SERIAL PRIMARY KEY USING CAST("id" AS SERIAL 
PRIMARY KEY)


I guess this needs to be taken to upstream.

Regards,
Ingo

--- System information. ---
Architecture: amd64
Kernel:       Linux 3.9-1-amd64

Debian Release: jessie/sid
   500 unstable        www.deb-multimedia.org
   500 unstable        ftp.debian.org
     1 experimental    ftp.debian.org

--- Package information. ---
Package's Depends field is empty.

Package's Recommends field is empty.

Package's Suggests field is empty.




-- 
Ciao...            //      Fon: 0381-2744150
       Ingo       \X/       http://blog.windfluechter.net
Please don't share this address with Facebook or Google!
gpg pubkey: http://www.juergensmann.de/ij_public_key.asc