Title: Moderation’s stopped working
Last modified: December 14, 2016

---

# Moderation’s stopped working

 *  [ccardin](https://wordpress.org/support/users/ccardin/)
 * (@ccardin)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/moderations-stopped-working/)
 * Hi !
 * Moderation shows 3 new links but the moderation page is empty. I have been unable
   to moderate link for a few months…
 * Does this exer happened to anyone ?
 * Thank you for your time 🙂

Viewing 6 replies - 1 through 6 (of 6 total)

 *  Thread Starter [ccardin](https://wordpress.org/support/users/ccardin/)
 * (@ccardin)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/moderations-stopped-working/#post-8601588)
 * [@jackdewey](https://wordpress.org/support/users/jackdewey/)
 * Des idées ?
 *  Plugin Author [Yannick Lefebvre](https://wordpress.org/support/users/jackdewey/)
 * (@jackdewey)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/moderations-stopped-working/#post-8603215)
 * Sorry for the late response. The holiday season has been quite busy.
 * When you go to the Moderation section, it runs the following query to find posts:
 *     ```
       SELECT distinct *, l.link_id as true_link_id
       FROM wp_links_extrainfo le 
       LEFT JOIN wp_links l ON (le.link_id = l.link_id) 
       LEFT JOIN wp_term_relationships tr ON (l.link_id = tr.object_id) 
       LEFT JOIN wp_term_taxonomy tt ON (tt.term_taxonomy_id = tr.term_taxonomy_id) 
       LEFT JOIN wp_terms t ON (t.term_id = tt.term_id) 
       WHERE l.link_description like '%LinkLibrary:AwaitingModeration:RemoveTextToApprove%' 
       AND tt.taxonomy = 'link_category' 
       ORDER by link_name ASC
       ```
   
 * Are you familiar enough with phpMyAdmin to try running this query and seeing 
   if it throws any errors?
 *  Plugin Author [Yannick Lefebvre](https://wordpress.org/support/users/jackdewey/)
 * (@jackdewey)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/moderations-stopped-working/#post-8603217)
 * You may need to change wp_ if you have another table prefix in your WordPress
   installation.
 *  Plugin Author [Yannick Lefebvre](https://wordpress.org/support/users/jackdewey/)
 * (@jackdewey)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/moderations-stopped-working/#post-8610620)
 * Any chance to try out that SQL statement to see what the problem might be displaying
   the moderation items on your site?
 *  Thread Starter [ccardin](https://wordpress.org/support/users/ccardin/)
 * (@ccardin)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/moderations-stopped-working/#post-8610778)
 * For the querry : it gives :
 * MySQL a retourné un résultat vide (aucune ligne). (Traitement en 0.0017 secondes.)
 * But no errors
 * And I have 4 links waiting for moderation.
 *  Plugin Author [Yannick Lefebvre](https://wordpress.org/support/users/jackdewey/)
 * (@jackdewey)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/moderations-stopped-working/#post-8631850)
 * Ok, here is another query to test. It should come up with the same number that
   you are seeing in the interface next to the moderation menu item:
 *     ```
       SELECT count(*) FROM wp_links l 
       WHERE l.link_description like '%LinkLibrary:AwaitingModeration:RemoveTextToApprove%' 
       ORDER by link_name ASC
       ```
   
 * If that does come up with a number, then we would need to figure out where information
   is missing. Run the following query:
 *     ```
       SELECT l.link_id FROM wp_links l 
       WHERE l.link_description like '%LinkLibrary:AwaitingModeration:RemoveTextToApprove%' 
       ORDER by link_name ASC
       ```
   
 * Then, look for the following records:
 * – Record with same link_id in wp_links_extrainfo
    – Record with same link_id 
   in wp_term_relationships. If found, write down corresponding term_taxonomy_id–
   Record with recorded term_taxonomy_id in wp_term_taxonomy. If found, note corresponding
   term_id – Record with recorded term_id in wp_terms
 * Once I understand where data is missing, I can make adjustments. One question
   though, do you user-submitted links have categories? If not, that would explain
   the issue.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Moderation’s stopped working’ is closed to new replies.

 * ![](https://ps.w.org/link-library/assets/icon-256x256.jpg?rev=971117)
 * [Link Library](https://wordpress.org/plugins/link-library/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/link-library/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/link-library/)
 * [Active Topics](https://wordpress.org/support/plugin/link-library/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/link-library/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/link-library/reviews/)

## Tags

 * [moderation](https://wordpress.org/support/topic-tag/moderation/)

 * 6 replies
 * 2 participants
 * Last reply from: [Yannick Lefebvre](https://wordpress.org/support/users/jackdewey/)
 * Last activity: [9 years, 4 months ago](https://wordpress.org/support/topic/moderations-stopped-working/#post-8631850)
 * Status: not resolved