Duplicate entries after edit

Issue #30 resolved
Ron Pringle repo owner created an issue

Sometimes after editing an entry, a search for that title will produce duplicate entries. This is likely related to the fact that the edit function always retrieves the latest info from TMDb including the poster. If the poster changed in any way, a new poster entry is written into ml_movie_posters.

The search query improperly joins multiple poster records to each movie entry.

Comments (1)

  1. Ron Pringle reporter

    Added a "group by 'title'" clause to the SQL Query to eliminate duplicate records, since the original query was creating a new record for each unique poster for each movie.

  2. Log in to comment