Fatal error: Allowed memory size of

Whelp, your table must have too much data in the results (it claims it exhausted 270megs which is too much to send to the client anyway). In situations like this I have added custom buttons and server side paging (eg: display only a single year/month of results at a time and have a button that changes what is displayed. This is fairly easy to accomplish if you set the sql parameter of add_db_table_editor and use request variables to determine what set to see.

You can use jquery to shim in a button (by loading a custom script on the admin page that displays the editor of your choice). If you need more details please let me know and I can probably find an example

a paging system would be really nice – i didn;t find any example… can you help me? thank you

i want to make a page system… can you help telling me where to put this code… where is the page that shows the table?

$page_links = paginate_links( array(
‘base’ => add_query_arg( ‘pagenum’, ‘%#%’ ),
‘format’ => ”,
‘prev_text’ => __( ‘«’, ‘text-domain’ ),
‘next_text’ => __( ‘»’, ‘text-domain’ ),
‘total’ => $num_of_pages,
‘current’ => $pagenum
) );

if ( $page_links ) {
echo ‘<div class=”tablenav”><div class=”tablenav-pages” style=”margin: 1em 0″>’ . $page_links . ‘</div></div>’;
}

or any other solutions is welcomed ??

thank you for your help

Alright I just committed an example of paging by year. Hopefully you can extrapolate that into paging / filtering by any random thing

PHP: https://github.com/AccelerationNet/wp-db-table-editor/blob/master/examples/paging.php

JS: https://github.com/AccelerationNet/wp-db-table-editor/blob/master/examples/payment-paging.js

Cheers, and hope this helps