Keepass Import: Malformed UTF-8 data - Undefined index: Entry in import.queries.php line 591

[bananatree23]

Page on which it happened

https://<anonym_url>/index.php?page=import

Steps to reproduce

1. Enable the import feature
2. Export a Keepass database to xml and upload it
3. Click on Perform

Expected behaviour

Import of Keepass entries and folders

Actual behaviour

No import of entries or folders

Server configuration

Operating system: Linux 5.4.17-2136.310.7.1.el8uek.x86_64 #2 SMP Wed Aug 17 15:14:08 PDT 2022 x86_64

Web server: Apache/2.4.37 (Oracle Linux) OpenSSL/1.1.1k

Database: 5.5.5-10.3.35-MariaDB

PHP version: 7.4.19

Teampass version: 3.0.0.19

Teampass configuration file:

'max_latest_items' => '10',
'enable_favourites' => '1',
'show_last_items' => '1',
'enable_pf_feature' => '1',
'log_connections' => '1',
'log_accessed' => '0',
'time_format' => 'H:i:s',
'date_format' => 'd/m/Y',
'duplicate_folder' => '0',
'item_duplicate_in_same_folder' => '0',
'duplicate_item' => '0',
'number_of_used_pw' => '3',
'manager_edit' => '1',
'cpassman_dir' => '/var/www/teampass',
'cpassman_url' => 'https://<anonym_url>
'favicon' => 'https://<anonym_url>/favicon.ico',
'path_to_upload_folder' => '/var/www/teampass/upload',
'path_to_files_folder' => '/var/www/teampass/files',
'url_to_files_folder' => 'https://<anonym_url>/files',
'activate_expiration' => '0',
'pw_life_duration' => '0',
'maintenance_mode' => '0',
'enable_sts' => '0',
'encryptClientServer' => '1',
'cpassman_version' => '3.0.0.19',
'ldap_mode' => '1',
'ldap_type' => 'ActiveDirectory',
'ldap_suffix' => '0',
'ldap_domain_dn' => '0',
'ldap_domain_controler' => '0',
'ldap_user_attribute' => 'samaccountname',
'ldap_ssl' => '1',
'ldap_tls' => '0',
'ldap_elusers' => '0',
'ldap_search_base' => '0',
'ldap_port' => '636',
'richtext' => '0',
'allow_print' => '0',
'roles_allowed_to_print' => '0',
'show_description' => '1',
'anyone_can_modify' => '0',
'anyone_can_modify_bydefault' => '0',
'nb_bad_authentication' => '0',
'utf8_enabled' => '1',
'restricted_to' => '0',
'restricted_to_roles' => '0',
'enable_send_email_on_user_login' => '0',
'enable_user_can_create_folders' => '0',
'insert_manual_entry_item_history' => '0',
'enable_kb' => '0',
'enable_email_notification_on_item_shown' => '0',
'enable_email_notification_on_user_pw_change' => '0',
'custom_logo' => '',
'custom_login_text' => '',
'default_language' => 'english',
'send_stats' => '0',
'send_statistics_items' => 'stat_country;stat_users;stat_items;stat_items_shared;stat_folders;stat_folders_shared;stat_admins;stat_managers;stat_ro;stat_mysqlversion;stat_phpversion;stat_teampassversion;stat_languages;stat_kb;stat_suggestion;stat_customfields;stat_api;stat_2fa;stat_agses;stat_duo;stat_ldap;stat_syslog;stat_stricthttps;stat_fav;stat_pf;',
'send_stats_time' => '1657703943',
'get_tp_info' => '1',
'send_mail_on_user_login' => '0',
'nb_items_by_query' => 'auto',
'enable_delete_after_consultation' => '0',
'enable_personal_saltkey_cookie' => '0',
'personal_saltkey_cookie_duration' => '31',
'email_smtp_server' => '<removed>'
'email_smtp_auth' => '1',
'email_auth_username' => '<removed>'
'email_auth_pwd' => '<removed>'
'email_port' => '25',
'email_security' => 'none',
'email_server_url' => '',
'email_from' => '<removed>'
'email_from' => '<removed>'
'pwd_maximum_length' => '64',
'google_authentication' => '0',
'delay_item_edition' => '0',
'allow_import' => '1',
'proxy_ip' => '<removed>'
'proxy_port' => '',
'upload_maxfilesize' => '64mb',
'upload_docext' => 'doc,docx,dotx,xls,xlsx,xltx,rtf,csv,txt,pdf,ppt,pptx,pot,dotx,xltx',
'upload_imagesext' => 'jpg,jpeg,gif,png',
'upload_pkgext' => '7z,rar,tar,zip',
'upload_otherext' => 'sql,xml',
'upload_imageresize_options' => '1',
'upload_imageresize_width' => '800',
'upload_imageresize_height' => '600',
'upload_imageresize_quality' => '90',
'use_md5_password_as_salt' => '0',
'ga_website_name' => 'TeamPass for ChangeMe',
'api' => '0',
'subfolder_rights_as_parent' => '1',
'show_only_accessible_folders' => '0',
'enable_suggestion' => '0',
'otv_expiration_period' => '7',
'default_session_expiration_time' => '30',
'duo' => '0',
'enable_server_password_change' => '0',
'ldap_object_class' => '0',
'bck_script_path' => '/var/www/teampass/backups',
'bck_script_filename' => 'bck_teampass',
'syslog_enable' => '0',
'syslog_host' => 'localhost',
'syslog_port' => '514',
'manager_move_item' => '1',
'create_item_without_password' => '1',
'otv_is_enabled' => '0',
'agses_authentication_enabled' => '0',
'item_extra_fields' => '0',
'saltkey_ante_2127' => 'none',
'migration_to_2127' => 'done',
'files_with_defuse' => 'done',
'timezone' => 'Europe/Berlin',
'enable_attachment_encryption' => '1',
'personal_saltkey_security_level' => '50',
'ldap_new_user_is_administrated_by' => '0',
'disable_show_forgot_pwd_link' => '1',
'offline_key_level' => '60',
'enable_http_request_login' => '0',
'ldap_and_local_authentication' => '1',
'secure_display_image' => '1',
'upload_zero_byte_file' => '1',
'upload_all_extensions_file' => '0',
'bck_script_passkey' => '<removed>'
'admin_2fa_required' => '0',
'password_overview_delay' => '4',
'copy_to_clipboard_small_icons' => '1',
'duo_akey' => '',
'duo_ikey' => '',
'duo_skey' => '',
'duo_host' => '',
'teampass_version' => '',
'roles_allowed_to_print_select' => '',
'clipboard_life_duration' => '15',
'mfa_for_roles' => '',
'tree_counters' => '0',
'settings_offline_mode' => '0',
'settings_tree_counters' => '0',
'enable_massive_move_delete' => '1',
'email_debug_level' => '0',
'ga_reset_by_user' => '',
'onthefly-backup-key' => '<removed>'
'onthefly-restore-key' => '<removed>'
'ldap_user_dn_attribute' => 'distinguishedname',
'ldap_dn_additional_user_dn' => 'ou=<anonym>,ou=<anonym>,ou=<anonym>,ou=<anonym>',
'ldap_user_object_filter' => '(&(memberOf:1.2.840.113556.1.4.1941:=cn=<anonym>,ou=<anonym>,ou=<anonym>,ou=<anonym>,ou=<anonym>,dc=<anonym>,dc=<anonym>)(!objectClass=group))',
'ldap_bdn' => 'dc=<anonym>,dc=<anonym>',
'ldap_hosts' => '<removed>'
'ldap_password' => '<removed>'
'ldap_username' => 'cn=<anonym>,cn=<anonym>,dc=<anonym>,dc=<anonym>',
'api_token_duration' => '60',
'enable_tasks_manager' => '0',
'task_maximum_run_time' => '300',
'tasks_manager_refreshing_period' => '20',
'maximum_number_of_items_to_treat' => '100',
'ldap_new_user_role' => '13',
'can_create_root_folder' => '1',

