Probably the page is trying to show all the records (or just too many of the records), you need to set it to show only some of the records. The preference for how many records to show is saved as a user preference, but since you can’t open the page, you can’t save a different preference.
First check to make sure your global “Records per Page” preference for Participants Database is not set to “-1” that will probably crash your site on the frontend too. Should be set to a reasonable value like 25-50. Showing a massively long list is not good UI.
To reset the admin preference, you need to delete the preference directly in the database where it is stored. Open the database using phpMyAdmin (you’ll find this in your hosting control panel) select your WP database, then click on the options table (wp_options).
The name of the option with the preference will include the user ID, so you will need to know your user ID. You can see this if you go to your profile page in the admin section.
The option you’re looking for will be named: “pdb-admin-user-settings-1” where the “1” is the user id. Replace the 1 with your id to find the preference in the options table. Once you’ve found the preference just delete the whole thing. That will reset the options to their default values.
Now you should be able to open your list page in the admin.
Also, bear in mind that the number of columns you are showing will affect the memory footprint of displaying the list, so keep that to a minimum too.
Hi Thanks for the quick response.
I have tried removing the entry for this.
There where actually 2 entries.
pdb-admin-user-settings-1
pdb-admin-user-settings-2
I tried deleting both individually whilst retrying but still no joy.
I have also used the manage list columns to reduce the number displayed, and when i disabled the plugins i was also to set the show items on page to a low number.
but the rest of the page still fails to load below that.
I reviewed the line in the code where it advises the line in wp-db.php on line 2720
it is the line listed below as “foreach ( (array) $this->last_result as $row ) {”
not sure whether this helps any however.
return $new_array;
} elseif ( ARRAY_A === $output || ARRAY_N === $output ) {
// Return an integer-keyed array of...
if ( $this->last_result ) {
foreach ( (array) $this->last_result as $row ) {
if ( ARRAY_N === $output ) {
// ...integer-keyed row arrays.
$new_array[] = array_values( get_object_vars( $row ) );
} else {
// ...column name-keyed row arrays.
$new_array[] = get_object_vars( $row );
There are a lot of records in the database approx 30’000, and with unfortunately still more to add from here,
thanks again for all of your help, the plugin is amazing and the extra search functions of the multicombo search is great.
Thanks in advince
OK, well this kind of thing is very difficult to diagnose because there’s no direct way to know what’s causing the problem. The error message is no help because it’s just telling you where the code ran out of memory, not what happened to get you there.
Still, it is a good idea to turn plugin debugging on, clear the debugging log, then attempt to load the page (in another tab). See what comes into the log, it might be helpful.
Did you try cutting down on the number of columns the lists are showing?
Hi.
sorry for the late reply.
ive turned on debugging and went back to the list page and back again, but nothing listed in the debug log that i can see.
Yeah ive taken the columns down to 2.
would it help any if i gave you a login to the back end>
Cheers
The list display you tested, was it in the backend? That should be reset when you deleted the admin preference settings. If you’re still having the problem loading the list of records in the admin then the problem may be in the actual data contained in the records, if you choose 1 or 2 columns that are small pieces of data, you should be able to at least get it to show that list.
Another thing to check is in the admin, go to the Tools/Site Health page and check to see if there are any recommendations. You can also look at the “Info” tab: Check the “Server” and “WordPress Constants” tabs. Make sure your memory configurations are all all correct. You may need to increase all your memory limits in order to accommodate a large database.
