bobbysmith007 on "[Plugin: WP-DB-Table-Editor] Fatal error: Allowed memory size of"

Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 71 bytes) in /public_html/wp-includes/wp-db.php on line 2349

that line is: $new_array[] = array_values( get_object_vars( $row ) );

when i try to see all the coloumns of one table the plugin dies.
if i limit the query it work very well...

what can i do?

thank you

https://wordpress.org/plugins/wp-db-table-editor/

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