Updated from an older Teampass or fresh install: Updated from 3.0.0.17 or .18 I believe

Client configuration

Browser: Chrome, Firefox, Edge

Operating system: Windows 10 & 11

Logs

Next error occurred
Error: Malformed UTF-8 data

Log from the web-browser developer console (CTRL + SHIFT + i)

import.queries.php

<br />
<b>Notice</b>:  Undefined index: Entry in <b>/var/www/teampass/sources/import.queries.php</b> on line <b>591</b><br />
eyJjaXBoZXJ0ZXh0IjoiR1RSbVFqMjFNUTRTUDlSdlhlQkVIQ1ZtYTVJbEZRNE9pOGdWeUk2dlhCXC80eVlXMXJEWW1BdEYzR3g2aFd3SndZMksrS3FFU3hMOW83RXVnNkNreEQ4anNyMEVBTzNoVXo3WXAyOXlTUDdPSFwvTjhwNGwrNmwzRGNzV2MrZUxVbFJEdkJcL2cyaXZ1MFgwOUJQK3hVdHh0bnZuZnhkZVV5Q0syMUZuMmNcL2YzNHVCWUlWcHoyQ0dDR0tNWUlReGFoZktKQjZnOFNEdTNmVnFCTnNvWXlQMTFPZ3lRb083QWQyRGU3XC9yNHlSckJzS3hmZ1RcL2pCOGJJZExmc0UxM3lHdXpaRE53VG13Q0hOb0lLdWlTUVNwV0NRUWM5QnlXUE0zdGJ5TnVMM0VtZG53V1FcL3d1ajloYjRsVG9jTzg0dUc4S0lKcTFReGxhQklWYWRhTG5ibXd1UWRpZ3VlRW83REZQR0Z3a2pRN0dUYnZKZUdOckdHRGU4TEUrelFjWExWWXRLVmZycnd2WFdEMldKa1FVK3FYMWFHNW5jMGVzR3BOcE9ucXUxQXdEVWppUGQ5UDA1Uzg1dTZ3emVnWnVzQnl4TE9UV0F4YWF1UWI5TWN3d05QXC9OK21hNW5EVFlyZ25jeWFVcUNoTE54WXlFUWU1a0Zndm9SSHpQeGQ5bVVrNnNFeUgwXC9YTHJyT3B2S2dqV0crWlR1QkpmczJwV1ZLbklKUTBkY0IrazBieThuVWc4dmFcL2IrUUM0MnRFUitaa0VpdHpxMm9ZT25taFo2ckc4ejNwd2lXc3IyaHJPNmw5WVd4YUljYzBmdkNKekZkQlRBSlVZUDVsYXpwNXBRUXRsWjJ4M1BsNGVzaFc1TWo2TkNQMDFwVXo2TEtYVm1HenVKcXUzMDFcL0tORzhUd1hoZys1Y1NFWkl1Sk4wbFNGT3hzTm9kaHpUVnMyYWNCNnhFQkVIclFCajBURmJyUmVzNTJrN0hRZmxLY3RzRExOTk02OVROVUV6K3ZCMGhYemk2cTgwY0hUeG1sM3pSUEpNamZBbFhJbjdUbUp3XC9WREx4cTdGK0phQktsS0w1bjA4UzYyejdXS0oyWXFRNXJraUFJRlNcLzFPQUlHR2dtWGc5K2VHeVJJTEtlOUVlWERUcTgrVUlQRWRPNEFYRlhFNFVMYnB2eGFRaytzQ25GTCtMbytTM1lhSkJvakVjcUNkK0d4c05yMllLV1Rhak9VNDdqUjhOXC9kSnVIUG1kWXlZM1gxaWNFbGhJcWRvMVR1NnN2c09Kcnh4bGlPMU5pdUFsYUd3aFwvWElmXC8rRzJBcEl5dVwvT1IrN1FvR2RUaFFHTFwvMk9cL0hicWhzRDR1Y1hKcXF0Y1VBZmNrXC9WZjFBMEE1bVFqWUhkdGhid09YbTVHck9Mbk9BSmx3MEE0eU1rYzhzV1o0RmE5OW40eE51WXdyZmZRQnZyVERqTlB4dGdodCtObWR4QTRrME5FYUlYM1dQYm8yWFE3akZ3RElXd0RRUkdZZW9uVUlvV1VlMzJwXC9CMVg3aDc3WTdvakVwZmlFVEJScFwvb3plSVpOdFBtYThpMXNxdHZQOTVteVdoTHRCb2xjU1dadzF3QnpVRTM1OE9JSTd0RHV0anUyQk1hT0o2SVJHcndKbkF0bFwvWTluV1VnNTk5M1o0clV4WUl2bjRSNFo4OG9JSEdvaEIyRlFUSWp1RUVRTjA2NE8zUnlNRGk1OXRIVHdVZE1YeExIU0dwXC9OSDJVNXJcL0ZQd0xcL1ljZXBCYkh6RTdVR2JQOVpZMkN1c2FSMnhKYldSNjhhVkhSWWtXbkVVUDhWZ2M5NDBmeGN0eCtOSWdpU05KVVhvRVZFSWZsKzl4dzB4R2IwMXhrZmhCS2VPSTRrTWRuQTJNdU5jRXZWNEVtb3dZbkN6RHM5UFVsXC91SGNuajdIRkJidzM5dmdWVUczRFAwcmFmM0pKdmtna08xajI5dmg0bW5vS0lXa2pkWXZZSm5VbUFmaTR0QXhhNVA5aGcycGNQbkw0b3VNV2lJK0huV2NPbkhyQWxFMG94WWU0ayt3THRYWldNQjVEUXZYc3IxN1wvRVJpZzloYml6dFwvazkxaSt6WFBrYkhWcGlKRXFBdWl2OTB0dTI3bm5tOWlxajlTeU1rdFBhbmNManhKUUdtUTBRYmYzOVR4eDI3NXZTcWRLNkptc0EydEhxVW1Xc1M2UXQ5b3JPMllNUmEwTzlBT0xaUGxDeGl4Uk1cL2hHeDVHQklmY1pcLzE5QnB5MUhjMkRXcEVjSjZrZnRlOFwvYlBvXC9NSkpyYUZYVUVMTXpDU3dSK25SakNzVEVnc1wvVzNNUStaRFhrWURhNFlCZHlubEg4ZUhab2U4THBKajdWRWcxUzdzUlB4ZDR2MGtldVwvZThFQWphZWhLVlJLVDRvZit4bEtLZlBSQ1lHT0N2WFwvUnFjbFF1OEZiN3Q4OG9rK3c3K2U5VlNpclFvNTQ4YmV0SENmOUpXN0dtZGhNS2tJT0doZDdcLzUrN1laaWFFcFBGc3RoMXErbFFxQWVSOWE5bktBemZSdjhOeUs3anNlYkhOMis2eGMxbWtYSWVhckpaOE5FcVJBUHJLR0FCVDMzRmhRWmFxeVhsaUtBYklYVnZOVnJpZ0lpeW43SnZ5ajF1NlwvNHJtQVNaTzhqQldhS0JSRVZCUlR1cTJFd1IxQ3k5VXVKTFFPUHByRTQyakhOYnFNaXVqaCIsIml2IjoiYTNmYjA1ZDE5NzYwY2RiZjIxNTA5OTY4NjQ2MDcyYmQiLCJzYWx0IjoiY2Q0YWU2Yzk0YTliNGY1M2E5MGNhZWJhMjk2NGY0ZTJmODhkZTJlMWRkZTJlMzdjMGIyNTZhMjg0NWQxYWRjZjNhODZkMWQyNmEzMTI0NDNlOTE4ZjNjMWJmMmI4ZDE2NThjMDI3ZGYxNGVjY2RjMDVjYzJmMThjZTRiYmY0MzFiODcxMzNjMTIwZDY5MTkxMDQxOTNkOTQzNWZjZGQ5NGZkZWVlOGU1ZDI1MDUxMjVlOGI3ZGNkYWU2Y2RiYTU4YmU5NDEzMWZhN2FhMTU3NGZlYzE0NTcyMWRhMDUzNGUxMGQ4ZTgwODNiMGNhNGVjNDM2ZjI3YTdiZDdmODlmYmYwNTQ0NzgxNzc4NzVlZWM2YTJmMWZhZTU5OGQwNjE4YTM3OGQzMjJiZGFjMGRmMjc4NTcwNDRhYjQ3NjJlODNiZjdlYjU3YjA3MDM0NDMyOWQ3ZTVmNTg0YWFmMTg5ZDYxYjQ0YWE2MjhlZTBiNjAyNWFlMzE2NmFlODNmNDk1ZGZkYmRkODhmMTUzNzAzZTFhNDI2Y2ZiMDllZDExMjg4NDBjODk3YTNjNmI1ODI3MmIxYjkyNTU3MTYzYzI0YjBlODVlNDEyNjA3MWJhZWM0MzZmODVjNGQxMzVmZWQ2NDQxZmY1YjMzOTE5YjQ2OWQyYjBlOTI1YWNhOGQ4NzQiLCJpdGVyYXRpb25zIjo5OTl9

