owncloud / announcementcenter Goto Github PK

:loudspeaker: Announcement Center for ownCloud

License: GNU Affero General Public License v3.0

JavaScript 25.32% PHP 36.06% CSS 0.28% Makefile 2.67% Starlark 35.68%

announcementcenter's Introduction

Announcement Center

An Announcement Center app for ownCloud (allows administrators to publish announcements for users)
Depends on 'notifications' backend

QA metrics on master branch:

Screenshots

Announcements front page (the "Add announcement" form is admin only)

The users are also informed by an activity in their stream (can not be disabled)

announcementcenter's People

Contributors

Stargazers

Watchers

Forkers

dotnetcomgazio lbruninx dasong janklostermann stjordanis

announcementcenter's Issues

Remove travis

Remove .travis.yml file as tests are now in drone CI

Blank page when there are no announcements

The

<div id="no-announcements">
    <p><?php p($l->t('No announcements posted')); ?></p>
</div>

got dropped when moving to loading via ajax.

Anouncement notification-link URI invalid

The announcement centers notification-link is not complete, it should contain the absolute URL instead of just a relative path:

currently:

<a class="notification-link" href="/index.php/apps/announcementcenter/">Administrator announced “Integration Online Editing”

A valid link would be

Administrator announced “Integration Online Editing”

Ajax

.ajax()

/js/script.js

Core

.height()

/js/script.js

Data

.data()

/js/script.js

.on()

/js/script.js

.bind()

/js/script.js

Announcementcenter is listing only the last 5 announcements

Is there a adjustement to show all announcements?

Use new doctrine/dbal methods

After doctrine/dbal was updated in core owncloud/core#38647 some methods have been deprecated. The deprecation messages have been suppressed in #166 to get CI passing again.

Investigate these and adjust the code to use the appropriate new methods.

Allow comments for announcements

The WebDAV API finally supports it.

Missing option to delete announcements

Should really be possible

Calendar Integration

I think we should offer to announce dates and periods in the announcements which will show up in the users' calendar called "Announcements" ;)

Question: Show all Notifications

Question: Is there a possibility to show all recent notifcations in a user sight?
This time only last few notifications are shown, but not all recent.
I notify my users about changes, howtos etc. They cannot see that old posts anymore.

Pop-up window for new announcement

Would be nice if admin can configure and enable an pop-up window for new announcement, make sure everyone will not miss it after login. And users can click 'Acknowledge' to close this window.

This would be very helpful in many cases, e.g. term of services.

Thanks for considering !

Repository / AppStore Questions

Hi,

Why is this app not created into the "ownCloud"-organisation? I think you are one of the employees of the ownCloud Inc. so that would make sense 😄 or not?

I cant find this app in the 8.2 app-store (in my instance). Is it a bug, or has it any reason?

[For Semver] Announcement Center 1.2.1

Reason

Core switching to Semver owncloud/core#33242

QA

Create QA Milestone
Move items from development to qa
Create release branch release-1.2.1
Test: Install from the provided tarball and enable in ownCloud stable10 and check it works

Documentation

Changes in the docs needed? => none

Marketing

Ping RocketChat channel #marketing
Check/adapt info.xml stuff
Check/adapt screenshot
Blog post or other communication if applicable

Build & Marketplace release

All actions to be done on the release branch from here:

Set permissions to non-admin users to make announcements

Hi!

I would like to suggest the feature to set the permissions to allow non-admin users to send announcements.

This with the ability to choose groups to send announcements would be awesome.

Thanks for your attention.

php-cs-fixer

@DeepDiver1975
Any plans to implement php-cs-fixer as we have in core ?

Announcement noticication is not rendered when message is not supplied

Steps to reproduce

Create announcement with only a title
Login to user with notificaitons app enabled
Notification is not displayed because INotification->setMessage is called with an empty string which throws an exception which causes the notification to not be prepared by the notifier

Expected behaviour

Should show just with no message

Actual behaviour

No notification is shown at all

Server configuration

Operating system:

Web server:

Database:

PHP version:

ownCloud version: (see ownCloud admin page)

Where did you install ownCloud from:

Signing status (ownCloud 9.0 and above):

Login as admin user into your ownCloud and access 
http://example.com/index.php/settings/integrity/failed 
paste the results here.

List of activated apps:

If you have access to your command line run e.g.:
sudo -u www-data php occ app:list
from within your ownCloud installation folder

The content of config/config.php:

If you have access to your command line run e.g.:
sudo -u www-data php occ config:list system
from within your ownCloud installation folder

or 

Insert your config.php content here
(Without the database password, passwordsalt and secret)

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...

Client configuration

Browser:

Operating system:

Logs

ownCloud log (data/owncloud.log)

Insert your ownCloud log here

Browser log

Insert your browser log here, this could for example include:

a) The javascript console log
b) The network log 
c) ...

Add notification support

Allow admins to request confirmation of announcements by users

Announcement Center is marked as "Experimental"

Happens since ownCloud 9.0.0 😒

Pop-Up Announcements

Hi there,

I think we should integrate "Pop-Up" Announcements styled like the "Welcome-Center" ;)
This should be optional but could be an good option to show users important notes!

Show Announcements if ownCloud Instance is in Maintenance

Announcement Center Icon is not shown using Mozilla Firefox as browser

Mozilla Firefox 60.0.2 for Mac

Safari and Chrome:

[strictly 10.8.0] Announcementcenter 1.2.2

Release 1.2.2

Needed for:

Use relative URLs instead of absolute URLs in Notifications #164
Drop PHP 7.1 - #148

Product approval

Verify transifex commits are in master: If a folder https://github.com/owncloud//tree/master/l10n exists, then https://drone.owncloud.com/owncloud/ should receive nightly '[tx] updated from transifex` ...
Ping pmaier to check info.xml description and screenshot
Get approval on translations from pmaier - send the date of the last tx commit from drone to Patrick

QA

Create QA Milestone and set the description to $version
Move tickets from milestone development to qa (testplan and tickets mentioned in release ticket)
Create release branch with the format "release-$version"
Create "$version Testplan" (QA templates or Enterprise) -> Changelog tests no testplans needed
copy new/reopened issues from the previous release ticket as 'Issues to review' below.
check if Non-normal Release Process applies, and adapt this checklist.

Documentation

Changes in the docs needed? If so create issue in owncloud/docs.

Marketing

Ping @owncloud/marketing
Update https://confluence.owncloud.com/display/PROD/Upcoming+Releases
Request a screenshot if the app is new or changed fundamentally

Build

All actions to be done on the release branch from here:

Bump version in info.xml (no version suffix)
Bump version in sonar-project.properties (no version suffix)
Check php version dependency in info.xml
Check minimum ownCloud version dependency in info.xml
Change CHANGELOG.md 'Unreleased' to '$version' (today's date)

Beta/RC

Final

Check that no documentation issues are pending
Rename last RC tarball to final
Create github tag for final v${version} on release branch
Upload as Github release using changelog entries
Ping #marketing channel to coordinate publishing

Publishing

Upload tarball to marketplace (see handbook in confluence for details)
Publish tarball for customers - old 10, old 10.0 and new portal (see handbook for details)
Send mail to release-coordination with link to this ticket and to the changelog
Copy email to rocket chat #updates channel

Post-release

Add a new 'Unreleased' section in CHANGELOG.md (and also update links at the bottom!)
Create PR to merge changes back to the master branch with description "Closes #XYZ" with the release ticket number
Rename QA milestone to $version and close the milestone
Update https://confluence.owncloud.com/display/PROD/Upcoming+Releases
Ensure release template is up to date
Ensure the testplan template (community or enterprise) is up to date
Close the testplan issue

Fix unit test function name so that test runs (and fails)

Steps to reproduce

fix https://github.com/owncloud/announcementcenter/pull/20/files#diff-1879b41e5a6d3340aeaa60e56c81373fR167
public function te1stAnnouncement() => public function testAnnouncement()
make test-php-unit

Expected behaviour

Unit tests pass

Actual behaviour

make test-php-unit
composer install
Loading composer repositories with package information
Installing dependencies (including require-dev) from lock file
Nothing to install or update
Generating autoload files
php -d zend.enable_gc=0 "/home/phil/git/owncloud/core/apps-external/announcementcenter/../../lib/composer/bin/phpunit" --configuration ./phpunit.xml --testsuite unit
PHPUnit 6.5.14 by Sebastian Bergmann and contributors.

Runtime:       PHP 7.2.16-1+ubuntu18.04.1+deb.sury.org+1 with Xdebug 2.7.0
Configuration: /home/phil/git/owncloud/core/apps-external/announcementcenter/phpunit.xml

............................................................F     61 / 61 (100%)

Time: 1.61 seconds, Memory: 22.00MB

There was 1 failure:

1) OCA\AnnouncementCenter\Tests\Unit\Notification\NotifierTest::testAnnouncement
Failed asserting that null is of type "int".

