Exception: Database error when running migration latest for app electronicsignatures

Kenneth-w commented 3 years ago

How to use GitHub

Please use the 👍 reaction to show that you are affected by the same issue.
Please don't comment if you have no relevant information to add. It's just extra noise for everyone subscribed to this issue.
Subscribe to receive notifications on status change and new comments.

Steps to reproduce

I installed a the 21.02 stable version of NextCloud as a fresh install.
Installed a number of apps - one of which was the "ElectronicSignature" app
1. I received today a message that an update was available.
Went to the app list and clicked the update & install button next to the app
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 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

``` Insert your browser log here, this could for example include: a) The javascript console log b) The network log c) ... ```

szaimen commented 3 years ago

Hi there, as this seems to be an issue with the electronicsignature app, Please report this issue to https://github.com/eideasy/nextcloud-electronic-signatures-plugin/. Thanks! :)

Kenneth-w commented 3 years ago

Thanks for the reply

nextcloud / server