backup only all tables you need from localhost so your .sql file contain only the tables you need & after this go to your live server keep your databse as it the use the following cmd from unix/linux SSH to keep the old tables & only restore the new tables mysql -u username -ppassword databasename … Read more
So what you need to do is order it by the custom value of the meta_key date value. Something like this (untested): $wp_query = new WP_Query( array( ‘post_type’ => ‘upcoming_events’, ‘order’ => ‘ASC’, ‘meta_query’ => array ( array ( ‘key’ => ‘your_custom_date_key’, ‘value’ => date(‘Y-m-d’) ) ), ‘orderby’ => ‘meta_value’ ) ); Hope that helps.
You can use Query Monitor plugin From Plugin Documention: Here’s an overview of what’s shown: Database Queries Shows all database queries performed on the current page Shows affected rows and time for all queries Show notifications for slow queries and queries with errors Filter queries by query type (SELECT, UPDATE, DELETE, etc) Filter queries by … Read more
A key must be defined for a table by using a single column, or multiple. So on your code, you need to a line to the sql KEY id (id) – $sql = “CREATE TABLE $table_name ( id int NOT NULL AUTO_INCREMENT, feedurl text NOT NULL, category text NOT NULL, KEY id (id) );”;
You want the query to look like this: SELECT email FROM wp_my_users WHERE email=”[email protected]” instead of this: SELECT email FROM ‘wp_my_users’ WHERE email=”[email protected]” So try to construct your query with: $sql = “SELECT email FROM {$my_table_name} WHERE email = %s”; $result = $wpdb->get_var( $wpdb->prepare( $sql, $email_address ) ); where you don’t need to escape the … Read more
Of course, minutes after posting this I work it out. The following worked: SELECT m.* FROM wp_postmeta m WHERE m.meta_key = ‘image’ AND NOT EXISTS (SELECT * FROM wp_posts p WHERE m.meta_value = p.ID)
I believe the shortest and best approach is to (1) modify the query: function search_faqs_metadata($query) { if(!is_admin() && $query->is_main_query()) { if($query->is_search) { $query->set(‘meta_query’, array(array( ‘key’ => ‘_faqs’, ‘value’ => $query->query_vars[‘s’], ‘compare’ => ‘LIKE’ ))); } } } add_action(‘pre_get_posts’, ‘search_faqs_metadata’); and then (2) replace the AND with OR via the get_meta_sql filter: function change_meta_key_where_from_and_to_or($sql) { if(is_search()) … Read more
I had something similar recently. The context was a store but the model is fairly typical. To greatly simplify, there was a table for Products and another for Serial Numbers (distributed when purchase was completed) to be imported or linked. At first I tried to make Custom Post Types (CPT) fit the model for both. … Read more
If you’re trying to get all meta values for a key within a specific post type, you can do something like this in a single query: SELECT post_id, meta_value FROM $wpdb->postmeta pm, $wpdb->posts p WHERE meta_key = ‘sd_rating’ and pm.post_id = p.ID AND p.post_type=”cpu”
If that is the error, a couple of things could be going on. The part that uses ‘require’, ‘require_once’ and ‘include’ is not likely correct in the code. Each of these code statements should end with a semi-colon [;] not a comma [,] hh3_ I expect is the table prefix initially used in your database. … Read more