Upgrade 2.1.27.36 to 3.0.0.20 does not work

[fuserke]

Steps to reproduce

1. install old latest 2.1.27.36 we've imported a backup of the db (everything is working)
2. follow the upgrade procedure to 3.0.0.20 (copy original dir to teampassv2, copy new files in the original dir teampass)
3. run /install/upgrade.php

Expected behaviour

Upgrade.php should ask for uid and pw of the admin. START -> follow all the other upgrade steps and then upgrade should start with changing the db.

Actual behaviour

Upgrade.php ask for uid and pw of the admin. We press START and then the ajax keeps on turning. The we rename the file tp.config.php and we rerun the upgrade.php -> uid and pw > and we can start and follow till the end. But when we want to start doing the db upgrade the script stays on Loop#1.

Server configuration

Operating system: Windows 2019 Web server: IIS Database: Mysql 8.0.31 PHP version: PHP 7.4.32 Teampass version: 2.1.27.36 Teampass configuration file:

global $SETTINGS; $SETTINGS = array ( 'max_latest_items' => '10', 'enable_favourites' => '1', 'show_last_items' => '1', 'enable_pf_feature' => '1', 'log_connections' => '1', 'log_accessed' => '1', 'time_format' => 'H:i:s', 'date_format' => 'd/m/Y', 'duplicate_folder' => '1', 'item_duplicate_in_same_folder' => '0', 'duplicate_item' => '1', 'number_of_used_pw' => '5', 'manager_edit' => '1', 'cpassman_dir' => 'C:/inetpub/wwwroot/secrettest', 'cpassman_url' => 'https://secrettest', 'favicon' => 'https://secrettest/favicon.ico', 'path_to_upload_folder' => 'C:/inetpub/wwwroot/secrettest/upload', 'url_to_upload_folder' => 'https://secrettest/upload', 'path_to_files_folder' => 'C:/inetpub/wwwroot/secrettest/files', 'url_to_files_folder' => 'https://secrettest/files', 'activate_expiration' => '0', 'pw_life_duration' => '0', 'maintenance_mode' => '1', 'enable_sts' => '0', 'encryptClientServer' => '1', 'cpassman_version' => '2.1.27', 'ldap_mode' => '1', 'ldap_type' => 'REDACTED', 'ldap_suffix' => 'REDACTED', 'ldap_domain_dn' => 'REDACTED', 'ldap_domain_controler' => 'REDACTED', 'ldap_user_attribute' => '0', 'ldap_ssl' => '0', 'ldap_tls' => '0', 'ldap_elusers' => '0', 'ldap_search_base' => '0', 'ldap_port' => '389', 'richtext' => '0', 'allow_print' => '1', 'roles_allowed_to_print' => '12', 'show_description' => '1', 'anyone_can_modify' => '1', 'anyone_can_modify_bydefault' => '1', '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' => '1', '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' => 'REDACTED', 'default_language' => 'english', 'send_stats' => '0', 'send_statistics_items' => '', 'send_stats_time' => '1544449076', 'get_tp_info' => '0', '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' => '90', 'email_smtp_server' => '10.133.0.46', 'email_smtp_auth' => '', 'email_auth_username' => '', 'email_auth_pwd' => '', 'email_port' => '25', 'email_security' => '', 'email_server_url' => '', 'email_from' => 'secret@REDACTED', 'email_from_name' => 'Password server', 'pwd_maximum_length' => '40', 'google_authentication' => '0', 'delay_item_edition' => '0', 'allow_import' => '1', 'proxy_ip' => 'REDACTED', 'proxy_port' => 'REDACTED', 'upload_maxfilesize' => '0mb', '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' => 'REDACTED Secret Server', 'api' => '1', 'subfolder_rights_as_parent' => '1', 'show_only_accessible_folders' => '1', 'enable_suggestion' => '0', 'otv_expiration_period' => '7', 'default_session_expiration_time' => '240', 'duo' => '0', 'enable_server_password_change' => '0', 'ldap_object_class' => '0', 'bck_script_path' => 'C:/inetpub/wwwroot/secrettest/backups', 'bck_script_filename' => 'bck_teampass', 'syslog_enable' => '0', 'syslog_host' => 'localhost', 'syslog_port' => '514', 'manager_move_item' => '1', 'create_item_without_password' => '0', '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/Brussels', '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' => '0', 'upload_all_extensions_file' => '0', 'bck_script_passkey' => 'REDACTED', 'admin_2fa_required' => '0', 'teampass_version' => '2.1.27', 'can_create_root_folder' => '1', 'copy_to_clipboard_small_icons' => '1', 'tree_counters' => '1', 'settings_offline_mode' => '1', 'ldap_new_user_role' => '21', 'ga_reset_by_user' => '1', 'use_http_request_login' => '0', 'yubico_authentication' => '0', );

Updated from an older Teampass or fresh install: PLEASE attach to this issue the file /includes/config/tp.config.php. Update from older Teampass

Client configuration

Browser: Chrome (cache cleared) Firefox (cache cleared)

Operating system: Windows 11

Logs

Web server error log

none

Insert your webserver log here

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

Insert the log here and especially the answer of the query that failed.

No answer to be seen. It just stops working