France
Hello,
When i try to login, i've this sql error :
A Database Error Occurred
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND (ItemType IS NULL OR ItemType <> 'M' OR movies.Adult = 0)' at line 87
SELECT users.Username, stream.* , movie_details.TranslatedTitle as MovieTitle , (select case when ItemType = 'S' then sd1.SeriesId else sd2.SeriesId end) as SeriesId , (select case when ItemType = 'S' then sd1.SeriesName else sd2.SeriesName end) as SeriesName , tv_episode_details.EpisodeName , tv_episodes.SeasonNumber , tv_episodes.EpisodeNumber , movies.YEAR as MovieYear , achievements.AchievementId , achievements.AchievementName , friend.UserId as FriendUserId , friend.Username as FriendUsername , movie_ratings.QuickThoughts as mQuickThoughts , tv_series_ratings.QuickThoughts as sQuickThoughts , tv_episode_ratings.QuickThoughts as eQuickThoughts FROM stream LEFT OUTER JOIN movies ON ItemType = 'M' AND stream.ItemId = movies.MovieId LEFT OUTER JOIN movie_details ON ItemType = 'M' AND MovieDetailId = ( SELECT MovieDetailId FROM movie_details WHERE MovieId = stream.ItemId ORDER BY ( CASE movie_details.Locale WHEN 'fr' THEN 1 WHEN 'en' THEN 2 ELSE 3 END ) LIMIT 1 ) LEFT OUTER JOIN tv_episode_details ON ItemType = 'E' AND EpisodeDetailId = ( SELECT EpisodeDetailId FROM tv_episode_details WHERE EpisodeId = stream.ItemId ORDER BY ( CASE tv_episode_details.Locale WHEN 'fr' THEN 1 WHEN 'en' THEN 2 ELSE 3 END ) LIMIT 1 ) LEFT JOIN tv_episodes ON ItemType='E' AND tv_episodes.EpisodeId=tv_episode_details.EpisodeId LEFT OUTER JOIN tv_series_details sd1 ON ItemType = 'S' AND sd1.SeriesDetailsId = ( SELECT SeriesDetailsId FROM tv_series_details WHERE SeriesId = stream.ItemId ORDER BY ( CASE tv_series_details.Locale WHEN 'fr' THEN 1 WHEN 'en' THEN 2 ELSE 3 END ) LIMIT 1 ) LEFT OUTER JOIN tv_series_details sd2 ON ItemType = 'E' AND sd2.SeriesDetailsId = ( SELECT SeriesDetailsId FROM tv_series_details WHERE SeriesId = tv_episodes.SeriesId ORDER BY ( CASE tv_series_details.Locale WHEN 'fr' THEN 1 WHEN 'en' THEN 2 ELSE 3 END ) LIMIT 1 ) LEFT OUTER JOIN achievements ON stream.IntParam1 = achievements.AchievementId LEFT OUTER JOIN users ON stream.UserId = users.UserId LEFT OUTER JOIN users AS friend ON Action = 5 and stream.IntParam1 = friend.userId LEFT OUTER JOIN movie_ratings on Action = 8 and stream.ItemId = movie_ratings.MovieId and stream.userid = movie_ratings.UserId and movie_ratings.quickthoughts <> '' LEFT OUTER JOIN tv_series_ratings on Action = 13 and stream.ItemId = tv_series_ratings.SeriesId and stream.userid = tv_series_ratings.UserId and tv_series_ratings.quickthoughts <> '' LEFT OUTER JOIN tv_episode_ratings on Action = 11 and stream.ItemId = tv_episode_ratings.EpisodeId and stream.userid = tv_episode_ratings.UserId and tv_episode_ratings.quickthoughts <> '' WHERE stream.UserId in ( ) AND (ItemType IS NULL OR ItemType <> 'M' OR movies.Adult = 0) AND stream.IsDeleted = 0 and '170' > 0 ORDER BY DATE DESC, StreamId DESC LIMIT 0, 40
When i try to login, i've this sql error :
A Database Error Occurred
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND (ItemType IS NULL OR ItemType <> 'M' OR movies.Adult = 0)' at line 87
SELECT users.Username, stream.* , movie_details.TranslatedTitle as MovieTitle , (select case when ItemType = 'S' then sd1.SeriesId else sd2.SeriesId end) as SeriesId , (select case when ItemType = 'S' then sd1.SeriesName else sd2.SeriesName end) as SeriesName , tv_episode_details.EpisodeName , tv_episodes.SeasonNumber , tv_episodes.EpisodeNumber , movies.YEAR as MovieYear , achievements.AchievementId , achievements.AchievementName , friend.UserId as FriendUserId , friend.Username as FriendUsername , movie_ratings.QuickThoughts as mQuickThoughts , tv_series_ratings.QuickThoughts as sQuickThoughts , tv_episode_ratings.QuickThoughts as eQuickThoughts FROM stream LEFT OUTER JOIN movies ON ItemType = 'M' AND stream.ItemId = movies.MovieId LEFT OUTER JOIN movie_details ON ItemType = 'M' AND MovieDetailId = ( SELECT MovieDetailId FROM movie_details WHERE MovieId = stream.ItemId ORDER BY ( CASE movie_details.Locale WHEN 'fr' THEN 1 WHEN 'en' THEN 2 ELSE 3 END ) LIMIT 1 ) LEFT OUTER JOIN tv_episode_details ON ItemType = 'E' AND EpisodeDetailId = ( SELECT EpisodeDetailId FROM tv_episode_details WHERE EpisodeId = stream.ItemId ORDER BY ( CASE tv_episode_details.Locale WHEN 'fr' THEN 1 WHEN 'en' THEN 2 ELSE 3 END ) LIMIT 1 ) LEFT JOIN tv_episodes ON ItemType='E' AND tv_episodes.EpisodeId=tv_episode_details.EpisodeId LEFT OUTER JOIN tv_series_details sd1 ON ItemType = 'S' AND sd1.SeriesDetailsId = ( SELECT SeriesDetailsId FROM tv_series_details WHERE SeriesId = stream.ItemId ORDER BY ( CASE tv_series_details.Locale WHEN 'fr' THEN 1 WHEN 'en' THEN 2 ELSE 3 END ) LIMIT 1 ) LEFT OUTER JOIN tv_series_details sd2 ON ItemType = 'E' AND sd2.SeriesDetailsId = ( SELECT SeriesDetailsId FROM tv_series_details WHERE SeriesId = tv_episodes.SeriesId ORDER BY ( CASE tv_series_details.Locale WHEN 'fr' THEN 1 WHEN 'en' THEN 2 ELSE 3 END ) LIMIT 1 ) LEFT OUTER JOIN achievements ON stream.IntParam1 = achievements.AchievementId LEFT OUTER JOIN users ON stream.UserId = users.UserId LEFT OUTER JOIN users AS friend ON Action = 5 and stream.IntParam1 = friend.userId LEFT OUTER JOIN movie_ratings on Action = 8 and stream.ItemId = movie_ratings.MovieId and stream.userid = movie_ratings.UserId and movie_ratings.quickthoughts <> '' LEFT OUTER JOIN tv_series_ratings on Action = 13 and stream.ItemId = tv_series_ratings.SeriesId and stream.userid = tv_series_ratings.UserId and tv_series_ratings.quickthoughts <> '' LEFT OUTER JOIN tv_episode_ratings on Action = 11 and stream.ItemId = tv_episode_ratings.EpisodeId and stream.userid = tv_episode_ratings.UserId and tv_episode_ratings.quickthoughts <> '' WHERE stream.UserId in ( ) AND (ItemType IS NULL OR ItemType <> 'M' OR movies.Adult = 0) AND stream.IsDeleted = 0 and '170' > 0 ORDER BY DATE DESC, StreamId DESC LIMIT 0, 40
