There are multiple ways to fix this. You can either remove the if-condition containing SHOW TABLES LIKE
(remove lines: 117, 135 and 137, 157). That should work as the dbDelta function checks itself if the tables are already presend.
Or you could just add some single quotes to the table names in the lines 117 and 137:
"SHOW TABLES LIKE '$jsrm_menu_table'"
Related Posts:
- after wordpress update to 3.5+ i get many errors in plugin wpdb::prepare()
- Help With MySQL to WPDB Query Conversion
- Write mysql credentials in plugin
- Is there a plugin that will override the “Error establishing a database connection” message? [closed]
- How to delete all records from or empty a custom database table?
- How to properly insert data into custom table via plugin
- How does WordPress handle MySQL row lock errors?
- Can I explicitly specify ENGINE=InnoDB in WordPress?
- Bad Request (Invalid Hostname) on working server, database problem
- $wpdb->get_results() does not fetch results with unicode ‘WHERE’ clause
- What causes the “max_user_connections” warning on WordPress frontend?
- Changing BIGINT to INT
- greatest() function returns undefined property
- How to write one comment and publish on every post using database or plugin?
- How to determine what is generating large amount of database queries?
- Doubt using $wpbd->get_col for a single column
- Access WordPress database outside of WordPress
- Creating mySQL procedure with $wpdb
- How can I perform high-level database merging for WordPress within continues delivery?
- WordPress Backend HA (Automatic failover)
- Automatic switch to backup database on fail
- Migrating to WordPress Recipe Plugin and Some SQL Issues
- Create a table with wordpress plugin boilerplate
- Multiple instance of data in plugin custom database table on plugin activation
- plugin code is pulling information from database in one instance and not in other. What is wrong?
- Better ads plugin has 500.000 entries in wp_postmeta
- Cannot get wpdb data (Error in a simple fuction) [closed]
- WPDB: Update table
- Issue running db create table query from static method
- dbDelta not adding additional columns in plugin database update
- Always get creating a new table with foreign key
- How to do database for download stats?
- Getting error “Warning: mysql_query(): Can’t connect to local MySQL server through socket ‘FILEPATH/cccatalog-plugin.php on line 1656”
- DB Query not working in Plugin
- External wpdb connections in different plugins on single page
- WordPress plugin: efficient way to store large data
- How to access the WordPress DB from a plugin file
- Integrating Custom Database with WordPress
- How to display results from a data table with an encrypted user id?
- add_action for publish_post doesn’t work
- What database state changes happen after a post is manually “updated” with no changes?
- Cant create table on plugin activation
- $wpdb->delete not working for me
- Performing CRUD operations on front end in wordpress
- How to securely controlling data without keeping it in postmeta?
- Store GravityForm data in phpmyadmin (mysql)
- Moving a few select DB tables to a new WP instance
- WordPress database problem wp_posts, primary key
- HyperDB failover Delay
- A plugin is giving me “You do not have sufficient permissions to access this page.” error
- Is there a plugin that will override the “Error establishing a database connection” message? [closed]
- Is it safe to increase/alter the size of the wp_post.guid column from VARCHAR(255) to VARCHAR(2048)?
- Get all the related data from WordPress DB
- How can I delete the options from DB when the plugin is deleted?
- Using wpdb to connect to a separate database
- How do I show data from gravity forms in my template? [closed]
- How to return number of found rows from SELECT query
- How to catch/what to do with a WP Error Object
- An unexpected error occurred. Something may be wrong with WordPress.org or this server’s configuration
- Delete tables from database when deleting plugin
- Is it bad practice to create own table for a plugin?
- Get error messages when $wpdb->insert() returns false?
- How to Add an Index to Plugin Database table
- Detecting errors generated by $wpdb->get_results()
- What are the best practices for updating?
- How can I delete orphan keys in WordPress database tables?
- How to fetch Data in WordPress using MySQLi or $wpdb
- Error: call_user_func_array() expects parameter 1 to be a valid callback
- How to eliminate weird 404 errors in wp-admin?
- dbDelta only creates the last table
- wpdb->insert multiple record at once
- Loading external page template and enqueue script from plugin causes 403 forbidden error
- Validation error: Extending Gutenberg gallery block
- What are these entries in the database? Looks similar to JSON
- WordPress sharding: which multi-DB plugin to use?
- Creating 20,000 Posts or Pages using a .csv file?
- Creating two database tables via plugin
- Resetting comment count
- How to define composite keys with dbDelta()
- How to make sense of the active_plugins option_value to enable and disable certain plugins from the database?
- $wpdb->prepare() warning in WordPress 3.5
- find a random blogid across my multisite network that has at least one post published
- How do I fix the “sorry, you are not allowed to access this page” error I get on the “plugins > settings” links?
- $wpdb->delete column values IN ARRAY()?
- How to empty wordpress custom post Database table
- Should messages in WP_Error already be html escaped?
- insert data in database table from plugin with WP3.1
- Simple form that saves to database
- Is their any way to Extend WPDB class and Overwrite the Default Query Function
- How to run Two WordPress blogs with different themes and with single database and same content
- $wpdb->get_results leaking memory
- Searching users with WP_List_Table plugin
- How to get Login Error messages on a custom template
- Plugins or Tutorials for displaying data from SQL-db on WP-page? [closed]
- Insert query inserts 2 entries, should insert 1
- Using Vagrant for customizable WordPress Multi-sites [closed]
- Search and replace text across all posts
- Convert WordPress posts to products in WooCommerce
- PHP Deprecated: Non-static method should not be called statically
- Is it a bad practice to go directly to the mysql database while developing a plugin?