Topher

It’s possible you’re uploading files that are so big that it takes the server too long to process them. WordPress makes 4 different sized copies of each image you upload.

iOS (on the iPad) often doesn’t give you the full sized original, but rather a downsampled version. I found this with my phone.

Take one of the images that doesn’t work, resize it to something like 2560 wide, and try uploading that. If that works then the server simply doesn’t have the oomph to process the really big ones.

That’s great sleuthing, well done.

Ok, that actually sounds like a great use case for multi-site. It’s certainly one viable option for multi-lingual, and using all the same theme (and probably plugins?) makes it sound quite reasonable.

The custom table shouldn’t matter, you can just adjust the query accordingly. If you look stuff up in phpMyAdmin it’ll show you the query it used.

The array I showed has post_ids as keys and dates as values. So you’d do something like

foreach ( $birth_dates_array as $post_id => #term ) {
  wp_set_post_terms( $post_id, $term, 'WhateverYourTaxonomyIs' );
}

First use a tool like phpMyAdmin to look at the postmeta table and find your custom fields. Is the date stored in plain text like 2022-10-01 or is serialized somehow? Plain text is preferred, but we could work with serialized.

Read about $wpdb: https://developer.wordpress.org/reference/classes/wpdb/

That makes it easy to send a custom query. Something like this:

$birth_dates = $wpdb->get_results(
    "SELECT post_id, meta_value FROM {$wpdb->postmeta} WHERE <code>meta_key</code> = 'YOURKEYNAME'"
);

where YOURKEYNAME is whatever you called your birthdate field.

I don’t know for sure what the format will be coming back from that, but to be sure then you can do something like this:

$birth_dates_array = [];
foreach ( $birth_dates as $birth_date ) {
    $birth_dates_array[ $birth_date->post_id ] = $birth_date->meta_value;
    // it might be this instead:
    // $birth_dates_array[ $birth_date['post_id'] ] = $birth_date['meta_value'];
}

then you’ll have an array that looks like this:

[
1,'2022-10-01',
2,'1971-07-17'
]

then it’s a plain array. Use foreach to loop over it and use wp_set_post_terms (I misspoke about wp_create_term above) to connect posts to terms.

• This reply was modified 3 months, 2 weeks ago by Topher.

May the wind be ever at your back. Unless it’s hot out, and then a gentle breeze to the face.

The taxonomy query is going to be WAY faster than a custom field query with math in it. Plus as a term you can do all sorts of other interesting things like make data maps of age groups, without every hitting the posts table.