search

bigdaddydad / android-xbmcremote

Automatically exported from code.google.com/p/android-xbmcremote
0 stars 0 forks source link

No Movies Found #394

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Clicking on "watch your Movies shows "no movies found"
2. File Mode works.
3.

What is the expected output? What do you see instead?
Should see my movie list instead of "no movies found"

What version of XBMC Remote are you using?
v0.8.4-beta1
Rev 703

Which Android device are you using (and which ROM, if custom)?
Motorola Milestone CM6

Which XBMC revision are you running and on which platform?
10.0-beta2 r33778 on Lucid

Please provide any additional information below.
Using MySQL Backend. TV Shows seem to work, at least there is a list, but no 
season covers.

Original issue reported on code.google.com by hardware...@gmail.com on 27 Sep 2010 at 12:39

GoogleCodeExporter commented 9 years ago 
Maybe the xbmc debug helps:
16:27:40 T:3054925696 M:1715961856  NOTICE: Enabled debug logging due to GUI 
setting. Level 2.
16:27:47 T:3054925696 M:1719656448   DEBUG: HttpApi Start command: 
GetSystemInfo  paras: GetSystemInfo; 120
16:27:49 T:3054925696 M:1719656448   DEBUG: Previous line repeats 1 times.
16:27:49 T:3054925696 M:1719656448   DEBUG: HttpApi Start command: 
QueryVideoDatabase  paras: [not recorded]
16:27:51 T:3054925696 M:1719783424   DEBUG: HttpApi Start command: 
GetSystemInfo  paras: GetSystemInfo; 120
16:27:53 T:3054925696 M:1719791616   DEBUG: SECTION:UnloadDelayed(DLL: 
special://xbmcbin/system/libexif-i486-linux.so)
16:27:53 T:3054925696 M:1719791616   DEBUG: Unloading: libexif-i486-linux.so
16:27:53 T:3054925696 M:1719918592   DEBUG: HttpApi Start command: 
GetSystemInfo  paras: GetSystemInfo; 120
16:27:53 T:3054925696 M:1719918592   DEBUG: HttpApi Start command: GetShares  
paras: GetShares; pictures
16:27:54 T:3054925696 M:1719918592   DEBUG: HttpApi Start command: 
GetSystemInfo  paras: GetSystemInfo; 120
16:27:55 T:3054925696 M:1719791616   DEBUG: Previous line repeats 1 times.
16:27:55 T:3054925696 M:1719791616   DEBUG: HttpApi Start command: 
QueryVideoDatabase  paras: QueryVideoDatabase; SELECT idMovie, c00, c07, 
strPath, strFileName, c15, c11, c14, ROUND(c05, 2), playCount FROM movie, 
files, path WHERE movie.idFile=files.idFile AND path.idPath=files.idPath ORDER 
BY CASE WHEN c10 IS NULL OR c10 == '' THEN lower(c00) ELSE lower(c10) END ASC
16:27:55 T:3054925696 M:1719791616   ERROR: SQL: Undefined MySQL error: Code 
(1064)
                                            Query: SELECT idMovie, c00, c07, strPath, strFileName, c15, c11, c14, ROUND(c05, 2), playCount FROM movie, files, path WHERE movie.idFile=files.idFile AND path.idPath=files.idPath ORDER BY CASE WHEN c10 IS NULL OR c10 == '' THEN lower(c00) ELSE lower(c10) END ASC
16:27:55 T:3054925696 M:1720303616   ERROR: GetArbitraryQuery failed
16:27:58 T:3054925696 M:1720356864   DEBUG: HttpApi Start command: 
GetSystemInfo  paras: GetSystemInfo; 120
16:27:58 T:3054925696 M:1720356864   DEBUG: HttpApi Start command: 
QueryVideoDatabase  paras: QueryVideoDatabase; SELECT DISTINCT actors.idActor, 
strActor FROM actors, actorlinkmovie WHERE actorlinkmovie.idActor = 
actors.idActor ORDER BY upper(strActor), strActor
16:28:03 T:3054925696 M:1719857152   DEBUG: HttpApi Start command: 
GetSystemInfo  paras: GetSystemInfo; 120
16:28:03 T:3054925696 M:1719857152   DEBUG: HttpApi Start command: 
QueryVideoDatabase  paras: QueryVideoDatabase; SELECT idGenre, strGenre FROM 
genre WHERE idGenre IN (SELECT idGenre FROM genrelinkmovie) ORDER BY 
upper(strGenre)
16:28:07 T:2809981808 M:1719865344   DEBUG: Thread 2809981808 terminating 
(autodelete)
16:28:07 T:3054925696 M:1719865344   DEBUG: SECTION:UnloadDelayed(DLL: 
special://xbmcbin/system/ImageLib-i486-linux.so)
16:28:07 T:3054925696 M:1719865344   DEBUG: Unloading: ImageLib-i486-linux.so

Original comment by hardware...@gmail.com on 29 Sep 2010 at 2:30

GoogleCodeExporter commented 9 years ago 
This issue was closed by revision r705.

Original comment by Gabor.Fo...@gmail.com on 29 Sep 2010 at 4:37

GoogleCodeExporter commented 9 years ago 
I also have my my movies database in mysql and get the same symptoms as the 
original poster.

I also use the 3rd party Media Companion to create the movie information in the 
file structure (vs. having to read it from the internet on each PC build).

I am not sure if the problem lies in the mysql part or that XBMC uses the file 
structure for info instead of scraping it off the internet.

I am running 
XBMC 10.0-beta4 r35067 on the PC
v0.8.4-beta1 on a Samsung Captivate (Galaxy S) Android 2.1

Thanks,

-Dave

Original comment by dave...@gmail.com on 2 Nov 2010 at 1:15

GoogleCodeExporter commented 9 years ago 
I have the same exact issue, I'm also running mysql. TV Shows work fine but 
Movies are only available in File Mode.

Original comment by csco...@gmail.com on 23 Nov 2010 at 5:02

GoogleCodeExporter commented 9 years ago 
Issue 452 has been merged into this issue.

Original comment by Gabor.Fo...@gmail.com on 24 Dec 2010 at 11:33

GoogleCodeExporter commented 9 years ago 
Issue 453 has been merged into this issue.

Original comment by phree...@gmail.com on 16 Jan 2011 at 3:40