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
The following Message is shown:
CSV export failed with error:
Incorrect TIMESTAMP value: ”
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 3 years ago by lwith.
-
This reply was modified 3 years ago by lwith.
-
This reply was modified 3 years ago by lwith.
