You are mentioning the mysqldump, and it might be linked to the problem. If your mysqldump takes long time, and lock tables, it might cause the requests to your server when tryig to save posts, to time out. It could also just be a plugin that is messing something up, server-side settings that have errors … Read more
Here is how I fixed it: Toms comment made me check how I could migrate the database URL without accessing the admin panel. Turns out it’s really easy. Go to phpMyAdmin and into your wp database. Go into the wp_options table and the first row should be the site url. Change it to the correct … Read more
I found my answer by just digging through wp-includes/meta.php … I just had to add to $wpdb myself at runtime. add_action(‘init’, function(){ global $wpdb; $wpdb->mytypemeta = “{$wpdb->prefix}mytypemeta”; });
Oh, dear! Never mind! There really IS a wp_users table. I just realised that there is a second page to the list. My wp_users table was at the top of the second page of the navigation panel! I have never had a WP site with more than one page of tables, and didn’t realise it … Read more
The problem was that one if the the serialized string lengths did not match its true string length. One of the migration steps was to change the domain name in the database SQL file with: sed -i ‘s/old-domain-name/new-domain/g’ db-dump.sql One of the theme mods was a string that contained the old domain name. When it … Read more
I don’t have gravity forms but I experience in creating autocomplete fields using data from DB, csv, apis and so one. The concept remains the same, it’s just how you call and receive the date that changes, depending in your source. Starting with my csv, I looked for country names to stay as close to … Read more
It looks like I’ve managed to work it out. I needed to: JOIN to wp_posts With the link keys: TABLE : wp_postmeta column : meta_key TABLE : wp_posts column : ID SELECT * FROM wp_terms wpt LEFT JOIN wp_termmeta wptm ON wptm.term_id = wpt.term_id AND wptm.meta_key = ‘thumbnail_id’ LEFT JOIN wp_postmeta wppm ON wppm.post_id = … Read more
That’s not what esc_sql is for, or what it should be used for. Safely Escaping Variables In SQL Queries To make variables safe for an SQL query, use $wpdb->prepare, e.g. $table_name = “{$wpdb->prefix}myTable”; $myID = 12; $wpdb->query( $wpdb->prepare( “UPDATE `$table_name` SET `your_column_1` = 1 WHERE `$table_name`.`your_column_id` = %d”, $myID ) ); Notice that $myID is … Read more
Just run the following commands in your database DELETE FROM wp_commentmeta; DELETE FROM wp_comments; If you changed the db prefix, the name might be foo_comments / foo_commentmeta or similar.
I don’t have a ton of experience with manage wp but I am going to suggest an alternative for setting up a local site based on a live site. I would suggest using the plugin “All In One Migration” https://wordpress.org/plugins/all-in-one-wp-migration/ Install the plugin on the live, select “export” it will generate a file for you. … Read more