My records have disappeared in admin view

  • bbbaldie

    (@bbbaldie)


    1 year, 10 months ago

    My records are intact, but they’re not showing in the admin “list participants” view. I’ve cleared the filters, and also tried filtering using terms that are in the records. Nothing.

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter bbbaldie

    (@bbbaldie)

    1 year, 10 months ago

    [05/04/23 7:44pm UTC]
    Constant FORCE_SSL_ADMIN already defined
    in /home/dh_v5ihwp/miamihistory.net/wp-config.php on line 113
    Log file initiated at: May 4, 2023 7:44 pm UTC
    [05/04/23 7:44pm UTC]
    Constant FORCE_SSL_ADMIN already defined
    in /home/dh_v5ihwp/miamihistory.net/wp-config.php on line 113
    [05/04/23 7:44pm UTC]
    Constant FORCE_SSL_ADMIN already defined
    in /home/dh_v5ihwp/miamihistory.net/wp-config.php on line 113
    Log file initiated at: May 4, 2023 7:44 pm UTC
    [05/04/23 7:44pm UTC]
    PDb_List_Admin::initialize list query: SELECT * FROM wp_hfh3ns_participants_database p ORDER BY p.date_updated = "" OR p.date_updated IS NULL, p.date_updated desc LIMIT 0,300
    [05/04/23 7:44pm UTC]
    Constant FORCE_SSL_ADMIN already defined
    in /home/dh_v5ihwp/miamihistory.net/wp-config.php on line 113
    [05/04/23 7:44pm UTC]
    Constant FORCE_SSL_ADMIN already defined
    in /home/dh_v5ihwp/miamihistory.net/wp-config.php on line 113
    Log file initiated at: May 4, 2023 7:44 pm UTC
    [05/04/23 7:44pm UTC]
    PDb_List_Admin::initialize list query: SELECT * FROM wp_hfh3ns_participants_database p ORDER BY p.date_updated = "" OR p.date_updated IS NULL, p.date_updated desc LIMIT 0,300
    [05/04/23 7:44pm UTC]
    Constant FORCE_SSL_ADMIN already defined
    in /home/dh_v5ihwp/miamihistory.net/wp-config.php on line 113
    [05/04/23 7:44pm UTC]
    Constant FORCE_SSL_ADMIN already defined
    in /home/dh_v5ihwp/miamihistory.net/wp-config.php on line 113
    Plugin Author xnau webdesign

    (@xnau)

    1 year, 10 months ago

    The errors shown in the error log you posted are from another plugin, check into whatever plugin (or custom code) might be setting the FORCE_SSL_ADMIN constant. Participants Database doesn’t do that.

    lwith

    (@lwith)

    1 year, 10 months ago

    My records also dissapeared in the admin view.

    I get the following debug log when trying to export CSV:


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

    Pasting the select statement into phpMyAdmin results in “Unrecognized Keyword near IS”

    MySQL version is 8.0

    • This reply was modified 1 year, 10 months ago by lwith.
    • This reply was modified 1 year, 10 months ago by lwith.
    • This reply was modified 1 year, 10 months ago by lwith.
    Plugin Author xnau webdesign

    (@xnau)

    1 year, 10 months ago

    That is a bit mysterious, the query is compatible with MySql 8.0 as far as I can tell, so I’m not sure what the problem is. If there is no error message in the log, then this isn’t the problme, it’s something else.

    What exactly is happening when you attempt the export?

    lwith

    (@lwith)

    1 year, 10 months ago

    The following Message is shown:

    CSV export failed with error:

    Incorrect TIMESTAMP value: ”

    lwith

    (@lwith)

    1 year, 10 months ago

    I removed
    p.date_updated = “” or
    in participants-database/classes/PDb_admin_list/query.php line 181 resulting in

    $sortclause = 'ORDER BY p.%1$s IS NULL, p.%1$s %2$s';

    and it works again

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘My records have disappeared in admin view’ is closed to new replies.