problem after owncloud-files update 9.1.6 > 10.0.3 / db upgrade error

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

problem after owncloud-files update 9.1.6 > 10.0.3 / db upgrade error

Fabian A. Santiago
hello,

using:

centos 7.4.1708
mariadb 10.2.8
php 7.0.23
nginx 1.13.5 w/ php-fpm, and redis, memcached, apc/apcu installed

owncloud config for ca:
'memcache.locking' => '\\OC\\Memcache\\Redis',
'memcache.local' => '\\OC\\Memcache\\APCu',


owncloud-files installed via @ce_stable yum repo.

recent update left my site hosed up. after fixing web dir permissions that had been changed by the rpm update (changed owner to 'apache'), the web interface allowed me to start the upgrade but then died / failed, with no error details.

running occ upgrade from command line produces the error:

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'ALTER TABLE oc_calendarsubscriptions CHANGE `lastmodified` lastmodified INT UNSIGNED DEFAULT NULL NOT NULL':

SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'lastmodified'
2017-09-19T18:53:13+00:00 Update failed

any ideas? Thanks.


--

Thanks,

Fabian S.

OpenPGP: 3C3FA072ACCB7AC5DB0F723455502B0EEB9070FC
_______________________________________________
User mailing list
[hidden email]
http://mailman.owncloud.org/mailman/listinfo/user
Reply | Threaded
Open this post in threaded view
|

Re: problem after owncloud-files update 9.1.6 > 10.0.3 / db upgrade error

Vincent Petry
Hello,

Seems you got unlucky. See https://github.com/owncloud/core/issues/28695

The reason for this issue is still unknown and being investigated.

Cheers,

Vincent


On 09/19/2017 09:08 PM, Fabian A. Santiago wrote:

> hello,
>
> using:
>
> centos 7.4.1708
> mariadb 10.2.8
> php 7.0.23
> nginx 1.13.5 w/ php-fpm, and redis, memcached, apc/apcu installed
>
> owncloud config for ca:
> 'memcache.locking' => '\\OC\\Memcache\\Redis',
> 'memcache.local' => '\\OC\\Memcache\\APCu',
>
>
> owncloud-files installed via @ce_stable yum repo.
>
> recent update left my site hosed up. after fixing web dir permissions that had been changed by the rpm update (changed owner to 'apache'), the web interface allowed me to start the upgrade but then died / failed, with no error details.
>
> running occ upgrade from command line produces the error:
>
> Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'ALTER TABLE oc_calendarsubscriptions CHANGE `lastmodified` lastmodified INT UNSIGNED DEFAULT NULL NOT NULL':
>
> SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'lastmodified'
> 2017-09-19T18:53:13+00:00 Update failed
>
> any ideas? Thanks.
>
>
> --
>
> Thanks,
>
> Fabian S.
>
> OpenPGP: 3C3FA072ACCB7AC5DB0F723455502B0EEB9070FC
> _______________________________________________
> User mailing list
> [hidden email]
> http://mailman.owncloud.org/mailman/listinfo/user


_______________________________________________
User mailing list
[hidden email]
http://mailman.owncloud.org/mailman/listinfo/user