whosht
commented
1 week ago +1 I upgraded from 380c0f6 to 3.1.2.134 (7583672) and run into that problem.
- I commented out the query and added
$maxTimestamp = null;as suggested - run install/upgrade.php
- It finished but gave me a warning on the login page (Database and config is inconsistent - administrator shall do upgrade process)
- Restored install folder
- restored vendor/teampassclasses/configmanager/src/ConfigManager.php to original file
- run install/upgrade.php again
- It finished and login was possible
Expected behaviour
going to the "Next" step in upgrade
Actual behaviour
nothing happens after pressinf "Start"
Server configuration
Operating system: OL9
Web server: Apache
Database: MariaDB 10
PHP version: 8.2
Teampass version: 3.1.2.131
Teampass configuration file:
Updated from an older Teampass or fresh install: PLEASE attach to this issue the file
/includes/config/tp.config.php.Client configuration
Browser:
Operating system:
Logs
PHP Fatal error: Uncaught MeekroDBException: Unknown column 'created_at' in 'field list' in /var/www/html/teampass/vendor/sergeytsalkov/meekrodb/db.class.php:934
What really happened is en error in /var/www/html/teampass/vendor/teampassclasses/configmanager/src/ConfigManager.php line: 134 $maxTimestamp = DB::queryFirstField( 'SELECT MAX(GREATEST(created_at, updated_at)) AS timestamp FROM ' . prefixTable('misc') . ' WHERE type = %s', 'admin' ); at this moment there are no columns created_at, updated_at in table 'teampass_misc'
a workaround is to set $maxTimestamp = null; for the time of upgrade