From owner-freebsd-ports@freebsd.org Tue May 30 20:37:04 2017 Return-Path: Delivered-To: freebsd-ports@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 8FDD2BEBDFF for ; Tue, 30 May 2017 20:37:04 +0000 (UTC) (envelope-from david.marec@davenulle.org) Received: from smtp.smtpout.orange.fr (smtp10.smtpout.orange.fr [80.12.242.132]) by mx1.freebsd.org (Postfix) with ESMTP id 394A978A30 for ; Tue, 30 May 2017 20:37:03 +0000 (UTC) (envelope-from david.marec@davenulle.org) Received: from [192.168.1.14] ([86.199.67.222]) by mwinf5d88 with ME id SkVQ1v00S4njora03kVRwd; Tue, 30 May 2017 22:29:25 +0200 X-ME-Helo: [192.168.1.14] X-ME-Date: Tue, 30 May 2017 22:29:25 +0200 X-ME-IP: 86.199.67.222 To: freebsd-ports@freebsd.org From: David Marec Subject: Owncloud upgrade failure Message-ID: <91931afa-9a39-d0e9-8809-8db95e61acff@davenulle.org> Date: Tue, 30 May 2017 22:29:24 +0200 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:52.0) Gecko/20100101 Thunderbird/52.1.1 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: fr-classic Content-Transfer-Encoding: 7bit X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 30 May 2017 20:37:04 -0000 Hi, After updating owncloud from the early 10.0.1 package, the upgrading process failed on the following: root:/<1>local/www/owncloud#sudo -u www php occ upgrade The process control (PCNTL) extensions are required in case you want to interrupt long running commands - see http://php.net/manual/en/book.pcntl.php ownCloud or one of the apps require upgrade - only a limited number of commands are available You may use your browser or the occ upgrade command to do the upgrade Set log level to debug Updating database schema 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 Update failed Maintenance mode is kept active Reset log level Any clue to get this working again ? -- David Marec https://lapinbilly.eu/