Problem with where-clause in shortcode

Check the security setting in Pods Admin > Settings > Security section

Look for the option: Allow SQL clauses to be used in Dynamic Features

Set this to restricted if it’s set to disabled so that you can enable the “where” clause of the dynamic features functionality.

Thanks Scott,

I was referred to this thread, but I don’t think it’s quite the same issue.

The security settings were already set to “restricted” there. I also tried “unrestricted” just in case.

In my setup, it’s not returning any records, just the error:

Pods Embed Error: JOIN contains SQL that is not allowed.

It’s been working perfectly for a few years, and suddenly stopped working and displays that error.

@brianatkinson what is your shortcode?

Thanks Scott – this is a site I inherited from a developer who is no longer in business, and while I’m fine making content changes, I don’t have the developer skill set.

I don’t see an obvious short code. The code that seems to use the Pod on one of the pages is (it’s similar on the other pages with different pods names etc):

<ul class="author_list column_3">[pods name="user" orderby="last_name" join="JOIN wp_usermeta_staff ON id=user_id" where="is_staff=1" template="Users"]</ul>

I also had to purge the caches after setting to unrestricted – that got it.