TeamPass icon indicating copy to clipboard operation
TeamPass copied to clipboard

New installation - error Uncaught mysqli_sql_exception

Open Michalis-Chatzimichalis opened this issue 2 years ago • 0 comments

Steps to reproduce

  1. Install Ubuntu 22.04 with all the requirements (phpmyAdmin, php, MariaDB, TeamPass 3.0.019)
  2. Successfully install TeamPass and manually delete install folder in /var/www/html
  3. Try to login with admin and the password that was created in setup

Expected behaviour

Successful login

Actual behaviour

Can't login to dashboard after the 6 or so installation steps completed successfully

grafik

Server configuration

Operating system: Ubuntu 22.04 LTS

Web server: Apache

Database: MariaDB 10.9.3

PHP version: 8.1.2

Teampass version: 3.0.0.19

Client configuration

Browser: Firefox / Chrome

Operating system: Windows 10

Logs

Web server error log

PHP Fatal error:  Uncaught mysqli_sql_exception: Unknown column 'public_key' in 'field list' in /var/www/html/TeamPass/includes/libraries/Database/Meekrodb/db.class.php:682\nStack trace:\n#0 /var/www/html/TeamPass/includes/libraries/Database/Meekrodb/db.class.php(682): mysqli->query()\n#1 /var/www/html/TeamPass/includes/libraries/Database/Meekrodb/db.class.php(637): MeekroDB->queryHelper()\n#2 /var/www/html/TeamPass/includes/libraries/Database/Meekrodb/db.class.php(638): MeekroDB->prependCall()\n#3 /var/www/html/TeamPass/includes/libraries/Database/Meekrodb/db.class.php(319): MeekroDB->query()\n#4 /var/www/html/TeamPass/includes/libraries/Database/Meekrodb/db.class.php(83): MeekroDB->update()\n#5 /var/www/html/TeamPass/sources/identify.php(586): DB::update()\n#6 /var/www/html/TeamPass/sources/identify.php(118): identifyUser()\n#7 {main}\n  thrown in /var/www/html/TeamPass/includes/libraries/Database/Meekrodb/db.class.php on line 682,

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

POST http://tmp.domain.ch/TeamPass/sources/identify.php [HTTP/1.0 500 Internal Server Error 880ms]

Michalis-Chatzimichalis avatar Oct 13 '22 14:10 Michalis-Chatzimichalis