Query for Finding Orphaned files In Drupal
SELECT fm.*
FROM file_managed AS fm
LEFT OUTER JOIN file_usage AS fu ON ( fm.fid = fu.fid )
LEFT OUTER JOIN node AS n ON ( fu.id = n.nid )
WHERE (fu.type = 'node' OR fu.type IS NULL) AND n.nid IS NULL
More articles by Waliullah Khan
-
Drupal 8 Page Call Process
Drupal 8 Page Call Process
Let's talk about the page call process in drupal 8 Drupal 8 utilization and architecture where index.php acts as front…
-
hook_init() in Drupal8
hook_init() in Drupal8
In Drupal – 8 most of the Hooks such as hook_init, hook_boot are removed from the Drupal 8. These Hooks are replaced…
-
How to create Custom Rest Resources for GET methods in Drupal 8
How to create Custom Rest Resources for GET methods in Drupal 8
One of the biggest changes in Drupal 8 is the integration of Rest services in the core. With use of Views it become…
-
SWITCHING THEMES PROGRAMATICALLY IN DRUPAL 8
SWITCHING THEMES PROGRAMATICALLY IN DRUPAL 8
Sometimes we need to use different designs for separate pages or for separate menu items in a site.The most obvious way…
-
Drupal 8: How to create custom token programmatically
Drupal 8: How to create custom token programmatically
What is Token: Token is a small bits of text, which can be placed into a large documents as a simple placeholders. What…
-
Implementing #autocomplete in Drupal 8 with Custom Callbacks
Implementing #autocomplete in Drupal 8 with Custom Callbacks
Autocomplete on textfields like tags / user & node reference helps improve the UX and interactivity for your site…
-
Drupal 8: How to create a custom block programatically
Drupal 8: How to create a custom block programatically
Blocks in Drupal 8 are instances of the block plugin. The Drupal block manager scans your modules for any classes that…
-
How to setup eSpeak TTS server for WebSpeech
How to setup eSpeak TTS server for WebSpeech
STEP-1 : Download and install Espeak Please get eSpeak from http://espeak.sourceforge.
1 Comment
Explore content categories
- Career
- Productivity
- Finance
- Soft Skills & Emotional Intelligence
- Project Management
- Education
- Technology
- Leadership
- Ecommerce
- User Experience
- Recruitment & HR
- Customer Experience
- Real Estate
- Marketing
- Sales
- Retail & Merchandising
- Science
- Supply Chain Management
- Future Of Work
- Consulting
- Writing
- Economics
- Artificial Intelligence
- Employee Experience
- Workplace Trends
- Fundraising
- Networking
- Corporate Social Responsibility
- Negotiation
- Communication
- Engineering
- Hospitality & Tourism
- Business Strategy
- Change Management
- Organizational Culture
- Design
- Innovation
- Event Planning
- Training & Development