Question:
For some strange reason, I need to delete an entry directly from the database rather than via the control panel. What tables do I need to make sure it’s gone from?
Answer:
Entry information is stored in several tables in the database, so you need to delete information from all of the appropriate tables. Specifically, make sure you look in the “exp_weblog_titles” and “exp_weblog_data” tables.
Also, if you’re caching your Templates then deleting an entry may not immediately cause any change on your site since it would still be displaying the cached version. You can manually clear the cache under ‘Admin > Clear Cached Data Files’.