It’s Simple. Step 1: Create a replica of the instance. Step 2: Import the old .sql file which contained one day lost orders data. Step 3: Use https://wordpress.org/plugins/woocommerce-simply-order-export/ plugin and export CSV or XML of 1 day data which you have lost. Step 4: Install the above plugin in the LIVE instance and import the … Read more
There are a lot of data stored in those 4 tables wp_terms stores the term_id, name, slug and term_group ID for a specific term. wp_termmeta stores any meta data which you add to a term. This is a new feature introduced in WordPress 4.4 wp_term_taxonomy holds the other info of a term stored in wp_terms. … Read more
Thanks to @Samuel Elh I manage to get this done. I added this to my order-confirmation.php after I included config.php require (‘../wp-blog-header.php’); global $wpdb; global $current_user; get_currentuserinfo(); $skrivID = $current_user->ID; Then the insert query, I added the table I wanted the user ID stored in and used the variable $skrivID as value. $sql = mysqli_query($db_conn, … Read more
The obvious method would be to write a custom WP-CLI script to run through the table, extract the first and last names, use sanitize_title to create a new nicename and update the record. You’d also need to copy the first and last names in wp_usermeta as you mention, at the same time. I’m not sure … Read more
Two things, at least: It looks like you need to declare the global $wpdb and you’re using $wpdb->insert() incorrectly. The insert() method doesn’t take your SQL query but a list of variables. It then create the SQL for you. See here You can execute SQL directly but it’s a different process.
it is better you write like this: class My_Activator { public function jal_install() { global $wpdb; global $jal_db_version; $table_name = $wpdb->prefix . ‘fnotice’; $charset_collate = $wpdb->get_charset_collate(); $sql = “CREATE TABLE $table_name ( id INT NOT NULL AUTO_INCREMENT, msg varchar(500) NOT NULL, time DATETIME NOT NULL, type varchar(350) NOT NULL, link varchar(350) NOT NULL, status ENUM(‘0’, … Read more
As discussed in the comments, your database prefix settings are off-kilter. Check the database prefix actually in use in your database, and make sure it’s the same as the one in wp-config.php. Also make sure all of your WordPress-related tables have the same prefix. You’ll also need to search through your database, particularly in the … Read more
This is untested, but give it a go. First get a list of the term names in the taxonomy. Then filter the returned array of names against your regex. Then use that filtered array of names for your WP query. // assumes these assignments: // // $taxonomy – the taxonomy name you are querying against … Read more
I’ve checked and WordPress does, by default, retrieve & cache all post meta along with the main query’s posts, so you’re perfectly fine storing a product’s additional fields as standard post meta. You might want to store Brands (merchants? manufacturers?) as a custom taxonomy so that you can take advantage of built-in templates and queries … Read more
It seems to be a caching issue, though there isn’t a single cause for it. There is still ongoing discussion, as well as multiple suggestions for fixes about this on the WordPress issue tracker: https://core.trac.wordpress.org/ticket/37889 You can fix the symptoms by ensuring pages under “/wp-admin” are never cached. If using Apache, you can do this … Read more