I've got a Runway site with Perch Members. I've imported members direct into the database from Excel. Everything appears to be working OK. But when on the "Listing members" page in Perch admin and clicking column headings to sort the list of members, I'm getting this notice displayed above the list of members (this is in my local development site where I display all errors etc):
Notice: Undefined index: _id in C:\wamp\www\pixel\cms\addons\apps\perch_members\modes\members.list.post.php on line 121
And in debug (in both development and live sites):
[type] => 8
[message] => Undefined index: _id
[file] => C:\wamp\www\pixel\cms\addons\apps\perch_members\modes\members.list.post.php
[line] => 121
The error is not displayed when sorting by members' email addresses; it only happens when sorting by the "Joined" date or by "Status". Despite the error, the sorting still works correctly.
This wasn't happening before I imported members from Excel - sorting wasn't producing the error then. So I'm pretty sure it's a problem with how I've imported the data not an issue with Runway or the Perch Members app. I've made no changes to Perch core or Perch Members files.
I'd be really grateful if someone could point me in the right direction to resolve this in case it affects something else in the future that I haven't tested yet.
Perch Runway: 3.1.7, PHP: 7.2.0, MySQL: mysqlnd 5.0.12-dev - 20150407 - $Id: b396954eeb2d1d9ed7902b8bae237b287f21ad9e $, with PDO
Server OS: WINNT, apache2handler
Installed apps: content (3.1.7), assets (3.1.7), categories (3.1.7), perch_forms (1.12), perch_members (1.6.4), mbk_forms (1.0), pipit (0.6.1), pipit_members (1.3.0)
App runtimes: <?php $apps_list = [ 'perch_forms', 'mbk_forms', 'perch_members', 'pipit', 'pipit_members', ]; ?>
Image manipulation: GD
PHP limits: Max upload 128M, Max POST 128M, Memory: 1024M, Total max file upload: 128M
Resource folder writeable: Yes