Don’t store serialised PHP data in the database! It can be a major security risk! When the contents of the value are deserialised, any objects get recreated and their constructors and wakeup methods run, this can be used to launch an attack. Additionally, that data can’t be search replaced, because PHP serialised strings contain values … Read more
I had an issue similar to this with two separate machines (db and web). Calls from web server to the db server were taking an extraordinary amount of time and it turned out to be that MySQL was trying to do IP resolution on each call to it, causing a DNS lookup. Because the db … Read more
I think you are jumping a gun with custom SQL, complexity of this seems still in realm of WP_Query. Even if not it’s a good idea to start with it to have more solid base for custom SQL. If I try something like this: $meta_query = array( array( ‘key’ => ‘body_type’, ‘value’ => ‘bt’ ), … Read more
The problem occurs in MySQL 5.6.20 or later, if the innodb_log_file_size in the my.ini is set too low. I changed mine to 16M and the problem went away. Thanks to @Otto for the solution. http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-20.html
Try this. Hopefully I’ve interpreted your output correctly. I’d recommend a good read of the $wpdb codex, particularly in relation to the get_col() method – http://codex.wordpress.org/Class_Reference/wpdb#SELECT_a_Column global $wpdb; // You won’t need this unless this code is within a function $query = $wpdb->prepare( ‘SELECT %1$s.guid FROM %1$s’, $wpdb->posts ); $results = $wpdb->get_col($query); $counter = 1; … Read more
Domain change This kind of error may be caused by wrong host name in image urls that are stored in the database. It is necessary to replace strings holding your old domain with new one: http://olddomain.com –> http://newdomain.com In every migtration process I use the following recommended tool: https://interconnectit.com/products/search-and-replace-for-wordpress-databases/ Upload it to your WP root … Read more
You should store additional user data in wp_usermeta table. For that, use add_user_meta() function. Here’s an example of how you can store locations $location = array(‘name’ => ‘example location name’, ‘street’ => ‘example street name’, ‘note’ => ‘example user note’ ); add_user_meta($user_id, ‘location’, $location); You can store as many locations as you want. To retrieve … Read more
In short, this is serialized data and this is how data is stored from a custom field (and many other datastrings) in the db. s:114 is auto generated and simply means that the value http://localhost/wp-content/uploads/woocommerce_uploads/2014/09/test-file.pdf is a string and is 114 characters long. This is used when the data is read and used. If the … Read more
In your code, if an email is set and validated (which I suppose should be the normal case), your code will exit at wp_die(), and never reaches the $wpdb->insert. Your $wpdb->insert statement will only ever be reached if an email is not set, or if “validation” is false. You might want to get rid of … Read more
You can run this MySQL query to empty post content. UPDATE wp_posts SET post_content=””; make sure you have a backup before you run this query, in case you need it later. Also make sure that your MySQL table prefix is wp_. Another Method. You can also use WP_Query custom query to remove post content. $args … Read more