{"action":"created","issue":{"url":"https://api.github.com/repos/DobyTang/LazyLibrarian/issues/155","labels_url":"https://api.github.com/repos/DobyTang/LazyLibrarian/issues/155/labels{/name}","comments_url":"https://api.github.com/repos/DobyTang/LazyLibrarian/issues/155/comments","events_url":"https://api.github.com/repos/DobyTang/LazyLibrarian/issues/155/events","html_url":"https://github.com/DobyTang/LazyLibrarian/issues/155","id":112682568,"number":155,"title":"Unicode problem on Library Scan","user":{"login":"theguardian","id":2790499,"avatar_url":"https://avatars.githubusercontent.com/u/2790499?v=3","gravatar_id":"","url":"https://api.github.com/users/theguardian","html_url":"https://github.com/theguardian","followers_url":"https://api.github.com/users/theguardian/followers","following_url":"https://api.github.com/users/theguardian/following{/other_user}","gists_url":"https://api.github.com/users/theguardian/gists{/gist_id}","starred_url":"https://api.github.com/users/theguardian/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/theguardian/subscriptions","organizations_url":"https://api.github.com/users/theguardian/orgs","repos_url":"https://api.github.com/users/theguardian/repos","events_url":"https://api.github.com/users/theguardian/events{/privacy}","received_events_url":"https://api.github.com/users/theguardian/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-10-21T21:27:45Z","updated_at":"2015-10-22T18:04:53Z","closed_at":null,"body":"Tried the \"Library Scan\" feature for the first time today. It got through a few authors but then errored out with this:\r\n\r\n21-Oct-2015 14:08:35 - INFO :: DBIMPORT : [Billy Crystal] Author update complete\r\n21-Oct-2015 14:08:35 - ERROR :: DBIMPORT : Fatal error executing SELECT BookID FROM books where AuthorName=? and BookName=? :: You must not use 8-bit bytestrings unless you use a text_factory that can interpret 8-bit bytestrings (like text_factory = str). It is highly recommended that you instead just switch your application to Unicode strings.\r\n"},"comment":{"url":"https://api.github.com/repos/DobyTang/LazyLibrarian/issues/comments/150307955","html_url":"https://github.com/DobyTang/LazyLibrarian/issues/155#issuecomment-150307955","issue_url":"https://api.github.com/repos/DobyTang/LazyLibrarian/issues/155","id":150307955,"user":{"login":"philborman","id":12158777,"avatar_url":"https://avatars.githubusercontent.com/u/12158777?v=3","gravatar_id":"","url":"https://api.github.com/users/philborman","html_url":"https://github.com/philborman","followers_url":"https://api.github.com/users/philborman/followers","following_url":"https://api.github.com/users/philborman/following{/other_user}","gists_url":"https://api.github.com/users/philborman/gists{/gist_id}","starred_url":"https://api.github.com/users/philborman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/philborman/subscriptions","organizations_url":"https://api.github.com/users/philborman/orgs","repos_url":"https://api.github.com/users/philborman/repos","events_url":"https://api.github.com/users/philborman/events{/privacy}","received_events_url":"https://api.github.com/users/philborman/received_events","type":"User","site_admin":false},"created_at":"2015-10-22T18:04:53Z","updated_at":"2015-10-22T18:04:53Z","body":"Can't reproduce that here. I've added author \"Billy Crystal\" with goodreads and google books and works fine. The error is being generated in  the function \"find_book_in_db\" with parameters \"author\" and \"book\" . \"author\" has already been used in a call to myDB.action before we get to this point in the code, so I guess it's the book name it objects to. The bookname is sanitised with unidecode before we reach this point. The version of unidecode you uploaded is much smaller than mine, (has far fewer files x0??.py) maybe that's the problem?  I have uploaded my version to master, can you try that and see if the problem persists, or try my branch??  I would recommend deleting the caches in case of conflict too. You might get more help in debug mode, there should be a line  \"file meta [%s] [%s] [%s] [%s]\" or \"book meta [%s] [%s] [%s] [%s]\" which will show the bookname it doesn't like. As far as I can see the names should be unicode safe."}}