/home/phil/git/owncloud/core/apps-external/announcementcenter/tests/Unit/Notification/NotifierTest.php:197

FAILURES!
Tests: 61, Assertions: 140, Failures: 1.

Generating code coverage report in Clover XML format ... done
Makefile:108: recipe for target 'test-php-unit' failed
make: *** [test-php-unit] Error 1

Note: before fixing the function name, only 60 tests are running. Test 61 has not been running.

Server configuration

git clone development environment or drone

Announcements via email

What I would really love to see is a check box under the announcement for sending an email to all users.

Short Description

I think we should replace the short description of the repository, which is currently

An announcement center for ownCloud

with:

📢 Announcement Center for ownCloud

like ownCloud Calendar, Contacts and Music already does 😉

Better Style in Notification-Center

Hi there,

I think we should:

make the title of the announcement bold
maybe show user-picture in front of "username has announced ..."
date of announcement

Error clicking link on announcement bluebell

Steps to reproduce

Install app announcementcenter 1.2.0
generate an announcement
click on announcement blueball

Expected behaviour

Tell us what should happen
Happen the redirect to https://hostname/index.php/apps/announcementcenter/
and not to https://hostnamr/owncloud/index.php/apps/announcementcenter/

Actual behaviour

Tell us what happens instead
Happen the redirect to https://hostname/index.php/apps/announcementcenter/
and not to https://hostnamr/owncloud/index.php/apps/announcementcenter/

Server configuration

Operating system:
centos 6
Web server:
Apache 2.0
Database:
Server version: 5.5.41 MySQL Community Server (GPL) by Remi

PHP version:
PHP 5.6.31 (cli)
ownCloud version: (see ownCloud admin page)
ownCloud 10.0.3 Server
Where did you install ownCloud from:

Signing status (ownCloud 9.0 and above):

If you have access to your command line run e.g.:
sudo -u www-data php occ app:list
from within your ownCloud installation folder
[root@xpr-owncloud config]# sudo -u apache php /var/www/html/owncloud/occ app:list
Enabled:

activity: 2.3.6
announcementcenter: 1.2.0
comments: 0.3.0
configreport: 0.1.1
dav: 0.3.0
external: 1.2
federatedfilesharing: 0.3.1
federation: 0.1.0
files: 1.5.1
files_clipboard: 0.6.2
files_external: 0.7.1
files_pdfviewer: 0.8.2
files_sharing: 0.10.1
files_texteditor: 2.2.1
files_trashbin: 0.9.1
files_versions: 1.3.0
files_videoplayer: 0.9.8
firstrunwizard: 1.1
gallery: 16.0.2
notifications: 0.3.1
provisioning_api: 0.5.0
systemtags: 0.3.0
templateeditor: 0.1
updatenotification: 0.2.1
user_external: 0.4
user_ldap: 0.9.1
Disabled:
encryption
files_antivirus
files_reader
imprint
libreonline
mail
market
news
oclife
ownnote
search_lucene
shorty
tasks
theme-example
treebookmarks

The content of config/config.php:

If you have access to your command line run e.g.:
sudo -u www-data php occ config:list system
from within your ownCloud installation folder
sudo -u apache php /var/www/html/owncloud/occ config:list system
{
    "system": {
        "instanceid": "oczq4bwvlfhg",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "xpr-owncloud.exprivia.it",
            "10.0.3.198",
            "92.223.151.244",
            "185.162.48.20"
        ],
        "files_external_allow_create_new_local": "true",
        "datadirectory": "\/var\/www\/html\/owncloud\/data",
        "overwrite.cli.url": "https:\/\/xpr-owncloud.exprivia.it\/owncloud",
        "dbtype": "mysql",
        "version": "10.0.3.3",
        "dbname": "xprowncloud",
        "dbhost": "localhost",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "memcache.local": "\\OC\\Memcache\\APCu",
        "installed": true,
        "mail_smtpmode": "php",
        "forcessl": true,
        "forceSSLforSubdomains": true,
        "maintenance": false,
        "theme": "",
        "ldapUserCleanupInterval": "20",
        "loglevel": 4,
        "default_language": "it",
        "defaultapp": "files",
        "knowledgebaseenabled": true,
        "enable_avatars": true,
        "allow_user_to_change_display_name": true,
        "remember_login_cookie_lifetime": 1296000,
        "session_lifetime": 86400,
        "session_keepalive": true,
        "skeletondirectory": "\/path\/to\/owncloud\/core\/skeleton",
        "updatechecker": false,
        "trashbin_retention_obligation": "auto, 15, auto",
        "mail_from_address": "ExpriviaCloud",
        "mail_domain": "exprivia.it",
        "mail_smtphost": "no-mail.exprivia.it",
        "mail_smtpport": "999",
        "mail_smtpauth": 1,
        "appstore.experimental.enabled": false,
        "htaccess.RewriteBase": "\/owncloud"
    }
}

or 

Insert your config.php content here
(Without the database password, passwordsalt and secret)
<?php
$CONFIG = array (
  'instanceid' => 'oczq4bwvlfhg',
  'trusted_domains' =>
  array (
    0 => 'xpr-owncloud.exprivia.it',
    1 => '10.0.3.198',
    2 => '92.223.151.244',
    3 => '185.162.48.20',
  ),
  'files_external_allow_create_new_local' => 'true',
  'datadirectory' => '/var/www/html/owncloud/data',
  'overwrite.cli.url' => 'https://xpr-owncloud.exprivia.it/owncloud',
  'dbtype' => 'mysql',
  'version' => '10.0.3.3',
  'dbname' => 'xprowncloud',
  'dbhost' => 'localhost',
  'dbtableprefix' => 'oc_',
  'dbuser' => 'oc_xpradmin',
  'memcache.local' => '\\OC\\Memcache\\APCu',
  'installed' => true,
  'mail_smtpmode' => 'php',
  'forcessl' => true,
  'forceSSLforSubdomains' => true,
  'maintenance' => false,
  'theme' => '',
  'ldapUserCleanupInterval' => '20',
  'loglevel' => 4,
  'default_language' => 'it',
  'defaultapp' => 'files',
  'knowledgebaseenabled' => true,
  'enable_avatars' => true,
  'allow_user_to_change_display_name' => true,
  'remember_login_cookie_lifetime' => 1296000,
  'session_lifetime' => 86400,
  'session_keepalive' => true,
  'skeletondirectory' => '/path/to/owncloud/core/skeleton',
  'updatechecker' => false,
  'trashbin_retention_obligation' => 'auto, 15, auto',
  'mail_from_address' => 'ExpriviaCloud',
  'mail_domain' => 'exprivia.it',
  'mail_smtphost' => 'no-mail.exprivia.it',
  'mail_smtpport' => '999',
  'mail_smtpauth' => 1,
  'appstore.experimental.enabled' => false,
  'htaccess.RewriteBase' => '/owncloud',
);

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...
ActiveDirectory

Client configuration

Browser:
Chrome, Internet Explorer, Microsoft Edge
Operating system:
Windows 10

Logs

ownCloud log (data/owncloud.log)

Insert your ownCloud log here
 [13/Oct/2017:14:02:28 +0200] "GET /index.php/apps/announcementcenter/ HTTP/1.1" 404 323


#### Browser log

Insert your browser log here, this could for example include:

a) The javascript console log
b) The network log
c) ...

announcement center

When I click on an announcement the link redirect to https://webname/index.php/apps/announcementcenter/ and not to https://webname/owncloud/index.php/apps/announcementcenter/

announcementcenter not working with notification dependency in OC 10.0.9

Steps to reproduce

create an annoucement via announcementcenter as an admin
log out as admin, login as user
no bell icon by the username, no announcement shown

Expected behaviour
expect to see bell icon by username once logged in

Actual behaviour
no bell icon, no announcement shown

Operating system:
CENTOS 7.5
Web server:
Apache 2.4.33
Database:
MySQL MariaDB 10.2.16
PHP version:
ea-php56
ownCloud version: (see ownCloud admin page)
community 10.0.9.5
Updated from an older ownCloud or fresh install:
updated from 10.0.8 to 10.0.9 by built-in updater, updated from 10.0.3 to 10.0.8 by built-in updater, 10.0.3 was installed by softaculous.
Where did you install ownCloud from:
originally from softaculous provided for shared hosting, installation was moved to VPS server prior to update by built-in updater.
Signing status (ownCloud 9.0 and above):
all signing checks passed.

integrity result: no errors have been found.

List of activated apps:

