Delete WP logs from database

  • Resolved vimalsoneil

    (@vimalsoneil)


    2 years, 3 months ago

    https://prnt.sc/lygO00ywcXS6

    when trying to access wp-admin/edit.php?post_type=wp_log , getting error There has been a critical error on this website.

    had words with WPE they asked its memory limit issue and they can’t increase more than 512mb So , is there a way to delete old logs directly from database?

Viewing 1 replies (of 1 total)
  • Plugin Author Jonathan Stegall

    (@jonathanstegall)

    Well, I’m not a SQL expert, but sure. You would do something like this (I’d recommend you test it first):

    DELETE p, pm
  FROM wp_posts p
 INNER
  JOIN wp_postmeta pm
    ON pm.post_id = p.ID
 WHERE p.post_type= 'wp_log';

    You should probably figure out how often the plugin should delete the logs on its own though, to avoid having too many logs for the memory to handle. There’s some documentation about this.

Viewing 1 replies (of 1 total)
  • The topic ‘Delete WP logs from database’ is closed to new replies.

Tags