Try with this, It will delete existing wp_commentmeta table then create ‘wp_commentmeta’ table :
DROP TABLE IF EXISTS `wp_commentmeta`;
CREATE TABLE `wp_commentmeta` (
`meta_id` bigint(20) UNSIGNED NOT NULL,
`comment_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
`meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`meta_value` longtext COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
Related Posts:
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- phpMyAdmin – Error > Incorrect format parameter?
- Why is my database import losing text widget data?
- Relaunch 4.2 utf8mb4 database upgrade
- Get error messages when $wpdb->insert() returns false?
- Does dbDelta delete columns as well?
- Where can I find the database changes between WordPress versions?
- Insert data in database using form
- When is it appropriate to create a new table in the WordPress database?
- Special characters in WordPress UTF-8 [closed]
- How to delete outdated, wrongly sized images in _wp_attachment_metadata?
- Upload files – total size limit – WordPress/Contact Form 7
- $wpdb variable throw this error Call to a member function get_results() on a non-object in
- Extend the wp_users table
- Relationship between performance and database size
- I have a problem with my WordPress DB after I tried to install multi-site
- Database sync between local and production
- Scheduling posts in database
- Database error Deadlock found when trying to get lock; try restarting
- Connect Second Database to WordPress
- Should I be able to run two different “close” code versions of wordpress with the same DB
- update_user_meta() does not work
- Query from a different database than the default
- Need of separate security plugins for both root and subfolder sites WordPress?
- Escaping / encoding data before insert into a database?
- how to store arrays into a database
- Error: SELECT SQL_CALC_FOUND_ROWS
- Check if column exists for one table in DB
- Error establishing database connection – high traffic?
- wp_get_current_user always returns 0 continued
- Switching database on the fly
- Allow logged in users to store and display some data
- Replace/Mute/Stop Search Query
- Populate dropdown from database
- How to merge two WordPress databases with the same structure?
- Finding the original login information in the database
- wordpress ‘database update required’ loop after update
- Database Table for customer user
- How to Access wp_usermeta Data Immediately After a New User is Created
- Cleanup: best way to remove WooCommerce comments from the wp_comments table
- How to prevent/delay MySQL connections when an object cache is used?
- How to paginate information obtained from a query to a custom table?
- How can I show related posts from multiple separate installations
- WordPress site URL changed; how to fix it without database access?
- “Error establishing a database connection” – Intermittent error on GoDaddy
- Importing Direct to DB – GUID Question
- Error establishing a database connection,
- WordPress site to be able to connect with data on local machine of user
- Post Views / Hit Counter Problem?
- Bulk Updating Post Date in 1 day Increments
- Trying to create a custom meta table for working with a custom table
- Connecting to a different database
- Debugging – logging database queries
- Update multiple rows in one query
- How to direct my site to the proper URL without Dashboard
- SELECT SQL_CALC_FOUND_ROWS with wordpress search
- Regenerate user_nicename column
- Create Pages for database content
- Should I use an additional column in the DB?
- Storing user submitted forms [closed]
- User Tracking for Custom Post Type “Lesson”. Database Queries and Performance
- access JSON results from wordpress database with wpdb
- How to add checkbox with multiple values in table?
- Can’t log into wordpress site – I have made a new user and still cant access
- Button to update database row from admin menu
- How to save EXIF metadata in WordPress database?
- Export WP Subsite DB Fully Ready for Import Elsewhere
- Sed Command Not Writing Changes to SQL file
- Recurring 502 Bad Gateway issue
- Error during installation (DB)
- is it possible to install new WordPress in an old WordPress folder?
- how restrict user to give star ratings once for a post?
- Insert JSON output into WordPress Database
- HELP $q=mysql_query($sel) or die(mysql_error()) HELP
- Updating Posts table in database without overwriting user generated content
- WordPress credentials not matched
- wp term relationships error
- Performance bug – slow DB query
- WordPress adding item to menu deletes post metadata
- Updating database with CSV file and Cron job
- Change Domain name in database
- WordPress character set issue
- Improving wpdb queries with large data
- Changed meta_key value in structures, now dashboard shows zero users
- Why is wordpress trying to re-install itself?
- How to Determine a Post’s Last Edited Date?
- Searchable database of members using multiple criteria / filters
- Download user generated data from WordPress
- I broke database after reuploading local version – what exactly happened? Database error
- Working local with one database
- Using class id from array for query
- Inserting into data into external DB using WPDB
- Media Library won’t recognize SOME old files after move
- Error at time of WordPress Installation
- WordPress dbdelta a semicolon
- single.php not pulling in any data from database
- How do I use update_option to give me a new option name each time a form is submitted? [duplicate]
- How do join in query with WordPress
- How to create a table that interact with database in real time
- WordPress Theme Customize doesn’t save changes