search

bigdaddydad / android-xbmcremote

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

"No Movies Found" on XBMC 10.0 w/ MySQL #453

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1.Launch XBMC Remote
2.Press Watch your Movies
3.Ponder the meaning of life

What is the expected output? What do you see instead?
Movie list should appear but instead a black list stating "No movies found." 
appears.  The proper files appear in the file view, but none in the  movie 
views.  TV Shows and music all appear as they should.

What version of XBMC Remote are you using?
0.8.4-beta1

Which Android device are you using (and which ROM, if custom)?
Android 2.2 Nero v2 Samsung Vibrant

Which XBMC revision are you running and on which platform?
XBMC 10.0 Windows 7 32-bit

Please provide any additional information below.
My XBMC Remote connects to my XBMC install through a DynDNS domain to my PC.  
The library is on my server's MySQL database.  All the ports are forwarded 
properly and whatnot.

Original issue reported on code.google.com by nickkars...@gmail.com on 26 Dec 2010 at 5:00

GoogleCodeExporter commented 8 years ago 
I'm seeing this issue also. Everything else works with the remote except movies.

MySQL database is perhaps the commonality.

If any debugging is needed let me know.

Original comment by hadley.r...@gmail.com on 31 Dec 2010 at 5:18

GoogleCodeExporter commented 8 years ago 
I have the same problem. My xbmc.log file gets the following appended each time 
I access the "Movies" button on the Android app: 

ERROR: SQL: Undefined MySQL error: Code (1064)
Query: SELET 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
ERROR: GetArbitaryQuery failed

Original comment by martin.b...@gmail.com on 2 Jan 2011 at 1:48

GoogleCodeExporter commented 8 years ago 
Hi there,

guess it is the same bug as 
http://code.google.com/p/android-xbmcremote/issues/detail?id=394
which is already fixed. 
But everybody seems to wait for a new .apk
As a Test try to sort by rating, then the movies should apear.

Original comment by hardware...@gmail.com on 10 Jan 2011 at 6:55

GoogleCodeExporter commented 8 years ago

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