nilsteampassnet / TeamPass

Collaborative Passwords Manager
https://www.teampass.net
1.66k stars 540 forks source link

Lost items after upgrade to 3.1.2 #4135

Open jokerby opened 5 months ago

jokerby commented 5 months ago

Steps to reproduce

  1. Upgrade from 3.1.1 to 3.1.2.
  2. Log into.
  3. Try access to data.

Expected behaviour

Normal access for data placed in DB.

Actual behaviour

Despite the availability of files in the database, part of the data for a specific folder is missing - 23/55. All these records are easily accessible at the database level. An attempt to move manually (a-la UPDATE teampass_items SET id_tree=23 WHERE id=192;) successfully changes the counters, but the data is still not displayed.

Server configuration

Operating system: Debian 12 Web server: Apache/2.4.57 (Debian) Database: 10.11.4-MariaDB-1~deb12u1-log Debian 12 PHP version: 8.2.17 Teampass version: 3.1.2 (master for 10.04) Teampass configuration file: tp.config.txt Updated from an older Teampass or fresh install: Updated from 3.1.1 to 3.1.2 via git pull

Client configuration

**

Browser: Latest FF/Edge. Operating system:** Win10/11.

Logs

No error in web server logs or console.

s1mm0n commented 5 months ago

Hi, we have the same Problem.

It seems as there is an issue with deleted users. In our case in the log_items table is no "at_creation" row for the id from items table.

Might be better described here: https://github.com/nilsteampassnet/TeamPass/issues/4073#issuecomment-2018132325

jokerby commented 5 months ago

Hi, we have the same Problem.

It seems as there is an issue with deleted users. In our case in the log_items table is no "at_creation" row for the id from items table.

Might be better described here: #4073 (comment)

It looks very similar, because at the same time I was trying to fix a problem with resetting accesses (#4134) for a user who was supposed to create "lost" records and who I was re-creating by deleting.