[bananatree23]

Some additional info: I have tried out old and new Keepass databases created in version 2.49 and 2.52. Even a new database with only one entry leads to the error. The CSV-Import works, although it creates no additional folders.

[nilsteampassnet]

Hello
Sorry I cannot reproduce.
My Keepass file is created from 2.52 and contains hundreds of items organized into a structure of folders.
All the tests are successful.
I also performed it with the by default Keepass database (the one proposed by default). No error.

I'm curious to get your xml file.

NOte: regarding CSV, it is by design, no folders as explain in documentation.

[bananatree23]

Hello, thank you for the reply. I have uploaded one of the xml files I used for testing (it contains no actual login data).
I will try updating to the latest version as well.
Many thanks!
xml.zip

[bananatree23]

Updating to the latest version has sadly not fixed the issue.

[bananatree23]

After changing the owner of the upload folder from root to my apache user I get a new error message.
I have also generated a new database + a new xml export (xml2.zip)

Error message:
Next error occurred
Error: Malformed UTF-8 data

Raw answer from server:

Notice: Undefined index: folders in /var/www/teampass/sources/import.queries.php on line 713

Fatal error: Uncaught TypeError: filter_var_array() expects parameter 1 to be array, null given in /var/www/teampass/sources/import.queries.php:714 Stack trace: #0 /var/www/teampass/sources/import.queries.php(714): filter_var_array() #1 {main} thrown in /var/www/teampass/sources/import.queries.php on line 714

