search

eideasy / nextcloud-electronic-signatures-plugin

NextCloud plugin for qualified and non-qualified electonic signatures.
GNU Affero General Public License v3.0
3 stars 3 forks source link

Exception: Database error when running migration latest for app electronicsignatures #52

Closed Kenneth-w closed 3 years ago

Kenneth-w commented 3 years ago

Copied from https://github.com/nextcloud/server/issues/27784

How to use GitHub

Steps to reproduce

  1. I installed a the 21.02 stable version of NextCloud as a fresh install.
  2. Installed a number of apps - one of which was the "ElectronicSignature" app
    1. I received today a message that an update was available.
  4. Went to the app list and clicked the update & install button next to the app
  5. When going to the installation the following message appeared as the root domain of the installation. The START UPDATING button was clicked:

App update required

The following apps will be updated:

*Electronic Signatures (electronicsignatures)*

Please make sure that the database, the config folder and the data folder have been backed up before proceeding. To avoid timeouts with larger installations, you can instead run the following command from your installation directory:

[START UPDATING]

./occ upgrade

Expected behaviour

It was expected that the update for the app was to update and the NextCloud installation should be operating as normal. It is a relatively fresh install (may be one week) and has not been used very much for any work. The electronicsignature app was never used - only was installed from curiosity

Actual behaviour

The following message now appears when typing the root domain of the installation:
pdate to 21.0.2

Exception: Database error when running migration latest for app electronicsignatures
Detailed logs

Preparing update

Set log level to debug

Turned on maintenance mode

Repair step: Repair MySQL collation

Repair info: All tables already have the correct collation -> nothing to do

Repair step: Repair SQLite autoincrement

Repair step: Copy data from accounts table when migrating from ownCloud

Repair step: Drop account terms table when migrating from ownCloud

Updating database schema

Updated database

Exception: Database error when running migration latest for app electronicsignatures

The update was unsuccessful. Please report this issue to the Nextcloud community.

Server configuration

Operating system: Ubuntu 20.04

Web server: nginx

Database: MariaDB

PHP version: 7.4.3

Nextcloud version: (see Nextcloud admin page) 21.02

Updated from an older Nextcloud/ownCloud or fresh install: Fresh

Where did you install Nextcloud from: Followed the great instructions here https://www.linuxbabe.com/ubuntu/install-nextcloud-ubuntu-20-04-nginx-lemp-stack

Signing status:

Signing status ``` Login as admin user into your Nextcloud and access http://example.com/index.php/settings/integrity/failed paste the results here. ``` **Unable to get past the front page of the root domain**

List of activated apps:

App list ``` If you have access to your command line run e.g.: sudo -u www-data php occ app:list from within your Nextcloud installation folder ``` Running the above command give the response: - accessibility: 1.7.0 - activity: 2.14.3 - audioplayer: 3.1.0 - bruteforcesettings: 2.2.0 - calendar: 2.3.0 - circles: 0.21.2 - cloud_federation_api: 1.4.0 - comments: 1.11.0 - contacts: 3.5.1 - contactsinteraction: 1.2.0 - dashboard: 7.1.0 - dav: 1.17.1 - deck: 1.4.2 - electronicsignatures: 1.1.0 - federatedfilesharing: 1.11.0 - federation: 1.11.0 - files: 1.16.0 - files_mindmap: 0.0.24 - files_pdfviewer: 2.1.0 - files_rightclick: 1.0.0 - files_sharing: 1.13.1 - files_trashbin: 1.11.0 - files_versions: 1.14.0 - files_videoplayer: 1.10.0 - firstrunwizard: 2.10.0 - forms: 2.2.4 - logreader: 2.6.0 - lookup_server_connector: 1.9.0 - mail: 1.9.5 - music: 1.2.1 - nextcloud_announcements: 1.10.0 - notes: 4.1.0 - notifications: 2.9.0 - oauth2: 1.9.0 - ownpad: 0.6.16 - password_policy: 1.11.0 - photos: 1.3.0 - privacy: 1.5.0 - provisioning_api: 1.11.0 - recommendations: 1.0.0 - serverinfo: 1.11.0 - settings: 1.3.0 - sharebymail: 1.11.0 - spreed: 11.2.2 - support: 1.4.0 - survey_client: 1.9.0 - systemtags: 1.11.0 - talk_matterbridge: 1.22.4 - tasks: 0.13.6 - text: 3.2.0 - theming: 1.12.0 - twofactor_backupcodes: 1.10.0 - updatenotification: 1.11.0 - user_status: 1.1.1 - viewer: 1.5.0 - weather_status: 1.1.0 - workflowengine: 2.3.0 Disabled: - admin_audit - encryption - files_external - richdocuments - user_ldap

