|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
I just found a 2.7MB+ pdf file stired in 'filedata' table that was orphaned.... IAW had NO reference anywhere else... not in 'attachment' table, et al. As far as I can tell, unless the file is listed in 'attachment', you can't find it in CP or anywhere else except by accident using phpMyAdmin, et al. database browser. So... if there is one orphan attachment, there is likely more... and I want to clean 'em out. I'm not a DBA or a SQL guy, so can anyone help out? Looks like to me what needs to happen is that I need to run an outside loop choosing each filedataid one at a time, and then see if there is a corresponding record in attachment with the same filedataid... and for any record in filedata that doesn't have a corresponding record in attachment, the record is added to a list of records to display as the query result. Anyone want to take a stab at helping me construct such a query/tool? Thanks! __DEFINE_LIKE_SHARE__ |
مواقع النشر (المفضلة) |
| |
المواضيع المتشابهه | ||||
الموضوع | كاتب الموضوع | المنتدى | مشاركات | آخر مشاركة |
Forum Attachments of images not working correctly | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 01-09-2013 06:10 PM |
CMS Can't get rid of (orphaned) attachments | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 06-19-2010 03:21 AM |
Forum How to open images or attachments in a new window? | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 01-28-2010 08:00 PM |
CMS Orphaned attachments in articles with no deletion options? | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 11-22-2009 12:30 AM |
CMS Orphaned attachments in articles with no deletion options? | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 11-22-2009 12:10 AM |