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
- Is it mandatory to use $wpdb->prefix in custom tables
- Why $wpdb->show_errors() and print_error() is showing an output even if the query output is correct?
- $wpdb->insert not working in any way
- How to delete all records from or empty a custom database table?
- WordPress Paginate $wpdb->get_results
- get_results on large datasets
- How to implement WP_List_Table? WP_List_Table giving array instead of a value in listing table
- wpdb->insert not working
- passing variables as parameters to stored procedures via wpdb from php-script
- How do I create a single.php for a specific category?
- $wpdb->query() multiple query support
- Using $wpdb generates DB error
- How do you use prepare when asking for a list of id’s
- Add search Value to wp_list_table pagination
- How to get top 10 user is based on user meta value
- $wpdb Query Result not coming but in phpmyadmin it works [closed]
- $wpdb insert array
- How to update records using $wpdb?
- Join inside a wpdb query.. confused!
- Why doesn’t my insert query work?
- How to prevent $wpdb->prepare stripping a leading zero in variable value?
- Generate a unique hash/number for tracking on $wpdb insert
- show badge with count for pending items in custom post type
- wpdb->insert and stripslashes against sql injection
- create drop down menu in theme customizer from custom db
- Where to store the name of a custom table?
- Are there risks associated with using wp_options table using wpdb to update theme options
- $wpdb->insert is running multiple times on page load, but only called once
- Get an array of meta_values for a user meta_key
- Confused by $wpdb->prepare
- WordPress (on AWS ubuntu) database Fails “Connection refused in .. /wp-includes/wp-db.php on line 1531”
- How to display user_nicename and usermeta values by custom query in WordPress?
- $wpdb->replace: WHERE?
- How can I combine one field using wpdb and group by?
- Create a table with wordpress plugin boilerplate
- Creating custom database table with crud operation
- Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
- How to get entry by title by using wpdb
- How to sort posts in a custom post type by title in ascending order by default?
- How to obtain a reference to $table_prefix in $wpdb object
- Trying to Connect to different database
- WordPress is trimming leading 0s
- Why does this WPDB code throw an empty WPDB error? [closed]
- wordpress $wpdb works only once
- WordPress core code contains things marked as deprecated by… WordPress?
- $wpdb – joining shows no result
- Compare transient data with a meta box value
- How to left join meta in queries [closed]
- CREATE TABLE with dbDelta does not create table
- Save data from a checkbox to a wpdb array
- Basic wpdb update question
- Querying specific table row by current user login
- WP-PostRatings: list current user’s rated posts
- Get unique results from this function
- Gravity Forms – gform_field_value – query custom table breaks functions.php
- WPDB Join with custom table
- Getting values from wpdb
- Why is this $wpdb query looping 5 times?
- wpdb query not returning results containing single quotes
- duplicate entries in database while using save_post or wp_insert_post
- Unknown column ‘siteurl’ in ‘where clause’ WPDB outside
- $wpdb is queried but results don’t show
- wpdb insert formatting for date in array
- how to list all post that are in the custom taxonomy using $wpdb
- $wpbd->insert() does not insert user data
- Why $wpdb->insert and $wpdb->update not working server but it is working in localhost?
- How to have differents sites share the same tables of DB?
- Sql query triggered twice
- Unable to insert data into using custom plugin
- Escaping a WPDB Object in One Shot
- data retrieval presents last set of data
- Create a stored procedure on plugin activation
- Get last element from wpdb as a string
- Creating an Angular factory from custom database table
- Custom database query to validate data
- Creates only one table and not the other
- Update all fields of table with ON DUPLICATE KEY UPDATE command
- WordPress – wpdb query does not list same result as sql query
- What is the best practice to initialise $wpdb by loading wp-load.php?
- $wpdb->get_results in not an array
- How to make iteration on wpdb->update or query statement?
- Display_rows() and column_cb() strange behaviour
- Search Query that Includes Custom Table
- Display single post inside accordion based on form submission results
- Custom WordPress SQL Query 4 posts per custom taxonomy
- Out of Memory – Line 791 of WP-DB.php (mysql_real_escape_string)
- get only 1 wpdb and get taxonomy, post to next page [closed]
- Site going down due to slow queries
- Call to a member function get_results() on a non-object in wordpress plugin
- $wpdb The query does not contain the correct number of placeholders
- $wpdb:insert, more arguements in $format array than in $data