Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unknown column 'activeSince' in 'field list' #1903

Closed
silas229 opened this issue Jun 12, 2019 · 1 comment

Comments

Projects
None yet
2 participants
@silas229
Copy link

commented Jun 12, 2019

Steps to reproduce

  1. Update Nextcloud Talk to version 5.0.4

Expected behaviour

The app should be updated

Actual behaviour

I got this error message:

Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'UPDATE `oc_talk_rooms` SET `active_since` = `activeSince`, `active_guests` = `activeGuests`': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'activeSince' in 'field list'

I don't have a column called activeSince but I have a column called active_since:
screenshot

Server configuration

Web server: Apache (+ Nginx proxy)

Database: Maria 5.5.60

PHP version: 7.2.19

Nextcloud Version: 15.0.7.0

List of activated apps:

- accessibility: 1.1.0 - activity: 2.8.2 - admin_audit: 1.5.0 - apporder: 0.6.0 - bruteforcesettings: 1.3.0 - calendar: 1.6.5 - camerarawpreviews: 0.7.0 - cloud_federation_api: 0.1.0 - cms_pico: 0.9.8 - comments: 1.5.0 - contacts: 3.1.3 - dashboard: 6.0.0 - data_request: 1.2.0 - dav: 1.8.1 - drop_account: 0.1.0 - dropit: 0.2.1 - end_to_end_encryption: 1.1.0 - external: 3.2.0 - federatedfilesharing: 1.5.0 - federation: 1.5.0 - files: 1.10.0 - files_antivirus: 2.1.1 - files_external: 1.6.0 - files_markdown: 2.0.6 - files_pdfviewer: 1.4.0 - files_sharing: 1.7.0 - files_texteditor: 2.7.0 - files_trashbin: 1.5.0 - files_versions: 1.8.0 - files_videoplayer: 1.4.0 - firstrunwizard: 2.4.0 - gallery: 18.2.0 - groupfolders: 3.0.2 - impersonate: 1.2.0 - logreader: 2.0.0 - lookup_server_connector: 1.3.0 - mail: 0.11.1 - metadata: 0.9.0 - news: 13.1.6 - nextcloud_announcements: 1.4.0 - notes: 2.6.0 - notifications: 2.3.0 - oauth2: 1.3.0 - ocsms: 2.1.1 - passman: 2.3.1 - password_policy: 1.5.0 - phonetrack: 0.5.1 - provisioning_api: 1.5.0 - serverinfo: 1.5.0 - sharebymail: 1.5.0 - sociallogin: 1.14.5 - socialsharing_email: 1.0.5 - socialsharing_twitter: 1.0.4 - spreed: 5.0.3 - support: 1.0.0 - survey_client: 1.3.0 - systemtags: 1.5.0 - theming: 1.6.0 - twofactor_backupcodes: 1.4.1 - updatenotification: 1.5.0 - user_ldap: 1.5.0 - weather: 1.5.5 - workflowengine: 1.5.0 Disabled: - circles - deck - encryption - unsplash

Nextcloud configuration:

```json { "system":{ "instanceid":"***REMOVED SENSITIVE VALUE***", "passwordsalt":"***REMOVED SENSITIVE VALUE***", "secret":"***REMOVED SENSITIVE VALUE***", "trusted_domains":[ "cloud.silas229.de", "cloud.silas229.de.195-34-83-18.server-abheyden-webhosting.de" ], "datadirectory":"***REMOVED SENSITIVE VALUE***", "dbtype":"mysql", "version":"15.0.7.0", "overwrite.cli.url":"http:\/\/cloud.silas229.de.195-34-83-18.server-abheyden-webhosting.de", "dbname":"***REMOVED SENSITIVE VALUE***", "dbhost":"***REMOVED SENSITIVE VALUE***", "dbport":"", "dbtableprefix":"oc_", "dbuser":"***REMOVED SENSITIVE VALUE***", "dbpassword":"***REMOVED SENSITIVE VALUE***", "installed":true, "maintenance":false, "theme":"", "loglevel":2, "ldapIgnoreNamingRules":false, "ldapProviderFactory":"OCA\\User_LDAP\\LDAPProviderFactory", "mysql.utf8mb4":false, "updater.release.channel":"stable" } } ```

Server log (data/nextcloud.log)