Enabled:
  - activity: 2.3.7
  - announcementcenter: 1.2.0
  - comments: 0.3.0
  - configreport: 0.1.1
  - dav: 0.3.2
  - federatedfilesharing: 0.3.1
  - federation: 0.1.0
  - files: 1.5.1
  - files_clipboard: 0.7.1
  - files_external: 0.7.1
  - files_pdfviewer: 0.9.0
  - files_sharing: 0.10.1
  - files_trashbin: 0.9.1
  - files_versions: 1.3.0
  - files_videoplayer: 0.9.8
  - firstrunwizard: 1.1
  - gallery: 16.1.0
  - impersonate: 0.2.0
  - market: 0.2.5
  - notifications: 0.3.4
  - provisioning_api: 0.5.0
  - systemtags: 0.3.0
  - templateeditor: 0.3.1
  - updatenotification: 0.2.1
Disabled:
  - encryption

The content of config/config.php:

{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "***REMOVED SENSITIVE VALUE***"
        ],
        "datadirectory": "\/home\/dollar31\/ownclouddata",
        "overwrite.cli.url": "https:\/\/***REMOVED SENSITIVE VALUE***",
        "htaccess.RewriteBase": "\/",
        "knowledgebaseenabled": false,
        "dbtype": "mysql",
        "version": "10.0.9.5",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "localhost",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "logtimezone": "UTC",
        "installed": true,
        "maintenance": false,
        "singleuser": false,
        "mail_smtpmode": "smtp",
        "mail_smtpsecure": "ssl",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpauthtype": "LOGIN",
        "mail_smtpauth": 1,
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "465",
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "loglevel": 4,
        "theme": "",
        "trashbin_retention_obligation": "auto, 15",
        "versions_retention_obligation": "auto, 15",
        "activity_expire_days": 183
    },
    "apps": {
        "activity": {
            "enabled": "yes",
            "installed_version": "2.3.7",
            "signed": "true",
            "types": "filesystem"
        },
        "announcementcenter": {
            "enabled": "yes",
            "installed_version": "1.2.0",
            "signed": "true",
            "types": ""
        },
        "backgroundjob": {
            "lastjob": "3"
        },
        "calendar": {
            "enabled": "no",
            "installed_version": "1.5.7",
            "signed": "true",
            "types": ""
        },
        "comments": {
            "enabled": "yes",
            "installed_version": "0.3.0",
            "types": "logging,dav"
        },
        "configreport": {
            "enabled": "yes",
            "installed_version": "0.1.1",
            "types": "filesystem"
        },
        "core": {
            "backgroundjobs_mode": "cron",
            "installedat": "1507262657.6656",
            "lastcron": "1533455103",
            "lastupdateResult": "[]",
            "lastupdatedat": "1533454665",
            "legal.imprint_url": "",
            "legal.privacy_policy_url": "***REMOVED SENSITIVE VALUE***",
            "oc.integritycheck.checker": "[]",
            "public_files": "files_sharing\/public.php",
            "public_webdav": "dav\/appinfo\/v1\/publicwebdav.php",
            "shareapi_allow_public_notification": "yes",
            "umgmt_send_email": "false",
            "umgmt_show_backend": "false",
            "umgmt_show_email": "true",
            "umgmt_show_is_enabled": "true",
            "umgmt_show_last_login": "true",
            "umgmt_show_storage_location": "false",
            "updater.secret.created": "1533181876",
            "vendor": "owncloud"
        },
        "dav": {
            "enabled": "yes",
            "installed_version": "0.3.2",
            "types": "filesystem"
        },
        "federatedfilesharing": {
            "enabled": "yes",
            "installed_version": "0.3.1",
            "types": "filesystem"
        },
        "federation": {
            "enabled": "yes",
            "installed_version": "0.1.0",
            "types": "authentication"
        },
        "files": {
            "cronjob_scan_files": "500",
            "default_quota": "57 GB",
            "enabled": "yes",
            "installed_version": "1.5.1",
            "types": "filesystem"
        },
        "files_clipboard": {
            "enabled": "yes",
            "installed_version": "0.7.1",
            "signed": "true",
            "types": ""
        },
        "files_external": {
            "enabled": "yes",
            "installed_version": "0.7.1",
            "ocsid": "166048",
            "types": "filesystem"
        },
        "files_pdfviewer": {
            "enabled": "yes",
            "installed_version": "0.9.0",
            "ocsid": "166049",
            "signed": "true",
            "types": ""
        },
        "files_sharing": {
            "enabled": "yes",
            "incoming_server2server_share_enabled": "no",
            "installed_version": "0.10.1",
            "outgoing_server2server_share_enabled": "no",
            "types": "filesystem"
        },
        "files_trashbin": {
            "enabled": "yes",
            "installed_version": "0.9.1",
            "types": "filesystem"
        },
        "files_versions": {
            "enabled": "yes",
            "installed_version": "1.3.0",
            "types": "filesystem"
        },
        "files_videoplayer": {
            "enabled": "yes",
            "installed_version": "0.9.8",
            "types": ""
        },
        "firstrunwizard": {
            "enabled": "yes",
            "installed_version": "1.1",
            "ocsid": "166055",
            "types": ""
        },
        "gallery": {
            "enabled": "yes",
            "installed_version": "16.1.0",
            "signed": "true",
            "types": ""
        },
        "impersonate": {
            "enabled": "yes",
            "impersonate_include_groups": "true",
            "impersonate_include_groups_list": "[\"team\",\"***REMOVED SENSITIVE VALUE***"]",
            "installed_version": "0.2.0",
            "signed": "true",
            "types": ""
        },
        "market": {
            "enabled": "yes",
            "installed_version": "0.2.5",
            "signed": "true",
            "types": ""
        },
        "notes": {
            "enabled": "no",
            "installed_version": "2.0.4",
            "signed": "true",
            "types": ""
        },
        "notifications": {
            "enabled": "yes",
            "installed_version": "0.3.4",
            "types": "logging"
        },
        "onlyoffice": {
            "enabled": "no",
            "installed_version": "1.3.0",
            "ocsid": "174798",
            "signed": "true",
            "skey": "***REMOVED SENSITIVE VALUE***",
            "types": "filesystem"
        },
        "provisioning_api": {
            "enabled": "yes",
            "installed_version": "0.5.0",
            "types": "prevent_group_restriction"
        },
        "systemtags": {
            "enabled": "yes",
            "installed_version": "0.3.0",
            "types": "logging"
        },
        "tasks": {
            "enabled": "no",
            "installed_version": "0.9.6",
            "signed": "true",
            "types": ""
        },
        "templateeditor": {
            "enabled": "yes",
            "installed_version": "0.3.1",
            "signed": "true",
            "types": ""
        },
        "updatenotification": {
            "enabled": "yes",
            "installed_version": "0.2.1",
            "types": ""
        }
    }
}

Are you using an external user-backend, if yes which one:
no external user backend in use.

Client configuration

Browser:
chrome 68
Operating system:
windows 7 ultimate

Logs

ownCloud log (data/owncloud.log)