[bananatree23]

Hello,
after some troubleshooting, it seems to appear that the error only occures when selecting a personal folder as the target folder.
Importing the Keepass database as an xml file to another, not personal, folder works flawlessly.
I get the same results with an LDAP user and a local Teampass user.
All of the folders of my teampass installation have my apache user as the owner. I am also on the latest commit.

After getting the error to occure, I am unable to properly select the "Folders" category and I get the errors provided at the bottom.
Due to snapshots I was easily able to restore my teampass installation. It seems that this error somehow "breaks" the database.
I can reproduce this error, but I sadly do not know what causes it or how you can reproduce it.

Does anyone have the same issue?
Thanks in advance.

Next error occurred
Error: Malformed UTF-8 data

Raw answer from server:

Notice: Trying to access array offset on value of type null in /var/www/teampass/sources/folders.queries.php on line 180

Notice: Trying to access array offset on value of type null in /var/www/teampass/sources/folders.queries.php on line 190

Notice: Trying to access array offset on value of type null in /var/www/teampass/sources/folders.queries.php on line 201

Notice: Trying to access array offset on value of type null in /var/www/teampass/sources/folders.queries.php on line 202
eyJjaXBoZXJ0ZXh0IjoiaklSeFR2RDFzcEV6dFBMeGdTOGdOdGxSZmdrais2WVFiRklIc2dualhVdWs2Sllwdk5pVWRxbzlCeGcrcFNKNENGQWw5WEM5MkhYXC9EYUVhMUtyZzIrc2pheUorc0NJbU0xcVgyK1Y3Q1VqdHc2aUVLNG5yR1lDU0N4THJZeUQ1dG1pMFczRGRqQU56OTNGcUlQZWtsWDF3MXd0QWZxZmFNc003YldRVGN0cWowSG56M1RRSGxPWUt0VDYwd25IUGtka0J2TWVBSWFhSmt3aEtMSHZJdElHUE1GNEw5Q2FVMlZEb3NVMXNXQUhQaElLM0xlZ0xPR28zTzdkck5GNWdMRG51dkMrQmd6ZktETE5uc1BVdzA1UFgrOFRTUWNOaVo4eWZlYmJTS3Z1ZUU5VVMyMXFOWG9YK0gwblhjVmtpQWVEamVtQ0NuOTFWSW4zRng5d2hSSEIyUENaMkF0RVc0R0RJR3VUcGRocHphaWZtXC84V3krMTh3Q0JiZ2I0K3VYRnhrSVRPdGJ3dXliOWhjUGFEOVdaWGI3Mlk5VHFZZXhCazI5ZzNCUjQxMERhb2JxUW5WMTQ4cllNcXZjNzBZM1wvZG1nYTlGdzZIXC9yemN2N1EzMFFyZFJyTlwvMUEwN3V3dWNacEowWUNRR0Z0VnZ3OXBWMXc3dEdLYlwvUStBWVwvaFhPUW9OMGtqNDVpVTFDM2g1elVTSXNjT1JVQ3crVTJCRHBqQTJsajR2NEU5dmFUeGt6RGlodEh5RVhHd1dpWWxqZXExTTMxM25OZFZaVjRlYkVvTzBkOHlcL2hIOUN2M2NQZWRPRVRNQlNyb2dPYXk2UzNqUjU5Vjc3V2s1eGMweU9VYU1BZ0xjOXR6a0k0XC9vdGl2VHRiSjI3S2R0NE5uT3dXeTJNTG5UMGRmbkdGUTVrR2lwcWhXemdUTWp3XC8rME1HOEJYdzhHckl2SU5ZQWtJbkVVcFZRN2JOb1dEM3VDb3BveU5uRStxSkE3XC9NcVFuXC9RRysyaDJjeTRieXVDNmtndmxxeFVjNUxqdVwvN3RpUUt5S251aFFEWWUwTkxEMG9LemJlUkhNNXhPdUlaaVB6dGNQSmx4KzdoYkxvSUtpMDh4d1BuekxRa1UrSGZrVUtzNHNYdTc0SlBHcGFlNlJiK1MybXRlRHlWSE44NUFyblFiRkt6eFRIOTN6OE5jNCt5RGNYSExwRW9aZk55c2tSaWp6MFZXa1VQdTBIRDgrRmtERitoZ213SWFCOElpa1lZZDZWUVBiT3huQ3dFalQ5QkcrSDA2eFZXQzBWY2h2YkJOZFdEcVRTaURpbk03R25CKzY2NjdjUVBnVnI3WkRyMXFJVHhyV1hQazNKNWlVM1p1ZVNpWTUrVEFhcXZoYVp2eWVIa1pmS3FcLzRlUThVaTJ5SG05VzNlQjlXT1h4NmhhaVVPVUZpRG9ZTGk2SXhUQlwvTlRqV0hwcm5RMFRPdkFHcE5EYzZKZ3lXdEFEenVmeURBZFA0VWxMN3VwRFBIOUtHNFwvbEpCbnFOVUh4Q0dsbU1BeEdmOGhYRHE1Y2MyNUZhNXNaTFhDVDYxbnUyK2FaKzd5UUlIUmc2UWcxK3hDVUswUFJYR1d1K3NYMTFBMEkyMDNwN1hocXU0bDFkdzQyK2RWb3NESVQ4aUNFRmVhUTNRTGM0bTVSckpBZFJxbU9mQzJLdW0wUmY4Sm5jWko0NXRcLzRSR0V5YmkxV1N5SlhKa1FFZ1p1NUxRbGt0NXM2emxGUUxYc3RuQWU5ZkZBMmFSTzI3WXpmMHdpWm9IZU1FRU9OdTkwQ3FoY0I2Zm5lSEZEQXlySW5qcERFbGhYZW81N2l6Q21OZnVOa2tMUXNtNWlSMHptS2hLVUtnZndJWVVLUmx6TTBmZTF0NG1cL0lXaFNRUVZzMnRaZHE0XC9xS0ZlXC9uS3oxREhsSFRNWFlZTFF4aitSV0NpdUw0XC9lYWV0TGV1bGMwdXV4SVVcL1Y3TnFiZXdkWE14UkV6bFRcLzhaRFFiRHRITm5uVHVQalJYVG4wdExmbVk5OU04NmFKOGNEZFBsTFYySHJ3dmswYWFpQUVKM3N5WDQ2dkNVR0VsVVBhbGFOWm50UlwvR0hMNWVzRk5xdUxJbmZHVXA0YVFMVitBUGpjcGZDUDRvdDdqbkw0cm1QXC9XK1NkOWZvbU0zTXdrU05OMVk4RFVYaTdNTGxcL2Y2bitBamJPWHR1RUVvZlVPaEtyXC9WWmZIbkNxMVFlN1RRTVVDNnVPRGt0cW9kWTU1b29paTJqRThvTFRnaWNLRkpsVjNmajZ5RjJ1MGJcL1lsTUltYlJiaUorbkMyeUhIUlppUUVLTFc1ZE4rN0VXVWE1dUVpazFweEhadGhrRm91TklyZ3I3MkZmK2JpTzVEd0hsWENhM1c1XC8xXC9HUUd2QkI2NmNaaXJtTHVxUFR3Nk5DdFVNQ1RtOUdEVkZMUkc0dm0yeVlyYlRUTGxqRHdmekRRVThhVmlJa0FtcVJ2VHpWcGtYNGVkMURkaTdNYkM5V0VWSHZ2T3BTRzh2U2NubXBBRFZKRUNlcHB1c1JuR1VEQ2ZraEZYeUp2YUwrSHZSRWx3c0pHbEtQQVVpc3dzUDlmc0FrRjA1VUQ5SmRYdGhnUUZ1NnlxV25WSVBMd3dXcjNrQmlpMUVsQ04xWkRTY0E3WVh2eFlsOE1HNmVGUVd2Nlozek9vXC84MGxDZGdsS1ZXZ2hcL3R0ZnBJVzJhM3ErbWFTYTdNMkdwQ3JyYUVaVU1KZTNicnYrZTdDMmxVSTdheDdpY1hcL21lVFNzVHdcL1NYK29RMEZhanBZU3ppeGkzODJtSVhPOHdnTXNQY09MZThJemppejMraVNCZHo4MWtVZzIxeU56dndXOVROVlhwcHdTcURQbE01UjhFYnhPQWJNTlBTbzg0YW9laUx5cW1hZExNVTJHSmg3eEVkd2RRaVVpV1wvWmpzemw5U2N1VzdWbGhtRkJ5ZnpsQ0plaDJmWWUxcnhrcWV2OEl6cmxCeHlBWHhYcUZkaTV4YVBlOUZDOGYzODd4cFo1VWRiQzNWZnQ4NG4wZXVOREhFTGtXaU15YXRzbnUwS1NyVnZ5cW8rZnlEN0tPMjltUWRaUGhQMjB0eFJWTVE4a2xMRVNBNkN2Wk9POFpjV0ZPeGhGcFkxWWxNdXMwaXpjVDFNSHFaQ1JoVTNYbHdyQ2xrNmxrVUhScXJhZXh2dU1TN3JJN20xT2xWMTI1M1VMdExGelpMWE1iUndnMm5XZ2toYVphVVwvdmxFeDdpV0kyNUxPUHN1SmJBTmhPXC9Gbm5MVTBaWTdyVkgrZnNncFpHbEs5TGJic09jVmFxckdGM2ZEUWE4MlRNTHBCdHZDMTZXNDdoN2RTT25aaTM5SytiOGVXK0hFVlJOcmZ5Q3dpZWdDUWlRa1grZlFqbFV0RVhUTFRIdWl5bnByNjB1S29FajZPeWRoVzhhekY1MmZzXC8wbThBNzhRT0k3anhqYUZjZ05NOFVST3hKZXJMbGp2N0FVUEtLXC9rQlNcL1h6dmZ6aEZGTFE5Um9lQ21wblgyOXdiR2l4MXF1TkRqcTdWUUtUYndlbWFEekZ3V3ZJenNPU2dLVnU0eU1Kb2lJcFVTMWcwaGF1NWxVVG5rc0RCVjFtRDFPNnEwa045QTlwbkJ6ZEd0ZHBCUDVVY25xMFBVeFpDN3NNdGREZktLUG9LRUhXY0l1Z1JKUkRQMm5rNHVmdWNORllLeGVkUllJV1FMaVk0MEFnVlhBcHV1M0dzakRpZHdEazMxV3Frbmo1XC9JQzFxN1lSc3RiNnA5RWFyZW9XWFYwQmRvZ25kWWpKT0hBdnFua1lPajRJcFJzZXd1RmZ2TitHb0x0eXFjR0haSWtTZU90MVd1bWg4ckhzN1RYbVhMSDNlb1VNTTFVVEw4bktQR3hqVkJIMHJrUGxyTzJ4VVpiZW4rRGtYZWRuNHdqUmtRUVwvcURiTitpcWt2WU81WTdqcGFhbjVVcDRYTEp0NXVTcU9iYnlsOXdVZ0UzUEtGWjVXWHhDU3QrZUV3d3BUZkI5UHZvejBMVUoxMlIwMStiNnNGVXpVbmxzUTBXOGU1QzBOODdUVEZBZGJIVDNRdXJUTCtDaVNONjlLVzFZK0dJZzBhdFBmSG5SR0gwUXhVZ2ZHdFNBSk85SE1cL3o0TVBGd2llUHlyYTN1a1FWNFdMR0RMOHJXNGtpc3N6b3QyMWx3RnNcL0ROWThONHBReGUwaUpid0piODVTdVlySVVhcDRKcFFId3NSdlAxNjgrTG9kNEk2QnZXcVdlXC91S2lBdk1NWWNKTGRpcmNaeTFpY1RaakZhUFNyRU1aZlBsQnJ1aEEycWU5elpYSWpGb3dKaXpXNjZnVXlENUFtZGkwKzNqNjBZeUNCVVh3R1RoQTFXcHp0a0VyUVJXWDV3c3lTOTZldFhtVUpLeFpSN0M0WENWSDZcL2Z5ZzZHbGx2b1JKbGRTUUhMVXQxNW8xMVR5T2RsSnc5ZmZ2QU1MckZiT3QrUWFnbm9kVk1jQ1YwWDNsV2xWU3BaTml5cDhqMGM5cENsNkk5NU1Tdk5NcGtieEJqdWF5WXkzQTh5QXVTYzFFdWtickxcL2tTVTVsbzJPbWdQZEt0T2M0K3o2SUF1WnBaSzBzVEhwVmJIRjlNaVpDQThQUnI4RGVsNjBKUmdISnRvVWlcL3NiQjdrMmtVRkFzeTc2TCt5d1lvc2FIbEsxV3VWZ1ZNVHhWOHpWbmI5SWw2bmNVd0RqZWxUWFNReVRlRzdMUFBoRnhodHYzYjR0NXRVOURLU2lCQjRjcFV6RzF0K1JOTFdRbk5WaEdQeTdrNWtRZnFqeVJIbGRXRENQK0JwVkZOZmtiaUkzalc2dlhnY0k5MkRpenlJV3BaXC9ycXlPMmpwZzBZZ1VGSkFsSzhTM0hnem92bU92bjdcLzk0SzBQIiwiaXYiOiI0MmVjZGEwNmEwNWM3YzE2OGYxODJlODljN2FlMzAzNCIsInNhbHQiOiI5ZGIwNzhhYjgxYmFjZDJhNjMyNjU4ODFkYzgxZDFmNWI3YmE0NWYxMWUzZjk3ODM1Y2VjYTgxOTU1N2U4MjhiZTc3OWFiMDU0OGNkNzljOTA3MjUxZDlkODQwNDk1NDUzY2U0Mzg3NTQ5MWYyYTBhZThjZjVkZjFkOTY4YjQ4YjY4ODA3Nzk2ZWNkNmJhOWQzYTdiMzAxMzI5YzEwNDM5NDFiMzVjZmY4MDIyNjQyY2JhYTQwYmY4ODBkMDBjMzRhZjJhNmI5NTA2Njg1MWJiNjYzODJkYTRiY2RlYmVjMzczYjY4YjBmYWE5MWNhMjI5ODYzMDEwOGI5ZDIwYTM3Y2YxNTg1ODViMDdhMjkzYmFmYTQwODVkMzIxNzMzM2MwNTQyMmJlMmU4MzQ2ZDI2MWVlYjIzYTA4MDg0MGY1MmNjOTE4ZTE1ODA4MjE0YTdhNjM5NDNjZTJhMzFmNjhiOGEwOGZjMTU3MWI3YjY2NDNlMzZiZjczNzBlYWYyNmQ4OWNlNDQzZWQ3MWVjYTliNTQwNmJhOTg5NTQxNzllNWJmYTRmZTE0YzcxNmM0ODJlOGIwOTU5MjI1YWI5NTMxMzYzZTVkN2MwMzRiNDc4Njg5YmFjMDhjNzFhNGI2YTYyMjhiZWFlOWY3NjYzMTU5NWNjOWMwNWVkOWRjNTkyZSIsIml0ZXJhdGlvbnMiOjk5OX0=

