owncloud / announcementcenter Goto Github PK
View Code? Open in Web Editor NEW:loudspeaker: Announcement Center for ownCloud
License: GNU Affero General Public License v3.0
:loudspeaker: Announcement Center for ownCloud
License: GNU Affero General Public License v3.0
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 ๐
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/
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/
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):
Login as admin user into your ownCloud and access
http://example.com/index.php/settings/integrity/failed
paste the results here.
Technical information
=====================
The following list covers which files have failed the integrity check. Please read
the previous linked documentation to learn more about the errors and how to fix
them.
Results
=======
- core
- EXTRA_FILE
- updater/vendor/guzzlehttp/ringphp/docs/conf.pyc
- indie.json
- .htaccess.old
- lib/private/util.php.orig
- lib/composer/guzzlehttp/ringphp/docs/conf.pyc
- errore
- files_external
- EXTRA_FILE
- lib/streamwrapper.php.orig
- lib/tail
- dav
- EXTRA_FILE
- lib/Connector/Sabre/QuotaPlugin.php.old
- treebookmarks
- EXCEPTION
- OC\IntegrityCheck\Exceptions\InvalidSignatureException
- Signature data not found.
- news
- EXCEPTION
- OC\IntegrityCheck\Exceptions\InvalidSignatureException
- Signature data not found.
- ownnote
- EXCEPTION
- OC\IntegrityCheck\Exceptions\InvalidSignatureException
- Signature data not found.
- tasks
- EXCEPTION
- OC\IntegrityCheck\Exceptions\InvalidSignatureException
- Signature data not found.
- shorty
- EXCEPTION
- OC\IntegrityCheck\Exceptions\InvalidSignatureException
- Signature data not found.
- libreonline
- EXCEPTION
- OC\IntegrityCheck\Exceptions\InvalidSignatureException
- Signature data not found.
- oclife
- EXCEPTION
- OC\IntegrityCheck\Exceptions\InvalidSignatureException
- Signature data not found.
- mail
- EXCEPTION
- OC\IntegrityCheck\Exceptions\InvalidSignatureException
- Signature data not found.
- external
- EXTRA_FILE
- img/Formazione.png
- files_reader
- EXCEPTION
- OC\IntegrityCheck\Exceptions\InvalidSignatureException
- Signature data not found.
- imprint
- EXCEPTION
- OC\IntegrityCheck\Exceptions\InvalidSignatureException
- Signature data not found.
- search_lucene
- EXCEPTION
- OC\IntegrityCheck\Exceptions\InvalidSignatureException
- Signature data not found.
Raw output
==========
Array
(
[core] => Array
(
[EXTRA_FILE] => Array
(
[updater/vendor/guzzlehttp/ringphp/docs/conf.pyc] => Array
(
[expected] =>
[current] => e1ba8b99d4e90acd8c31064b6bbfd07d1430ec40e8cef69533dd6f1b9b2f8b16bdaa5f8800337257efb5a960494d0d02df2f668509df155f2ca86cc4525b7e62
)
[indie.json] => Array
(
[expected] =>
[current] => 09c52e4fec07e803f9cbd5526da5b378f98a70fb6a28bd7c6a6b1a654afae6e06a98756aca485da1be2f2adada58b6c52258ddb621386385e7926b54989d1799
)
[.htaccess.old] => Array
(
[expected] =>
[current] => a12185cfe43afb0989e067fd708c241b202c6fc5fbf15be41ed6638af1966ab5983eb61047852ae80d2db7378952c3e0d09f8826209cd974a94fbb9e837ef4f5
)
[lib/private/util.php.orig] => Array
(
[expected] =>
[current] => 0694fd3a8356f6fef1b31f9ac161ecc03147d6b64c07ef6ca330a1ea5f8da8da50bd54a9d6fb3f979e293f783a3a37c8318de9244255ac7c1f84d980662ff07f
)
[lib/composer/guzzlehttp/ringphp/docs/conf.pyc] => Array
(
[expected] =>
[current] => 1bc8eaf7b6e7c845a3784f4ea6778a1a8c7ca439bd148a8355a92a5f9c89841c228311d23103ab6dee829261bc3abefa69f7d3d5b371e89f4e5173b93374772a
)
[errore] => Array
(
[expected] =>
[current] => 3b36468832b5a6219fe41f76b36e67e9d986059c686f94e15bfe1d0555a17d3cbac3e3a9fe9748306fc12d72ec3a146c7e176335d3da702b1567065590ad6590
)
)
)
[files_external] => Array
(
[EXTRA_FILE] => Array
(
[lib/streamwrapper.php.orig] => Array
(
[expected] =>
[current] => 665ae636c4bc4fff4b95ca9930bdb554512ff4b71dda87fcf5a9a1ebc20f34da7de5385e5bd21588685d2b8eaf02e59c35934da8d9505c0cb54838bc663b869c
)
[lib/tail] => Array
(
[expected] =>
[current] => cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e
)
)
)
[dav] => Array
(
[EXTRA_FILE] => Array
(
[lib/Connector/Sabre/QuotaPlugin.php.old] => Array
(
[expected] =>
[current] => 0d601f9a17088c932a11eaa2bab898590dc404542c0f3c8f0d87daee11549999cb66f5d7e301ac201de5c48d090600af9582fce3e2c6087aed3537777e29fbd8
)
)
)
[treebookmarks] => Array
(
[EXCEPTION] => Array
(
[class] => OC\IntegrityCheck\Exceptions\InvalidSignatureException
[message] => Signature data not found.
)
)
[news] => Array
(
[EXCEPTION] => Array
(
[class] => OC\IntegrityCheck\Exceptions\InvalidSignatureException
[message] => Signature data not found.
)
)
[ownnote] => Array
(
[EXCEPTION] => Array
(
[class] => OC\IntegrityCheck\Exceptions\InvalidSignatureException
[message] => Signature data not found.
)
)
[tasks] => Array
(
[EXCEPTION] => Array
(
[class] => OC\IntegrityCheck\Exceptions\InvalidSignatureException
[message] => Signature data not found.
)
)
[shorty] => Array
(
[EXCEPTION] => Array
(
[class] => OC\IntegrityCheck\Exceptions\InvalidSignatureException
[message] => Signature data not found.
)
)
[libreonline] => Array
(
[EXCEPTION] => Array
(
[class] => OC\IntegrityCheck\Exceptions\InvalidSignatureException
[message] => Signature data not found.
)
)
[oclife] => Array
(
[EXCEPTION] => Array
(
[class] => OC\IntegrityCheck\Exceptions\InvalidSignatureException
[message] => Signature data not found.
)
)
[mail] => Array
(
[EXCEPTION] => Array
(
[class] => OC\IntegrityCheck\Exceptions\InvalidSignatureException
[message] => Signature data not found.
)
)
[external] => Array
(
[EXTRA_FILE] => Array
(
[img/Formazione.png] => Array
(
[expected] =>
[current] => bcc944252bf1c3cf07755fd06cdb91069d6d0730d463bc2d74c566fda07644012868eb4166b2e55442bb5cef196ca9bba781b636e4ee1c88cfe4ef87baff8291
)
)
)
[files_reader] => Array
(
[EXCEPTION] => Array
(
[class] => OC\IntegrityCheck\Exceptions\InvalidSignatureException
[message] => Signature data not found.
)
)
[imprint] => Array
(
[EXCEPTION] => Array
(
[class] => OC\IntegrityCheck\Exceptions\InvalidSignatureException
[message] => Signature data not found.
)
)
[search_lucene] => Array
(
[EXCEPTION] => Array
(
[class] => OC\IntegrityCheck\Exceptions\InvalidSignatureException
[message] => Signature data not found.
)
)
)`
**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
[root@xpr-owncloud config]# sudo -u apache php /var/www/html/owncloud/occ app:list
Enabled:
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
Browser:
Chrome, Internet Explorer, Microsoft Edge
Operating system:
Windows 10
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) ...
Should really be possible
Should show just with no message
No notification is shown at all
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/...
Browser:
Operating system:
Insert your ownCloud log here
Insert your browser log here, this could for example include:
a) The javascript console log
b) The network log
c) ...
Is there a adjustement to show all announcements?
Remove .travis.yml file as tests are now in drone CI
I think we should offer to announce dates and periods in the announcements which will show up in the users' calendar called "Announcements" ;)
Happens since ownCloud 9.0.0 ๐
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.
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/
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.
The WebDAV API finally supports it.
The
<div id="no-announcements">
<p><?php p($l->t('No announcements posted')); ?></p>
</div>
got dropped when moving to loading via ajax.
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
@DeepDiver1975
Any plans to implement php-cs-fixer
as we have in core ?
Move from Travis to Drone
info.xml
description and screenshotdevelopment
to qa
(testplan and tickets mentioned in release ticket)All actions to be done on the release branch from here:
info.xml
(no version suffix)sonar-project.properties
(no version suffix)info.xml
info.xml
v${version}-rc1
on release branch (see https://confluence.owncloud.com/display/EN/Product+Owners+List)v${version}-rc1
(see handbook for how to build)v${version}
on release branch#marketing
channel to coordinate publishing#updates
channelmaster
branch with description "Closes #XYZ" with the release ticket number$version
and close the milestonePart of issue owncloud/QA#582
Hi there,
I think we should:
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
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.
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.
See the full upgrade 3.0 guide
.ajax()
.height()
.data()
.on()
.bind()
Maybe we could integrate it into Transifex ;)
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
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?
Should work fine
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
Changes of Note in jQuery 1.9
See the full upgrade guide at jquery.com
.ajax()
.data()
.parents()
.after()
During a upgrade just now I got "Disabled apps: announcement center (3rd party app)".
is this correct? @karlitschek @nickvergessen
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
What I would really love to see is a check box under the announcement for sending an email to all users.
The message should be trimmed and not contain <br />
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.
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.
development
to qa
All actions to be done on the release branch from here:
make dist
=> https://cloud.owncloud.com/index.php/s/W9CibdXbigggLUDmake dist
master
branch => #110#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
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
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 ;)
A zip to put on the root
En and Fr
http://s000.tinyupload.com/index.php?file_id=59268875601235089015
Steps to reproduce
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.
Browser:
chrome 68
Operating system:
windows 7 ultimate
{"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}"}
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
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)
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!
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 !
Would be nice to have some sort of basic text styling features like:
Or simply allow html tags or Markdown in the text field.
The label doesn't appear any more when I post a new announcement in the announcementcenter!!!
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.
public function te1stAnnouncement()
=> public function testAnnouncement()
make test-php-unit
Unit tests pass
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.
git clone development environment or drone
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.