{"reqId":"W2aaSkU2JV3mO@6ylKUg0gAAAAI","level":4,"time":"2018-08-05T06:33:47+00:00","remoteAddr":"***REMOVED SENSITIVE VALUE***","user":"***REMOVED SENSITIVE VALUE***","app":"webdav","method":"GET","url":"\/remote.php\/dav\/files\/***REMOVED SENSITIVE VALUE***\/***REMOVED SENSITIVE VALUE***\/ADS\/ads-wwb-ver-16\/watertown-003-1024x679.jpg?preview=1&c=0497404a1855e6b3b0c9687f90796ee4&x=150&y=150","message":"Exception: An exception occurred while executing 'INSERT INTO `oc_file_locks` (`key`,`lock`,`ttl`) SELECT ?,?,? FROM `oc_file_locks` WHERE `key` = ? HAVING COUNT(*) = 0' with params [\"files\\\/74b077547ea7f769812bdfd65624d2af\", 1, 1533454427, \"files\\\/74b077547ea7f769812bdfd65624d2af\"]:\n\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\DriverException\",\"Message\":\"An exception occurred while executing 'INSERT INTO `oc_file_locks` (`key`,`lock`,`ttl`) SELECT ?,?,? FROM `oc_file_locks` WHERE `key` = ? HAVING COUNT(*) = 0' with params [\\\"files\\\\\\\/74b077547ea7f769812bdfd65624d2af\\\", 1, 1533454427, \\\"files\\\\\\\/74b077547ea7f769812bdfd65624d2af\\\"]:\\n\\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction\",\"Code\":0,\"Trace\":\"#0 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1015): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'INSERT INTO `oc...', Array)\\n#2 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/DB\\\/Connection.php(210): Doctrine\\\\DBAL\\\\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)\\n#3 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/DB\\\/Adapter.php(116): OC\\\\DB\\\\Connection->executeUpdate('INSERT INTO `oc...', Array)\\n#4 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/DB\\\/Connection.php(248): OC\\\\DB\\\\Adapter->insertIfNotExist('*PREFIX*file_lo...', Array, Array)\\n#5 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Lock\\\/DBLockingProvider.php(118): OC\\\\DB\\\\Connection->insertIfNotExist('*PREFIX*file_lo...', Array, Array)\\n#6 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Lock\\\/DBLockingProvider.php(166): OC\\\\Lock\\\\DBLockingProvider->initLockField('files\\\/74b077547...', 1)\\n#7 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Common.php(656): OC\\\\Lock\\\\DBLockingProvider->acquireLock('files\\\/74b077547...', 1)\\n#8 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(589): OC\\\\Files\\\\Storage\\\\Common->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#9 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(589): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#10 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(589): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#11 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(589): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#12 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/View.php(1978): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#13 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/View.php(2085): OC\\\\Files\\\\View->lockPath('\\\/***REMOVED SENSITIVE VALUE***\\\/file...', 1)\\n#14 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/View.php(1172): OC\\\\Files\\\\View->lockFile('\\\/***REMOVED SENSITIVE VALUE***\\\/file...', 1)\\n#15 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/View.php(1029): OC\\\\Files\\\\View->basicOperation('fopen', '\\\/***REMOVED SENSITIVE VALUE***\\\/file...', Array, 'r')\\n#16 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Node\\\/File.php(106): OC\\\\Files\\\\View->fopen('\\\/***REMOVED SENSITIVE VALUE***\\\/file...', 'r')\\n#17 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Preview\\\/Image.php(47): OC\\\\Files\\\\Node\\\\File->fopen('r')\\n#18 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Preview.php(1123): OC\\\\Preview\\\\Image->getThumbnail(Object(OC\\\\Files\\\\Node\\\\File), 2048, 2048, false)\\n#19 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Preview.php(762): OC\\\\Preview->generatePreview()\\n#20 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Node\\\/File.php(166): OC\\\\Preview->getPreview()\\n#21 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/apps\\\/dav\\\/lib\\\/Files\\\/PreviewPlugin.php(115): OC\\\\Files\\\\Node\\\\File->getThumbnail(Array)\\n#22 [internal function]: OCA\\\\DAV\\\\Files\\\\PreviewPlugin->httpGet(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#23 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#24 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(479): Sabre\\\\Event\\\\EventEmitter->emit('method:GET', Array)\\n#25 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(254): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#26 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/apps\\\/dav\\\/lib\\\/Server.php(282): Sabre\\\\DAV\\\\Server->exec()\\n#27 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#28 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/remote.php(165): require_once('\\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/...')\\n#29 {main}\",\"File\":\"\\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":115}"}
{"reqId":"W2aaSkU2JV3mO@6ylKUg0QAAABQ","level":4,"time":"2018-08-05T06:33:47+00:00","remoteAddr":"***REMOVED SENSITIVE VALUE***","user":"***REMOVED SENSITIVE VALUE***","app":"webdav","method":"GET","url":"\/remote.php\/dav\/files\/***REMOVED SENSITIVE VALUE***\/***REMOVED SENSITIVE VALUE***\/ADS\/ads-wwb-ver-16\/serivce.jpg?preview=1&c=d274c9e5bf73391f8e846f8fbd7d94e0&x=150&y=150","message":"Exception: An exception occurred while executing 'INSERT INTO `oc_file_locks` (`key`,`lock`,`ttl`) SELECT ?,?,? FROM `oc_file_locks` WHERE `key` = ? HAVING COUNT(*) = 0' with params [\"files\\\/74b077547ea7f769812bdfd65624d2af\", 1, 1533454427, \"files\\\/74b077547ea7f769812bdfd65624d2af\"]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'files\/74b077547ea7f769812bdfd65624d2af' for key 'lock_key_index': {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\UniqueConstraintViolationException\",\"Message\":\"An exception occurred while executing 'INSERT INTO `oc_file_locks` (`key`,`lock`,`ttl`) SELECT ?,?,? FROM `oc_file_locks` WHERE `key` = ? HAVING COUNT(*) = 0' with params [\\\"files\\\\\\\/74b077547ea7f769812bdfd65624d2af\\\", 1, 1533454427, \\\"files\\\\\\\/74b077547ea7f769812bdfd65624d2af\\\"]:\\n\\nSQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'files\\\/74b077547ea7f769812bdfd65624d2af' for key 'lock_key_index'\",\"Code\":0,\"Trace\":\"#0 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1015): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'INSERT INTO `oc...', Array)\\n#2 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/DB\\\/Connection.php(210): Doctrine\\\\DBAL\\\\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)\\n#3 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/DB\\\/Adapter.php(116): OC\\\\DB\\\\Connection->executeUpdate('INSERT INTO `oc...', Array)\\n#4 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/DB\\\/Connection.php(248): OC\\\\DB\\\\Adapter->insertIfNotExist('*PREFIX*file_lo...', Array, Array)\\n#5 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Lock\\\/DBLockingProvider.php(118): OC\\\\DB\\\\Connection->insertIfNotExist('*PREFIX*file_lo...', Array, Array)\\n#6 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Lock\\\/DBLockingProvider.php(166): OC\\\\Lock\\\\DBLockingProvider->initLockField('files\\\/74b077547...', 1)\\n#7 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Common.php(656): OC\\\\Lock\\\\DBLockingProvider->acquireLock('files\\\/74b077547...', 1)\\n#8 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(589): OC\\\\Files\\\\Storage\\\\Common->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#9 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(589): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#10 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(589): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#11 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(589): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#12 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/View.php(1978): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#13 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/View.php(2085): OC\\\\Files\\\\View->lockPath('\\\/***REMOVED SENSITIVE VALUE***\\\/file...', 1)\\n#14 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/View.php(1172): OC\\\\Files\\\\View->lockFile('\\\/***REMOVED SENSITIVE VALUE***\\\/file...', 1)\\n#15 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/View.php(1029): OC\\\\Files\\\\View->basicOperation('fopen', '\\\/***REMOVED SENSITIVE VALUE***\\\/file...', Array, 'r')\\n#16 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Node\\\/File.php(106): OC\\\\Files\\\\View->fopen('\\\/***REMOVED SENSITIVE VALUE***\\\/file...', 'r')\\n#17 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Preview\\\/Image.php(47): OC\\\\Files\\\\Node\\\\File->fopen('r')\\n#18 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Preview.php(1123): OC\\\\Preview\\\\Image->getThumbnail(Object(OC\\\\Files\\\\Node\\\\File), 2048, 2048, false)\\n#19 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Preview.php(762): OC\\\\Preview->generatePreview()\\n#20 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Node\\\/File.php(166): OC\\\\Preview->getPreview()\\n#21 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/apps\\\/dav\\\/lib\\\/Files\\\/PreviewPlugin.php(115): OC\\\\Files\\\\Node\\\\File->getThumbnail(Array)\\n#22 [internal function]: OCA\\\\DAV\\\\Files\\\\PreviewPlugin->httpGet(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#23 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#24 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(479): Sabre\\\\Event\\\\EventEmitter->emit('method:GET', Array)\\n#25 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(254): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#26 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/apps\\\/dav\\\/lib\\\/Server.php(282): Sabre\\\\DAV\\\\Server->exec()\\n#27 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#28 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/remote.php(165): require_once('\\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/...')\\n#29 {main}\",\"File\":\"\\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":66}"}
{"reqId":"W2aaVEU2JV3mO@6ylKUg8gAAAAs","level":4,"time":"2018-08-05T06:33:56+00:00","remoteAddr":"***REMOVED SENSITIVE VALUE***","user":"***REMOVED SENSITIVE VALUE***","app":"webdav","method":"GET","url":"\/remote.php\/dav\/files\/***REMOVED SENSITIVE VALUE***\/***REMOVED SENSITIVE VALUE***\/Come%20Clean\/wbb\/come_clean-ver-06\/banner-rent.png?preview=1&c=aea8fa21c2f62be004b9a2a1670d5b57&x=150&y=150","message":"Exception: An exception occurred while executing 'INSERT INTO `oc_file_locks` (`key`,`lock`,`ttl`) SELECT ?,?,? FROM `oc_file_locks` WHERE `key` = ? HAVING COUNT(*) = 0' with params [\"files\\\/8d6ca25200c95fc457e61f6e31073226\", 1, 1533454436, \"files\\\/8d6ca25200c95fc457e61f6e31073226\"]:\n\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\DriverException\",\"Message\":\"An exception occurred while executing 'INSERT INTO `oc_file_locks` (`key`,`lock`,`ttl`) SELECT ?,?,? FROM `oc_file_locks` WHERE `key` = ? HAVING COUNT(*) = 0' with params [\\\"files\\\\\\\/8d6ca25200c95fc457e61f6e31073226\\\", 1, 1533454436, \\\"files\\\\\\\/8d6ca25200c95fc457e61f6e31073226\\\"]:\\n\\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction\",\"Code\":0,\"Trace\":\"#0 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1015): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'INSERT INTO `oc...', Array)\\n#2 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/DB\\\/Connection.php(210): Doctrine\\\\DBAL\\\\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)\\n#3 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/DB\\\/Adapter.php(116): OC\\\\DB\\\\Connection->executeUpdate('INSERT INTO `oc...', Array)\\n#4 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/DB\\\/Connection.php(248): OC\\\\DB\\\\Adapter->insertIfNotExist('*PREFIX*file_lo...', Array, Array)\\n#5 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Lock\\\/DBLockingProvider.php(118): OC\\\\DB\\\\Connection->insertIfNotExist('*PREFIX*file_lo...', Array, Array)\\n#6 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Lock\\\/DBLockingProvider.php(166): OC\\\\Lock\\\\DBLockingProvider->initLockField('files\\\/8d6ca2520...', 1)\\n#7 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Common.php(656): OC\\\\Lock\\\\DBLockingProvider->acquireLock('files\\\/8d6ca2520...', 1)\\n#8 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(589): OC\\\\Files\\\\Storage\\\\Common->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#9 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(589): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#10 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(589): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#11 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(589): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#12 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/View.php(1978): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#13 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/View.php(2081): OC\\\\Files\\\\View->lockPath('\\\/***REMOVED SENSITIVE VALUE***\\\/file...', 1, false)\\n#14 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/View.php(1172): OC\\\\Files\\\\View->lockFile('\\\/***REMOVED SENSITIVE VALUE***\\\/file...', 1)\\n#15 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/View.php(1029): OC\\\\Files\\\\View->basicOperation('fopen', '\\\/***REMOVED SENSITIVE VALUE***\\\/file...', Array, 'r')\\n#16 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Node\\\/File.php(106): OC\\\\Files\\\\View->fopen('\\\/***REMOVED SENSITIVE VALUE***\\\/file...', 'r')\\n#17 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Preview\\\/Image.php(47): OC\\\\Files\\\\Node\\\\File->fopen('r')\\n#18 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Preview.php(1123): OC\\\\Preview\\\\Image->getThumbnail(Object(OC\\\\Files\\\\Node\\\\File), 2048, 2048, false)\\n#19 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Preview.php(762): OC\\\\Preview->generatePreview()\\n#20 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Node\\\/File.php(166): OC\\\\Preview->getPreview()\\n#21 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/apps\\\/dav\\\/lib\\\/Files\\\/PreviewPlugin.php(115): OC\\\\Files\\\\Node\\\\File->getThumbnail(Array)\\n#22 [internal function]: OCA\\\\DAV\\\\Files\\\\PreviewPlugin->httpGet(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#23 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#24 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(479): Sabre\\\\Event\\\\EventEmitter->emit('method:GET', Array)\\n#25 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(254): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#26 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/apps\\\/dav\\\/lib\\\/Server.php(282): Sabre\\\\DAV\\\\Server->exec()\\n#27 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#28 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/remote.php(165): require_once('\\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/...')\\n#29 {main}\",\"File\":\"\\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":115}"}
{"reqId":"W2aaVEU2JV3mO@6ylKUg8wAAABE","level":4,"time":"2018-08-05T06:33:56+00:00","remoteAddr":"***REMOVED SENSITIVE VALUE***","user":"***REMOVED SENSITIVE VALUE***","app":"webdav","method":"GET","url":"\/remote.php\/dav\/files\/***REMOVED SENSITIVE VALUE***\/***REMOVED SENSITIVE VALUE***\/Come%20Clean\/wbb\/come_clean-ver-06\/banner-rent-smaller.png?preview=1&c=eed106735fd925cde0f574a035f5cecf&x=150&y=150","message":"Exception: An exception occurred while executing 'INSERT INTO `oc_file_locks` (`key`,`lock`,`ttl`) SELECT ?,?,? FROM `oc_file_locks` WHERE `key` = ? HAVING COUNT(*) = 0' with params [\"files\\\/f366cbd1659516a6e0c073fd9a362ea6\", 1, 1533454436, \"files\\\/f366cbd1659516a6e0c073fd9a362ea6\"]:\n\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\DriverException\",\"Message\":\"An exception occurred while executing 'INSERT INTO `oc_file_locks` (`key`,`lock`,`ttl`) SELECT ?,?,? FROM `oc_file_locks` WHERE `key` = ? HAVING COUNT(*) = 0' with params [\\\"files\\\\\\\/f366cbd1659516a6e0c073fd9a362ea6\\\", 1, 1533454436, \\\"files\\\\\\\/f366cbd1659516a6e0c073fd9a362ea6\\\"]:\\n\\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction\",\"Code\":0,\"Trace\":\"#0 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1015): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'INSERT INTO `oc...', Array)\\n#2 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/DB\\\/Connection.php(210): Doctrine\\\\DBAL\\\\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)\\n#3 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/DB\\\/Adapter.php(116): OC\\\\DB\\\\Connection->executeUpdate('INSERT INTO `oc...', Array)\\n#4 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/DB\\\/Connection.php(248): OC\\\\DB\\\\Adapter->insertIfNotExist('*PREFIX*file_lo...', Array, Array)\\n#5 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Lock\\\/DBLockingProvider.php(118): OC\\\\DB\\\\Connection->insertIfNotExist('*PREFIX*file_lo...', Array, Array)\\n#6 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Lock\\\/DBLockingProvider.php(166): OC\\\\Lock\\\\DBLockingProvider->initLockField('files\\\/f366cbd16...', 1)\\n#7 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Common.php(656): OC\\\\Lock\\\\DBLockingProvider->acquireLock('files\\\/f366cbd16...', 1)\\n#8 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(589): OC\\\\Files\\\\Storage\\\\Common->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#9 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(589): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#10 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(589): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#11 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(589): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#12 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/View.php(1978): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#13 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/View.php(2081): OC\\\\Files\\\\View->lockPath('\\\/***REMOVED SENSITIVE VALUE***\\\/file...', 1, false)\\n#14 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/View.php(1172): OC\\\\Files\\\\View->lockFile('\\\/***REMOVED SENSITIVE VALUE***\\\/file...', 1)\\n#15 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/View.php(1029): OC\\\\Files\\\\View->basicOperation('fopen', '\\\/***REMOVED SENSITIVE VALUE***\\\/file...', Array, 'r')\\n#16 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Node\\\/File.php(106): OC\\\\Files\\\\View->fopen('\\\/***REMOVED SENSITIVE VALUE***\\\/file...', 'r')\\n#17 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Preview\\\/Image.php(47): OC\\\\Files\\\\Node\\\\File->fopen('r')\\n#18 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Preview.php(1123): OC\\\\Preview\\\\Image->getThumbnail(Object(OC\\\\Files\\\\Node\\\\File), 2048, 2048, false)\\n#19 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Preview.php(762): OC\\\\Preview->generatePreview()\\n#20 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Node\\\/File.php(166): OC\\\\Preview->getPreview()\\n#21 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/apps\\\/dav\\\/lib\\\/Files\\\/PreviewPlugin.php(115): OC\\\\Files\\\\Node\\\\File->getThumbnail(Array)\\n#22 [internal function]: OCA\\\\DAV\\\\Files\\\\PreviewPlugin->httpGet(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#23 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#24 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(479): Sabre\\\\Event\\\\EventEmitter->emit('method:GET', Array)\\n#25 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(254): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#26 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/apps\\\/dav\\\/lib\\\/Server.php(282): Sabre\\\\DAV\\\\Server->exec()\\n#27 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#28 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/remote.php(165): require_once('\\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/...')\\n#29 {main}\",\"File\":\"\\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":115}"}
{"reqId":"W2aaYM-8lgMRDbNaaIXmOAAAANA","level":4,"time":"2018-08-05T06:34:08+00:00","remoteAddr":"***REMOVED SENSITIVE VALUE***","user":"***REMOVED SENSITIVE VALUE***","app":"webdav","method":"GET","url":"\/remote.php\/dav\/files\/***REMOVED SENSITIVE VALUE***\/***REMOVED SENSITIVE VALUE***\/Come%20Clean\/wbb\/come_clean-ver-03\/cir-app.png?preview=1&c=6d45d66647cf7aa220c9c7218ae84422&x=150&y=150","message":"Exception: An exception occurred while executing 'INSERT INTO `oc_file_locks` (`key`,`lock`,`ttl`) SELECT ?,?,? FROM `oc_file_locks` WHERE `key` = ? HAVING COUNT(*) = 0' with params [\"files\\\/f45ff0bd3e9faed65f822e62c48c578c\", 1, 1533454448, \"files\\\/f45ff0bd3e9faed65f822e62c48c578c\"]:\n\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\DriverException\",\"Message\":\"An exception occurred while executing 'INSERT INTO `oc_file_locks` (`key`,`lock`,`ttl`) SELECT ?,?,? FROM `oc_file_locks` WHERE `key` = ? HAVING COUNT(*) = 0' with params [\\\"files\\\\\\\/f45ff0bd3e9faed65f822e62c48c578c\\\", 1, 1533454448, \\\"files\\\\\\\/f45ff0bd3e9faed65f822e62c48c578c\\\"]:\\n\\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction\",\"Code\":0,\"Trace\":\"#0 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1015): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'INSERT INTO `oc...', Array)\\n#2 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/DB\\\/Connection.php(210): Doctrine\\\\DBAL\\\\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)\\n#3 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/DB\\\/Adapter.php(116): OC\\\\DB\\\\Connection->executeUpdate('INSERT INTO `oc...', Array)\\n#4 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/DB\\\/Connection.php(248): OC\\\\DB\\\\Adapter->insertIfNotExist('*PREFIX*file_lo...', Array, Array)\\n#5 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Lock\\\/DBLockingProvider.php(118): OC\\\\DB\\\\Connection->insertIfNotExist('*PREFIX*file_lo...', Array, Array)\\n#6 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Lock\\\/DBLockingProvider.php(166): OC\\\\Lock\\\\DBLockingProvider->initLockField('files\\\/f45ff0bd3...', 1)\\n#7 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Common.php(656): OC\\\\Lock\\\\DBLockingProvider->acquireLock('files\\\/f45ff0bd3...', 1)\\n#8 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(589): OC\\\\Files\\\\Storage\\\\Common->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#9 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(589): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#10 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(589): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#11 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(589): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#12 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/View.php(1978): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#13 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/View.php(2081): OC\\\\Files\\\\View->lockPath('\\\/***REMOVED SENSITIVE VALUE***\\\/file...', 1, false)\\n#14 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/View.php(1172): OC\\\\Files\\\\View->lockFile('\\\/***REMOVED SENSITIVE VALUE***\\\/file...', 1)\\n#15 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/View.php(1029): OC\\\\Files\\\\View->basicOperation('fopen', '\\\/***REMOVED SENSITIVE VALUE***\\\/file...', Array, 'r')\\n#16 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Node\\\/File.php(106): OC\\\\Files\\\\View->fopen('\\\/***REMOVED SENSITIVE VALUE***\\\/file...', 'r')\\n#17 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Preview\\\/Image.php(47): OC\\\\Files\\\\Node\\\\File->fopen('r')\\n#18 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Preview.php(1123): OC\\\\Preview\\\\Image->getThumbnail(Object(OC\\\\Files\\\\Node\\\\File), 2048, 2048, false)\\n#19 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Preview.php(762): OC\\\\Preview->generatePreview()\\n#20 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Node\\\/File.php(166): OC\\\\Preview->getPreview()\\n#21 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/apps\\\/dav\\\/lib\\\/Files\\\/PreviewPlugin.php(115): OC\\\\Files\\\\Node\\\\File->getThumbnail(Array)\\n#22 [internal function]: OCA\\\\DAV\\\\Files\\\\PreviewPlugin->httpGet(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#23 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#24 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(479): Sabre\\\\Event\\\\EventEmitter->emit('method:GET', Array)\\n#25 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(254): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#26 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/apps\\\/dav\\\/lib\\\/Server.php(282): Sabre\\\\DAV\\\\Server->exec()\\n#27 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#28 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/remote.php(165): require_once('\\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/...')\\n#29 {main}\",\"File\":\"\\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":115}"}
{"reqId":"W2aaYLBRR9AJIIG6oPfyogAAAI8","level":4,"time":"2018-08-05T06:34:08+00:00","remoteAddr":"***REMOVED SENSITIVE VALUE***","user":"***REMOVED SENSITIVE VALUE***","app":"webdav","method":"GET","url":"\/remote.php\/dav\/files\/***REMOVED SENSITIVE VALUE***\/***REMOVED SENSITIVE VALUE***\/Come%20Clean\/wbb\/come_clean-ver-03\/banner-rent.png?preview=1&c=c510bfc1aec70daa1790de2a66d0db0f&x=150&y=150","message":"Exception: An exception occurred while executing 'INSERT INTO `oc_file_locks` (`key`,`lock`,`ttl`) SELECT ?,?,? FROM `oc_file_locks` WHERE `key` = ? HAVING COUNT(*) = 0' with params [\"files\\\/4d4852d8607d56b54959024b7a90eebb\", 1, 1533454448, \"files\\\/4d4852d8607d56b54959024b7a90eebb\"]:\n\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\DriverException\",\"Message\":\"An exception occurred while executing 'INSERT INTO `oc_file_locks` (`key`,`lock`,`ttl`) SELECT ?,?,? FROM `oc_file_locks` WHERE `key` = ? HAVING COUNT(*) = 0' with params [\\\"files\\\\\\\/4d4852d8607d56b54959024b7a90eebb\\\", 1, 1533454448, \\\"files\\\\\\\/4d4852d8607d56b54959024b7a90eebb\\\"]:\\n\\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction\",\"Code\":0,\"Trace\":\"#0 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1015): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'INSERT INTO `oc...', Array)\\n#2 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/DB\\\/Connection.php(210): Doctrine\\\\DBAL\\\\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)\\n#3 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/DB\\\/Adapter.php(116): OC\\\\DB\\\\Connection->executeUpdate('INSERT INTO `oc...', Array)\\n#4 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/DB\\\/Connection.php(248): OC\\\\DB\\\\Adapter->insertIfNotExist('*PREFIX*file_lo...', Array, Array)\\n#5 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Lock\\\/DBLockingProvider.php(118): OC\\\\DB\\\\Connection->insertIfNotExist('*PREFIX*file_lo...', Array, Array)\\n#6 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Lock\\\/DBLockingProvider.php(166): OC\\\\Lock\\\\DBLockingProvider->initLockField('files\\\/4d4852d86...', 1)\\n#7 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Common.php(656): OC\\\\Lock\\\\DBLockingProvider->acquireLock('files\\\/4d4852d86...', 1)\\n#8 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(589): OC\\\\Files\\\\Storage\\\\Common->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#9 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(589): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#10 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(589): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#11 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(589): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#12 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/View.php(1978): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/Dollar A ...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#13 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/View.php(2081): OC\\\\Files\\\\View->lockPath('\\\/***REMOVED SENSITIVE VALUE***\\\/file...', 1, false)\\n#14 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/View.php(1172): OC\\\\Files\\\\View->lockFile('\\\/***REMOVED SENSITIVE VALUE***\\\/file...', 1)\\n#15 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/View.php(1029): OC\\\\Files\\\\View->basicOperation('fopen', '\\\/***REMOVED SENSITIVE VALUE***\\\/file...', Array, 'r')\\n#16 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Node\\\/File.php(106): OC\\\\Files\\\\View->fopen('\\\/***REMOVED SENSITIVE VALUE***\\\/file...', 'r')\\n#17 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Preview\\\/Image.php(47): OC\\\\Files\\\\Node\\\\File->fopen('r')\\n#18 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Preview.php(1123): OC\\\\Preview\\\\Image->getThumbnail(Object(OC\\\\Files\\\\Node\\\\File), 2048, 2048, false)\\n#19 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Preview.php(762): OC\\\\Preview->generatePreview()\\n#20 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/private\\\/Files\\\/Node\\\/File.php(166): OC\\\\Preview->getPreview()\\n#21 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/apps\\\/dav\\\/lib\\\/Files\\\/PreviewPlugin.php(115): OC\\\\Files\\\\Node\\\\File->getThumbnail(Array)\\n#22 [internal function]: OCA\\\\DAV\\\\Files\\\\PreviewPlugin->httpGet(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#23 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#24 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(479): Sabre\\\\Event\\\\EventEmitter->emit('method:GET', Array)\\n#25 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(254): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#26 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/apps\\\/dav\\\/lib\\\/Server.php(282): Sabre\\\\DAV\\\\Server->exec()\\n#27 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#28 \\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/remote.php(165): require_once('\\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/...')\\n#29 {main}\",\"File\":\"\\\/home\\\/***REMOVED SENSITIVE VALUE***\\\/***REMOVED SENSITIVE VALUE***\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":115}"}

