Dropped download attributes

[HinterWelt2]

So, the saga continues. I run several sites from 1.3.6 to 1.3.8a and they all show this dropping of downloads. Before, I thought it was out and out dropping of the attribute but no, the attribute is still there but the associates file descriptor is not. So, the indicator for the attribute is on, you can go and edit the attribute but the actual file name is missing. Note: the file is still on the server.

So, I came up with this sql and it seems to show all the dropped file names.

select pa.products_id, pa.products_attributes_id, p.products_name
from Products_attributes as pa, products_description as p
where not exists(select * from products_attributes_download as pad where  pa.products_attributes_id = pad.products_attributes_id ) and pa.products_id=p.products_id order by pa.products_id

The list is generates is

43 4418 Seeds: Supers I
44 4419 Seeds: Supers II
45 4420 Seeds: Supers III
46 4421 Seeds: Supers IV
47 4422 Seeds: Supers V
106 4496 Liber Artefactorum
213 4497 DM's Pipeline--2004
214 4498 DM's Idea Pipeline--2005
225 4499 Forbidden Arcana
250 4500 The Artificial Hero's Handbook
297 4501 Future: Datastream
305 4504 Future: 13 Starship Cargos
310 4505 Future: 13 Starship Devices
311 4506 Future: 13 More Starship Devices
313 4507 Future: Another 13 Starship Devices
314 4508 Future: 13 Vehicle Class Templates
315 4509 Future: 13 Gene Therapy Templates
338 4510 Modern Dispatch (#64): Mecha Defects and Quirks
349 4511 Future: Alien Race 2
352 4512 Future: Arcana
363 4513 Runic Fantasy: A Dozen Free Legendary Abilities
364 4514 Runic Fantasy: Expanded Professions
377 4515 Mortal Magic (Whispering Vault)
388 4516 vs. Monsters Deluxe Edition
389 4517 vs. Monsters Addition
403 4424 1st Appearance: T.O.M.C.A.T.S
404 4425 1st Appearance: Luminous
414 4426 A Matter of Family
415 4427 Superline: Campaign Planner
417 4429 Superline: A Fistful of Plot Devices 1
418 4430 Alien Invaders 2
422 4434 Superline: Campaign Planner 2
425 4437 PZP: Mooks Amok! #1
579 4518 Firefly Games: Monster Island (Main Rules)
580 4519 Firefly Games: Escape from Monster Island
581 4520 Firefly Games: Invasion of Monster Island
582 4521 Firefly Games: CyborGladiatiors (Main Rules)
588 4522 Firefly Games: Invincible (CyborGladiatiors)
590 4523 Firefly Games: Faery's Tale
605 3008 The Iconic Bestiary -- Volume One
612 4524 MEG: E-Giant Monster Rampage 2
622 4525 MEG: Giant Monster Rampage: Live Wire
629 4526 MEG: Zombie Dawn
662 4528 Seven Psionic Kata
671 4529 The Conjurer: The Core Specialist Wizard
672 4530 The Diviner: The Core Specialist Wizard
673 4531 The Abjurer: The Core Specialist Wizard
674 4532 The Illusionist: The Core Specialist Wizard
675 4533 The Enchanter: The Core Specialist Wizard
676 4534 The Transmuter: The Core Specialist Wizard
677 4535 The Evoker: The Core Specialist Wizard
678 4536 The Necromancer: The Core Specialist Wizard
771 4537 Tales of Gaea 1.5
772 3304 Another Man's Treasure: A Guide to Shadazar
773 3305 Circuses & Carnivals
774 2612 Austrian Holiday: A Day in the Country with Super Soldiers
776 4538 Roma Imperious
777 4539 Shades of Earth
782 4540 Supers Inc.
788 4542 Aerial Adventure Guide: Sky Captain's Handbook
801 4543 Complete Guide to Fey
810 4544 Demon Hunter's Handbook
863 4545 Lethal Legacies: Traps of the World Before
865 4546 Power Gamer's 3.5 Warrior Strategy Guide
866 4547 Power Gamer's 3.5 Wizard Strategy Guide
903 3027 (Su) Monsters: The Headless Horseman
969 3375 MagicQuest
972 3376 Fantasy Ships of the High Seas
1005 4548 Unusual Core Classes: The Spellweaver
1006 4549 Superior Synergy: Fantasy
1007 4550 OGL Barbarian: The Hawkeye (sampler)
1008 4551 OGL Barbarian: The Sea Devil (sampler)
1010 4440 Hearts & Souls
1016 4552 OGL Barbarian: The Child of Set (Sampler)
1017 4553 OGL Barbarian: The Deep Wilder (Sampler)
1018 4554 OGL Barbarian: The Barbaric Warrior
1019 4555 OGL Barbarian: The Barbaric Sorcerer
1023 4556 Superior Synergy: Modern and Future
1025 4557 Treasure Trove #1: SpirosBlaak Arsenal
1029 4558 Superior Synergy: Superheroic
1030 4559 Metahuman Mystics & Supernatural Supers 1
1031 4560 Metahuman Mystics & Supernatural Supers 2
1032 4561 Supernames
1040 4562 Metahuman Mystics & Supernatural Supers 3
1081 4563 Space Opera Passenger Generator
1082 4564 15 Space Opera Passengers
1084 4565 15 Starport Encounters
1087 4566 Space Opera Passengers Collection
1149 3402 DreamCatcher
1157 3404 NUGGETS Fantasy Toolkit
1159 3406 QMR - Character Assistant
1160 3407 QMR - Book of Bewildering Beasts
1161 4447 Legends Walk!
1182 4569 Mythic Heroes
1244 4448 Evil Genius #1: World Domination (M&M Superlink)
1246 4449 Zodiac Ring
1248 4451 Day of Dr Null
1249 4452 Death of Dr Null
1250 4571 Bits of Darkness: Dungeons
1253 4572 Bits of Darkness: Caverns
1254 4573 Bits of the Boulevard
1255 4574 Bits of the Wilderness: Into the Wildwood
1256 4575 Bits of the Wilderness: into the Swamp
1257 4576 Bits of the Wilderness: Into the Open
1258 4577 Bits of Darkness: Dungeons II
1259 4578 Shards of the Heart
1270 3418 Deck O' Names Anglo Saxon Places
1271 3419 Deck O' Names Card Deck 1
1359 4453 PZP: The Vault of Dr. Mechaniaikal
1360 3432 Digital Denizens: Challenge Rating Four
1361 3433 Digital Denizens: Challenge Rating One
1362 3434 Digital Denizens: Challenge Rating Three
1363 3435 Digital Denizens: Challenge Rating Two
1365 3437 TIC: Digital Denizens - Templates
1366 3438 TIC: Legends of Avadnu
1367 3439 TIC: The Broken Isles Lorebook
1368 3440 TIC: The Broken Isles Player's Guide
1388 3038 Lords of the Peaks: The Essential Guide to Giants
1396 3445 Digital Denizens: Challenge Rating Five
1402 4454 Dr Null / World Domination Bundle
1417 3042 Cooper's Corrected Creature Codex: A - C
1430 4580 Legends Walk - Truth & Justice Edition
1439 4581 Bits of the Banquet: Into the Desserts
1440 4456 Evil Genius #2: Crime & Punishment
1453 3456 Halls of Elysium
1455 3457 Wilderness Encounters 1
1457 3458 Wilderness Encounters 2 - Into The Mountains
1458 3459 Wilderness Encounters 3 - Desert Encounters
1459 3460 Wilderness Encounters 4 - The Deep Dark
1464 3461 Wilderness Encounters #5 - Inner City
1465 3462 Wilderness Survival
1487 3043 Cooper's Corrected Creature Codex: E - G
1491 2236 Dead of Night: Coyote Creek
1513 4582 LWTJ - Pantheon: China
1517 4583 Petty-Magick, Petty-Sorcerers and Hedge Wizards
1518 4584 The Collected Character
1532 3471 Yhtrek v1.1 (EABA)
1539 3472 Nocturne v1.0a (EABA)
1540 3473 Nocturne v1.0b (EABA)
1547 3474 Dreamtime v1.0 (CORPS)
1549 2630 Apocalypse v1.0 (CORPS)
1556 3475 Halls of Elysium 3rd Edition
1593 2667 17 Archer Feats
1598 4458 LWTJ - Pantheon: Celtic
1607 3045 Blackdyrge's Templates: Armored Apparition
1618 3046 Blackdyrge's Templates: Elder Fiend
1620 3048 Blackdyrge's Bestiary: Perils of the Burning Waste
1632 4461 D6 Powers
1633 4462 GODSEND Agenda
1634 4463 GODSEND Agenda D20 Conversion
1635 4464 GODSEND Agenda: U.S.E.R.'s Most Wanted
1636 4465 GODSEND Agenda: Superlink
1637 4466 GODSEND Agenda: God-Maker
1638 4467 GODSEND Agenda: Mother's Milk
1639 4468 GODSEND Agenda: Booster Deck
1641 3050 Into the Green: A Guide for Forests, Jungles, Woods and Plains
1645 3051 Blackdyrge's Templates: Spawn of Apophis
1668 3484 Qerth Apprentice Level Rules
1690 4469 Like Father, Like Son (Trial of Dr Null)
1692 4586 LWTJ - Pantheon: Mesopotamia
1703 3052 Blackdyrge's Bestiary: Terrors of the Under Realm (Revised)
1704 3053 Blackdyrge's Templates: Abominable
1712 3054 Blackdyrge's Templates: Messianic
1713 3486 The Adventures of Sindbad
1716 3055 Kaiser's Garden - 23 Monstrous Plants
1724 3056 Blackdyrge's Templates: Primordial Beast
1725 3057 Into the Blue: A Guide to Oceans and Coastal Waters
1727 2668
1728 3058 Blackdyrge's Templates: Elemental Exemplar
1802 3491 Worlds of Wonder
1803 3492 Worlds of Wonder, Book of Races
1804 3493 Worlds of Wonder, Book of Skills
1805 3494 Worlds of Wonder, Book of the Arcane
1806 3059 Blackdyrge's Templates: Martial
1808 3495 Worlds of Wonder, Healer Skill Set
1809 3496 Worlds of Wonder, Book of Faith
1810 3497 Worlds of Wonder, Book of Enchanting
1811 3498 Worlds of Wonder, Archer Skill Set
1812 3499 Worlds of Wonder, Deluxe Character Sheet
1813 3500 Worlds of Wonder, Book of Foes
1814 3501 Worlds of Wonder, Book of Beast
1815 3502 Worlds of Wonder, Blade Master Skill Set
1816 3503 Worlds of Wonder, Book of Black Magic
1817 3504 Worlds of Wonder, Sister of the Sun Skill Set
1818 3505 Worlds of Wonder, Monk Skill Set
1819 3506 Worlds of Wonder, Book of the Dead
1822 4471 Don't Rest Your Head
1823 3507 Behind the Monsters: Bulette
1828 3509 Behind the Monsters: Xorn
1829 3510 Behind the Spells: Vampiric Touch
1845 3060 Fell Beasts: Goblins
1852 2934 Lost Prehistorica
1862 4472 Wilderness Encounters 7 - Super Seed
1863 3061 Blackdyrge's Templates: Moldering
1876 3514 Lotsa Blocks!
1877 3515 Daemornia RPG Gamers Bundle
1879 4473 Pants Go On The Outside
1886 4587 Better Mousetrap
1889 4588 Rocket Jocks
1918 4475 Evil Genius #1: World Domination (Truth & Justice)
1925 3065 Blackdyrge's Templates: Roguish
1931 3526 Behind the Monsters: Terror Turkey
1961 4795 Labyrinth Lord
1962 4796 Labyrinth Lord (alternate cover)
1963 4797 Monster Listing (Labyrinth Lord)
1982 3067 Animal Archives: DinoFiles I - Raptor Pack
2003 4476 Ape Attack!
2004 4477 Mooks Amok! I: G-Men, Goons and Gorillas
2005 4478 The Vault of Dr. Mechaniaikial
2009 4482 Catacombs of Mistress Hecate
2044 3068 Blackdyrge's Templates: Devout
2047 4589 Altar of Reason v1.0 (EABA)
2055 4590 Colin Thomas Presents RASSLIN'
2068 4591 GM Gems
2069 3538 Behind the Monsters: Skeleton
2072 3069 Animal Archives: DinoFiles II - Theropods
2075 4483 Misfits & Menaces: Mixed Villains
2080 3539 Maelstrom Storytelling (Dogbound Edition)
2083 4592 The Book of Dumb Tables
2088 3070 Blackdyrge's Templates: Lesser Half-Dragon
2108 3544 Atomik Psioniks
2116 3547 Behind the Spells: Sanctuary
2117 3073 Blackdyrge's Templates: Brute
2119 4484 Truth & Justice: More Power
2158 4798 Delving Deeper - Bard
2162 4594 Eldritch Core Rule Book
2163 4799 Delving Deeper - Paladin
2190 4800 Valtor the Mighty, God of Strength, Courage and Combat Skill
2232 4801 Mutant Future
2248 4803 Delving Deeper - Ranger
2269 4596 Your World No Longer
2362 4597 Haiiii-Ya: Cartoon Martial Arts Combat
2370 4598 Misfits & Menaces: DOOM
2376 4600 Colonial Gothic: Poor Wizard's Grimoire
2380 4805 Scribe of Orcus, Volume 1 Issue 3
2413 4601 Advanced Player's Guide
2418 4602 Do-Gooders & Daredevils: Mixed Heroes
2430 4603 Misfits & Menaces: Tricks & Treats
2442 4604 Forgotten Heroes
2452 4808 Original Edition Characters
2461 4605 Eldritch Traps
2475 4809 Delving Deeper - Monk
2494 4606 Hero's Handbook: Dragonborn
2498 4607 Do-Gooders & Daredevils: Good I$ Capitali$m
2514 4810 The Ruins of Ramat
2540 4811 Delving Deeper - Skill Systems
2562 4609 Do-Gooders & Daredevils: Champions
2568 4610 Classifieds
2652 4812 Delving Deeper - Gnome
2731 4813 Scribe of Orcus, Volume 1 Issue 5
2761 4815 Green Devil Face #1
2763 4816 Green Devil Face #2
2764 4817 Death Frost Doom

Rather formidable. I will be working on a solution to this. For now, I get to run this SQL on the sites I administer.

Hopefully, if anyone else is having this sort of problem this will help.

[HinterWelt2]

I should point out the script above really only works well for download only stores. If you have a lot of products that do not have downloads you would get false positives. So, be aware if you have gift certificates or the like you would see those show up.

Bill