2021.7.20 Update Failure

marius-wieschollek / passwords

A simple, yet feature rich password manager for Nextcloud

GNU Affero General Public License v3.0

215 stars 45 forks source link

2021.7.20 Update Failure #393

Closed RJ-Make closed 3 years ago

RJ-Make commented 3 years ago

System Information

Nextcloud Version: 21.0.3 PHP Version: 7.4.3 Server OS and Version: ostgreSQL 12.7 (Ubuntu 12.7-0ubuntu0.20.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0, 64-bit

Passwords Version: 2021.6.20

Steps to reproduce

Install 2021.7.20 update via NC Web App Interface

Expected result

Install Succeed.

Actual result

Failure. From there I'm locked out. Tried updating via the VM command line update, but I don't think that is the proper way.

orlovnv commented 3 years ago

have the same problem, An exception occurred while executing a query: SQLSTATE[42P07]: Duplicate table: 7 ERROR: relation "pw_password_index" already exists

marius-wieschollek commented 3 years ago

I just published the nightly 2021.7.21-build4188 to the appstore. Can you confirm that it fixes the issue?

NemoNumquam commented 3 years ago

I have just tried to install passwords and get this error "An exception occurred while executing 'SELECT a.* FROM oc_passwords_entity_challenge a': SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextCloudDB.oc_passwords_entity_challenge' doesn't exist " It would appear that the tables created do not have "entity" in the name. I am using mysql v8

marius-wieschollek commented 3 years ago

I published a nightly which should also fix that.

staeglis commented 3 years ago

The issue still persists:

$ sudo -u www-data /var/www/html/occ app:enable passwords -n
An exception occurred while executing 'CREATE UNIQUE INDEX pw_password_index ON oc_passwords_password (user_id, uuid)':

SQLSTATE[42P07]: Duplicate table: 7 FEHLER:  Relation »pw_password_index« existiert bereits

marius-wieschollek commented 3 years ago

@staeglis Which build did you try?

staeglis commented 3 years ago

@marius-wieschollek Sorry I haven't seen the right link. With this build it's working: https://git.mdns.eu/nextcloud/passwords/-/jobs/12554/artifacts/raw/passwords.tar.gz

marius-wieschollek commented 3 years ago

Ok. I merged it and the update should be available in the appstore in a few minutes.

r3pek commented 3 years ago

@marius-wieschollek I don't thing this is fixed yet. I was just running the update and hit the same problem. I've downloaded the version available on the apps.nextcloud.com website (job 12568) and it still doesn't upgrade correctly. I get 4 of this errors on the upgrade:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY'

All of them trying to re'INSERT an entry into the passwords_folder table.

marius-wieschollek commented 3 years ago

@r3pek This does not seem to be the same error. Please make a separate bug report for this issue.

gcclinux commented 3 years ago

Hello,

I am still seeing the same error, has there been any more updates that I missed?

$ sudo -u www-data php occ app:enable passwords
An exception occurred while executing a query: SQLSTATE[42P07]: Duplicate table: 7 ERROR:  relation "pw_password_index" already exists

Many Thanks

gcclinux commented 3 years ago

Hello, i can confirm it worked and passwords is once more fully functioning but I had to restore the password from a backup as they had all gone.

At least I the app works again and the restore also.

Thank you