Browser log

The SSL certificate used to load resources from https://***REMOVED SENSITIVE VALUE*** will be distrusted in M70. Once distrusted, users will be prevented from loading these resources. See https://g.co/chrome/symantecpkicerts for more information.
VM6825 jquery-migrate.min.js:2 JQMIGRATE: Migrate is installed, version 1.4.0
DevTools failed to parse SourceMap: https://***REMOVED SENSITIVE VALUE***/core/vendor/jquery/dist/jquery.min.map
/apps/files/?dir=/:1 The SSL certificate used to load resources from https://***REMOVED SENSITIVE VALUE*** will be distrusted in M70. Once distrusted, users will be prevented from loading these resources. See https://g.co/chrome/symantecpkicerts for more information.
Navigated to https://***REMOVED SENSITIVE VALUE***/apps/files/?dir=/
jquery-migrate.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2 JQMIGRATE: Migrate is installed, version 1.4.0
jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3 [Violation] Added non-passive event listener to a scroll-blocking 'touchstart' event. Consider marking event handler as 'passive' to make the page more responsive. See https://www.chromestatus.com/feature/5745543795965952
add @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
a.event.add @ jquery-migrate.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
(anonymous) @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
each @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
each @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
on @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
initialize @ files.js?v=2600fe94ce1aa283ecacb606b5e5ded9:284
initialize @ app.js?v=2600fe94ce1aa283ecacb606b5e5ded9:100
(anonymous) @ app.js?v=2600fe94ce1aa283ecacb606b5e5ded9:317
(anonymous) @ underscore.js?v=2600fe94ce1aa283ecacb606b5e5ded9:768
jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3 [Violation] Added non-passive event listener to a scroll-blocking 'touchmove' event. Consider marking event handler as 'passive' to make the page more responsive. See https://www.chromestatus.com/feature/5745543795965952
add @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
a.event.add @ jquery-migrate.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
(anonymous) @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
each @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
each @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
on @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
init @ select2.js?v=2600fe94ce1aa283ecacb606b5e5ded9:762
(anonymous) @ select2.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3578
each @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
each @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
$.fn.select2 @ select2.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3565
render @ systemtagsinputfield.js?v=2600fe94ce1aa283ecacb606b5e5ded9:381
render @ systemtagsinfoview.js?v=2600fe94ce1aa283ecacb606b5e5ded9:134
setFileInfo @ systemtagsinfoview.js?v=2600fe94ce1aa283ecacb606b5e5ded9:113
(anonymous) @ detailsview.js?v=2600fe94ce1aa283ecacb606b5e5ded9:241
_.each._.forEach @ underscore.js?v=2600fe94ce1aa283ecacb606b5e5ded9:153
setFileInfo @ detailsview.js?v=2600fe94ce1aa283ecacb606b5e5ded9:240
_updateDetailsView @ filelist.js?v=2600fe94ce1aa283ecacb606b5e5ded9:513
reload @ filelist.js?v=2600fe94ce1aa283ecacb606b5e5ded9:1611
changeDirectory @ filelist.js?v=2600fe94ce1aa283ecacb606b5e5ded9:1453
_onUrlChanged @ filelist.js?v=2600fe94ce1aa283ecacb606b5e5ded9:573
dispatch @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
r.handle @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
trigger @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
a.event.trigger @ jquery-migrate.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
(anonymous) @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
each @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
each @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
trigger @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
_onPopState @ app.js?v=2600fe94ce1aa283ecacb606b5e5ded9:276
initialize @ app.js?v=2600fe94ce1aa283ecacb606b5e5ded9:110
(anonymous) @ app.js?v=2600fe94ce1aa283ecacb606b5e5ded9:317
(anonymous) @ underscore.js?v=2600fe94ce1aa283ecacb606b5e5ded9:768
jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3 [Violation] Added non-passive event listener to a scroll-blocking 'touchstart' event. Consider marking event handler as 'passive' to make the page more responsive. See https://www.chromestatus.com/feature/5745543795965952
add @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
a.event.add @ jquery-migrate.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
(anonymous) @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
each @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
each @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
on @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
init @ select2.js?v=2600fe94ce1aa283ecacb606b5e5ded9:762
(anonymous) @ select2.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3578
each @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
each @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
$.fn.select2 @ select2.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3565
render @ systemtagsinputfield.js?v=2600fe94ce1aa283ecacb606b5e5ded9:381
render @ systemtagsinfoview.js?v=2600fe94ce1aa283ecacb606b5e5ded9:134
setFileInfo @ systemtagsinfoview.js?v=2600fe94ce1aa283ecacb606b5e5ded9:113
(anonymous) @ detailsview.js?v=2600fe94ce1aa283ecacb606b5e5ded9:241
_.each._.forEach @ underscore.js?v=2600fe94ce1aa283ecacb606b5e5ded9:153
setFileInfo @ detailsview.js?v=2600fe94ce1aa283ecacb606b5e5ded9:240
_updateDetailsView @ filelist.js?v=2600fe94ce1aa283ecacb606b5e5ded9:513
reload @ filelist.js?v=2600fe94ce1aa283ecacb606b5e5ded9:1611
changeDirectory @ filelist.js?v=2600fe94ce1aa283ecacb606b5e5ded9:1453
_onUrlChanged @ filelist.js?v=2600fe94ce1aa283ecacb606b5e5ded9:573
dispatch @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
r.handle @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
trigger @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
a.event.trigger @ jquery-migrate.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
(anonymous) @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
each @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
each @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
trigger @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
_onPopState @ app.js?v=2600fe94ce1aa283ecacb606b5e5ded9:276
initialize @ app.js?v=2600fe94ce1aa283ecacb606b5e5ded9:110
(anonymous) @ app.js?v=2600fe94ce1aa283ecacb606b5e5ded9:317
(anonymous) @ underscore.js?v=2600fe94ce1aa283ecacb606b5e5ded9:768
underscore.js?v=2600fe94ce1aa283ecacb606b5e5ded9:767 [Violation] 'setTimeout' handler took 136ms
jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3 [Violation] Added synchronous DOM mutation listener to a 'DOMNodeRemoved' event. Consider using MutationObserver to make the page more responsive.
add @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
a.event.add @ jquery-migrate.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
(anonymous) @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
each @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
each @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
on @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
(anonymous) @ clipboard.js?v=2600fe94ce1aa283ecacb606b5e5ded9:39
dispatch @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
r.handle @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
trigger @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
a.event.trigger @ jquery-migrate.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
(anonymous) @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
each @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
each @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
trigger @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:3
_nextPage @ filelist.js?v=2600fe94ce1aa283ecacb606b5e5ded9:986
setFiles @ filelist.js?v=2600fe94ce1aa283ecacb606b5e5ded9:1038
reloadCallback @ filelist.js?v=2600fe94ce1aa283ecacb606b5e5ded9:1675
(anonymous) @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
j @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
fireWith @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
e.(anonymous function) @ jquery.min.js?v=2600fe94ce1aa283ecacb606b5e5ded9:2
(anonymous) @ client.js?v=2600fe94ce1aa283ecacb606b5e5ded9:479
DevTools failed to parse SourceMap: https://***REMOVED SENSITIVE VALUE***/core/vendor/jquery/dist/jquery.min.map

