Hi all.
Bit of a problem here:
I updated couch potato on my new FreeNAS system. I SSH'd into the jail and replaced the files with the updated ones from Master Gollom. Now when I try to search and add a movie I get the following errors in my logs:
When I installed the PBI CP asked me to update in order for it to function properly. I did so and now cant add movies to search for/download.
Any help would be greatly appreciated
Thank you
Bit of a problem here:
I updated couch potato on my new FreeNAS system. I SSH'd into the jail and replaced the files with the updated ones from Master Gollom. Now when I try to search and add a movie I get the following errors in my logs:
When I installed the PBI CP asked me to update in order for it to function properly. I did so and now cant add movies to search for/download.
Any help would be greatly appreciated
Thank you
Code:
10-11 15:00:11 INFO [hpotato.core.plugins.base] Opening url: https://api.couchpota.to/search/j/?limit=5, params: []10-11 15:00:11 INFO [hpotato.core.plugins.base] Opening url: http://www.omdbapi.com/?y=&t=j, params: []10-11 15:00:11 INFO [hpotato.core.plugins.base] Opening url: http://www.imdbapi.com/?y=&t=j, params: []10-11 15:00:11 INFO [e.providers.movie.imdbapi] Found: J (2000)10-11 15:00:11 ERROR [roviders.movie.themoviedb] Failed searching TMDB for "j": Traceback (most recent call last): File "/usr/pbi/couchpotato-amd64/CouchPotato/couchpotato/core/providers/movie/themoviedb/main.py", line 68, in search raw = tmdb.search(search_string) File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/themoviedb/tmdb.py", line 700, in search return mdb.search(name) File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/themoviedb/tmdb.py", line 317, in search etree = XmlHandler(url).getEt() File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/themoviedb/tmdb.py", line 91, in getEt xml = self._grabUrl(self.url) File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/themoviedb/tmdb.py", line 85, in _grabUrl raise TmdHttpError(errormsg) TmdHttpError: HTTP Error 404: Not Found 10-11 15:00:17 INFO [providers.info.themoviedb] Found: [u'j (2012)', u'J. Edgar (2011)', u'J-U-N-K (1920)', u'J-Men Forever (1979)', u'J-Horror Anthology: Underworld (2005)', u'The J-K Conspiracy (0)', u'American Experience - The Trials Of J. Robert Oppenheimer (2009)', u'The Private Files of J. Edgar Hoover (1977)', u'Jessie J - Live at iTunes Festival (2012)', u"J. Edgar Hoover \u2013 Le plus grand ripou d'Am\xe9rique (2007)", u'Jessie-J - Konzert Tontr ger 3satfestival 2011 (0)', u'J Zone (1998)']10-11 15:00:17 INFO [hpotato.core.plugins.base] Opening url: https://api.couchpota.to/search/just+m+y/?limit=5, params: []10-11 15:00:17 INFO [hpotato.core.plugins.base] Opening url: http://www.omdbapi.com/?y=&t=just+m+y, params: []10-11 15:00:17 INFO [hpotato.core.plugins.base] Opening url: http://www.imdbapi.com/?y=&t=just+m+y, params: []10-11 15:00:17 ERROR [roviders.movie.themoviedb] Failed searching TMDB for "just m y": Traceback (most recent call last): File "/usr/pbi/couchpotato-amd64/CouchPotato/couchpotato/core/providers/movie/themoviedb/main.py", line 68, in search raw = tmdb.search(search_string) File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/themoviedb/tmdb.py", line 700, in search return mdb.search(name) File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/themoviedb/tmdb.py", line 317, in search etree = XmlHandler(url).getEt() File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/themoviedb/tmdb.py", line 91, in getEt xml = self._grabUrl(self.url) File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/themoviedb/tmdb.py", line 85, in _grabUrl raise TmdHttpError(errormsg) TmdHttpError: HTTP Error 404: Not Found 10-11 15:00:18 INFO [hpotato.core.plugins.base] Opening url: https://api.couchpota.to/search/just+my/?limit=5, params: []10-11 15:00:18 INFO [hpotato.core.plugins.base] Opening url: http://www.imdbapi.com/?y=&t=just+my, params: []10-11 15:00:18 INFO [hpotato.core.plugins.base] Opening url: http://www.omdbapi.com/?y=&t=just+my, params: []10-11 15:00:18 ERROR [roviders.movie.themoviedb] Failed searching TMDB for "just my": Traceback (most recent call last): File "/usr/pbi/couchpotato-amd64/CouchPotato/couchpotato/core/providers/movie/themoviedb/main.py", line 68, in search raw = tmdb.search(search_string) File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/themoviedb/tmdb.py", line 700, in search return mdb.search(name) File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/themoviedb/tmdb.py", line 317, in search etree = XmlHandler(url).getEt() File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/themoviedb/tmdb.py", line 91, in getEt xml = self._grabUrl(self.url) File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/themoviedb/tmdb.py", line 85, in _grabUrl raise TmdHttpError(errormsg) TmdHttpError: HTTP Error 404: Not Found 10-11 15:00:19 INFO [e.providers.movie.imdbapi] Found: Just My Luck (2006)10-11 15:00:19 INFO [re.providers.info.omdbapi] Found: Just My Luck (2006)10-11 15:00:22 INFO [providers.info.themoviedb] Found: [u'Just My Luck (2006)', u'Just My Luck (1935)', u'Just My Luck (1957)', u'Nephew Tommy: Just My Thoughts (0)', u'My Baby Just Cares for Me (1987)', u'Just One of the Girls (1993)']10-11 15:00:22 INFO [hpotato.core.plugins.base] Opening url: https://api.couchpota.to/search/just+my+luc/?limit=5, params: []10-11 15:00:22 INFO [hpotato.core.plugins.base] Opening url: http://www.omdbapi.com/?y=&t=just+my+luc, params: []10-11 15:00:22 INFO [hpotato.core.plugins.base] Opening url: http://www.imdbapi.com/?y=&t=just+my+luc, params: []10-11 15:00:22 ERROR [roviders.movie.themoviedb] Failed searching TMDB for "just my luc": Traceback (most recent call last): File "/usr/pbi/couchpotato-amd64/CouchPotato/couchpotato/core/providers/movie/themoviedb/main.py", line 68, in search raw = tmdb.search(search_string) File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/themoviedb/tmdb.py", line 700, in search return mdb.search(name) File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/themoviedb/tmdb.py", line 317, in search etree = XmlHandler(url).getEt() File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/themoviedb/tmdb.py", line 91, in getEt xml = self._grabUrl(self.url) File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/themoviedb/tmdb.py", line 85, in _grabUrl raise TmdHttpError(errormsg) TmdHttpError: HTTP Error 404: Not Found 10-11 15:00:23 INFO [hpotato.core.plugins.base] Opening url: https://api.couchpota.to/search/just+my+luck/?limit=5, params: []10-11 15:00:23 INFO [hpotato.core.plugins.base] Opening url: http://www.omdbapi.com/?y=&t=just+my+luck, params: []10-11 15:00:23 INFO [hpotato.core.plugins.base] Opening url: http://www.imdbapi.com/?y=&t=just+my+luck, params: []10-11 15:00:23 ERROR [roviders.movie.themoviedb] Failed searching TMDB for "just my luck": Traceback (most recent call last): File "/usr/pbi/couchpotato-amd64/CouchPotato/couchpotato/core/providers/movie/themoviedb/main.py", line 68, in search raw = tmdb.search(search_string) File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/themoviedb/tmdb.py", line 700, in search return mdb.search(name) File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/themoviedb/tmdb.py", line 317, in search etree = XmlHandler(url).getEt() File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/themoviedb/tmdb.py", line 91, in getEt xml = self._grabUrl(self.url) File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/themoviedb/tmdb.py", line 85, in _grabUrl raise TmdHttpError(errormsg) TmdHttpError: HTTP Error 404: Not Found 10-11 15:00:23 INFO [providers.info.themoviedb] Found: [u'Just My Luck (2006)', u'Just My Luck (1935)', u'Just My Luck (1957)']10-11 15:00:23 INFO [re.providers.info.omdbapi] Found: Just My Luck (2006)10-11 15:00:23 INFO [e.providers.movie.imdbapi] Found: Just My Luck (2006)10-11 15:00:33 INFO [hpotato.core.plugins.base] Opening url: https://api.couchpota.to/ismovie/tt0397078/, params: []10-11 15:00:34 ERROR [ couchpotato.api] Failed doing api request "movie.add": Traceback (most recent call last): File "/usr/pbi/couchpotato-amd64/CouchPotato/couchpotato/api.py", line 101, in run_handler result = api[route](**kwargs) File "/usr/pbi/couchpotato-amd64/CouchPotato/couchpotato/core/media/movie/_base/main.py", line 506, in addView movie_dict = self.add(params = kwargs) File "/usr/pbi/couchpotato-amd64/CouchPotato/couchpotato/core/media/movie/_base/main.py", line 441, in add m = db.query(Movie).filter_by(library_id = library.get('id')).first() File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/query.py", line 2156, in first ret = list(self[0:1]) File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/query.py", line 2023, in __getitem__ return list(res) File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/query.py", line 2227, in __iter__ return self._execute_and_instances(context) File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/query.py", line 2242, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/engine/base.py", line 1449, in execute params) File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement compiled_sql, distilled_params File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/engine/base.py", line 1698, in _execute_context context) File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/engine/base.py", line 1691, in _execute_context context) File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/engine/default.py", line 331, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: movie.category_id u'SELECT movie.id AS movie_id, movie.last_edit AS movie_last_edit, movie.library_id AS movie_library_id, movie.status_id AS movie_status_id, movie.profile_id AS movie_profile_id, movie.category_id AS movie_category_id \nFROM movie \nWHERE movie.library_id = ?\n LIMIT ? OFFSET ?' (2, 1, 0)