2010-01-04, 20:21
another error when scanning new tv episodes:
the error is in the where clause
it should be
this is on line 1605 in VideoDatabase.cpp:
Code:
20:10:12 T:139844867377488 M:609370112 ERROR: SQLite: Undefined MySQL error: Code (1052)
Query: select tvshow.*,path.strPath as strPath,counts.totalcount as totalCount,counts.watchedcount as watchedCount,counts.totalcount=counts.watchedcount as watched from tvshow join tvshowlinkpath on tvshow.idShow=tvshowlinkpath.idShow join path on path.idpath=tvshowlinkpath.idPath left outer join ( select tvshow.idShow as idShow,count(1) as totalcount,count(files.playCount) as watchedcount from tvshow join tvshowlinkepisode on tvshow.idShow = tvshowlinkepisode.idShow join episode on episode.idEpisode = tvshowlinkepisode.idEpisode join files on files.idFile = episode.idFile group by tvshow.idShow) counts on tvshow.idShow = counts.idShow where idShow=1
20:10:12 T:139844867377488 M:609370112 ERROR: GetTvShowInfo (/storage/drive1/TVSeries/MySeries/Warehouse.13/) failed
the error is in the where clause
Code:
where idShow=1
it should be
Code:
where tvshow.idShow=1
this is on line 1605 in VideoDatabase.cpp:
Code:
CStdString sql = FormatSQL(VIDEO_DATABASE_VIEW_TVSHOW " where idShow=%i", idTvShow);