Investigate phan error report

After PR #112 implements phan it is reporting:

make test-php-phan
php -d zend.enable_gc=0 vendor-bin/phan/vendor/bin/phan --config-file .phan/config.php --require-config-exists
[info] Disabling xdebug: Phan is around five times as slow when xdebug is enabled (xdebug only makes sense when debugging Phan itself)
[info] To run Phan with xdebug, set the environment variable PHAN_ALLOW_XDEBUG to 1.
[info] To disable this warning, set the environment variable PHAN_DISABLE_XDEBUG_WARN to 1.
[info] To include function signatures of xdebug, see .phan/internal_stubs/xdebug.phan_php
[debug] Checking PHAN_ALLOW_XDEBUG
[debug] The xdebug extension is loaded (2.6.1)
[debug] Process restarting (PHAN_ALLOW_XDEBUG=internal|2.6.1|1|*|*)
[debug] Running '/usr/bin/php7.1' '-n' '-c' '/tmp/VH72lx' 'vendor-bin/phan/vendor/bin/phan' '--config-file' '.phan/config.php' '--require-config-exists'
lib/Activity/Extension.php:100 PhanTypeMismatchArgument Argument 1 (id) is string but \OCA\AnnouncementCenter\Manager::getAnnouncement() takes int defined at lib/Manager.php:110
lib/Notification/Notifier.php:77 PhanTypeMismatchArgument Argument 1 (id) is string but \OCA\AnnouncementCenter\Manager::getAnnouncement() takes int defined at lib/Manager.php:110
[debug] Restarted process exited 1
Makefile:133: recipe for target 'test-php-phan' failed
make: *** [test-php-phan] Error 1

