Well, after looking at the other tables I had created successfully, only difference was the description column. Apparently WordPress or MySQL doesn’t like that as a column name and somehow has it reserved. So, after renaming it, the table was created fine. Hope this helps someone else in the same boat.
Related Posts:
- Get random row from custom table
- $wpdb->replace / Replace or update primary key
- Create new database through static page code
- Register custom table for WP to use in a plugin
- Custom select query two tables by a meta key
- What is my error trying to create a new table in the database?
- get_var result empty for query of custom table in plugin admin
- Error inserting row into table
- DBDelta: “table doesn’t exist” for a table that was just created
- $wpdb->get_row() only returns a single row?
- Is it mandatory to use $wpdb->prefix in custom tables
- wpdb->insert: do I need to prepare against SQL injection?
- How to parse row results from $wpdb -> get_results
- Why $wpdb->show_errors() and print_error() is showing an output even if the query output is correct?
- what is the way to see the currently executing query in wordpress?
- Fetch array with $wpdb
- How do I check for a duplicate record before inserting using wpdb
- WordPress 4.8.1 uses mysql_connect which doesn’t work with PHP 7
- How to use $wpdb to delete in a custom table
- $wpdb->insert not working in any way
- WPDB prepare – like % – placeholders?
- How to delete all records from or empty a custom database table?
- WordPress Paginate $wpdb->get_results
- $wpdb->update multiple rows, like IN in normal SQL
- Matching database content types to PHP types
- Does $wpdb->prepare not create a prepared statement that I can execute multiple times?
- WordPress Unit Testing – Cannot Create Tables
- get_results on large datasets
- $wpdb->insert() and Values for Datetime Columns?
- $wpdb->last_error doesn’t show the query on error
- Why does $wpdb return strings for mysql integer values?
- When is it appropriate to create a new table in the WordPress database?
- How to Remove Certain Screen Options and Table Columns from post type in wp_list_table?
- Avoiding “Usage of a direct database call is discouraged”
- dbDelta does not create Table, but returns success
- How to implement WP_List_Table? WP_List_Table giving array instead of a value in listing table
- Theoretical Multi-Server WordPress Setup with Shared Users
- Change post status based on meta value
- Redirect after deleting post and keep track of pagination
- wpdb->insert not working
- Delete row of custom table in WordPress using AJAX
- Saving custom form data into database
- Creating search form for custom database table
- passing variables as parameters to stored procedures via wpdb from php-script
- Get data from database table by post_id to get data from second database table
- wp-content/db.php : where is this file?
- Quotes in table name
- Delete/replace img tags in post content for auto published posts [closed]
- $wpdb sql help. Select post id and post meta value based on 2 other post_meta values
- Can’t pass table to $wpdb->prepare
- Can I use $wpdb for my custom tables in the WordPress database?
- $wpdb->get_results() returns good result only in first foreach iteration
- $wpdb->insert – inserting multiple rows
- Speed optimization of $wpdb->get_results
- How do I create a single.php for a specific category?
- Get number of comments after modifying comment query
- $wpdb prepared with search term
- WPDB->insert with special characters
- What does wp_update_post() do that the $wpdb class does not?
- How Can I Use $wpdb in PayPal IPN file?
- $wpdb is get_results escaped
- $wpdb->query() multiple query support
- wpdb-> not adding prefix to custom table
- Is there a (better) way to access $wpdb results?
- Using $wpdb generates DB error
- WordPress insert NOW() in TIMESTAMP column returns all zeros
- How do you use prepare when asking for a list of id’s
- Set media metadata (i.e. “dimensions” field) on SVG file after extracting it with a filter
- $wpdb prepare issue with mysql DATE_FORMAT
- How-To: wpdb Insert Record With Date
- $wpdb->prepare not working with update table prefix
- How to use prepare to query with variables
- Use $wpdb in wordpress theme files
- Add search Value to wp_list_table pagination
- How to pass NULL in where array for $wpdb->update
- Get multiple db prefix with $wpdb
- how to execute different sql query in non-sanitized $wpdb->get_results function
- $wpdb not returning data
- How to get top 10 user is based on user meta value
- $wpdb Query Result not coming but in phpmyadmin it works [closed]
- WPDB update row with != in where clause
- store custom WP table names in a global variable
- wpdb prepare: passing varible number of fields as second argument
- $wpdb insert array
- How can I add data to a custom column in the Users section of the wordpress backend?
- I am not understandinhg $wpdb->prepare correctly
- $wpdb->insert inserting two rows in database
- Wpdb query for comment meta for current post
- How to update records using $wpdb?
- wpdb->get_row() / get_results – is it possible to return an object instances of my own class?
- Problem in creating table through plugin code
- I want to update my postcontent with $wpdb
- How to save html and text in the database?
- XOR functionality for meta_query
- How to email user after inserting the username in database in WordPress
- What’s the proper way to use a custom table? [closed]
- Join inside a wpdb query.. confused!
- Why would switch_to_blog stop working?
- Create an array with a string key from wpdb->get_results
- How to fetch an array in $wpdb?