Nextcloud configuration:

Config report ``` If you have access to your command line run e.g.: sudo -u www-data php occ config:list system from within your Nextcloud installation folder or Insert your config.php content here. Make sure to remove all sensitive content such as passwords. (e.g. database password, passwordsalt, secret, smtp password, …) { "system": { "instanceid": "***REMOVED SENSITIVE VALUE***", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "cloud2.cambaroo.com" ], "datadirectory": "***REMOVED SENSITIVE VALUE***", "dbtype": "mysql", "version": "21.0.2.1", "overwrite.cli.url": "https:\/\/cloud2.cambaroo.com", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbport": "", "dbtableprefix": "oc_", "mysql.utf8mb4": true, "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "installed": true, "mail_smtpmode": "smtp", "mail_sendmailmode": "smtp", "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_domain": "***REMOVED SENSITIVE VALUE***", "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "mail_smtpport": "465", "mail_smtpauth": 1, "mail_smtpname": "***REMOVED SENSITIVE VALUE***", "mail_smtppassword": "***REMOVED SENSITIVE VALUE***", "mail_smtpauthtype": "LOGIN", "mail_smtpsecure": "ssl", "memcache.distributed": "\\OC\\Memcache\\Redis", "memcache.local": "\\OC\\Memcache\\Redis", "memcache.locking": "\\OC\\Memcache\\Redis", "redis": { "host": "***REMOVED SENSITIVE VALUE***", "port": 6379 }, "maintenance": false, "theme": "", "loglevel": 2 } } ```

Are you using external storage, if yes which one: local/smb/sftp/... not sure - probably not

Are you using encryption: yes/no no

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

Client configuration

Browser: Firefox 89.0.2 (64-bit)

Operating system: Ubuntu 20.04

Logs

Detailed logs

Preparing update

Set log level to debug

Turned on maintenance mode

Repair step: Repair MySQL collation

Repair info: All tables already have the correct collation -> nothing to do

Repair step: Repair SQLite autoincrement

Repair step: Copy data from accounts table when migrating from ownCloud

Repair step: Drop account terms table when migrating from ownCloud

Updating database schema

Updated database

Exception: Database error when running migration latest for app electronicsignatures

Web server error log

Web server error log ``` [web Access.log](https://github.com/nextcloud/server/files/6758431/web.Access.log) ```

Nextcloud log (data/nextcloud.log)

Nextcloud log ``` [nextcloud.log](https://github.com/nextcloud/server/files/6758437/nextcloud.log) ```

Browser log

Browser log ``` Insert your browser log here, this could for example include: a) The javascript console log b) The network log c) ... ```
tpalts commented 3 years ago

Does your nextcloud.log contain any more detailed information?

Kenneth-w commented 3 years ago

Does your nextcloud.log contain any more detailed information?

No, there is no more information in the nextcloud.log file. What was shared was the log in its entirity.

tpalts commented 3 years ago

Might be a silly question, but just to check: did you enable logging in config.php?

solracsf commented 3 years ago

Same error here:

