Error while running background job

AndyXheli · January 2, 2017, 7:07pm

Has anyone seen this before?

Error while running background job (Doctrine\DBAL\Exception\SyntaxErrorException): An exception occurred while executing ‘DELETE FROM oc_activity_mq WHERE amq_timestamp <= ? AND amq_affecteduser IN ()’ with params [1483382700]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1

tflidd · January 2, 2017, 9:41pm

If you search for that term you find this bug report:

github.com/nextcloud/server

SQL error background job

opened 09:07AM - 15 Dec 16 UTC

closed 09:09AM - 19 Dec 16 UTC

amittel

bug feature: activity and notification

Just look at the log and found this error occuring at cron times. Nextcloud 1…1.0.0 (stable) Apps: Contacts, Calendar, News MySQL: Localhost MySQL - (Debian) 5.5.53-0+deb8u1 Encryption: No Timestamps of error ``` 2016-12-15T09:45:06+0100 2016-12-15T09:15:07+0100 2016-12-15T08:45:02+0100 2016-12-15T08:15:01+0100 2016-12-15T07:45:02+0100 ``` ``` Error while running background job (Doctrine\DBAL\Exception\SyntaxErrorException): An exception occurred while executing 'DELETE FROM `oc_activity_mq` WHERE `amq_timestamp` <= ? AND `amq_affecteduser` IN ()' with params [1481784301]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 OCA\Activity\BackgroundJob\EmailNotification ): /media/f147882d-b410-4463-873b-e1b81659918a/www/cloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 128: Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException)) /media/f147882d-b410-4463-873b-e1b81659918a/www/cloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Statement.php - line 178: Doctrine\DBAL\DBALException driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'DELETE FROM `oc...', Array) /media/f147882d-b410-4463-873b-e1b81659918a/www/cloud/apps/activity/lib/MailQueueHandler.php - line 334: Doctrine\DBAL\Statement->execute(Array) /media/f147882d-b410-4463-873b-e1b81659918a/www/cloud/apps/activity/lib/BackgroundJob/EmailNotification.php - line 131: OCA\Activity\MailQueueHandler->deleteSentItems(Array, 1481784301) /media/f147882d-b410-4463-873b-e1b81659918a/www/cloud/apps/activity/lib/BackgroundJob/EmailNotification.php - line 81: OCA\Activity\BackgroundJob\EmailNotification->runStep(500, 1481784301) /media/f147882d-b410-4463-873b-e1b81659918a/www/cloud/lib/private/BackgroundJob/Job.php - line 53: OCA\Activity\BackgroundJob\EmailNotification->run(NULL) /media/f147882d-b410-4463-873b-e1b81659918a/www/cloud/lib/private/BackgroundJob/TimedJob.php - line 54: OC\BackgroundJob\Job->execute(Object(OC\BackgroundJob\JobList), Object(OC\Log)) /media/f147882d-b410-4463-873b-e1b81659918a/www/cloud/cron.php - line 121: OC\BackgroundJob\TimedJob->execute(Object(OC\BackgroundJob\JobList), Object(OC\Log)) {main} ``` The only thing changing is the number in `params [1481786100]`

and fix (at least for NC 11):

AndyXheli · January 3, 2017, 4:30am

Thank you for your help!

Lautre · October 30, 2022, 8:14am

Hi there
Re opening this old post with nextcloud 25.0

I’ve got this “error while running background job” since my update to version 25 …