[TheBunnies]

Hi. If you've encountered this error on "Folders" category and if it fails on lines 180, 190, 201, 202. You might want to check the table named TeampassDatabase_nested_tree and see if the personal_folder column corresponds to the correct values. After all of the shenanigans descripted above your issue should be fixed.

[bananatree23]

Hello, thank you for the reply. While this might fix the issue that occurs after trying to import the xml, the main issue sadly persists.
I have upgraded to 3.0.0.22 and while the error message stays mostly the same:

Next error occurred
Error: Malformed UTF-8 data

Raw answer from server:

Notice: Undefined index: folders in /var/www/teampass/sources/import.queries.php on line 714

Fatal error: Uncaught TypeError: filter_var_array() expects parameter 1 to be array, null given in /var/www/teampass/sources/import.queries.php:715 Stack trace: #0 /var/www/teampass/sources/import.queries.php(715): filter_var_array() #1 {main} thrown in /var/www/teampass/sources/import.queries.php on line 715

Now it creates the folders, but no passwords are being imported.

It would be great if anyone could point me to the right direction for fixing this issue.
Thanks.

[bananatree23]

Apparently, the error only occures when I import an xml file that is over 2MB or import any file to a personal folder. If I split the file, the import to non-personal folders works. I have already adjusted the max upload size in the php.ini and in TeamPass itself so I am unsure why that is.

After upgrading to PHP 8.0.27 I get the following error message, hopefully it's more useful:

Next error occurred
Error: Malformed UTF-8 data

Raw answer from server:

Warning: Undefined array key "folders" in /var/www/teampass/sources/import.queries.php on line 714

Fatal error: Uncaught TypeError: filter_var_array(): Argument #1 ($array) must be of type array, null given in /var/www/teampass/sources/import.queries.php:715 Stack trace: #0 /var/www/teampass/sources/import.queries.php(715): filter_var_array() #1 {main} thrown in /var/www/teampass/sources/import.queries.php on line 715

[bananatree23]

I decided to do a fresh install on debian, it is working now.
If someone encounters the issue: Don't try to fix it, I spent hours on it trying everything I can.