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?
You may need to change wp_ if you have another table prefix in your WordPress installation.
Any chance to try out that SQL statement to see what the problem might be displaying the moderation items on your site?
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.
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.
