Passwords empty after upgrade from 2.1.26 to 2.1.27

[prozit]

Steps to reproduce

1. Upgrade from 2.1.26 final 3 to 2.1.27.x (tried with 2.1.27.1, 2.1.27.25 and 2.1.27.26)
2. Login to Teampass after the upgrade
3. Open an existing entry and look for the password

Expected behaviour

The password should be in the password fields (when entering the entry itself) or on the bottom screen (showing stars).

Actual behaviour

There are no stars and there is now password in both password fields when entering the entry itself

Server configuration

Operating system: Linux backend 4.4.59+ #23824 SMP PREEMPT Fri Oct 12 18:31:34 CST 2018 x86_64

Web server: nginx/1.13.3

Database: MariaDB 10.3.7

PHP version: 7.0.30

Teampass version: 2.1.26 final 3

Teampass configuration file: ./includes/config/settings.php

[nilsteampassnet]

BEfore upgrading, run the next SQL query ALTER TABLE `teampass_misc` CHANGE `id` `increment_id` INT(12) NOT NULL AUTO_INCREMENT;

[prozit]

When I run this SQL query, I receive the following error: 1054 - Unknown column 'id' in 'teampass_misc', Time: 0.003000s

When I check the fields of this table, there is no field called id. Is this query intended for another table of should this field be added to this table.

Btw, I am stunned by the fantastic fast way you are responding !

Thanks, Francis.

[nilsteampassnet]

Thank you

OK run query

''' ALTER TABLE teampass_misc ADD increment_id INT(12) NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (id); '''

I need to investigate why those queries are not always performed during upgrade

[prozit]

I changed this query to the following: ALTER TABLE teampass_misc ADD increment_id INT(12) NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (increment_id);

However, this made the upgrade script go into error, since apparently it is indeed adding this field to that table.

After running the upgrade (without running this SQL script) I have checked the design of the table and noticed the new field was indeed added. So I don't think this is not causing my problem.

The upgrade runs fine, and I can see some values in the pw fields, but they are not shown in the application.

Best regards, Francis.

[nilsteampassnet]

Ok so it is not a case that I'm aware of.

Can we have a shared screen session with teamviewer?

Please contact me at [email protected]

[brestows]

Hi I have the same problem. How to upgrade teampass 2.1.26 final 3 to 2.1.27 ?

[dominicblade]

Hi I have the same problem. No id field at teampass_misc table. I've tried add fileds with: ALTER TABLE teampass_misc ADD increment_id INT(12) NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (increment_id); Tried upgrade to 2.1.27.0, 2.1.27.10, 2.1.27 latest

Server configuration Operating system: Centos 7 kernel 4.15.0

Web server: Apache 2.4.6-67

Database: MariaDB 5.5.56

PHP version: 5.6.40

Teampass version: 2.1.26 final 3

[Henrycuenk]

Hello, I'm Henry, and I'm new to this, I have version 2.1.26 working, but I need to update to the newest version, I have tried to update to version 2.1.26 final 3 without problem, but when updating to version 2.1.27 All the passwords in my file were lost and there are a lot of them, is there already a solution to this problem?