announcementcenter seems to be expecting the "announcement id" to always be int. But notifications classes/methods allow string.

Investigate and sort out.

jQuery 2 Migration

jQuery Core 1.9 Upgrade Guide

Changes of Note in jQuery 1.9
See the full upgrade guide at jquery.com

Minor

.ajax()

js/script.js

.data()

js/script.js

.parents()

js/script.js

.after()

js/script.js

Translation

A zip to put on the root

En and Fr

http://s000.tinyupload.com/index.php?file_id=59268875601235089015

Non-admin users shouldn't be see the announcement field

Tried to press the Announce button as a normal user and got:

Also, i don't like the heading styling for the announcements texts. It's should somehow be more clear. Or do you just have to follow the oC styling guide?
What do you think @nickvergessen

Standardize CI

Part of issue owncloud/QA#582

Announcements for certain people/groups

Is there a way to set the configuration up so that only certain groups or people see the announcements? I use this for both personal and school related and would only like announcements to be seem by my peers.

Thanks.

Make announcement center an official app

During a upgrade just now I got "Disabled apps: announcement center (3rd party app)".

is this correct? @karlitschek @nickvergessen

Error when app enabled for admins only.

Steps to reproduce

Enable app for admins only
Create announcement

Expected behaviour

Should work fine

Actual behaviour

