DobyTang / LazyLibrarian

This project isn't finished yet. Goal is to create a SickBeard, CouchPotato, Headphones-like application for ebooks. Headphones is used as a base, so there are still a lot of references to it.
730 stars 70 forks source link

Error when past magazines to wanted #1664

Closed Bigmonty69 closed 6 years ago

Bigmonty69 commented 6 years ago

I am in the Past Issues section of Magazines and am trying to change the status of one of the rejected magazines to Wanted. However I get a 500 Internal Server Error as follows:

Traceback (most recent call last): File "/app/lazylibrarian/cherrypy/_cprequest.py", line 670, in respond response.body = self.handler() File "/app/lazylibrarian/cherrypy/lib/encoding.py", line 217, in call self.body = self.oldhandler(*args, *kwargs) File "/app/lazylibrarian/cherrypy/_cpdispatch.py", line 61, in call return self.callable(self.args, **self.kwargs) File "/app/lazylibrarian/lazylibrarian/webServe.py", line 3267, in markPastIssues myDB.upsert("wanted", newValueDict, controlValueDict) File "/app/lazylibrarian/lazylibrarian/database.py", line 143, in upsert self._action(query, list(valueDict.values()) + list(keyDict.values()), suppress="UNIQUE") File "/app/lazylibrarian/lazylibrarian/database.py", line 58, in _action sqlResult = self.connection.execute(query, args) IntegrityError: FOREIGN KEY constraint failed

I am on the latest version of Lazy Librarian.