search

mkucej / i-librarian

Legacy I, Librarian - collaborative PDF manager. Not maintained, new version is at https://github.com/mkucej/i-librarian-free
https://i-librarian.net
98 stars 38 forks source link

Integrity constraint violation while upgrading #151

Closed miquelbofill closed 4 years ago

miquelbofill commented 4 years ago

I got the following FOREIGN KEY integrity constraint violation while trying to migrate the database to version 5.5.0. Any ideas?

500 Internal Server Error Database error: SQLSTATE[23000]: Integrity constraint violation: 19 FOREIGN KEY constraint failed #0 /usr/share/i-librarian/classes/storage/database.php(237): PDOStatement->execute() #1 /usr/share/i-librarian/app/models/migration.php(726): Librarian\Storage\Database->run() #2 /usr/share/i-librarian/app/models/migration.php(93): LibrarianApp\MigrationModel->_legacyLibrary() #3 [internal function]: LibrarianApp\MigrationModel->_legacyupgrade() #4 /usr/share/i-librarian/classes/mvc/model.php(125): call_user_func_array() #5 /usr/share/i-librarian/app/controllers/migration.php(78): Librarian\Mvc\Model->__call() #6 /usr/share/i-librarian/classes/router.php(117): LibrarianApp\MigrationController->legacyupgradeAction() #7 /usr/share/i-librarian/classes/application.php(103): Librarian\Router->dispatch() #8 /usr/share/i-librarian/public/index.php(156): Librarian\Application->handle() #9 {main}.

miquelbofill commented 4 years ago

Solved