{
  "reqId": "AmDasZBk3Iz6cqeh8Dl4",
  "level": 3,
  "time": "2021-07-05T21:27:57+02:00",
  "remoteAddr": "",
  "user": "--",
  "app": "core",
  "method": "",
  "url": "--",
  "message": {
    "Exception": "Exception",
    "Message": "Database error when running migration latest for app electronicsignatures",
    "Code": 0,
    "Trace": [
      {
        "file": "/lib/private/legacy/OC_App.php",
        "line": 993,
        "function": "migrate",
        "class": "OC\\DB\\MigrationService",
        "type": "->",
        "args": []
      },
      {
        "file": "/lib/private/Updater.php",
        "line": 340,
        "function": "updateApp",
        "class": "OC_App",
        "type": "::",
        "args": [
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/lib/private/Updater.php",
        "line": 260,
        "function": "doAppUpgrade",
        "class": "OC\\Updater",
        "type": "->",
        "args": []
      },
      {
        "file": "/lib/private/Updater.php",
        "line": 132,
        "function": "doUpgrade",
        "class": "OC\\Updater",
        "type": "->",
        "args": [
          "21.0.2.1",
          "21.0.2.1"
        ]
      },
      {
        "file": "/core/Command/Upgrade.php",
        "line": 255,
        "function": "upgrade",
        "class": "OC\\Updater",
        "type": "->",
        "args": []
      },
      {
        "file": "/3rdparty/symfony/console/Command/Command.php",
        "line": 255,
        "function": "execute",
        "class": "OC\\Core\\Command\\Upgrade",
        "type": "->",
        "args": [
          {
            "__class__": "Symfony\\Component\\Console\\Input\\ArgvInput"
          },
          {
            "__class__": "Symfony\\Component\\Console\\Output\\ConsoleOutput"
          }
        ]
      },
      {
        "file": "/3rdparty/symfony/console/Application.php",
        "line": 1009,
        "function": "run",
        "class": "Symfony\\Component\\Console\\Command\\Command",
        "type": "->",
        "args": [
          {
            "__class__": "Symfony\\Component\\Console\\Input\\ArgvInput"
          },
          {
            "__class__": "Symfony\\Component\\Console\\Output\\ConsoleOutput"
          }
        ]
      },
      {
        "file": "/3rdparty/symfony/console/Application.php",
        "line": 273,
        "function": "doRunCommand",
        "class": "Symfony\\Component\\Console\\Application",
        "type": "->",
        "args": [
          {
            "installer": {
              "__class__": "OC\\Installer"
            },
            "__class__": "OC\\Core\\Command\\Upgrade"
          },
          {
            "__class__": "Symfony\\Component\\Console\\Input\\ArgvInput"
          },
          {
            "__class__": "Symfony\\Component\\Console\\Output\\ConsoleOutput"
          }
        ]
      },
      {
        "file": "/3rdparty/symfony/console/Application.php",
        "line": 149,
        "function": "doRun",
        "class": "Symfony\\Component\\Console\\Application",
        "type": "->",
        "args": [
          {
            "__class__": "Symfony\\Component\\Console\\Input\\ArgvInput"
          },
          {
            "__class__": "Symfony\\Component\\Console\\Output\\ConsoleOutput"
          }
        ]
      },
      {
        "file": "/lib/private/Console/Application.php",
        "line": 215,
        "function": "run",
        "class": "Symfony\\Component\\Console\\Application",
        "type": "->",
        "args": [
          {
            "__class__": "Symfony\\Component\\Console\\Input\\ArgvInput"
          },
          {
            "__class__": "Symfony\\Component\\Console\\Output\\ConsoleOutput"
          }
        ]
      },
      {
        "file": "/console.php",
        "line": 100,
        "function": "run",
        "class": "OC\\Console\\Application",
        "type": "->",
        "args": []
      },
      {
        "file": "/occ",
        "line": 11,
        "args": [
          "/console.php"
        ],
        "function": "require_once"
      }
    ],
    "File": "/lib/private/DB/MigrationService.php",
    "Line": 430,
    "Previous": {
      "Exception": "Doctrine\\DBAL\\Exception\\InvalidFieldNameException",
      "Message": "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'used' in 'field list'",
      "Code": 1054,
      "Trace": [
        {
          "file": "/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1728,
          "function": "convert",
          "class": "Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter",
          "type": "->",
          "args": [
            {
              "__class__": "Doctrine\\DBAL\\Driver\\PDO\\Exception"
            },
            {
              "__class__": "Doctrine\\DBAL\\Query"
            }
          ]
        },
        {
          "file": "/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1667,
          "function": "handleDriverException",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->",
          "args": [
            {
              "__class__": "Doctrine\\DBAL\\Driver\\PDO\\Exception"
            },
            {
              "__class__": "Doctrine\\DBAL\\Query"
            }
          ]
        },
        {
          "file": "/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1146,
          "function": "convertExceptionDuringQuery",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->",
          "args": [
            {
              "__class__": "Doctrine\\DBAL\\Driver\\PDO\\Exception"
            },
            "UPDATE `oc_esignature_sessions` SET `is_downloaded` = `used`",
            [],
            []
          ]
        },
        {
          "file": "/lib/private/DB/Connection.php",
          "line": 257,
          "function": "executeStatement",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->",
          "args": [
            "UPDATE `oc_esignature_sessions` SET `is_downloaded` = `used`",
            [],
            []
          ]
        },
        {
          "file": "/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
          "line": 213,
          "function": "executeStatement",
          "class": "OC\\DB\\Connection",
          "type": "->",
          "args": [
            "UPDATE `oc_esignature_sessions` SET `is_downloaded` = `used`",
            [],
            []
          ]
        },
        {
          "file": "/lib/private/DB/QueryBuilder/QueryBuilder.php",
          "line": 287,
          "function": "execute",
          "class": "Doctrine\\DBAL\\Query\\QueryBuilder",
          "type": "->",
          "args": []
        },
        {
          "file": "/apps/electronicsignatures/lib/Migration/Version010300Date20210702111934.php",
          "line": 51,
          "function": "execute",
          "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
          "type": "->",
          "args": []
        },
        {
          "file": "/lib/private/DB/MigrationService.php",
          "line": 548,
          "function": "postSchemaChange",
          "class": "OCA\\ElectronicSignatures\\Migration\\Version010300Date20210702111934",
          "type": "->",
          "args": [
            {
              "__class__": "OC\\Migration\\SimpleOutput"
            },
            {
              "__class__": "Closure"
            },
            {
              "tablePrefix": "oc_"
            }
          ]
        },
        {
          "file": "/lib/private/DB/MigrationService.php",
          "line": 426,
          "function": "executeStep",
          "class": "OC\\DB\\MigrationService",
          "type": "->",
          "args": [
            "010300Date20210702111934",
            false
          ]
        },
        {
          "file": "/lib/private/legacy/OC_App.php",
          "line": 993,
          "function": "migrate",
          "class": "OC\\DB\\MigrationService",
          "type": "->",
          "args": []
        },
        {
          "file": "/lib/private/Updater.php",
          "line": 340,
          "function": "updateApp",
          "class": "OC_App",
          "type": "::",
          "args": [
            "*** sensitive parameters replaced ***"
          ]
        },
        {
          "file": "/lib/private/Updater.php",
          "line": 260,
          "function": "doAppUpgrade",
          "class": "OC\\Updater",
          "type": "->",
          "args": []
        },
        {
          "file": "/lib/private/Updater.php",
          "line": 132,
          "function": "doUpgrade",
          "class": "OC\\Updater",
          "type": "->",
          "args": [
            "21.0.2.1",
            "21.0.2.1"
          ]
        },
        {
          "file": "/core/Command/Upgrade.php",
          "line": 255,
          "function": "upgrade",
          "class": "OC\\Updater",
          "type": "->",
          "args": []
        },
        {
          "file": "/3rdparty/symfony/console/Command/Command.php",
          "line": 255,
          "function": "execute",
          "class": "OC\\Core\\Command\\Upgrade",
          "type": "->",
          "args": [
            {
              "__class__": "Symfony\\Component\\Console\\Input\\ArgvInput"
            },
            {
              "__class__": "Symfony\\Component\\Console\\Output\\ConsoleOutput"
            }
          ]
        },
        {
          "file": "/3rdparty/symfony/console/Application.php",
          "line": 1009,
          "function": "run",
          "class": "Symfony\\Component\\Console\\Command\\Command",
          "type": "->",
          "args": [
            {
              "__class__": "Symfony\\Component\\Console\\Input\\ArgvInput"
            },
            {
              "__class__": "Symfony\\Component\\Console\\Output\\ConsoleOutput"
            }
          ]
        },
        {
          "file": "/3rdparty/symfony/console/Application.php",
          "line": 273,
          "function": "doRunCommand",
          "class": "Symfony\\Component\\Console\\Application",
          "type": "->",
          "args": [
            {
              "installer": {
                "__class__": "OC\\Installer"
              },
              "__class__": "OC\\Core\\Command\\Upgrade"
            },
            {
              "__class__": "Symfony\\Component\\Console\\Input\\ArgvInput"
            },
            {
              "__class__": "Symfony\\Component\\Console\\Output\\ConsoleOutput"
            }
          ]
        },
        {
          "file": "/3rdparty/symfony/console/Application.php",
          "line": 149,
          "function": "doRun",
          "class": "Symfony\\Component\\Console\\Application",
          "type": "->",
          "args": [
            {
              "__class__": "Symfony\\Component\\Console\\Input\\ArgvInput"
            },
            {
              "__class__": "Symfony\\Component\\Console\\Output\\ConsoleOutput"
            }
          ]
        },
        {
          "file": "/lib/private/Console/Application.php",
          "line": 215,
          "function": "run",
          "class": "Symfony\\Component\\Console\\Application",
          "type": "->",
          "args": [
            {
              "__class__": "Symfony\\Component\\Console\\Input\\ArgvInput"
            },
            {
              "__class__": "Symfony\\Component\\Console\\Output\\ConsoleOutput"
            }
          ]
        },
        {
          "file": "/console.php",
          "line": 100,
          "function": "run",
          "class": "OC\\Console\\Application",
          "type": "->",
          "args": []
        },
        {
          "file": "/occ",
          "line": 11,
          "args": [
            "/console.php"
          ],
          "function": "require_once"
        }
      ],
      "File": "/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php",
      "Line": 65,
      "Previous": {
        "Exception": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
        "Message": "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'used' in 'field list'",
        "Code": 1054,
        "Trace": [
          {
            "file": "/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php",
            "line": 50,
            "function": "new",
            "class": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
            "type": "::",
            "args": [
              {
                "errorInfo": [
                  "42S22",
                  1054,
                  "Unknown column 'used' in 'field list'"
                ],
                "__class__": "PDOException"
              }
            ]
          },
          {
            "file": "/3rdparty/doctrine/dbal/src/Connection.php",
            "line": 1144,
            "function": "exec",
            "class": "Doctrine\\DBAL\\Driver\\PDO\\Connection",
            "type": "->",
            "args": [
              "UPDATE `oc_esignature_sessions` SET `is_downloaded` = `used`"
            ]
          },
          {
            "file": "/lib/private/DB/Connection.php",
            "line": 257,
            "function": "executeStatement",
            "class": "Doctrine\\DBAL\\Connection",
            "type": "->",
            "args": [
              "UPDATE `oc_esignature_sessions` SET `is_downloaded` = `used`",
              [],
              []
            ]
          },
          {
            "file": "/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
            "line": 213,
            "function": "executeStatement",
            "class": "OC\\DB\\Connection",
            "type": "->",
            "args": [
              "UPDATE `oc_esignature_sessions` SET `is_downloaded` = `used`",
              [],
              []
            ]
          },
          {
            "file": "/lib/private/DB/QueryBuilder/QueryBuilder.php",
            "line": 287,
            "function": "execute",
            "class": "Doctrine\\DBAL\\Query\\QueryBuilder",
            "type": "->",
            "args": []
          },
          {
            "file": "/apps/electronicsignatures/lib/Migration/Version010300Date20210702111934.php",
            "line": 51,
            "function": "execute",
            "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
            "type": "->",
            "args": []
          },
          {
            "file": "/lib/private/DB/MigrationService.php",
            "line": 548,
            "function": "postSchemaChange",
            "class": "OCA\\ElectronicSignatures\\Migration\\Version010300Date20210702111934",
            "type": "->",
            "args": [
              {
                "__class__": "OC\\Migration\\SimpleOutput"
              },
              {
                "__class__": "Closure"
              },
              {
                "tablePrefix": "oc_"
              }
            ]
          },
          {
            "file": "/lib/private/DB/MigrationService.php",
            "line": 426,
            "function": "executeStep",
            "class": "OC\\DB\\MigrationService",
            "type": "->",
            "args": [
              "010300Date20210702111934",
              false
            ]
          },
          {
            "file": "/lib/private/legacy/OC_App.php",
            "line": 993,
            "function": "migrate",
            "class": "OC\\DB\\MigrationService",
            "type": "->",
            "args": []
          },
          {
            "file": "/lib/private/Updater.php",
            "line": 340,
            "function": "updateApp",
            "class": "OC_App",
            "type": "::",
            "args": [
              "*** sensitive parameters replaced ***"
            ]
          },
          {
            "file": "/lib/private/Updater.php",
            "line": 260,
            "function": "doAppUpgrade",
            "class": "OC\\Updater",
            "type": "->",
            "args": []
          },
          {
            "file": "/lib/private/Updater.php",
            "line": 132,
            "function": "doUpgrade",
            "class": "OC\\Updater",
            "type": "->",
            "args": [
              "21.0.2.1",
              "21.0.2.1"
            ]
          },
          {
            "file": "/core/Command/Upgrade.php",
            "line": 255,
            "function": "upgrade",
            "class": "OC\\Updater",
            "type": "->",
            "args": []
          },
          {
            "file": "/3rdparty/symfony/console/Command/Command.php",
            "line": 255,
            "function": "execute",
            "class": "OC\\Core\\Command\\Upgrade",
            "type": "->",
            "args": [
              {
                "__class__": "Symfony\\Component\\Console\\Input\\ArgvInput"
              },
              {
                "__class__": "Symfony\\Component\\Console\\Output\\ConsoleOutput"
              }
            ]
          },
          {
            "file": "/3rdparty/symfony/console/Application.php",
            "line": 1009,
            "function": "run",
            "class": "Symfony\\Component\\Console\\Command\\Command",
            "type": "->",
            "args": [
              {
                "__class__": "Symfony\\Component\\Console\\Input\\ArgvInput"
              },
              {
                "__class__": "Symfony\\Component\\Console\\Output\\ConsoleOutput"
              }
            ]
          },
          {
            "file": "/3rdparty/symfony/console/Application.php",
            "line": 273,
            "function": "doRunCommand",
            "class": "Symfony\\Component\\Console\\Application",
            "type": "->",
            "args": [
              {
                "installer": {
                  "__class__": "OC\\Installer"
                },
                "__class__": "OC\\Core\\Command\\Upgrade"
              },
              {
                "__class__": "Symfony\\Component\\Console\\Input\\ArgvInput"
              },
              {
                "__class__": "Symfony\\Component\\Console\\Output\\ConsoleOutput"
              }
            ]
          },
          {
            "file": "/3rdparty/symfony/console/Application.php",
            "line": 149,
            "function": "doRun",
            "class": "Symfony\\Component\\Console\\Application",
            "type": "->",
            "args": [
              {
                "__class__": "Symfony\\Component\\Console\\Input\\ArgvInput"
              },
              {
                "__class__": "Symfony\\Component\\Console\\Output\\ConsoleOutput"
              }
            ]
          },
          {
            "file": "/lib/private/Console/Application.php",
            "line": 215,
            "function": "run",
            "class": "Symfony\\Component\\Console\\Application",
            "type": "->",
            "args": [
              {
                "__class__": "Symfony\\Component\\Console\\Input\\ArgvInput"
              },
              {
                "__class__": "Symfony\\Component\\Console\\Output\\ConsoleOutput"
              }
            ]
          },
          {
            "file": "/console.php",
            "line": 100,
            "function": "run",
            "class": "OC\\Console\\Application",
            "type": "->",
            "args": []
          },
          {
            "file": "/occ",
            "line": 11,
            "args": [
              "/console.php"
            ],
            "function": "require_once"
          }
        ],
        "File": "/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php",
        "Line": 26,
        "Previous": {
          "Exception": "PDOException",
          "Message": "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'used' in 'field list'",
          "Code": "42S22",
          "Trace": [
            {
              "file": "/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php",
              "line": 44,
              "function": "exec",
              "class": "PDO",
              "type": "->",
              "args": [
                "UPDATE `oc_esignature_sessions` SET `is_downloaded` = `used`"
              ]
            },
            {
              "file": "/3rdparty/doctrine/dbal/src/Connection.php",
              "line": 1144,
              "function": "exec",
              "class": "Doctrine\\DBAL\\Driver\\PDO\\Connection",
              "type": "->",
              "args": [
                "UPDATE `oc_esignature_sessions` SET `is_downloaded` = `used`"
              ]
            },
            {
              "file": "/lib/private/DB/Connection.php",
              "line": 257,
              "function": "executeStatement",
              "class": "Doctrine\\DBAL\\Connection",
              "type": "->",
              "args": [
                "UPDATE `oc_esignature_sessions` SET `is_downloaded` = `used`",
                [],
                []
              ]
            },
            {
              "file": "/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
              "line": 213,
              "function": "executeStatement",
              "class": "OC\\DB\\Connection",
              "type": "->",
              "args": [
                "UPDATE `oc_esignature_sessions` SET `is_downloaded` = `used`",
                [],
                []
              ]
            },
            {
              "file": "/lib/private/DB/QueryBuilder/QueryBuilder.php",
              "line": 287,
              "function": "execute",
              "class": "Doctrine\\DBAL\\Query\\QueryBuilder",
              "type": "->",
              "args": []
            },
            {
              "file": "/apps/electronicsignatures/lib/Migration/Version010300Date20210702111934.php",
              "line": 51,
              "function": "execute",
              "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
              "type": "->",
              "args": []
            },
            {
              "file": "/lib/private/DB/MigrationService.php",
              "line": 548,
              "function": "postSchemaChange",
              "class": "OCA\\ElectronicSignatures\\Migration\\Version010300Date20210702111934",
              "type": "->",
              "args": [
                {
                  "__class__": "OC\\Migration\\SimpleOutput"
                },
                {
                  "__class__": "Closure"
                },
                {
                  "tablePrefix": "oc_"
                }
              ]
            },
            {
              "file": "/lib/private/DB/MigrationService.php",
              "line": 426,
              "function": "executeStep",
              "class": "OC\\DB\\MigrationService",
              "type": "->",
              "args": [
                "010300Date20210702111934",
                false
              ]
            },
            {
              "file": "/lib/private/legacy/OC_App.php",
              "line": 993,
              "function": "migrate",
              "class": "OC\\DB\\MigrationService",
              "type": "->",
              "args": []
            },
            {
              "file": "/lib/private/Updater.php",
              "line": 340,
              "function": "updateApp",
              "class": "OC_App",
              "type": "::",
              "args": [
                "*** sensitive parameters replaced ***"
              ]
            },
            {
              "file": "/lib/private/Updater.php",
              "line": 260,
              "function": "doAppUpgrade",
              "class": "OC\\Updater",
              "type": "->",
              "args": []
            },
            {
              "file": "/lib/private/Updater.php",
              "line": 132,
              "function": "doUpgrade",
              "class": "OC\\Updater",
              "type": "->",
              "args": [
                "21.0.2.1",
                "21.0.2.1"
              ]
            },
            {
              "file": "/core/Command/Upgrade.php",
              "line": 255,
              "function": "upgrade",
              "class": "OC\\Updater",
              "type": "->",
              "args": []
            },
            {
              "file": "/3rdparty/symfony/console/Command/Command.php",
              "line": 255,
              "function": "execute",
              "class": "OC\\Core\\Command\\Upgrade",
              "type": "->",
              "args": [
                {
                  "__class__": "Symfony\\Component\\Console\\Input\\ArgvInput"
                },
                {
                  "__class__": "Symfony\\Component\\Console\\Output\\ConsoleOutput"
                }
              ]
            },
            {
              "file": "/3rdparty/symfony/console/Application.php",
              "line": 1009,
              "function": "run",
              "class": "Symfony\\Component\\Console\\Command\\Command",
              "type": "->",
              "args": [
                {
                  "__class__": "Symfony\\Component\\Console\\Input\\ArgvInput"
                },
                {
                  "__class__": "Symfony\\Component\\Console\\Output\\ConsoleOutput"
                }
              ]
            },
            {
              "file": "/3rdparty/symfony/console/Application.php",
              "line": 273,
              "function": "doRunCommand",
              "class": "Symfony\\Component\\Console\\Application",
              "type": "->",
              "args": [
                {
                  "installer": {
                    "__class__": "OC\\Installer"
                  },
                  "__class__": "OC\\Core\\Command\\Upgrade"
                },
                {
                  "__class__": "Symfony\\Component\\Console\\Input\\ArgvInput"
                },
                {
                  "__class__": "Symfony\\Component\\Console\\Output\\ConsoleOutput"
                }
              ]
            },
            {
              "file": "/3rdparty/symfony/console/Application.php",
              "line": 149,
              "function": "doRun",
              "class": "Symfony\\Component\\Console\\Application",
              "type": "->",
              "args": [
                {
                  "__class__": "Symfony\\Component\\Console\\Input\\ArgvInput"
                },
                {
                  "__class__": "Symfony\\Component\\Console\\Output\\ConsoleOutput"
                }
              ]
            },
            {
              "file": "/lib/private/Console/Application.php",
              "line": 215,
              "function": "run",
              "class": "Symfony\\Component\\Console\\Application",
              "type": "->",
              "args": [
                {
                  "__class__": "Symfony\\Component\\Console\\Input\\ArgvInput"
                },
                {
                  "__class__": "Symfony\\Component\\Console\\Output\\ConsoleOutput"
                }
              ]
            },
            {
              "file": "/console.php",
              "line": 100,
              "function": "run",
              "class": "OC\\Console\\Application",
              "type": "->",
              "args": []
            },
            {
              "file": "/occ",
              "line": 11,
              "args": [
                "/console.php"
              ],
              "function": "require_once"
            }
          ],
          "File": "/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php",
          "Line": 44
        }
      }
    },
    "CustomMessage": "--"
  },
  "userAgent": "--",
  "version": "21.0.2.1"
}
Kenneth-w commented 3 years ago

Everything is as default from installation. I checked the config.php file. I saw the following excerpt: 'maintenance' => false, 'theme' => '', 'loglevel' => 2,

Should this be increased this to 3 or 4 ?

tpalts commented 3 years ago

@Kenneth-w Don't bother with the logs. I already got what I need form @acsfer 's comment.

Which version of the plugin do you currently have installed?

Kenneth-w commented 3 years ago

Looking at the installed apps list via the command line - it says V1.1.0

Kenneth-w commented 3 years ago

Is there anything I can do to just bring the installation back online. I haven't really applied the electronic signature and so - would be fine to revert back to the previous version. Basically I just want to be able to get access back to my installation. Does anyone have some advice on how that could be done without having to do a re-install.

Thanks

solracsf commented 3 years ago

Try disable the app trough occ like

occ app:disable electronicsignatures

Kenneth-w commented 3 years ago

@acsfer Thank you so much. The command basically worked but just had to make sure to be in the NextCloud installation directory and then execute the following: sudo -u www-data php occ app:disable electronicsignatures The command has to be run using the web user - as explained here - https://help.nextcloud.com/t/occ-command-not-found/54852/4 The response after running the command was:

Nextcloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade
electronicsignatures 1.4.0 disabled

So may be the version was 1.4.0 @tpalts (?) Anyway, thanks for your help @acsfer and @tpalts - really appreciate you taking the time to consider this problem

solracsf commented 3 years ago

Don't close this as this is not solved please.

tpalts commented 3 years ago

@acsfer please try updating again. We made a new release (v1.5.1) that should fix this issue.

solracsf commented 3 years ago

v1.5.2 fixed the issue @tpalts