Query to see list of pages where plugin is used not working

  • A frequent question here: how do I get a list of places on my site where this plugin is used?
    Four+ years ago the plugin author (thank you) suggested:

    This SQL query will tell you if you are using the plugin on any of your posts or pages:
    SELECT * FROM wp_postmeta WHERE meta_key = “_links_to”

    Alas, when I run this query I get this error:
    1054 – Unknown column ‘“_links_to”’ in ‘where clause’

    Has something changed to make this query no longer valid? Any suggestions appreciated.

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

  • that should still work

    just manually type the quotations ” ” or ‘ ‘

    When you copy and paste, the quotes get messed up

    that’s why it isn’t working for you

    • This reply was modified 1 year, 3 months ago by derher.
    Thread Starter JimGasperini

    (@jimgasperini)

    Thanks, that did the trick, at least in getting the query to work.

    It found 783 rows. Few of these use the Links To plugin, so there must be something else that uses the same text string. I see a few that do use it, and some maybes; there is at least one that does use it that I cannot find in the results. Strangely, the numbers that show up in the post_id column do not seem to correspond to any posts or pages on the site.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Query to see list of pages where plugin is used not working’ is closed to new replies.