[Pkg-owncloud-maintainers] Bug#756658: owncloud: After migration from 6.0.4, database upgrade fail to find a table

Mathias BOCQUET dbts at sekoya.org
Thu Jul 31 20:45:47 UTC 2014

Package: owncloud
Version: 7.0.1~rc1+dfsg-1
Severity: grave
Justification: renders package unusable

Dear Maintainer,

   * What led up to the situation?
upgrade from owncloud 6.0.4+dfsg-1. Upgrade process (from browser) failed while
searching for oc_oc_ldap_user_mapping* table. Note the double oc_oc_ which means
the upgrade script should contains an 'oc_' prefix which shouldn't be there...
Following is the error from the owncloud main page after pushing the upgrade
button :
Updating ownCloud to version 7.0.1 RC1, this may take a while.

Basculé en mode maintenance
An exception occurred while executing 'ALTER TABLE `oc_oc_ldap_user_mapping_a151345098df0` DROP PRIMARY KEY': SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'PRIMARY'; check that column/key exists

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

   * What exactly did you do (or not do) that was effective (or ineffective)?
Issue appeared with upgrade to version 7.0.0+dfsg-1. Tried versions 7.0.0+dfsg-2
from unstable and 7.0.1~rc1+dfsg-1 from experimental. All have the same issue.

   * What was the outcome of this action?
The upgrade process failed leaving owncloud unusable.

   * What outcome did you expect instead?
The upgrade process is sucessfull and owncloud is usable.

-- System Information:
Debian Release: 7.6
  APT prefers stable
  APT policy: (990, 'stable'), (500, 'testing-proposed-updates'), (500, 'stable-updates'), (500, 'proposed-updates'), (90, 'testing')
Architecture: amd64 (x86_64)

Kernel: Linux 3.2.0-3-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages owncloud depends on:
ii  apache2                  2.4.6-3
ii  apache2-bin [httpd]      2.4.6-3
ii  fonts-font-awesome       4.0.0~dfsg-1
ii  fonts-liberation         1.07.2-6
ii  fonts-linuxlibertine     5.3.0-2
ii  fonts-lohit-deva         2.5.3-1
ii  fonts-sil-gentium-basic  1.1-7
ii  fonts-wqy-microhei       0.2.0-beta-2
ii  libjs-chosen             0.9.11-1
ii  libjs-dojo-dojox         1.7.2+dfsg-1
ii  libjs-jcrop              0.9.12+dfsg-1
ii  libjs-jquery-minicolors  1.2.1-1
ii  libjs-jquery-mousewheel  6-1
ii  libjs-jquery-timepicker  1.2-1
ii  libjs-pdf                1.0.473+dfsg-1
ii  libphp-phpmailer         5.1-1
ii  owncloud-doc             0~20140120-1
ii  php-assetic              1.1.2-1
ii  php-doctrine-dbal        2.4.2-2
ii  php-getid3               1.9.7-1
ii  php-opencloud            1.10.0-2
ii  php-patchwork-utf8       1.1.7-1
ii  php-pear                 5.4.4-14+deb7u12
ii  php-pimple               1.1.1-1
ii  php-sabre-dav            1.8.10-1
ii  php-seclib               0.3.5-2
ii  php-symfony-classloader  2.3.6-1
ii  php-symfony-console      2.3.1+dfsg-1
ii  php-symfony-routing      2.0.19-1
ii  php5                     5.6.0~rc2+dfsg-1
ii  php5-gd                  5.6.0~rc2+dfsg-1
ii  php5-json                1.3.5-3
ii  php5-mysql               5.6.0~rc2+dfsg-1
ii  php5-sqlite              5.6.0~rc2+dfsg-1
ii  zendframework            1.12.3-1

Versions of packages owncloud recommends:
ii  libav-tools                     6:9.10-2
ii  libreoffice                     1:4.1.4-2+b1
ii  php-aws-sdk                     2.5.2-1
ii  php-crypt-blowfish              1.1.0~RC2-3
ii  php-dropbox                     1.0.0-1
ii  php-google-api-php-client       0.6.2-1
ii  php5-apcu                       4.0.6-1
ii  php5-cli                        5.6.0~rc2+dfsg-1
ii  php5-curl                       5.6.0~rc2+dfsg-1
ii  php5-imagick                    3.1.2-1+b1
ii  php5-intl                       5.6.0~rc2+dfsg-1
ii  php5-ldap                       5.6.0~rc2+dfsg-1
ii  php5-mcrypt                     5.6.0~rc2+dfsg-1
ii  postfix [mail-transport-agent]  2.9.6-2
pn  smbclient                       <none>

Versions of packages owncloud suggests:
ii  libapache2-mod-xsendfile                    0.12-2
ii  mariadb-server-10.0 [virtual-mysql-server]  10.0.12+maria-1~wheezy

-- Configuration Files:
/etc/owncloud/htaccess changed:
<IfModule mod_fcgid.c>
<IfModule mod_setenvif.c>
<IfModule mod_headers.c>
SetEnvIfNoCase ^Authorization$ "(.+)" XAUTHORIZATION=$1
RequestHeader set XAuthorization %{XAUTHORIZATION}e env=XAUTHORIZATION
<IfModule mod_php5.c>
php_value upload_max_filesize 513M
php_value post_max_size 513M
php_value memory_limit 512M
php_value mbstring.func_overload 0
<IfModule env_module>
  SetEnv htaccessWorking true
<IfModule mod_rewrite.c>
RewriteEngine on
RewriteRule .* - [env=HTTP_AUTHORIZATION:%{HTTP:Authorization}]
RewriteRule ^/owncloud/\.well-known/host-meta /owncloud/public.php?service=host-meta [QSA,L]
RewriteRule ^/owncloud/\.well-known/host-meta\.json /owncloud/public.php?service=host-meta-json [QSA,L]
RewriteRule ^/owncloud/\.well-known/carddav /owncloud/remote.php/carddav/ [R]
RewriteRule ^/owncloud/\.well-known/caldav /owncloud/remote.php/caldav/ [R]
RewriteRule ^/owncloud/apps/calendar/caldav\.php /owncloud/remote.php/caldav/ [QSA,L]
RewriteRule ^/owncloud/apps/contacts/carddav\.php /owncloud/remote.php/carddav/ [QSA,L]
RewriteRule ^/owncloud/remote/(.*) /owncloud/remote.php [QSA,L]
<IfModule mod_mime.c>
AddType image/svg+xml svg svgz
AddEncoding gzip svgz
<IfModule dir_module>
DirectoryIndex index.php index.html
AddDefaultCharset utf-8
Options -Indexes
<IfModule pagespeed_module>
        ModPagespeed Off
ErrorDocument 403 /owncloud/core/templates/403.php
ErrorDocument 404 /owncloud/core/templates/404.php
ErrorDocument 403 /owncloud/core/templates/403.php
ErrorDocument 404 /owncloud/core/templates/404.php
ErrorDocument 403 /owncloud/core/templates/403.php
ErrorDocument 404 /owncloud/core/templates/404.php
ErrorDocument 403 /owncloud/core/templates/403.php
ErrorDocument 404 /owncloud/core/templates/404.php
ErrorDocument 403 /owncloud/core/templates/403.php
ErrorDocument 404 /owncloud/core/templates/404.php
ErrorDocument 403 /owncloud/core/templates/403.php
ErrorDocument 404 /owncloud/core/templates/404.php

-- no debconf information

More information about the Pkg-owncloud-maintainers mailing list