No entries found in admin/record edit role

  • This had been working fine for ages but suddenly I am being met with the “no records found” message when I go to “List Participants” either as an admin user or editor level, in the WP dashboard/backend.

    I can confirm that the data is still there in the raw database and people are still able to add new fields from the front-end side of things.

    I have searched for records I know are there in various ways via the plugin’s own search functionality and nothing is ever found.

    I cannot give access to the backend due to GDPR etc. but I really need to find a solution to this quickly as I need to contact our volunteers for an upcoming event, so I’d really appreciate any assistance.

    I am on the latest version of the plugin, on the latest WordPress, running PHP 8.1.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author xnau webdesign

    (@xnau)

    Take a look at what is getting used for the database query by turning plugin debugging on. Clear the debugging log, then load the page and check the log for the database query that was used.

    Thread Starter sply

    (@sply)

    PDb_List_Admin::initialize list query: SELECT * FROM wp_participants_database p  ORDER BY p.date_updated = "" OR p.date_updated IS NULL, p.date_updated desc LIMIT 0,10

    So a timestamp field can’t be compared to a string there… something like wrapping it in year(field)=0 or unix_timestamp(field)=0 would be a better idea if you’re trying to catch non-null situations. The following worked in the raw database:

    SELECT * FROM wp_participants_database p  ORDER BY UNIX_TIMESTAMP(p.date_updated) = 0 OR p.date_updated IS NULL, p.date_updated desc LIMIT 0,10
    Thread Starter sply

    (@sply)

    I think even just:

    SELECT * FROM wp_participants_database p  ORDER BY p.date_updated = 0 OR p.date_updated IS NULL, p.date_updated desc LIMIT 0,10

    Should work OK. Can you correct this, or tell me where I can correct it myself in the plugin files for speed, whilst you change the code.

    Plugin Author xnau webdesign

    (@xnau)

    A query like the one the plugin uses where the timestamp value is compared to an empty string is normally fine, and it is testing good here.

    Nevertheless, I’ve gotten a couple of reports this is causing a problem and it seems to be related to the timezone setting of the database server.

    In the next release, we are going to avoid doing this for timezone columns, it should be out in a few days.

    Thread Starter sply

    (@sply)

    Ah thank you – is there anything I can edit in the meantime to temporarily overcome this? Thanks for your assistance, much appreciated!

    Plugin Author xnau webdesign

    (@xnau)

    The only thing I know you can do is avoid sorting the list by a timestamp field.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘No entries found in admin/record edit role’ is closed to new replies.