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

Cant restore Backup after update to 2021.7.21 #396

Closed schnello closed 3 years ago

schnello commented 3 years ago

Nextcloud 21.0.3 stable

After update to 2021.7.21 no passwords are shown: image

Try to restore a backup fails with this error message: image

marius-wieschollek commented 3 years ago

Can you check if these tables are there:

'passwords_entity_challenge'        
'passwords_entity_folder'           
'passwords_entity_folder_revision'  
'passwords_entity_keychain'         
'passwords_entity_password'         
'passwords_entity_password_revision'
'passwords_entity_registration'     
'passwords_entity_session'          
'passwords_entity_share'            
'passwords_entity_tag'              
'passwords_entity_tag_revision'     
'passwords_relation_password_tag'   
schnello commented 3 years ago

hi.

I checked the tabels and my output is: image

So what i see... all is available.

Greetings

marius-wieschollek commented 3 years ago

That looks like another issue like #395 where the migration was incompletely executed.

schnello commented 3 years ago

Do you have any recommendations how I should proceed here?

schnello commented 3 years ago

Solved my issue. I restore the full database, upgrade NC to 22 .... and rename the tabels manualy to: 'passwords_entity_challenge' => 'passwords_challenge', 'passwords_entity_folder' => 'passwords_folder', 'passwords_entity_folder_revision' => 'passwords_folder_rv', 'passwords_entity_keychain' => 'passwords_keychain', 'passwords_entity_password' => 'passwords_password', 'passwords_entity_password_revision' => 'passwords_password_rv', 'passwords_entity_registration' => 'passwords_pw_tag_rel', 'passwords_entity_session' => 'passwords_registration', 'passwords_entity_share' => 'passwords_session', 'passwords_entity_tag' => 'passwords_share', 'passwords_entity_tag_revision' => 'passwords_tag', 'passwords_relation_password_tag' => 'passwords_tag_rv'