I think this is the right passage
{"reqId":"XQD@R0ZhFrPdFc2dx5Q1UQAAAMI","level":1,"time":"2019-06-12T13:29:43+00:00","remoteAddr":"46.81.119.114","user":"--","app":"updater","method":"GET","url":"\/core\/ajax\/update.php?requesttoken=SP%2FbMZv1KKFKN4G9lvVXmA4RIahrxPHi0WxH7o00bNY%3D%3AA4mResyDTsokRuvIw4051UNbVfkBk8KWgVgsgOJSGKQ%3D","message":"\\OC\\Updater::maintenanceEnabled: Turned on maintenance mode","userAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/74.0.3729.169 Safari\/537.36","version":"15.0.7.0"}
{"reqId":"XQD@R0ZhFrPdFc2dx5Q1UQAAAMI","level":0,"time":"2019-06-12T13:29:43+00:00","remoteAddr":"46.81.119.114","user":"--","app":"core","method":"GET","url":"\/core\/ajax\/update.php?requesttoken=SP%2FbMZv1KKFKN4G9lvVXmA4RIahrxPHi0WxH7o00bNY%3D%3AA4mResyDTsokRuvIw4051UNbVfkBk8KWgVgsgOJSGKQ%3D","message":"starting upgrade from 15.0.7.0 to 15.0.7.0","userAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/74.0.3729.169 Safari\/537.36","version":"15.0.7.0"}
{"reqId":"XQD@R0ZhFrPdFc2dx5Q1UQAAAMI","level":1,"time":"2019-06-12T13:29:43+00:00","remoteAddr":"46.81.119.114","user":"--","app":"updater","method":"GET","url":"\/core\/ajax\/update.php?requesttoken=SP%2FbMZv1KKFKN4G9lvVXmA4RIahrxPHi0WxH7o00bNY%3D%3AA4mResyDTsokRuvIw4051UNbVfkBk8KWgVgsgOJSGKQ%3D","message":"\\OC\\Repair::step: Repair step: Repair MySQL collation","userAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/74.0.3729.169 Safari\/537.36","version":"15.0.7.0"}
{"reqId":"XQD@R0ZhFrPdFc2dx5Q1UQAAAMI","level":1,"time":"2019-06-12T13:29:43+00:00","remoteAddr":"46.81.119.114","user":"--","app":"updater","method":"GET","url":"\/core\/ajax\/update.php?requesttoken=SP%2FbMZv1KKFKN4G9lvVXmA4RIahrxPHi0WxH7o00bNY%3D%3AA4mResyDTsokRuvIw4051UNbVfkBk8KWgVgsgOJSGKQ%3D","message":"\\OC\\Repair::info: Repair info: All tables already have the correct collation -> nothing to do","userAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/74.0.3729.169 Safari\/537.36","version":"15.0.7.0"}
{"reqId":"XQD@R0ZhFrPdFc2dx5Q1UQAAAMI","level":1,"time":"2019-06-12T13:29:43+00:00","remoteAddr":"46.81.119.114","user":"--","app":"updater","method":"GET","url":"\/core\/ajax\/update.php?requesttoken=SP%2FbMZv1KKFKN4G9lvVXmA4RIahrxPHi0WxH7o00bNY%3D%3AA4mResyDTsokRuvIw4051UNbVfkBk8KWgVgsgOJSGKQ%3D","message":"\\OC\\Repair::step: Repair step: Repair SQLite autoincrement","userAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/74.0.3729.169 Safari\/537.36","version":"15.0.7.0"}
{"reqId":"XQD@R0ZhFrPdFc2dx5Q1UQAAAMI","level":1,"time":"2019-06-12T13:29:43+00:00","remoteAddr":"46.81.119.114","user":"--","app":"updater","method":"GET","url":"\/core\/ajax\/update.php?requesttoken=SP%2FbMZv1KKFKN4G9lvVXmA4RIahrxPHi0WxH7o00bNY%3D%3AA4mResyDTsokRuvIw4051UNbVfkBk8KWgVgsgOJSGKQ%3D","message":"\\OC\\Repair::step: Repair step: Copy data from accounts table when migrating from ownCloud","userAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/74.0.3729.169 Safari\/537.36","version":"15.0.7.0"}
{"reqId":"XQD@R0ZhFrPdFc2dx5Q1UQAAAMI","level":1,"time":"2019-06-12T13:29:44+00:00","remoteAddr":"46.81.119.114","user":"--","app":"updater","method":"GET","url":"\/core\/ajax\/update.php?requesttoken=SP%2FbMZv1KKFKN4G9lvVXmA4RIahrxPHi0WxH7o00bNY%3D%3AA4mResyDTsokRuvIw4051UNbVfkBk8KWgVgsgOJSGKQ%3D","message":"\\OC\\Repair::step: Repair step: Drop account terms table when migrating from ownCloud","userAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/74.0.3729.169 Safari\/537.36","version":"15.0.7.0"}
{"reqId":"XQD@R0ZhFrPdFc2dx5Q1UQAAAMI","level":1,"time":"2019-06-12T13:29:44+00:00","remoteAddr":"46.81.119.114","user":"--","app":"updater","method":"GET","url":"\/core\/ajax\/update.php?requesttoken=SP%2FbMZv1KKFKN4G9lvVXmA4RIahrxPHi0WxH7o00bNY%3D%3AA4mResyDTsokRuvIw4051UNbVfkBk8KWgVgsgOJSGKQ%3D","message":"\\OC\\Updater::dbUpgradeBefore: Updating database schema","userAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/74.0.3729.169 Safari\/537.36","version":"15.0.7.0"}
{"reqId":"XQD@R0ZhFrPdFc2dx5Q1UQAAAMI","level":1,"time":"2019-06-12T13:29:44+00:00","remoteAddr":"46.81.119.114","user":"--","app":"updater","method":"GET","url":"\/core\/ajax\/update.php?requesttoken=SP%2FbMZv1KKFKN4G9lvVXmA4RIahrxPHi0WxH7o00bNY%3D%3AA4mResyDTsokRuvIw4051UNbVfkBk8KWgVgsgOJSGKQ%3D","message":"\\OC\\Updater::dbUpgrade: Updated database","userAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/74.0.3729.169 Safari\/537.36","version":"15.0.7.0"}
{"reqId":"XQD@R0ZhFrPdFc2dx5Q1UQAAAMI","level":1,"time":"2019-06-12T13:29:44+00:00","remoteAddr":"46.81.119.114","user":"--","app":"updater","method":"GET","url":"\/core\/ajax\/update.php?requesttoken=SP%2FbMZv1KKFKN4G9lvVXmA4RIahrxPHi0WxH7o00bNY%3D%3AA4mResyDTsokRuvIw4051UNbVfkBk8KWgVgsgOJSGKQ%3D","message":"\\OC\\Updater::appUpgradeStarted: Updating <spreed> ...","userAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/74.0.3729.169 Safari\/537.36","version":"15.0.7.0"}
{"reqId":"XQD@R0ZhFrPdFc2dx5Q1UQAAAMI","level":3,"time":"2019-06-12T13:29:45+00:00","remoteAddr":"46.81.119.114","user":"--","app":"core","method":"GET","url":"\/core\/ajax\/update.php?requesttoken=SP%2FbMZv1KKFKN4G9lvVXmA4RIahrxPHi0WxH7o00bNY%3D%3AA4mResyDTsokRuvIw4051UNbVfkBk8KWgVgsgOJSGKQ%3D","message":{"Exception":"Doctrine\\DBAL\\Exception\\InvalidFieldNameException","Message":"An exception occurred while executing 'UPDATE `oc_talk_rooms` SET `active_since` = `activeSince`, `active_guests` = `activeGuests`':\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'activeSince' in 'field list'","Code":0,"Trace":[{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php","line":128,"function":"convertException","class":"Doctrine\\DBAL\\Driver\\AbstractMySQLDriver","type":"->","args":["An exception occurred while executing 'UPDATE `oc_talk_rooms` SET `active_since` = `activeSince`, `active_guests` = `activeGuests`':\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'activeSince' in 'field list'",{"errorInfo":["42S22",1054,"Unknown column 'activeSince' in 'field list'"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"}]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php","line":1015,"function":"driverExceptionDuringQuery","class":"Doctrine\\DBAL\\DBALException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDOMySql\\Driver"},{"errorInfo":["42S22",1054,"Unknown column 'activeSince' in 'field list'"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"},"UPDATE `oc_talk_rooms` SET `active_since` = `activeSince`, `active_guests` = `activeGuests`",[]]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/lib\/private\/DB\/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE `oc_talk_rooms` SET `active_since` = `activeSince`, `active_guests` = `activeGuests`",[],[]]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Query\/QueryBuilder.php","line":208,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["UPDATE `oc_talk_rooms` SET `active_since` = `activeSince`, `active_guests` = `activeGuests`",[],[]]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/lib\/private\/DB\/QueryBuilder\/QueryBuilder.php","line":214,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/apps\/spreed\/lib\/Migration\/Version2001Date20180103144447.php","line":132,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/lib\/private\/DB\/MigrationService.php","line":469,"function":"postSchemaChange","class":"OCA\\Spreed\\Migration\\Version2001Date20180103144447","type":"->","args":[{"__class__":"OC\\Migration\\SimpleOutput"},{"__class__":"Closure"},{"tablePrefix":"oc_"}]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/lib\/private\/DB\/MigrationService.php","line":392,"function":"executeStep","class":"OC\\DB\\MigrationService","type":"->","args":["2001Date20180103144447",false]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/lib\/private\/legacy\/app.php","line":900,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/lib\/private\/Updater.php","line":365,"function":"updateApp","class":"OC_App","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/lib\/private\/Updater.php","line":245,"function":"doAppUpgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/lib\/private\/Updater.php","line":121,"function":"doUpgrade","class":"OC\\Updater","type":"->","args":["15.0.7.0","15.0.7.0"]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/core\/ajax\/update.php","line":212,"function":"upgrade","class":"OC\\Updater","type":"->","args":[]}],"File":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractMySQLDriver.php","Line":71,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDOException","Message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'activeSince' in 'field list'","Code":"42S22","Trace":[{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php","line":1012,"function":"exec","class":"Doctrine\\DBAL\\Driver\\PDOConnection","type":"->","args":["UPDATE `oc_talk_rooms` SET `active_since` = `activeSince`, `active_guests` = `activeGuests`"]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/lib\/private\/DB\/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE `oc_talk_rooms` SET `active_since` = `activeSince`, `active_guests` = `activeGuests`",[],[]]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Query\/QueryBuilder.php","line":208,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["UPDATE `oc_talk_rooms` SET `active_since` = `activeSince`, `active_guests` = `activeGuests`",[],[]]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/lib\/private\/DB\/QueryBuilder\/QueryBuilder.php","line":214,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/apps\/spreed\/lib\/Migration\/Version2001Date20180103144447.php","line":132,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/lib\/private\/DB\/MigrationService.php","line":469,"function":"postSchemaChange","class":"OCA\\Spreed\\Migration\\Version2001Date20180103144447","type":"->","args":[{"__class__":"OC\\Migration\\SimpleOutput"},{"__class__":"Closure"},{"tablePrefix":"oc_"}]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/lib\/private\/DB\/MigrationService.php","line":392,"function":"executeStep","class":"OC\\DB\\MigrationService","type":"->","args":["2001Date20180103144447",false]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/lib\/private\/legacy\/app.php","line":900,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/lib\/private\/Updater.php","line":365,"function":"updateApp","class":"OC_App","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/lib\/private\/Updater.php","line":245,"function":"doAppUpgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/lib\/private\/Updater.php","line":121,"function":"doUpgrade","class":"OC\\Updater","type":"->","args":["15.0.7.0","15.0.7.0"]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/core\/ajax\/update.php","line":212,"function":"upgrade","class":"OC\\Updater","type":"->","args":[]}],"File":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOConnection.php","Line":59,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'activeSince' in 'field list'","Code":"42S22","Trace":[{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOConnection.php","line":57,"function":"exec","class":"PDO","type":"->","args":["UPDATE `oc_talk_rooms` SET `active_since` = `activeSince`, `active_guests` = `activeGuests`"]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php","line":1012,"function":"exec","class":"Doctrine\\DBAL\\Driver\\PDOConnection","type":"->","args":["UPDATE `oc_talk_rooms` SET `active_since` = `activeSince`, `active_guests` = `activeGuests`"]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/lib\/private\/DB\/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE `oc_talk_rooms` SET `active_since` = `activeSince`, `active_guests` = `activeGuests`",[],[]]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Query\/QueryBuilder.php","line":208,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["UPDATE `oc_talk_rooms` SET `active_since` = `activeSince`, `active_guests` = `activeGuests`",[],[]]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/lib\/private\/DB\/QueryBuilder\/QueryBuilder.php","line":214,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/apps\/spreed\/lib\/Migration\/Version2001Date20180103144447.php","line":132,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/lib\/private\/DB\/MigrationService.php","line":469,"function":"postSchemaChange","class":"OCA\\Spreed\\Migration\\Version2001Date20180103144447","type":"->","args":[{"__class__":"OC\\Migration\\SimpleOutput"},{"__class__":"Closure"},{"tablePrefix":"oc_"}]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/lib\/private\/DB\/MigrationService.php","line":392,"function":"executeStep","class":"OC\\DB\\MigrationService","type":"->","args":["2001Date20180103144447",false]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/lib\/private\/legacy\/app.php","line":900,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/lib\/private\/Updater.php","line":365,"function":"updateApp","class":"OC_App","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/lib\/private\/Updater.php","line":245,"function":"doAppUpgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/lib\/private\/Updater.php","line":121,"function":"doUpgrade","class":"OC\\Updater","type":"->","args":["15.0.7.0","15.0.7.0"]},{"file":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/core\/ajax\/update.php","line":212,"function":"upgrade","class":"OC\\Updater","type":"->","args":[]}],"File":"\/var\/www\/vhosts\/silas-meyer.de\/silas229\/cloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOConnection.php","Line":57}},"CustomMessage":"--"},"userAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/74.0.3729.169 Safari\/537.36","version":"15.0.7.0"}
{"reqId":"XQD@R0ZhFrPdFc2dx5Q1UQAAAMI","level":3,"time":"2019-06-12T13:29:45+00:00","remoteAddr":"46.81.119.114","user":"--","app":"updater","method":"GET","url":"\/core\/ajax\/update.php?requesttoken=SP%2FbMZv1KKFKN4G9lvVXmA4RIahrxPHi0WxH7o00bNY%3D%3AA4mResyDTsokRuvIw4051UNbVfkBk8KWgVgsgOJSGKQ%3D","message":"\\OC\\Updater::failure: Doctrine\\DBAL\\Exception\\InvalidFieldNameException: An exception occurred while executing 'UPDATE `oc_talk_rooms` SET `active_since` = `activeSince`, `active_guests` = `activeGuests`':\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'activeSince' in 'field list'","userAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/74.0.3729.169 Safari\/537.36","version":"15.0.7.0"}
{"reqId":"XQD@R0ZhFrPdFc2dx5Q1UQAAAMI","level":3,"time":"2019-06-12T13:29:45+00:00","remoteAddr":"46.81.119.114","user":"--","app":"updater","method":"GET","url":"\/core\/ajax\/update.php?requesttoken=SP%2FbMZv1KKFKN4G9lvVXmA4RIahrxPHi0WxH7o00bNY%3D%3AA4mResyDTsokRuvIw4051UNbVfkBk8KWgVgsgOJSGKQ%3D","message":"\\OC\\Updater::updateEnd: Update failed","userAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/74.0.3729.169 Safari\/537.36","version":"15.0.7.0"}
{"reqId":"XQD@R0ZhFrPdFc2dx5Q1UQAAAMI","level":1,"time":"2019-06-12T13:29:45+00:00","remoteAddr":"46.81.119.114","user":"--","app":"updater","method":"GET","url":"\/core\/ajax\/update.php?requesttoken=SP%2FbMZv1KKFKN4G9lvVXmA4RIahrxPHi0WxH7o00bNY%3D%3AA4mResyDTsokRuvIw4051UNbVfkBk8KWgVgsgOJSGKQ%3D","message":"\\OC\\Updater::maintenanceActive: Maintenance mode is kept active","userAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/74.0.3729.169 Safari\/537.36","version":"15.0.7.0"}
{"reqId":"XQD@R0ZhFrPdFc2dx5Q1UQAAAMI","level":1,"time":"2019-06-12T13:29:45+00:00","remoteAddr":"46.81.119.114","user":"--","app":"updater","method":"GET","url":"\/core\/ajax\/update.php?requesttoken=SP%2FbMZv1KKFKN4G9lvVXmA4RIahrxPHi0WxH7o00bNY%3D%3AA4mResyDTsokRuvIw4051UNbVfkBk8KWgVgsgOJSGKQ%3D","message":"\\OC\\Updater::resetLogLevel: Reset log level to Warning(2)","userAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/74.0.3729.169 Safari\/537.36","version":"15.0.7.0"}
@nickvergessen

This comment has been minimized.

Copy link
Member

commented Jun 20, 2019

Seems like your database had stray entries from a previous installation of the app?

Try the following, open file apps/spreed/lib/Migration/Version2001Date20180103144447.php
find:

		if (version_compare($this->config->getAppValue('spreed', 'installed_version', '0.0.0'), '2.0.0', '<')) {
			// Migrations only work after 2.0.0
			return;
		}

after add:

		/** @var ISchemaWrapper $schema */
		$schema = $schemaClosure();
		if (!$schema->hasTable('talk_rooms')) {
			return;
		}

		$table = $schema->getTable('talk_rooms');
		if (!$table->hasColumn('activeSince')) {
			return;
		}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.