The Movie Database Support
Support → Website Support
Foreign genre tag: Over 1 year and still not removed
posted by Matthew SandersSTAFFMOD on February 17, 2013 at 10:50 AM
Discussions about this are older than 1 year and the tag is still with us. I've had to remove the foreign tag from over a dozen movies tonight. Foreign does not equal non-USA or even non-English. It's a subjective term that doesn't make friends with the rest of the non-English aspects of this site.
<?php $sql = $mysqli->query("SELECT index_id, genre FROM movie_db WHERE genre LIKE '%foreign%'"); while($result=mysqli_fetch_assoc($sql)) { $genre= str_replace("foreign", "", "$result['genre']"); $delete = $mysqli->query("UPDATE movie_db SET genre = '$genre' WHERE index_id = '".$result['index_id']."'"); } ?>
The new way to edit movies is beautiful. I appreciate all of your work behind the scenes making this site easier to update and browse, Travis. Removing the foreign genre is also a step in the right direction.
Reply by MacFly 🇫🇷
on February 20, 2013 at 12:29 AM
i agree
i had about 500 movies with foreign genre (30% of my database, not yet complete)
removed manually on my side (this could have been made on themoviedb but it's buggy ;-)
this NEEDS to be fixed !
Reply by Travis Bell
on February 20, 2013 at 1:46 AM
This is a known issue and is discussed here: http://www.themoviedb.org/talk/5070e718760ee335210009df
As soon as the genre stuff is fixed, I'll be looking at the foreign issue.
There's reasons this hasn't been fixed yet but it's close to being able to be worked on. My hands are tied for a few more weeks.
Reply by Matthew Sanders
on February 21, 2013 at 10:24 AM
Alright. Thanks for replying Travis. Any moderator positions open?
Reply by Skeata
on February 21, 2013 at 2:22 PM
I'd also like to point out that removing the Foreign tag manually from a movie doesn't appear to stick. I too have removed Foreign tags only to have them reappear days later with out any manual intervention. ie. there is no history in the changes log showing someone had put the genre back on to the movie. Please look at Full Metal Jacket as an example. It has a history of the genre being removed and magically reappearing.
Reply by Matthew Sanders
on February 21, 2013 at 2:28 PM
That's interesting. Maybe it has to do with database backups being reinstated under certain conditions? That wouldn't leave a log entry for us to see.