Error while running background job (class: OCA\DAV\BackgroundJob\EventReminderJob, arguments: )“,“userAgent”:”–“,“version”:“25.0.0.18”,“exception”:{“Exception”:“OC\DB\Exceptions\DbalException”,“Message”:“An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘icon’ in ‘field list’”,“Code”:1054,“Trace”:[{“file”:”/var/www/Nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",“line”:329,“function”:“wrap”,“class”:“OC\DB\Excetions\DbalException”,“type”:“::”}

Any idea ?

Lautre · October 31, 2022, 8:04pm

Ok, I’ve got the answer …
here

github.com/nextcloud/notifications

Column not found: 1054 Unknown column 'icon' in 'field list' at <<closure>>

opened 08:20PM - 30 Oct 19 UTC

closed 09:56AM - 31 Oct 19 UTC

benkinooby

### Steps to reproduce 1. use ``occ notification:generate <user> <s…hort message>`` ### Expected behaviour successful notification of user ### Actual behaviour ``` sudo -u nobody php occ notification:generate foouser "Hi" In AbstractMySQLDriver.php line 60: An exception occurred while executing 'INSERT INTO `oc_notifications` (`app`, `user`, `timestamp`, `object_type`, `object_id`, `subject`, `subject_parameters`, `message`, `message_parameters`, `link`, `icon`, `actions`) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["admin_notifications", "foouser", 157 2466737, "admin_notifications", "5db9f031", "cli", "[\"Hi\"]", "", "[]", "", "", "[]"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'icon' in 'field list' In PDOStatement.php line 119: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'icon' in 'field list' In PDOStatement.php line 117: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'icon' in 'field list' ``` ### Server configuration **Operating system**: Gentoo Linux **Web server:** nginx 1.17.4 **Database:** mysql 5.7.27-r1 **PHP version:** 7.2 **Nextcloud version:** (see Nextcloud admin page) 17.0.0 **Where did you install Nextcloud from:** **Signing status:** ``` Results ======= - text - EXTRA_FILE - .tx/config - .github/ISSUE_TEMPLATE/Bug_report.md - .github/ISSUE_TEMPLATE/Feature_request.md - .github/pull_request_template.md - .eslintrc.js - package-lock.json - l10n/.gitkeep - .gitattributes - README.md - package.json - .l10nignore ``` **List of activated apps:** ```sudo -u nobody php occ app:list Enabled: - accessibility: 1.3.0 - bruteforcesettings: 1.4.0 - calendar: 1.7.1 - cloud_federation_api: 1.0.0 - dav: 1.13.0 - federatedfilesharing: 1.7.0 - files: 1.12.0 - files_rightclick: 0.15.1 - files_sharing: 1.9.0 - files_trashbin: 1.7.0 - files_versions: 1.10.0 - logreader: 2.2.0 - lookup_server_connector: 1.5.0 - nextcloud_announcements: 1.6.0 - notes: 3.0.3 - notifications: 2.5.0 - oauth2: 1.5.0 - password_policy: 1.7.0 - polls: 0.10.4 - privacy: 1.1.0 - provisioning_api: 1.7.0 - recommendations: 0.5.0 - serverinfo: 1.7.0 - sharebymail: 1.7.0 - survey_client: 1.5.0 - text: 1.1.0 - twofactor_backupcodes: 1.6.0 - viewer: 1.1.0 - workflowengine: 1.7.0 Disabled: - activity - admin_audit - comments - encryption - federation - files_external - files_pdfviewer - files_videoplayer - firstrunwizard - gallery - support - systemtags - theming - updatenotification - user_ldap ``` **Nextcloud configuration:** ``` { "system": { "instanceid": "***REMOVED SENSITIVE VALUE***", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "example.host.com" ], "datadirectory": "***REMOVED SENSITIVE VALUE***", "overwrite.cli.url": "https:\/\/example.host.com", "dbtype": "mysql", "version": "17.0.0.9", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbtableprefix": "oc_", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "installed": true, "mail_smtpdebug": true, "mail_smtpmode": "smtp", "mail_smtpsecure": "tls", "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_domain": "***REMOVED SENSITIVE VALUE***", "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "mail_smtpport": "587", "loglevel": 1, "mail_smtpauthtype": "LOGIN", "forcessl": true, "forceSSLforSubdomains": true, "theme": "", "maintenance": false, "trashbin_retention_obligation": "auto", "mail_smtpauth": 1, "mail_smtpname": "***REMOVED SENSITIVE VALUE***", "mail_smtppassword": "***REMOVED SENSITIVE VALUE***", "htaccess.RewriteBase": "\/", "memcache.local": "\\OC\\Memcache\\Redis", "memcache.locking": "\\OC\\Memcache\\Redis", "redis": { "host": "***REMOVED SENSITIVE VALUE***", "port": 0 }, "enable_previews": false, "singleuser": false, "mail_sendmailmode": "smtp" } } ``` **Are you using an external user-backend, if yes which one:** LDAP/ActiveDirectory/Webdav/... no ### Client configuration **Browser:** Firefox 68 **Operating system:** ### Logs Gentoo Linux #### Nextcloud log (data/owncloud.log) ``` Insert your Nextcloud log here ``` #### Browser log ``` none ```

thanks