can't update Or install ownCloud in version 10.0.1

[jonesmith]

Actual behaviour

Tell us what happens instead

I recently got to know owncloud, when i install   owncloud 10.0.0.  ,it is  wonderful  work.but  when  i update to owncloud 10.0.1   ,i  get  a  error   "Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'CREATE TABLE oc_account_terms (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, account_id BIGINT UNSIGNED NOT NULL, term VARCHAR(256) NOT NULL, INDEX account_id_index (account_id), INDEX term_index (term), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes"

i know  the error  code  is   ' term varchar(256)',but  i can't  update the  owncloud  code.  so  ~ 

and  then   i   reinstall  in   owncloud 10.0.1  ,it happen  again.the  same  error.

Server configuration

Operating system:
ubuntu
Web server:
apache
Database:
mysql 5.6
PHP version:
PHP Version 5.6.30-0+deb8u1

ownCloud version: (see ownCloud admin page)
10.0.1
Updated from an older ownCloud or fresh install:
install | same as update from 10.0.0

Logs

Web server error

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'CREATE TABLE oc_account_terms (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, account_id BIGINT UNSIGNED NOT NULL, term VARCHAR(256) NOT NULL, INDEX account_id_index (account_id), INDEX term_index (term), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

error log

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'CREATE TABLE oc_account_terms (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, account_id BIGINT UNSIGNED NOT NULL, term VARCHAR(256) NOT NULL, INDEX account_id_index (account_id), INDEX term_index (term), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

[PVince81]

1071 Specified key was too long; max key length is 767 bytes

@DeepDiver1975

[PVince81]

also cc @tomneedham @butonic as I remember a discussion about index size for this particular table

[tomneedham]

This is the column and related index

core/core/Migrations/Version20170516100103.php

Lines 51 to 58 in f4b1dc1

	$table->addColumn('term', Type::STRING, [
	'notnull' => true,
	'length' => 256
	]);
	$table->setPrimaryKey(['id']);
	$table->addIndex(['account_id'], 'account_id_index');
	$table->addIndex(['term'], 'term_index');

[tomneedham]

according to https://dev.mysql.com/doc/refman/5.7/en/innodb-restrictions.html we can only go up to 255 chars, and we're trying 256 😞

[jerryjharrison]

Any update on the correction to this? I am a long time Owncloud user, but this is completely blocking the upgrade path. I typically use pkg to update, so I unless someone has a manual correction, I suppose I have to wait for the next version release to migrate through pkg before upgrading?

[PVince81]

@tomneedham a quickfix in the form of manually executable SQL statements would be nice.

Basically you need to make the column "term" 255 characters instead of 256.

[tomneedham]

Applying this patch to the 10.0.1 codebase before upgrading will make the upgrade run smoothly:

--- a/core/Migrations/Version20170516100103.php
+++ b/core/Migrations/Version20170516100103.php
@@ -50,7 +50,7 @@ public function changeSchema(Schema $schema, array $options) {
 
 			$table->addColumn('term', Type::STRING, [
 				'notnull' => true,
-				'length' => 256
+				'length' => 255
 			]);
 
 			$table->setPrimaryKey(['id']);

[jerryjharrison]

Not familiar with this process. Could you provide some guidance on steps required?

…

________________________________ From: Tom Needham <notifications@github.com> Sent: Tuesday, May 30, 2017 4:16 AM To: owncloud/core Cc: Jerry Harrison; Comment Subject: Re: [owncloud/core] can't update Or install ownCloud in version 10.0.1 (#28007) Applying this patch to the 10.0.1 codebase before upgrading will make the upgrade run smoothly:

--- a/core/Migrations/Version20170516100103.php +++ b/core/Migrations/Version20170516100103.php @@ -50,7 +50,7 @@ public function changeSchema(Schema $schema, array $options) { $table->addColumn('term', Type::STRING, [ 'notnull' => true, - 'length' => 256 + 'length' => 255 ]); $table->setPrimaryKey(['id']); — You are receiving this because you commented. Reply to this email directly, view it on GitHub<#28007 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AXclsw4w_UlgGN9dtctQszkiHvDHHDPzks5r-9BWgaJpZM4NmJ9q>.