Title: WordPress database error Table Last modified: December 4, 2018 --- # WordPress database error Table * Resolved [K](https://wordpress.org/support/users/karina-1984/) * (@karina-1984) * [7 years, 6 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-11/) * I have been using your pluggin for a long time. I have made near 300 tables with tablepress. I am having a lot of errors. I found many logs like this one bellow * [Sun Dec 02 16:27:58.922335 2018] [cgi:error] [pid 20074] [client 34.35.128.38: 3645646] AH01215: WordPress database error Table ‘./mywebsitename_myusername/ wp_wfhits’ is marked as crashed and last (automatic?) repair failed for query SHOW FULL COLUMNS FROM `wp_wfhits` made by wfLog->logHit, wfRequestModel->save, wfModel->save, wfModel->insert: /usr/local/cpanel/cgi-sys/ea-php71 * Also I saw multiple logs in /var/log/messages stating “out of memory” with PHP and MySQL immediately following as the culprit. * Time ago I wrote you about a problem with the huge amount of transient data the plugin generates. [https://wordpress.org/support/topic/problem-with-the-transient-data-that-the-plugin-generates/](https://wordpress.org/support/topic/problem-with-the-transient-data-that-the-plugin-generates/) * I think the problem came back. Is there a fix for this? If I erase 280 tables, and remain only with the 20 more important, is the problem going to be fix? - This topic was modified 7 years, 6 months ago by [K](https://wordpress.org/support/users/karina-1984/). * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fwordpress-database-error-table-11%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 7 replies - 1 through 7 (of 7 total) * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [7 years, 6 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-11/#post-10948041) * Hi, * thanks for your post, and sorry for the trouble. * This error message clearly refers to a database table called “wp_wfhits”, which belongs to the Wordfence security plugin. I found a similar topic here: [https://wordpress.org/support/topic/table-wp_wfhits-is-marked-as-crashed-and-should-be-repaired/](https://wordpress.org/support/topic/table-wp_wfhits-is-marked-as-crashed-and-should-be-repaired/) * So, this has nothing to do with TablePress. * Regards, Tobias * Moderator [Jan Dembowski](https://wordpress.org/support/users/jdembowski/) * (@jdembowski) * Forum Moderator and Brute Squad * [7 years, 6 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-11/#post-10948766) * [@karina-1984](https://wordpress.org/support/users/karina-1984/) There is nothing here to report. The “Report this topic” is to report spam, abuse, etc. This is not that. * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [7 years, 6 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-11/#post-10948852) * Hi, * thanks for the heads up! * Best wishes, Tobias * [rajinderverma](https://wordpress.org/support/users/rajinderverma/) * (@rajinderverma) * [7 years ago](https://wordpress.org/support/topic/wordpress-database-error-table-11/#post-11579583) * Hello Tobias, * From the logs, I can see that one of the plugins ‘Tablepress’ was causing immense load on the server in the form of heavy SQL queries. * For now, I have disabled the mentioned plugin and server load starting to normalize. * Kindly fix the issue with Tablepress plugin creating heavy load like this: * “creating select sql_calc_found_rows wpl4_posts.id from wpl4_posts where 1=1 AN” * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [7 years ago](https://wordpress.org/support/topic/wordpress-database-error-table-11/#post-11579598) * Hi rajinderverma, * please don’t simply post in other old threads, but let’s keep the discussion in the thread at [https://wordpress.org/support/topic/tablepress-causing-immense-load-on-the-server/](https://wordpress.org/support/topic/tablepress-causing-immense-load-on-the-server/) * Regards, Tobias * [Mayank Majeji](https://wordpress.org/support/users/mayankmajeji/) * (@mayankmajeji) * [6 years, 9 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-11/#post-11914018) * Hello! * My WordPress search is not working properly and it seems TablePress is the culprit. I did cross-check by deactivating TablePress and search started working fine. * When I turned on WP_DEBUG, it threw this error. * WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near‘]?)( 18)([\]”\’ /])’))) AND (wpdemo_posts.post_password = ”) AND wpdemo_post’ at line 1] SELECT SQL_CALC_FOUND_ROWS wpdemo_posts.ID FROM wpdemo_posts WHERE 1=1 AND((( wpdemo_posts.post_title LIKE ‘%keyword%’) OR (wpdemo_posts.post_excerpt LIKE ‘% keyword%’) OR (wpdemo_posts.post_content LIKE ‘%keyword%’) OR (wpdemo_posts.post_content REGEXP ‘\\[table id=([“\’]?)(18)([\]”\’ /])’))) AND (wpdemo_posts.post_password = ”) AND wpdemo_posts.post_type IN (‘post’) AND (wpdemo_posts.post_status = ‘ publish’) ORDER BY wpdemo_posts.post_title LIKE ‘%keyword%’ DESC, wpdemo_posts. post_date DESC LIMIT 0, 5 * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [6 years, 9 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-11/#post-11914119) * Hi, * as you opened a new thread for this at [https://wordpress.org/support/topic/wordpress-database-table-error-4/](https://wordpress.org/support/topic/wordpress-database-table-error-4/) I’ll respond there. * Regards, Tobias Viewing 7 replies - 1 through 7 (of 7 total) The topic ‘WordPress database error Table’ is closed to new replies. * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944) * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/) * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq) * [Support Threads](https://wordpress.org/support/plugin/tablepress/) * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/) * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/) ## Tags * [Database Error](https://wordpress.org/support/topic-tag/database-error/) * [MySQL](https://wordpress.org/support/topic-tag/mysql/) * 7 replies * 5 participants * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * Last activity: [6 years, 9 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-11/#post-11914119) * Status: resolved