Upgrade Error from 8.0.2 to 8.0.3

Ask all your questions regarding OC 8.0 and 8.1 Please read the Support Forum Rules
Forum rules
The forums were migrated over to https://central.owncloud.org which is based on the forum software Discourse. The forums here is put into read-only mode starting from today.

More background information about this move and the reasoning behind it is available in this blogpost:

https://daniel.molkentin.net/2016/07/20 ... d-central/
r0b0tAnthony
Newbie
Posts: 3
Joined: Tue Mar 24, 2015 2:06 am
ownCloud version: 8.0.2
Webserver: Apache
Database: MySQL
OS: Linux

Upgrade Error from 8.0.2 to 8.0.3

Postby r0b0tAnthony » Tue May 19, 2015 7:35 pm

OS: Ubuntu 14.04
Environment:
Server: Apache
Database: MariaDB/MySQL
Client: Firefox
OC-Version: 8.0.2 to 8.0.3
PHP-Version: PHP 5.5.9-1ubuntu4.9 (cli)

Did upgrade via apt-get and then ran upgrade wizard via browser. I get this in the upgrade wizard:
An exception occurred while executing ' DELETE FROM `oc_lucene_status` WHERE `fileid` IN ( SELECT `fileid` FROM ( SELECT `fileid` FROM `oc_lucene_status` GROUP BY `fileid` HAVING count(`fileid`) > 1 ) AS `mysqlerr1093hack` )': SQLSTATE[HY000]: General error: 1665 Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.


Not sure how to fix.

Thanks,
Anthony

RealRancor
ownCloud master
Posts: 17381
Joined: Sat May 26, 2012 3:00 pm
ownCloud version: 9.0.2
Webserver: nginx
Database: MySQL
OS: Linux
PHP version: 7.0.x

Re: Upgrade Error from 8.0.2 to 8.0.3

Postby RealRancor » Tue May 19, 2015 7:40 pm

Hi,

see the documentation available here how to fix this:

https://doc.owncloud.org/server/8.0/adm ... leshooting

or the thread here:

viewtopic.php?f=31&t=26310

Seems the devs are coming up with a other possible workaround in OC 8.0.4 according to:

https://github.com/owncloud/core/issues/16008
*gone*


  • Similar Topics
    Replies
    Views
    Last post

Return to “ownCloud Server 8.0 and 8.1”

Who is online

Users browsing this forum: No registered users and 5 guests