Leantime / leantime

Leantime is a goals focused project management system for non-project managers. Building with ADHD, Autism, and dyslexia in mind.
https://leantime.io
GNU Affero General Public License v3.0
4.44k stars 582 forks source link

[BUG] Updating from 3.1.4 to the latest version makes Leantime unusable as login does not work anymore #2649

Open RKLBusinessDevelopment opened 1 week ago

RKLBusinessDevelopment commented 1 week ago

If you have problems with the installation please use our community forum

What set up are you using

Describe the bug After updating to the latest version, Leantime updates the database upon first login. After that, I can't login to Leantime any more. No error message, the credentials just won't work. I had to manually revert back to 3.1.4 and restore my database backup to use Leantime again.

To Reproduce Use a 3.1.4 self-hosted installation and update to the latest version.

Expected behavior Being able to login after Leantime has updated the database.

Leantime Version reverted back to 3.1.4, wanted to use the latest version

PHP / MySQL Version PHP 8.1.9 / MySQL 9.0.1

mattjbayly commented 1 week ago

I am also getting the same error. Message in leantime.log:

` [2024-09-08 19:21:05] production.CRITICAL: PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'zp_calendar' already exists in /var/www/html/leantime/app/Domain/Install/Repositories/Install.php:239 Stack trace:

0 /var/www/html/leantime/app/Domain/Install/Repositories/Install.php(239): PDOStatement->execute()

1 /var/www/html/leantime/app/Domain/Install/Controllers/Index.php(95): Leantime\Domain\Install\Repositories\Install->setupDB()

...

41 /var/www/html/leantime/app/Core/Bootstrap/Bootloader.php(129): Leantime\Core\Bootstrap\Bootloader->handleRequest()

42 /var/www/html/leantime/public/index.php(13): Leantime\Core\Bootstrap\Bootloader->boot()

`