mysql - WordPress 'Custom Post Type' gets set to wrong Taxonomy Term IDs -

-

first , foremost, need stress how appreciate takes time respond - in advance, thank you, thank you, thank you!

i feel pictures of great service explaining things, start off, here's of illustration of issue:

http://i.stack.imgur.com/b9oxr.png

preface:

  • my site has 400 posts under "dir_listing" custom post type
  • each "dir_listing" post can associated terms "listing category" custom taxonomy and/or "listing_region" custom taxonomy
  • i have 210 "listing_category" terms, , 155 "listing region" terms

the issue in summary:

when publishing or updating "dir_listing" post type, term ids recorded 'term_relationships' table without issue, , other times recorded erroneously.

even so, when go edit 1 of "dir_listing" post types checkboxes desired parent/child terms correctly marked.

actions related?

  • a number of "listing_category" terms have been shuffled around. (e.g. parent term has become child term, or vice-versa, or child term has been moved parent.)

  • both parent & child terms have been renamed without making changes "dir_listing" post types. (i don't think matters, since posts supposed related terms id #)

  • a number of parent terms , child terms may have been deleted admin-level user. seems happen child-terms of "listing_regions" taxonomy.

how i've investigated / tried fix it:

  • extensively searched wordpress trac (no similar issues reported)

  • searched google things *"wordpress tax_input bug"*, "wordpress taxonomy id bug", "wordpress custom taxonomy bug", etc. , found no matching issues

  • disabled plugins, custom rewrites, , other taxonomies

  • ensured checkbox inputs had correct taxonomy 'name' , term id 'value'

  • hacked /wp-admin/includes/post.php core file try fix myself. (no luck.)

  • posted issue [wordpress "how-to , troubleshooting" forum][3] morning (no replies)

  • posted issue reddit /r/web_design afternoon (also no replies)

i've spent better part of 8 hours trying determine cause of this, or if i'm missing step using custom mysql query directly list of posts related particular term id.

again, thoughts or suggestions might have appreciated - thanks!

this info might how term_id , and term_taxonomy_id work. seems there lot of conditions effect final outcome of how ids set.

see full reference here: http://phpxref.com/xref/wordpress/wp-includes/taxonomy.php.html#wp_insert_term

also have @ this trac ticket regarding need posts relationship table , of use cases.

get_term($term, $taxonomy, $output = object, $filter = 'raw')   x-ref term data database term id.  usage of get_term function apply filters term object. possible term object database before applying filters.  $term id must part of $taxonomy, database. failure, might able captured hooks. failure same value $wpdb returns get_row method.  there 2 hooks, 1 each term, named 'get_term', , second taxonomy name, 'term_$taxonomy'. both hooks gets term object, , taxonomy name parameters. both hooks expected return term object.  'get_term' hook - takes 2 parameters term object , taxonomy name. must return term object. used in get_term() catch-all filter every $term.  'get_$taxonomy' hook - takes 2 parameters term object , taxonomy name. must return term object. $taxonomy taxonomy name, example, if 'category', 'get_category' filter name. useful custom taxonomies or plugging default taxonomies.  param: int|object $term if integer, database. if object apply filters , return $term. param: string $taxonomy taxonomy name $term part of. param: string $output constant object, array_a, or array_n param: string $filter optional, default raw or no wordpress defined filter applied. return: mixed|null|wp_error term row database. return null if $term empty. if taxonomy not  get_term_by($field, $value, $taxonomy, $output = object, $filter = 'raw')   x-ref term data database term field , data.  warning: $value not escaped 'name' $field. must yourself, if required.  default $field 'id', therefore possible use null field, not recommended so.  if $value not exist, return value false. if $taxonomy exists , $field , $value combinations exist, term returned.  param: string $field either 'slug', 'name', or 'id' param: string|int $value search term value param: string $taxonomy taxonomy name param: string $output constant object, array_a, or array_n param: string $filter optional, default raw or no wordpress defined filter applied. return: mixed term row database. return false if $taxonomy not exist or $term not found.  get_term_children( $term_id, $taxonomy )   x-ref merge term children single array of ids.  recursive function merge of children of $term same array of term ids. useful taxonomies hierarchical.  return empty array if $term not exist in $taxonomy.  param: string $term id of term children param: string $taxonomy taxonomy name return: array|wp_error list of term objects. wp_error returned if $taxonomy not exist

Comments

Post a Comment

Popular posts from this blog

php - What is the difference between $_SERVER['PATH_INFO'] and $_SERVER['ORIG_PATH_INFO']? -

-
what’s difference between $_server['path_info'] , $_server['orig_path_info'] ? how use them? when run print_r($_server) , path_info , orig_path_info not present in array. why not? how can enable them? i have read php manual on them, still don’t understand them. the path_info variable present if invoke php script this: http://www.example.com/phpinfo.php/hello_there it's /hello_there part after .php script. if don't invoke url that, there won't $_server["path_info"] environment variable. the porig_ prefix uncommon. path_info standard cgi-environment variable, , should never prefixed. did read that? (there issues around php3/php4 if invoked php interpreter via cgi-bin/ - hardly has such setups today.) for reference: http://www.ietf.org/rfc/rfc3875
Read more

fortran - Function return type mismatch -

-
i'm attempting recode old c++ program in fortran make use of lapack (i'm aware c++ have lapack++, i'm having lot of trouble installing it, gave up). i didn't have problems compilation, when had variables declared real . when started coding section of program required lapack, found parameters passed dsyev need double precision . tried change double precision (including changing hard coded numbers double precision counterparts, i.e. 0.0 -> 0.0d0) when try compile, following error of functions , subroutines i've written: error: return type mismatch of function <function> @ (1) (real(4)/real(8)) i'm not sure coming from, in program has been changed double precision. for example, i've declared following: double precision :: alpha(3),d(3),zeta1,zeta2 double precision :: a1(3),a2(3),d1(3),d2(3) double precision :: pi pi = 3.14159265359d0 alpha = (/0.109818d0, 0.405771d0, 2.22766d0/) d = (/0.444635d0, 0.535328d0, 0.154329d0 /) 10 i=1,3 ...
Read more

queue - mq_receive: message too long -

-
i implementing communication between 2 processes using queue. problem when call function mq_receive, error: message long. i have done following: struct mq_attr attr; long size = attr.mq_msgsize; .... // initializing queue "/gateway" int rc = mq_receive(gateway, buffer, size, &prio); if print size value, size=1, while when print same size program (got same mechanism), not long integer ( -1217186280 )... how can solve error?....so while size = 1, believe it's right "message long" why 1? p.s. have tried put : int rc = mq_receive(gateway, buffer, sizeof(buffer), &prio); but no result. it seems need read docs more carefully. when call mq_receive should pass size of destination buffer. this size must greater mq_msgsize attribute of queue . in addition, seems have error in queue attributes initialisation makes proper mq_receive call impossible. here standard message queue session: fill mq_attr struct ( doc ): struct mq_a...
Read more