Title: Error Log Huge Last modified: August 21, 2016 --- # Error Log Huge * [WillOfTheWeb](https://wordpress.org/support/users/willoftheweb/) * (@willoftheweb) * [13 years, 1 month ago](https://wordpress.org/support/topic/error-log-huge/) * Hi * Tonight I downloaded a Database optimizer and while browing through it I noticed that wp_wordbooker_errorlogs entry was 97580.219 KB which I thought was a bit excessive! How can I delete the contents of this table in the database? * Thanks Will * [http://wordpress.org/extend/plugins/wordbooker/](http://wordpress.org/extend/plugins/wordbooker/) Viewing 15 replies - 1 through 15 (of 42 total) 1 [2](https://wordpress.org/support/topic/error-log-huge/page/2/?output_format=md) [3](https://wordpress.org/support/topic/error-log-huge/page/3/?output_format=md) [→](https://wordpress.org/support/topic/error-log-huge/page/2/?output_format=md) * Plugin Author [Steve](https://wordpress.org/support/users/steveatty/) * (@steveatty) * [13 years, 1 month ago](https://wordpress.org/support/topic/error-log-huge/#post-3705119) * You can either truncate it using a db management tool or you can delete it from the wordbooker options screen (there is a button to delete the diagnostic logs)– but that second method might not work if its that big. It should auto trim when you visit the admin page but either that’s not working or you’ve not been visiting the admin page. * Thread Starter [WillOfTheWeb](https://wordpress.org/support/users/willoftheweb/) * (@willoftheweb) * [13 years, 1 month ago](https://wordpress.org/support/topic/error-log-huge/#post-3705133) * Hi * I tried clicking the ‘Clear Diagnostic Data’ button and there are no logs appearing on the Wordbooker Admin page. I do visit the Wordbooker admin page very regularly so its not that either. 🙁 * Thread Starter [WillOfTheWeb](https://wordpress.org/support/users/willoftheweb/) * (@willoftheweb) * [13 years, 1 month ago](https://wordpress.org/support/topic/error-log-huge/#post-3705136) * I just went into PHP My Admin and ran the command `DELETE FROM wp_wordbooker_errorlogs;` It seemed to do the trick. * Plugin Author [Steve](https://wordpress.org/support/users/steveatty/) * (@steveatty) * [13 years, 1 month ago](https://wordpress.org/support/topic/error-log-huge/#post-3705173) * It still seems odd that its not clearing things down as you’d expect. Are there multiple users on your blog and which version of Wordbooker are you using? * [taniko1](https://wordpress.org/support/users/taniko1/) * (@taniko1) * [13 years ago](https://wordpress.org/support/topic/error-log-huge/#post-3705267) * Hi! * I have the same problem, I’m using the lastest version of wordbooker plugin. I need to keep cleaning the diagnostic data every few days as it get increasing really fast, 200-300 MB a week or so. * I use to visit my wordpress admin page everyday. * Any way to fix this? * Thanks! * Plugin Author [Steve](https://wordpress.org/support/users/steveatty/) * (@steveatty) * [13 years ago](https://wordpress.org/support/topic/error-log-huge/#post-3705268) * What is it filling up with? The cron job that refreshes the cache should clear old entries down. * [taniko1](https://wordpress.org/support/users/taniko1/) * (@taniko1) * [13 years ago](https://wordpress.org/support/topic/error-log-huge/#post-3705269) * It get cleaned just whe I click the button in wordbooker admin page “Clear diagnostic messages”.Or if I clear the table manually in phpmyadmin. * I don’t know what’s filling the table, diagnostics messages, I guess, mostly comment handling information. * FYI, from the last manual cleaning just a few hours ago the table has 11382 lines. * Thanks for your quick answer. * Plugin Author [Steve](https://wordpress.org/support/users/steveatty/) * (@steveatty) * [13 years ago](https://wordpress.org/support/topic/error-log-huge/#post-3705270) * Is this a multi-site install? What polling interval are you using? * [taniko1](https://wordpress.org/support/users/taniko1/) * (@taniko1) * [13 years ago](https://wordpress.org/support/topic/error-log-huge/#post-3705271) * No multi-site, comment handling every 30 minutes. * Plugin Author [Steve](https://wordpress.org/support/users/steveatty/) * (@steveatty) * [13 years ago](https://wordpress.org/support/topic/error-log-huge/#post-3705272) * OK – how comfortable do you feel about editing code? * in wordbooker_cron.php (in the wordbooker/includes directory) * Find * `$result = $wpdb->query('DELETE FROM '.WORDBOOKER_ERRORLOGS.' WHERE timestamp < '.$trimtime.' and blog_id ='.$blog_id.' and post_id=-2');` * and add after it: * `$result = $wpdb->query('DELETE FROM '.WORDBOOKER_ERRORLOGS.' WHERE timestamp < '.$trimtime.' and blog_id ='.$blog_id.' and post_id=-3');` * [taniko1](https://wordpress.org/support/users/taniko1/) * (@taniko1) * [13 years ago](https://wordpress.org/support/topic/error-log-huge/#post-3705273) * In my file it’s a bit different, like this: * `$result = $wpdb->query(' DELETE FROM ' . WORDBOOKER_ERRORLOGS . ' WHERE blog_id ='.$blog_id.' and (user_ID='.$user_id.' or user_ID=0 ) and post_id<=1');` * Should I have to add your line anyway? * Plugin Author [Steve](https://wordpress.org/support/users/steveatty/) * (@steveatty) * [13 years ago](https://wordpress.org/support/topic/error-log-huge/#post-3705274) * Braincramp on my part I meant wordbooker_comments.php … not wordbooker_cron.php * [taniko1](https://wordpress.org/support/users/taniko1/) * (@taniko1) * [13 years ago](https://wordpress.org/support/topic/error-log-huge/#post-3705275) * These are the first lines of support info from the plugin admin page: * Wordbooker: 2.1.32 Wordbooker Code Base: 2.1.32 R00 – When a Warm Wind Blows Through the Grass Wordbooker ID: 254577506873 Wordbooker Schema: 5.6 WordPress: 3.5.1 Table prefix: wp_ PHP: 5.4.16 * Plugin Author [Steve](https://wordpress.org/support/users/steveatty/) * (@steveatty) * [13 years ago](https://wordpress.org/support/topic/error-log-huge/#post-3705276) * OK so make the change to wordbooker_comments and not wordbooker_cron. * Its been a long week at work. * Thread Starter [WillOfTheWeb](https://wordpress.org/support/users/willoftheweb/) * (@willoftheweb) * [13 years ago](https://wordpress.org/support/topic/error-log-huge/#post-3705277) * Hi, Sorry I didnt get notified of your reply till today. * My site isn’t a multi user site, just me. I have made those changes also as you recommended above. Viewing 15 replies - 1 through 15 (of 42 total) 1 [2](https://wordpress.org/support/topic/error-log-huge/page/2/?output_format=md) [3](https://wordpress.org/support/topic/error-log-huge/page/3/?output_format=md) [→](https://wordpress.org/support/topic/error-log-huge/page/2/?output_format=md) The topic ‘Error Log Huge’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/wordbooker.svg) * [Wordbooker](https://wordpress.org/plugins/wordbooker/) * [Frequently Asked Questions](https://wordpress.org/plugins/wordbooker/#faq) * [Support Threads](https://wordpress.org/support/plugin/wordbooker/) * [Active Topics](https://wordpress.org/support/plugin/wordbooker/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wordbooker/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wordbooker/reviews/) * 42 replies * 3 participants * Last reply from: [taniko1](https://wordpress.org/support/users/taniko1/) * Last activity: [12 years, 11 months ago](https://wordpress.org/support/topic/error-log-huge/page/3/#post-3705314) * Status: not resolved