sply

Forum Replies Created

Viewing 3 replies - 1 through 3 (of 3 total)
  • Forum: Plugins
    In reply to: [Participants Database] No entries found in admin/record edit role
    Thread Starter sply

    (@sply)

    3 years ago

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

    Forum: Plugins
    In reply to: [Participants Database] No entries found in admin/record edit role
    Thread Starter sply

    (@sply)

    3 years ago

    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.

    Forum: Plugins
    In reply to: [Participants Database] No entries found in admin/record edit role
    Thread Starter sply

    (@sply)

    3 years ago

    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
Viewing 3 replies - 1 through 3 (of 3 total)