User avatar
Krumpy
Developer
Developer
Posts: 1407
Joined: Thu Sep 04, 2003 11:17 pm
Location: Minneapolis, Mn
Contact: Send private message

Movie data not loading....

Tue Nov 01, 2016 9:24 pm

On the latest of everything. Weird. Movie data is not loading. I do get the various movie thumbnails but when selecting a movie no actor data.

Receive the following error in the myServer event log:

WebCmd surface~LoadVCarousel|/getdata/movies/show/cast/selection~vcarousel6457
GetRowCount Error at GetRowCount at line #13444 - incorrect syntax near ')'
GetRowCount Select count(*) From Movies_MovieCast INNER JOIN Movies_Performers ON Movies_MovieCast.PerformerID = Movies_Performers.PerformerID Where (Movies_MovieCast.dvdNumber=) AND (Movies_MovieCast.SortOrder <=)

Thoughts?

User avatar
AllonisDave
Founder
Founder
Posts: 11580
Joined: Fri Feb 07, 2003 8:56 am
Location: Newport Beach, CA
Contact: Send private message

Re: Movie data not loading....

Wed Nov 02, 2016 12:40 pm

WebCmd surface~LoadVCarousel|/getdata/movies/show/cast/selection~vcarousel6457
GetRowCount Error at GetRowCount at line #13444 - incorrect syntax near ')'
GetRowCount Select count(*) From Movies_MovieCast INNER JOIN Movies_Performers ON Movies_MovieCast.PerformerID = Movies_Performers.PerformerID Where (Movies_MovieCast.dvdNumber=) AND (Movies_MovieCast.SortOrder <=)
Several interesting things are missing in the query. There is no dvdNumber value and the SortOrder is not defined. This is all using the sample myui.tablets scenes? Can you show me the entire server log starting with the (2) [Movies|GetMovie~NNNNNNN] from ... command.

User avatar
Krumpy
Developer
Developer
Posts: 1407
Joined: Thu Sep 04, 2003 11:17 pm
Location: Minneapolis, Mn
Contact: Send private message

Re: Movie data not loading....

Wed Nov 02, 2016 3:44 pm

Yes, default sample.

I think that the error is around 11/2/2016 2:41:26 PM. Log is attached. I am more puzzeled as I do think that this worked.

By the way, I did look at Content MGR and the details appear to be there.
Attachments
myServer-11-2-2016.log
(25.14 KiB) Downloaded 58 times

User avatar
AllonisDave
Founder
Founder
Posts: 11580
Joined: Fri Feb 07, 2003 8:56 am
Location: Newport Beach, CA
Contact: Send private message

Re: Movie data not loading....

Wed Nov 02, 2016 4:18 pm

Same thing as before dvdNumber is not being sent to the query. The query looks for the variable {{movies_selection_dvdnumber_{{clientname}}}} to hold the current movie id. I cannot reproduce the issue here. Are you seeing {{movies_selection_dvdnumber_{{clientname}}}} getting populated?

User avatar
Krumpy
Developer
Developer
Posts: 1407
Joined: Thu Sep 04, 2003 11:17 pm
Location: Minneapolis, Mn
Contact: Send private message

Re: Movie data not loading....

Wed Nov 02, 2016 8:10 pm

Ok, got some interesting information for you.

I used Microsoft Edge as part of Windows 10 to display this client. Once I played around and attempted to change the client name from w101226 to "surface" and I believe that it stopped working after that. I recall a getting a error message but discounted its importance as "everything" seemed to work. Long story short, I changed the client name back to default and it seems to work.

You were right that the movies_selection variables were empty.

Seems to be working now.

Return to “myMovies”

Who is online

Users browsing this forum: No registered users and 2 guests