PHP Notice when listing API keys.

[eri-trabiccolo]

Reproduction Steps

• As authenticated and allowed user retrieve the api keys list: GET https://yourdomain/wp-json/llms/v1/api-keys (enable wp debug logging)

Expected Behavior

• I'd expect the api keys list to be retrieved with no errors/warning

Actual Behavior

• PHP warnings are printed in the log:

Error Messages / Logs

[27-Dec-2022 16:23:45 UTC] WordPress database error Unknown column '_links' in 'field list' for query SELECT _links FROM wp_lifterlms_api_keys WHERE id = 1 made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, LLMS_REST_Controller->get_items, LLMS_REST_API_Keys_Controller->prepare_collection_items_for_response, LLMS_REST_API_Keys_Controller->prepare_item_for_response, LLMS_Abstract_Database_Store->get, LLMS_Abstract_Database_Store->read
[27-Dec-2022 16:23:45 UTC] PHP Notice:  Trying to access array offset on value of type bool in /shared/httpd/mywp/wordpress.git/wp-content/plugins/lifterlms/includes/abstracts/llms.abstract.database.store.php on line 170

System and Environment Information

LifterLMS 7.0.1 WordPress 6.1.1 LifterLMS REST API 1.0.0-beta.25

This issue has been recreated:

• [x] Locally
• [ ] On a staging site
• [ ] On a production website
• [ ] With only LifterLMS and a default theme

Browser, Device, and Operating System Information

n/a

Related User Information

n/a