Upgrade from TeamPass 3.0.0.22 to 3.1.2.12 - Some Items gone

[kultur-burgenland]

Hi, I'd like to share my experience, including challenges, with upgrading TeamPass from version 3.0.0.22 to 3.1.2.12. 🙂

Steps to Reproduce

1. I copied all files from version 3.1.2.12 into my TeamPass folder.
2. Attempting to start the upgrade in my test environment failed on the first upgrade screen, resulting in a JSON error displayed in the developer console. Fortunately, the solution provided in this GitHub issue comment resolved my issue: https://github.com/nilsteampassnet/TeamPass/issues/3553#issuecomment-1490828271
3. Subsequently, I was able to complete the upgrade process and access my TeamPass instance. However, I encountered several issues, particularly with my AD/LDAP configuration, which required adjustments. More on that later.
4. As admin, I manually started all the tasks ("Remove orphaned items", "Recreate cash" and so on...) and set up routines for them.
5. With all non-critical functionalities working as expected, I proceeded to update my production environment.
6. A few hours post-update, a colleague reported missing entries within a folder (not a private one, but one several people had access to). An investigation and comparison between the updated and original databases revealed that approximately 70 of my ~3500 items, including their related log entries, were missing. At first I thought this happened during the upgrade, but after a second test I found out, that executing the tasks deletes the items.
7. Despite examining these entries, no clear pattern emerged regarding their deletion. They varied in description, email addresses, URLs, and passwords / password characters, including special characters like !, ?, and @.

Following this, I manually recreated one of the missing items, which subsequently seemed to interfere with the cron job execution, leading to an error when accessing the "Task" menu as an admin, which I did not encounter before creating the item:

DataTables warning: table id=table-tasks_in_progress - Ajax error.
For more information about this error, please see http:// datatables.net/tn/7

Those were the only warnings I got: PHP Warning: Undefined array key 1 in /home/teampass/public_html/TeamPass/pages/tasks.php on line 232, referer: http://192.168.0.207/teampass/index.php?page=tasks PHP Warning: Undefined array key 1 in /home/teampass/public_html/TeamPass/pages/tasks.php on line 260, referer: http://192.168.0.207/teampass/index.php?page=tasks PHP Warning: Undefined array key 1 in /home/teampass/public_html/TeamPass/pages/tasks.php on line 282, referer: http://192.168.0.207/teampass/index.php?page=tasks PHP Warning: Undefined array key 1 in /home/teampass/public_html/TeamPass/pages/tasks.php on line 326, referer: http://192.168.0.207/teampass/index.php?page=tasks

After that I rolled back to the old version.

Additional issues encountered with the new installation include:

• Enabling HTTPS_Strict_Transport resulted in endless redirections and timeout, despite working in version 3.0.0.22 and including SSLOptions +StdEnvVars +ExportCertData in my Apache configuration as advised. Probably the same issue here: https://github.com/nilsteampassnet/TeamPass/issues/4072
• Occasionally, creating or deleting folders would not refresh the folder list, showing only "root" and "undefined" instead. Refreshing the page solves the issue for some time.
• The logout button was unresponsive on mobile devices (specifically, iPhone with the latest iOS and Brave Browser/Webkit).

Server configuration

Operating system: Ubuntu Server 22.04 Web server: Apache 2.4.52 Database: MariaDB 10.6.16 PHP version: 8.1.27 Teampass version: 3.0.0.22 -> 3.1.2.12 Teampass configuration file: - Updated from an older Teampass or fresh install: Update