This code is working for me with no “WordPress database error” messages:
if ( $wpdb->get_var( $wpdb->prepare( "SHOW TABLES LIKE %s", $table_name ) ) === $table_name ) {
error_log( 'Table exists' . ': ' . print_r( $table_name, true ) );
} else {
error_log( 'Table does not exist' . ': ' . print_r( $table_name, true ) );
}
Related Posts:
- Rename a table in MySQL
- How should I tackle –secure-file-priv in MySQL?
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
- Using wpdb to connect to a separate database
- Checking if Database Table exists
- WordPress (MyISAM) database is slow, should I switch to InnoDB?
- The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
- WordPress Database lost auto increment
- wpdb->insert multiple record at once
- How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
- Is it possible to define two databases for one installation?
- Slow wp_term_relationships query
- How to use “TRUNCATE TABLE” MySQL statement?
- WordPress for a very large website
- WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
- “MySQL server has gone away” since update to 3.8
- WooCommerce – Query for ordered products
- Error establishing a database connection – with Debug Data
- How to execute mulitple statement SQL queries using $wpdb->query?
- Can I transfer a mysql database to another site?
- Database with mixed collation (utf8mb4 & utf8_general_ci)
- Query WordPress database by registered date and role
- MySQL Syntax Error upon restoring database from backup [closed]
- Tons of Twitter rows in my database
- Set Display Name to first and last name (phpmyadmin SQL Query)
- Migrating database / content of non-CMS site to WordPress
- Does WordPress ever need multiple databases?
- Why are no posts showing despite my apparently correct DB restoration?
- Select Multiple meta_value from WP DB; Single Query
- Delete all post meta except featured image Using SQL
- Is it possible to split database tables using HyperDB?
- Adding new row to wp_post table
- What happens if I overwrite the current wp_options table with a backup from a week ago?
- SQL Error wp_commentmeta – incorrect table definition
- WordPress database error – Error in SQL syntax – I can’t identify any error?
- CRUD operations using WordPress database API
- How do I get the posts within a certain year/date(with sql query)?
- How to Mirror WordPress database from Remote server to Local server
- Is MariaDB’s Aria storage engine suitable for WordPress?
- Slow queries constantly getting stuck on WordPress database of ~100,000 posts
- How do I query wp_options for expired transient pairs with MySQL commands?
- WordPress running SQL query to update database from form
- How to fix database error duplicate entry
- Migrating from PDO using SQLite to clean new install using MySQL
- Migration: Copying database content to a different server
- Call to undefined function get_user_meta() – trying to access data in MySQL from custom fields
- How do I convert a MySQL database from utf8mb4 to utf8 encoding?
- Query multiple tables at once?
- Have working sql query… trying to adjust it to use $wpdb
- Can’t update WordFence Options, clear data manually
- creating new field on mysql
- Remove empty rows from the database
- Custom WordPress Table wpdb
- how to encyrpt DB_PASSWORD in wp-config
- SQL query to set posts in bulk based on the post content
- How can I detect right db type?
- How to create more than one new wpdb object?
- Changing order of db results when encoding to JSON
- Files on Localhost, Database on Server
- Remote database -> massive response time increase?
- Second ezSQL initialization for MSSQL
- Fetch a single row from a custom table for to a given ID
- Database create or redirect
- How to escape percentage sign(%) in sql query with $wpdb->prepare?
- Link multiple user databases together?
- DB prefix not updating
- Recovery – Restore Database after moving folder location locally
- Replacing javascript link in WordPress database without getting mysql syntax errors
- I wanted to Know that how can I give ingore to 0000-00-00 in my config file
- Set a cron job to delete a specific database table table every midnight
- How to edit custom table data in frontend
- how to access 2nd Mysqli Database from different server for wordpress
- Error establishing a database connection – WordPress setup, everything else is working
- How to import products in host instead of database on wordpress?
- I would like some help wth an SQL query to link posts with categories
- Where is the HTML-handler part in the wpdb class?
- How to map data on CSV to web pages?
- next comment id number wordpress
- Search and Replace in Windows XAMPP site
- WPCLI search and replace in a particlar site dir effect another site-dir
- How can i syn wordpress user table with a stand-alone php script?
- insert data from a form:: Warning Empty query mysqli::query()
- How can I get $wpdb to show MySQL warnings?
- Merging development site with live site
- The MySQL Connection could not be established., before it was joomla but i have change it into worpress
- WordPress Database Posts Table query
- How to extract some part of WordPress full source code
- Mysql Queries per Visit – Crazy High
- Check if a database is well installed
- live site do not update after importing sql database
- using same mysql user with many databases
- Why are my WordPress post queries so slow?
- MySQL Database User: Which Privileges are needed?
- Import Excel (or csv) Table with user-data as subscribers to wordpress
- Print output of Table Creation
- Migrated to Namecheap, now Trouble with Database & wp-config [closed]
- SQL query : Select a thumbnail for a media
- Custom wordpress SQL statement for a website
- WordPress database connection failed, while mysql client is working [closed]