Menu

#531 Create a way to identify no longer valid cover art URLs

Approved
closed
None
5
2014-02-02
2012-03-27
Anonymous
No

Create a way to identify no longer valid cover art URLs. Since pinging third party sites to check the existence of every URL could be too bandwidth-intensive, this will likely be an infrequently (once every 6 months?) process.

ORIGINAL DESCRIPTION entered by an anonymous contributor as a Bug report below:

I'm noticing that a lot of the URLs for cover art point to non existent images. Do you want these listed and corrected in some way?
Is there a good way I can supply you with corrections? SQL for operting directly on the MySQL?
(I'm using 11th March database dump)

Unable to add file http://g-ecx.images-amazon.com/images/G/01/ciu/fb/c7/b592225b9da088be7fe61110.L.jpg
Unable to add file http://ecx.images-amazon.com/images/I/41r4JChJHZL.jpg
Unable to add file http://g-ecx.images-amazon.com/images/G/01/ciu/69/69/1598228348a0143f9fe61110.L.jpg
Unable to add file http://ecx.images-amazon.com/images/I/51T5R3AGSQL.jpg
Unable to add file http://home.att.net/~dlmck/dlmck0.jpg
Unable to add file http://ecx.images-amazon.com/images/I/51rqIOKKUPL.jpg
Unable to add file http://ecx.images-amazon.com/images/I/513PQRrw8dL.jpg
Unable to add file http://www.tabula-rasa.info/HorrorImages/KimNewman.jpg
Unable to add file http://www.daveduncan.com/covers/book_back.jpg
Unable to add file http://www.nightshadebooks.com/jackcady.jpg
Unable to add file http://ecx.images-amazon.com/images/I/5102473A9JL.jpg
Unable to add file http://ecx.images-amazon.com/images/I/51meV13O53L.jpg
Unable to add file http://g-ec2.images-amazon.com/images/I/51DEE9Q2H4L.jpg
Unable to add file http://ecx.images-amazon.com/images/I/51Z84VX9VZL.jpg

Discussion

  • Ahasuerus

    Ahasuerus - 2014-01-25

    Ticket moved from /p/isfdb/bugs/248/

     
  • Ahasuerus

    Ahasuerus - 2014-01-25
    • summary: Lots of cover art urls are out of date --> Create a way to identify no longer valid cover art URLs
    • Description has changed:

    Diff:

    --- old
    +++ new
    @@ -1,6 +1,10 @@
    +Create a way to identify no longer valid cover art URLs. Since pinging third party sites to check the existence of every URL could be too bandwidth-intensive, this will likely be an infrequently (once every 6 months?) process.
    +
    +ORIGINAL DESCRIPTION entered by an anonymous contributor as a Bug report below:
    +
     I'm noticing that a lot of the URLs for cover art point to non existent images. Do you want these listed and corrected in some way? 
     Is there a good way I can supply you with corrections? SQL for operting directly on the MySQL? 
    -\(I'm using 11th March database dump\)
    +(I'm using 11th March database dump)
    
     Unable to add file http://g-ecx.images-amazon.com/images/G/01/ciu/fb/c7/b592225b9da088be7fe61110.L.jpg
     Unable to add file http://ecx.images-amazon.com/images/I/41r4JChJHZL.jpg
    
    • Group: --> Approved
     
  • Ahasuerus

    Ahasuerus - 2014-02-02
    • status: open --> closed
    • assigned_to: Ahasuerus
     
  • Ahasuerus

    Ahasuerus - 2014-02-02

    New cleanup script created. Implemented in:

    mod/bad_images.py 1.1
    mod/cleanup.py 1.21
    mod/resolve_bad_url.py 1.1
    mod/TARGETS 1.31
    scripts/create_bad_image_table.sql 1.1
    scripts/populate_bad_image_table.py 1.1
    

    Installed in r2014-73 on 2014-02-01. Closing.

     

Anonymous
Anonymous

Add attachments
Cancel





MongoDB Logo MongoDB