Uncaught mysqli_sql_exception: Incorrect table definition; there can be only one auto column and it must be defined as a key

[netphantm]

### Steps to reproduce 1. git pull 2. call https://my.site/install/upgrade.php in browser 3. ### Expected behaviour upgrade of the db and teampass.. ### Actual behaviour upgrade stopping at: 18:45:52 - upgrade_run_3.0.0.php - Loop #1 is now running ... ### Server configuration **Operating system**: Linux mail.hugo.ro 6.5.0-1018-aws #18~22.04.1-Ubuntu SMP Fri Apr 5 17:44:33 UTC 2024 x86_64 **Web server:** nginx/1.18.0 **Database:** 5.5.5-10.6.16-MariaDB-0ubuntu0.22.04.1 **PHP version:** 7.4.33 **Teampass version:** 3.0.0.17 **Teampass configuration file:** ``` **Teampass configuration file:** ``` 'max_latest_items' => '10', 'enable_favourites' => '1', 'show_last_items' => '1', 'enable_pf_feature' => '0', 'log_connections' => '1', 'log_accessed' => '1', '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/tp', 'cpassman_url' => 'https:/// 'favicon' => 'https:////favicon.ico', 'path_to_upload_folder' => '/var/www/tp/upload', 'url_to_upload_folder' => 'https:///upload', 'path_to_files_folder' => '/var/www/tp/files', 'url_to_files_folder' => 'https:///files', 'activate_expiration' => '0', 'pw_life_duration' => '0', 'maintenance_mode' => '0', 'enable_sts' => '1', 'encryptClientServer' => '1', 'cpassman_version' => '3.0.0.17', 'ldap_mode' => '0', 'ldap_type' => '0', 'ldap_suffix' => '0', 'ldap_domain_dn' => '0', 'ldap_domain_controler' => '0', 'ldap_user_attribute' => '0', 'ldap_ssl' => '0', 'ldap_tls' => '0', 'ldap_elusers' => '0', 'ldap_search_base' => '0', 'ldap_port' => '389', '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' => '10', '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' => '', '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' => '1519992199', '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' => '' 'email_smtp_auth' => '1', 'email_auth_username' => '' 'email_auth_pwd' => '' 'email_port' => '587', 'email_security' => 'tls', 'email_server_url' => '', 'email_from' => '' 'email_from' => '' 'pwd_maximum_length' => '40', 'google_authentication' => '0', 'delay_item_edition' => '0', 'allow_import' => '0', 'proxy_ip' => '', 'proxy_port' => '', 'upload_maxfilesize' => '10mb', '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' => '0', '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' => '0', 'show_only_accessible_folders' => '0', 'enable_suggestion' => '0', 'otv_expiration_period' => '1', 'default_session_expiration_time' => '20', 'duo' => '0', 'enable_server_password_change' => '0', 'ldap_object_class' => '0', 'bck_script_path' => '/var/www/tp/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' => '0', 'offline_key_level' => '0', 'enable_http_request_login' => '0', 'ldap_and_local_authentication' => '0', 'copy_to_clipboard_small_icons' => '1', 'teampass_version' => '2.1.27', 'admin_2fa_required' => '1', 'secure_display_image' => '1', 'upload_zero_byte_file' => '0', 'upload_all_extensions_file' => '0', 'password_overview_delay' => '4', 'roles_allowed_to_print_select' => '', 'clipboard_life_duration' => '10', 'mfa_for_roles' => '', 'tree_counters' => '0', 'settings_offline_mode' => '0', 'settings_tree_counters' => '0', 'enable_massive_move_delete' => '0', 'email_debug_level' => '3', 'ga_reset_by_user' => '', 'onthefly-backup-key' => '', 'onthefly-restore-key' => '', 'ldap_user_dn_attribute' => '', 'ldap_dn_additional_user_dn' => '', 'ldap_user_object_filter' => '', 'ldap_bdn' => '', 'ldap_hosts' => '', 'ldap_password' => '', 'ldap_username' => '', ``` **Updated from an older Teampass or fresh install:** PLEASE attach to this issue the file `/includes/config/tp.config.php`. [tp.config.php.txt](https://github.com/nilsteampassnet/TeamPass/files/15052809/tp.config.php.txt) ### Client configuration **Browser:** firefox 124.0.2 (64-bit) **Operating system:** on Ubuntu 23.10 ### Logs #### Web server error log ``` 2024/04/21 18:45:37 [error] 34847#34847: *267 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught mysqli_sql_exception: Incorrect table definition; there can be only one auto column and it must be defined as a key in /var/www/tp/install/tp.functions.php:217 Stack trace: #0 /var/www/tp/install/tp.functions.php(217): mysqli_query() #1 /var/www/tp/install/upgrade_run_3.0.0.php(1395): addColumnIfNotExist() #2 {main} thrown in /var/www/tp/install/tp.functions.php on line 217" while reading response header from upstream, client: 80.141.22.211, server: tp.my.site, request: "POST /install/upgrade_run_3.0.0.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.2-fpm.sock:", host: "tp.my.site" ``` #### Teampass 10 last system errors ``` * 06/01/2020 10:35:24 - Query: SELECT user_ip_lastdate FROM teampass_users WHERE id = 10000000
Error: Unknown column 'user_ip_lastdate' in 'field list'
@ /tp/sources/main.queries.php * 06/01/2020 10:30:23 - Query: SELECT user_ip_lastdate FROM teampass_users WHERE id = 10000000
Error: Unknown column 'user_ip_lastdate' in 'field list'
@ /tp/sources/main.queries.php * 01/04/2018 19:27:57 - Query: SELECT i.id_tree, r.item_id FROM teampass_items as i INNER JOIN teampass_restriction_to_roles as r ON (r.item_id=i.id) WHERE r.role_id=5 ORDER BY i.id_tree ASC
Error: Table 'teampass.teampass_restriction_to_roles' doesn't exist
@ /index.php * 01/04/2018 19:19:33 - Query: SELECT i.id_tree, r.item_id FROM teampass_items as i INNER JOIN teampass_restriction_to_roles as r ON (r.item_id=i.id) WHERE r.role_id=5 ORDER BY i.id_tree ASC
Error: Table 'teampass.teampass_restriction_to_roles' doesn't exist
@ /sources/identify.php * 01/04/2018 19:18:04 - Query: SELECT i.id_tree, r.item_id FROM teampass_items as i INNER JOIN teampass_restriction_to_roles as r ON (r.item_id=i.id) WHERE r.role_id=5 ORDER BY i.id_tree ASC
Error: Table 'teampass.teampass_restriction_to_roles' doesn't exist
@ /index.php * 01/04/2018 19:18:04 - Query: SELECT i.id_tree, r.item_id FROM teampass_items as i INNER JOIN teampass_restriction_to_roles as r ON (r.item_id=i.id) WHERE r.role_id=5 ORDER BY i.id_tree ASC
Error: Table 'teampass.teampass_restriction_to_roles' doesn't exist
@ /index.php * 01/04/2018 19:18:02 - Query: SELECT i.id_tree, r.item_id FROM teampass_items as i INNER JOIN teampass_restriction_to_roles as r ON (r.item_id=i.id) WHERE r.role_id=5 ORDER BY i.id_tree ASC
Error: Table 'teampass.teampass_restriction_to_roles' doesn't exist
@ / * 01/04/2018 19:18:01 - Query: SELECT i.id_tree, r.item_id FROM teampass_items as i INNER JOIN teampass_restriction_to_roles as r ON (r.item_id=i.id) WHERE r.role_id=5 ORDER BY i.id_tree ASC
Error: Table 'teampass.teampass_restriction_to_roles' doesn't exist
@ /index.php * 01/04/2018 19:17:58 - Query: SELECT i.id_tree, r.item_id FROM teampass_items as i INNER JOIN teampass_restriction_to_roles as r ON (r.item_id=i.id) WHERE r.role_id=5 ORDER BY i.id_tree ASC
Error: Table 'teampass.teampass_restriction_to_roles' doesn't exist
@ /index.php?page=items * 01/04/2018 19:17:50 - Query: SELECT i.id_tree, r.item_id FROM teampass_items as i INNER JOIN teampass_restriction_to_roles as r ON (r.item_id=i.id) WHERE r.role_id=5 ORDER BY i.id_tree ASC
Error: Table 'teampass.teampass_restriction_to_roles' doesn't exist
@ /index.php?page=manage_roles ``` #### Log from the web-browser developer console (CTRL + SHIFT + i) ``` This page is in Almost Standards Mode. Page layout may be impacted. For Standards Mode use “”. [upgrade.php](https://tp.my.site/install/upgrade.php) Object { finish: "0", scriptname: "upgrade_run_3.0.0.php", parameter: "user_id" } ```