See this in the log:
{"reqId":"VsPMO6eR4vKeMTZKKvwz","level":3,"time":"2017-06-20T10:13:06+00:00","remoteAddr":"","user":"--","app":"PHP","method":"--","url":"--","message":"Undefined index: announcementcenter at \/Users\/tomneedham\/Projects\/www\/cloud\/apps\/activity\/lib\/Consumer.php#69"}

OC 10.0.3 pre-alpha with announcementcentre enabled for admins only

Impact on mail notifications

Hello,
Currently running OC 8.2.2 and Annoucements 1.0.1
I noticed that publishing a new announcement puts entries in oc_activity_mq... and prevent any further mail notification to happen.

Diag: the EMail notification job disappears

Temp solution: purge the table from all announcement entries, re-create the cron job

Log: All I found in the log was:
{"reqId":"3jE/yF5UrDkt1B1SfJtf","remoteAddr":"","app":"no app in context","message":"Error while running background job: The token is invalid","level":3,"time":"2016-03-06T13:39:03+00:00"}

Queue:
I checked the oc_activity_mq

amq_appid was announcement
amq_subject was announcement

Quick thought (not sure of course): it seems OC looked for a template and/or application to generate the related mails but did not find anything and splashed

Get in touch if you need more information, and thank you for the job already done.

Basic Text Formatting

Would be nice to have some sort of basic text styling features like:

Bold,
Underline,
Text indent
Links (like href in html)

Or simply allow html tags or Markdown in the text field.

Label doesn't shown up on new announcements!!!

The label doesn't appear any more when I post a new announcement in the announcementcenter!!!

Server configuration

Operating system: Ubuntu 16.04

Web server: Apache2

Database: MySQL

PHP version: PHP Version 7.0.22-0ubuntu0.16.04.1

ownCloud version: 10.0.3.3

Updated from an older ownCloud or fresh install: fresh

Where did you install ownCloud from: owncloud

Signing status (ownCloud 9.0 and above): No errors have been found.

Translate the App

Maybe we could integrate it into Transifex ;)

Multiline message in notifications

The message should be trimmed and not contain <br />

Fix the notification issue when the author's displayname needs to be subject parameter

Announcement center 1.0.2 for 8.2 puts the uid of the author of the announcement in the notification. So end users see this uid instead of the author's name when they click their little bell icon. Within the announcement center app itself the display name is used except immediately after an announcement is written. When the announcement is saved and appears in the list at the bottom of the form it shows the author's uid. Reload the page and display name appears. Probably an ajax issue. Admins only see it so it's not a real problem.

To fix the notification issue the author's displayname needs to be set as the subject parameter instead of the uid.

announcementcenter/controller/pagecontroller.php line 185 to 189:
$notification->setApp('announcementcenter')
->setTimestamp($timeStamp)
->setObject('announcement', $id)
->setSubject('announced', [$this->userManager->get($authorId)->getDisplayName()])
->setLink($this->urlGenerator->linkToRoute('announcementcenter.page.index'));

@MorrisJobke A friendly update thanks to @scolebrook

Error when enabling app

I get the following error when trying to enable this app:

An exception occurred while executing 'CREATE TABLE `oc_announcements` (`announcement_id` INT AUTO_INCREMENT NOT NULL, `announcement_time` INT DEFAULT 0 NOT NULL, `announcement_user` VARCHAR(64) NOT NULL, `announcement_subject` VARCHAR(512) NOT NULL, `announcement_message` VARCHAR(64000) DEFAULT NULL, PRIMARY KEY(`announcement_id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB': SQLSTATE[42000]: Syntax error or access violation: 1074 Column length too big for column 'announcement_message' (max = 21845); use BLOB or TEXT instead

I have even tried to create the database myself and it has not worked to resolve this issue.

mysql> desc oc_announcements;
+----------------------+--------------+------+-----+---------+----------------+
| Field                | Type         | Null | Key | Default | Extra          |
+----------------------+--------------+------+-----+---------+----------------+
| announcement_id      | int(11)      | NO   | PRI | NULL    | auto_increment |
| announcement_time    | int(11)      | NO   |     | 0       |                |
| announcement_user    | varchar(64)  | NO   |     | NULL    |                |
| announcement_subject | varchar(512) | NO   |     | NULL    |                |
| announcement_message | text         | YES  |     | NULL    |                |
+----------------------+--------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

Add owncloud coding standard test in drone

coding style in drone

#104 moved all tests to drone but the coding standard test is still not implemented. That needs to be added to drone and also code style needs to be fixed to comply with the owncloud coding standard

Announcements via popup on sync client

Hi and thank you for this usefull application.

As you are planning to enhance messaging to send to a certain user or goup, please think also about the possibility to generate a popup message on the remote Windows PCs that are running Sync Desktop Client...

Thank in advance...

Enrico

Move Announcements from "Apps" to "User-Menu"

I think it should be an point in the menu "Personal - Help - Admin - Users - Announcements" and not as an app like Calendar, Contacts because it isnt an "real" app ;)

Recommend Projects

React

A declarative, efficient, and flexible JavaScript library for building user interfaces.
Vue.js

🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript

TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
TensorFlow

An Open Source Machine Learning Framework for Everyone
Django

The Web framework for perfectionists with deadlines.
Laravel

A PHP framework for web artisans
D3

Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

javascript

JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
web

Some thing interesting about web. New door for the world.
server

A server is a program made to process requests and deliver data to clients.
Machine learning

Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Visualization

Some thing interesting about visualization, use data art
Game

Some thing interesting about game, make everyone happy.

Recommend Org

Facebook

We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft

Open source projects and samples from Microsoft.
Google

Google ❤️ Open Source for everyone.
Alibaba

Alibaba Open Source for everyone
D3

Data-Driven Documents codes.
Tencent

China tencent open source team.

owncloud / announcementcenter Goto Github PK

announcementcenter's Introduction

Announcement Center

QA metrics on master branch:

Screenshots

Announcements front page (the "Add announcement" form is admin only)

The users are also informed by an activity in their stream (can not be disabled)

announcementcenter's People

Contributors

Stargazers

Watchers

Forkers

announcementcenter's Issues

jQuery 3 Upgrade

Ajax

Core

Data

Reason

QA

Documentation

Marketing

Build & Marketplace release

Steps to reproduce

Expected behaviour

Actual behaviour

Server configuration

Client configuration

Logs

ownCloud log (data/owncloud.log)

Browser log

Release 1.2.2

Needed for:

Product approval

QA

Documentation

Marketing

Build

Beta/RC

Final

Publishing

Post-release

Steps to reproduce

Expected behaviour

Actual behaviour

Server configuration

Steps to reproduce

Expected behaviour

Actual behaviour

Server configuration

Client configuration

Logs

ownCloud log (data/owncloud.log)

Client configuration

Logs

ownCloud log (data/owncloud.log)

Browser log

jQuery Core 1.9 Upgrade Guide

Minor

Steps to reproduce

Expected behaviour

Actual behaviour

Server configuration

coding style in drone

Recommend Projects

Recommend Topics

Recommend Org