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.
Yes, WordPress will sanitise data on its way to the database, so long as you use the APIs. If you’re using the wpdb object however you’ll need to use the prepare method to sanitise. I recommend against writing SQL queries as it bypasses object caches etc, but if you must write your own SQL, use … Read more
Normalizing data is more efficient, and storing serialized data in a table field that you want to search / work with on DB level isn’t something for Non-Nosql RDBMS like MySQL/MariaDB. Searching those fields is inefficient, you can’t use indexes on it, can’t join on it, and it’s generally painful to develop imho. If you’ve … Read more
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
wp_insert_post runs whenever a post is updated, not just when it’s first saved. So your payment_meta() function is running every time a post is saved, and since you’re using add_post_meta() in that function, a new meta entry is created every time the post is saved. Instead of using add_post_meta() stick to just using update_post_meta() if … Read more
Check wp-config.php. It’s possible to define these values there, in which case they won’t be available as settings, which means they won’t be saved in the database. It is possible to set the site URL manually in the wp-config.php file. Add these two lines to your wp-config.php, where “example.com” is the correct location of your … Read more
Try this plugin: http://wordpress.org/extend/plugins/search-and-replace/ – It helped me dozens of times. Or try this query: UPDATE tablename SET tablefield = replace(tablefield, “findstring”, “replacestring”); Or try this method, dump the database, open the SQL file, do a find and replace in a text editor then reimport it. Take care to backup your database prior to making … Read more
Unless you want to retrieve custom data from the database, you will hardly ever need to make use of the WPDB class (or its global object, respectively). Though it is obviously possible to do things that way as well. Just for the sake of completeness, if you had a reason to not use a more … Read more
If it’s information that logically belongs to a post/page – you store it in postmeta (with update_post_meta function). If it’s something that pertains to a user – usermeta table is for you. More still, there’s Settings API in case you have a plugin that needs to persist any settings. From your question it is somewhat … Read more
You can filter query. See wpdb::query() in wp-includes/wp-db.php. You get the complete SQL string as parameter. Then look for queries to the comments table: add_filter( ‘query’, function( $query ) { global $wpdb; if ( FALSE === stripos( $query, “FROM $wpdb->comments” ) return $query; // Now change the SQL }); But you have to catch all … Read more