Post meta is a data set containing additional core as well as custom post information.

learn more… | top users | synonyms

0
votes
1answer
100 views

how to fire join query with post_meta

I have print sql query that runs within 'posts_where' filter and its like: SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'shop_order' AND post_date >= '2013-08-26' AND ...
0
votes
1answer
251 views

saving/reading custom field value does not work - no value gets POSTed

I am trying to add a custom field to all my posts and of course saving/reading the value. As a starting point I took the example from the Wordpress Codex and stripped it down to bare bones. I know it ...
0
votes
1answer
53 views

How to display sql query fired by posts_where

I have used add_filter( 'posts_where', array(&$this, 'new_filter_where' )); function edcal_new_filter_where($where = '') { global $wpdb; $where .= " AND ...
-2
votes
1answer
2k views

cleaning up safely wordpress wp_postmeta table

In a effort to facilitate maintenance of my site, optimise page loading , and also helping out db migration , i am trying to cleanup the wordpress database of my site. i ahve realised the wp-postmeta ...
0
votes
1answer
150 views

mass delete posts based on metadata

I need to delete all posts that have a certain meta value for a certain meta key. I am looking for how to do this directly in the DB. So for instance, I have a meta field called "state", and I want to ...
0
votes
0answers
122 views

One-time bulk MySQL copy post_date values to Advanced Custom Field (date field)

Disclaimer First of all let me say this is probably mostly MySQL related and unfortunately I'm nearly a total newbie on database language and commands. The problem Situation is a site running ...
0
votes
1answer
174 views

Simple Custom Metabox Not Saving

I'm not quite sure why but I've been playing around with all kinds of different solutions but none seem to work. I've traded update_post_meta with add_post_meta and even broke it up into 3 ...
0
votes
0answers
129 views

query by meta value then date and not empty meta value

So i have a query like this function filter_where( $where = '' ) { // posts in the last 7 days $where .= " AND post_date > '" . date('Y-m-d', strtotime('-3 ...
0
votes
3answers
441 views

Get only used meta_values

this is how I'm getting the meta values: $apart_locations = $wpdb->get_col( "SELECT meta_value FROM $wpdb->postmeta WHERE meta_key = 'postal_location' ORDER BY meta_value ASC" ); This is how ...
0
votes
1answer
73 views

Fetch post meta data on POST request

I have inserted values product-price, name and size in wordpress. The insert code is below function products_save_postdata($post_id) { if (isset ($_POST['price'])) { update_post_meta($post_id, ...
0
votes
0answers
104 views

Get value from post meta array, and add it as a category

I have a form that performs an AJAX hook that does several things, one of them is that it takes some form fields, adds them to an array, and adds that array as meta to the post that is created from ...
0
votes
1answer
99 views

Search CPT Title AND Meta

I currently have a CPT I would like to search, the catch is I also need to be able to search the meta data for the CPT. I have the following code that currently searches the meta value needed but I ...
1
vote
5answers
1k views

Get meta_id along with meta_key and meta_value

Is it somehow possible to get_post_meta or get_post_custom and have meta_id returned along with the meta_value? For example: $data = get_post_meta( $post_id, 'my_key' ); // returns this: array( 0 ...
1
vote
1answer
735 views

Custom fields to save multiple values

I’m adding custom meta-box, by means of jquery I can create in it several custom fields with a key “test”. There can be one or several custom fields, but the key is only “test”. I can also delete key ...
0
votes
1answer
130 views

Unfiltered html with update_post_meta

I have buddypress installation. When posting an acitivity, I'm including some data (html) as meta. Let me show some code: this is an action triggered when acitivty is posted. function ...
0
votes
1answer
83 views

Change the contents of a dropdown through the admin panel?

I have a custom post type "Events". In Events, I have a custom field for "Place" which is a dropdown list. Is there a way to edit the contents of the dropdown list through the admin panel or is ...
0
votes
1answer
89 views

How to add post meta to post permalink with still keeping a good performance?

the following problem - I want to completly change my post permalink structure to be like this: www.example.com/%post_id%/%post_meta_value1%-%post_meta_value2%-.... It would even be more nice to ...
0
votes
1answer
50 views

Getting WordPress to store 0 values for custom post type meta

I've created a very complex custom post type system for a football website and am using custom meta boxes to store various match stats. To decide whether or not I should display a stat I check ...
0
votes
3answers
468 views

Can't publish custom post type - “You are not allowed to edit this post.”

Hey guys I've created this post type but when I click the publish button I receive the message: You are not allowed to edit this post. Have I done something wrong in my code to disallow anyone ...
1
vote
1answer
89 views

Get posts between custom dates

I created an event CPT and a meta box with a date. I saved the date as post_meta in the form dd.mm.yyyy. Now I want to create a shortcode that queries all posts which's dates meet the condition ...
0
votes
2answers
104 views

How can I show custom field according to taxonomy?

How I can show custom fields in my theme according to category? For example in Laptop category show some custom fields and in Motherboard category show another fields.
2
votes
2answers
883 views

Meta query with boolean true/false value

I'm trying to show all rental properties, first by all properties that have not been rented, and then by all properties that are currently rented. There is a custom post type 'rent' with custom post ...
0
votes
0answers
166 views

Importing into wp_postmeta

I am converting a custom site to WordPress but I have a problem. I have about 20,000 posts for one Custom Post Type that has custom fields for both "source_name" and "source_url". Both these Custom ...
0
votes
0answers
183 views

Editing does not change post_name

Suppose I wrote an article, "My Article Title", it has been saved into the database with $post_name=my-article-title , and the permalink is mysite.com/my-article-title. All good. Now, if I didn't ...
1
vote
1answer
397 views

Combine multiple custom field values into single value

I'm sure this is a fairly basic question but I can't seem to get it right. I have multiple custom field values for addresses in my custom post type and I want to save them as a single value or array ...
1
vote
1answer
48 views

Is it possible to paste a link without tags and make it directly a link in a post?

So for example: if I post http://testeteststetetst.com, it won't make it a link if it's a post. If it's comment, it does make it a link... Now, I want it for posts too.. Is this possible, if so, how? ...
1
vote
1answer
186 views

Restrict post edit/delete based on user ID and custom field

I've been able to prevent deletion and editing of posts based on user ID and page ID however, I need to restrict access to editing and deleting based on a custom field. Not sure how to go about doing ...
0
votes
1answer
1k views

Hide Post Meta Data on a specific category

I'm using the Canvas theme from Woothemes, and their framework (obviously.) I built a child theme and have my custom CSS segregated in a custom.css file in that directory. I've made some changes to ...
0
votes
2answers
139 views

Query posts by searching for a string in a meta field

I'm trying to see if I can make this happen with the built-in meta_query function. I'm taking a $_GET variable and want to return posts that contain that string inside the meta_key urls. So far, the ...
0
votes
1answer
132 views

Group posts by meta_key

I have a Problem with grouping meta_values. The Query looks for posts with the meta key "company". I want a unique listing of the colors like: blue red yellow array_unique was not successful and also ...
0
votes
1answer
40 views

Publish and save specific postmeta to a filtered post_type

I have multiple plugins with different post_type(s). When I save or publish, all of the custom_post_meta that belong to one specific post_type are also saving. I'd like to filter by post_type so ...
0
votes
1answer
354 views

Move Title and the Content WYSIWYG editor position

Right now, the Title is the first thing at the top of the page, then we have next the WYSIWYG Editor. I would like to add a Custom Meta Box and insert it before the title or WYSIWYG editor. How can ...
0
votes
0answers
263 views

Sort users by custom user meta value

I'm trying to sort users by a custom meta value "user_business" which is their business name that way when users are listed they're sorted alphabetically by their business name as they should be. I'm ...
1
vote
1answer
47 views

How can I sort homepage by a meta value?

I am trying to sort my home page posts by a custom meta value. I've been told I should use pre_get_posts but I seem to not be implementing it correctly. This is what I am doing: ...
0
votes
2answers
36 views

Have lots of meta for posts, is it better to get at all at once or each individually

I have a directory website and am doing a bit of a redesign/restructure. I have quite a few meta fields for each entry, i.e. address, city, country, website, where to buy their products, social links, ...
0
votes
0answers
93 views

How to create a custom field index page

I'm trying to create an index page for some custom fields, just like the taxonomy search pages. E.g. I have a custom field with slug=wpcf-delivery. I want an index page that lists all values where ...
0
votes
1answer
57 views

remove a single post_meta

I created a plugin that has multiple meta boxes. One meta box saves a single record by using update_post_meta(). Another meta box saves multiple record by using add_post_meta(). I do not have ...
0
votes
1answer
427 views

Post meta select input, if statement

I have created a meta box with a select input (drop down menu). It has a few values and I want to display different content depends on which value the user selects. I am just unsure how to display ...
0
votes
0answers
47 views

get_post_meta no longer working

I am trying to use get_post_meta to return a value from the post meta, it was working completely fine then suddenly stopped working. I've tried and checked everything and i cannot seem to get it ...
0
votes
0answers
15 views

How to bulk update META Data in posts [duplicate]

I have almost 50,000 posts in my wordpress website. I have never written the META Title, META Description and META Keywords. Now I need to write them for SEO purpose. How can I do it easily in the ...
0
votes
1answer
115 views

How to validate select field in post meta?

I want to display a select dropdown field in the post meta. How can I validate the input before saving it? Currently, I am simply saving without validating like this: if ( isset( ...
1
vote
1answer
102 views

Maintaining two permalink structures

How can I create two different permalink structures for a Wordpress blog, determined by an addition to the post meta? On the old site, articles were available through the following structure: ...
0
votes
2answers
41 views

Wordpress for questions and responses website

I am using Wordpress to create a Q&A website. The question is returned by the_content. If I store the answers as post meta field array: { [1] => 'first answer', [2] => ...
1
vote
1answer
224 views

How to best delete orphan wp_postmeta

I'm in the middle of doing some fairly complex queries involving metadata from a custom post type. Unfortunately if any posts are deleted the metadata stays put which complicates matters as I am ...
0
votes
2answers
109 views

Which query method to use? (edit- wpdb syntax problems)

I am trying to create a query in order to get all the metadata from a custom post type named match_reports that is associated with a meta_key and meta_value in another custom post type named ...
0
votes
1answer
54 views

Array of user ids to list of user names

I'm outputting an array of user ids from metadata like so: $awaygoalby = unserialize($post_meta_data['report_away-scorers'][0]); and I want to change each user id to the user name. So I was hoping ...
0
votes
1answer
404 views

Conditional For get_the_author_meta

In post loop I'd like to setup a condition for get_the_author_meta. So if the author meta field is empty, then nothing is displayed. Below is what I have but it's not working. <?php ...
0
votes
0answers
227 views

Using mysql queries to delete custom post types based on meta_value

I am trying to create a cron job to run on my server which deletes a custom post_type (post_type = event) from my databse based on a meta_key (st_date) and a meta_value (the date the event took place ...
0
votes
1answer
208 views

How to display custom post meta in the appearance->menus page

I'm working on a website and added a custom meta option for all pages / posts called: "Location". $value = get_post_meta( $post->ID, '_privacy_location', true ); I'd like to add the value on ...
0
votes
0answers
78 views

Ranking authors by post meta value

I have custom post-type with custom post-meta and i want to rank authors by post meta value.I can show the SUM of a meta value on author page with this code <? php $points = ...