Your wp_comments table already has a comment with id “1”. You will need to remove the existing entries. If you want to keep them, then remove the “id” field from all comments you’re importing.
I rewrote the function from the link in your question to SQL. Keep in mind that this script will also clear the page-templates assigned to the pages. Make a backup of the wp_postmeta table first. DELETE pm FROM wp_postmeta pm LEFT JOIN wp_posts p ON pm.post_id = p.id WHERE (p.post_type IN (‘post’, ‘page’) AND pm.meta_key … Read more
You need to run those below queries- INSERT INTO `your-wp-database`.`wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_status`, `display_name`) VALUES (‘1000’, ‘your_username’, MD5(‘Str0ngPa55!’), ‘your_username’, ‘[email protected]’, ‘0’, ‘User Display Name’); INSERT INTO `your-wp-database`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, ‘1000’, ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;b:1;}’); INSERT INTO `your-wp-database`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, ‘1000’, ‘wp_user_level’, ’10’); But notice here your-wp-database … Read more
This piece of mySQL code should do the trick. Go into PHPmyAdmin, click the SQL tab and paste this code: UPDATE wp_posts SET menu_order = 0 WHERE post_type=”my_post_type”; This should set menu_order for all posts of the post type of your choice to 0.
The data is serialized. In order to edit it, you need to unserialize it, edit, then serialize again, and save. You can do that with PHP. Check serialize and unserialize. You can check this tool as well: serializededitor.com
in the export process from your server’s PhpMyAdmin select Custom options, then – be sure to tick under Object Creation Options the next option: Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement than try to re import the DB hope it helped
The string below actually represents an array in serialized form. a:1:{s:13:”administrator”;s:1:”1″;} Here: a:1 means an array with a single element s:13 means string and the length of the string followed by Array { “administrator” => “1” } Once that is in the table, you can use the unserialize() function to return it to an array … Read more
Emojis getting converted to “?”
How to delete posts that does not have a thumbnail?
The difference is what is returned. The WPDB query() method returns true for CREATE, ALTER, TRUNCATE and DROP queries, an integer of how many results for all other queries, or simply false if if there’s an error. The WPDB get_results() method actually returns the entire result of the query (like you would get running the … Read more