Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Upgrade from 6 to 7: Failed to upgrade "files_sharing" #9921

Closed
florenthemmi opened this issue Jul 26, 2014 · 3 comments
Closed

Upgrade from 6 to 7: Failed to upgrade "files_sharing" #9921

florenthemmi opened this issue Jul 26, 2014 · 3 comments

Comments

@florenthemmi
Copy link

In my log file:

Failed to update database structure (exception 'PDOException' with message 'SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_share_external' already exists' in /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:742 Stack trace:
#0 [internal function]: PDO->query('CREATE TABLE `o...')
#1 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(742): call_user_func_array(Array, Array)
#2 /var/www/owncloud/lib/private/db/migrator.php(179): Doctrine\DBAL\Connection->query('CREATE TABLE `o...')
#3 /var/www/owncloud/lib/private/db/migrator.php(35): OC\DB\Migrator->applySchema(Object(Doctrine\DBAL\Schema\Schema))
#4 /var/www/owncloud/lib/private/db/mdb2schemamanager.php(98): OC\DB\Migrator->migrate(Object(Doctrine\DBAL\Schema\Schema))
#5 /var/www/owncloud/lib/private/db.php(320): OC\DB\MDB2SchemaManager->updateDbFromStructure('/var/www/ownclo...')
#6 /var/www/owncloud/lib/private/app.php(1172): OC_DB::updateDbFromStructure('/var/www/ownclo...')
#7 /var/www/owncloud/lib/private/app.php(980): OC_App::updateApp('files_sharing')
#8 /var/www/owncloud/lib/private/app.php(87): OC_App::checkUpgrade('files_sharing')
#9 /var/www/owncloud/lib/private/app.php(72): OC_App::loadApp('files_sharing')
#10 /var/www/owncloud/lib/private/updater.php(222): OC_App::loadApps()
#11 /var/www/owncloud/lib/private/updater.php(137): OC\Updater->doUpgrade('7.0.0.8', '6.0.4.1')
#12 /var/www/owncloud/core/ajax/update.php(35): OC\Updater->upgrade()
#13 {main} Next exception 'Doctrine\DBAL\DBALException' with message 'An exception occurred while executing 'CREATE TABLE `oc_share_external` (`id` INT AUTO_INCREMENT NOT NULL, `remote` VARCHAR(512) NOT NULL COMMENT 'Url of the remove owncloud instance', `share_token` VARCHAR(64) NOT NULL COMMENT 'Public share token', `password` VARCHAR(64) NOT NULL COMMENT 'Optional password for the public share', `name` VARCHAR(64) NOT NULL COMMENT 'Original name on the remote server', `owner` VARCHAR(64) NOT NULL COMMENT 'User that owns the public share on the remote server', `user` VARCHAR(64) NOT NULL COMMENT 'Local user which added the external share', `mountpoint` VARCHAR(4000) NOT NULL COMMENT 'Full path where the share is mounted', `mountpoint_hash` VARCHAR(32) NOT NULL COMMENT 'md5 hash of the mountpoint', INDEX sh_external_user (`user`), UNIQUE INDEX sh_external_mp (`user`, `mountpoint_hash`), PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB': SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_share_external' already exists' in /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:47 Stack trace:
#0 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(744): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'CREATE TABLE `o...')
#1 /var/www/owncloud/lib/private/db/migrator.php(179): Doctrine\DBAL\Connection->query('CREATE TABLE `o...')
#2 /var/www/owncloud/lib/private/db/migrator.php(35): OC\DB\Migrator->applySchema(Object(Doctrine\DBAL\Schema\Schema))
#3 /var/www/owncloud/lib/private/db/mdb2schemamanager.php(98): OC\DB\Migrator->migrate(Object(Doctrine\DBAL\Schema\Schema))
#4 /var/www/owncloud/lib/private/db.php(320): OC\DB\MDB2SchemaManager->updateDbFromStructure('/var/www/ownclo...')
#5 /var/www/owncloud/lib/private/app.php(1172): OC_DB::updateDbFromStructure('/var/www/ownclo...')
#6 /var/www/owncloud/lib/private/app.php(980): OC_App::updateApp('files_sharing')
#7 /var/www/owncloud/lib/private/app.php(87): OC_App::checkUpgrade('files_sharing')
#8 /var/www/owncloud/lib/private/app.php(72): OC_App::loadApp('files_sharing')
#9 /var/www/owncloud/lib/private/updater.php(222): OC_App::loadApps()
#10 /var/www/owncloud/lib/private/updater.php(137): OC\Updater->doUpgrade('7.0.0.8', '6.0.4.1')
#11 /var/www/owncloud/core/ajax/update.php(35): OC\Updater->upgrade()
#12 {main})
@ghost
Copy link

ghost commented Jul 26, 2014

Very likely a duplicate of: #9810

@jancborchardt
Copy link
Member

Closing as duplicate of #9810

@jancborchardt
Copy link
Member

Please provide any details in #9810 – thanks :)

@lock lock bot locked as resolved and limited conversation to collaborators Aug 17, 2019
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

2 participants