CouchPotato Search Issue

exactrawr · Oct 10, 2013

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

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)

overthinkingme · Oct 13, 2013

I have a similar problem. But I did not update CP, I am not sure if CP updated on its own.
I do not check CP that frequently so I am unable to say how long it hasn't been functioning correctly.

Search no longer works and the log gives me the following:

Code:

[ couchpotato.core.event] Error in event "movie.search", that wasn't caught: Traceback (most recent call last):
  File "/usr/pbi/couchpotato-amd64/CouchPotato/couchpotato/core/event.py", line 12, in runHandler
      return handler(*args, **kwargs)
  File "/usr/pbi/couchpotato-amd64/CouchPotato/couchpotato/core/providers/movie/themoviedb/main.py", line 64, 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
encoding=UTF-8 debug=False args=['--config_file', '/usr/pbi/couchpotato-amd64/data/config.ini', '--data_dir',
'/usr/pbi/couchpotato-amd64/data/', '--pid_file', '/usr/pbi/couchpotato-amd64/data/couchpotato.pid', '--daemon']
app_dir=/usr/pbi/couchpotato-amd64/CouchPotato data_dir=/usr/pbi/couchpotato-amd64/data/ desktop=None
options=Namespace(config_file='/usr/pbi/couchpotato-amd64/data/config.ini', console_log=False, daemon=True,
data_dir='/usr/pbi/couchpotato-amd64/data/', debug=False, pid_file='/usr/pbi/couchpotato-amd64/data/couchpotato.pid', quiet=False)

I hope it helps someone smarter than myself.
Cheers

Important Announcement for the TrueNAS Community.

CouchPotato Search Issue

exactrawr

Dabbler

overthinkingme

Cadet

Similar threads