Forum Replies Created

Viewing 15 replies - 16 through 30 (of 49 total)
  • Yeah, here you go. I think our hosting provider may be the one killing the query because it’s going on for too long:

    KILLED QUERY (16800 characters long generated in …./wp-content/plugins/seriously-simple-podcasting/php/includes/ssp-functions.php:1753): SELECT t.*, tt.* FROM wp_2_terms AS t INNER JOIN wp_2_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (1949,1386,1028,1027,725,8013,1504,605,1446,849,8016,2805,15331,7093,1808,3197,1763,1854,4748,7234,10475,91,979,220,1507,2410,6038,1138,12286,12288,4138,5444,5772,1010,2877,4384,13545,4032,1940,14074,192,16043,1905,2281,13311,1450,9958,305,19715,16512,3252,1293,543,1956,366,8197,4196,13717,19498,13952,13406,1939,840,1896,9126,982,3864,15578,7715,3160,767,10834,10835,7358,1861,2073,2860,10318,14643,13154,10508,2706,16329,1735,9115,3489,17565,1053,4139,4489,1146,1075,4191,4006,13987,1131,17309,17904,2809,11583,10137,19545,449,15626,11172,3624,1004,3627,848,4786,13212,2373,1835,304,4751,4669,1601,8805,1384,10542,4383,8325,907,2422,10128,19674,13167,3641,6269,2862,7830,15581,6602,19632,4928,3940,17908,12603,1717,12847,3280,19635,547,8570,735,1263,752,4618,2412,6975,708,13662,2436,327,1833,4791,4192,13123,8463,12370,981,3708,7081,8581,1525,1906,4752,2345,6571,16330,2026,4211,14439,8983,7458,1147,78,994,8960,1133,1196,1823,12174,15114,715,13293,13148,7005,2054,1193,6951,7357,5411,5380,6430,6199,6336,13244,14154,628,9233,15569,6899,1044,903,7741,7758,7675,10292,15613,12862,10894,2083,10783,10786,11171,3030,12998,13460,6394,367,13281,19393,4358,4403,13583,1923,1262,7266,19049,1011,13225,529,6345,412,2747,10935,6931,4895,1694,8801,6045,8631,5106,48,844,843,395,3695,2208,178,2016,1238,11789,4676,7864,9041 …..

    We had a lot of tags on this site, but when we started getting these errors, we cleaned out the list, so we’re down to about 4,500 tags, which doesn’t seem like a huge number to me given that we have more normal posts than that plus almost 350 posts of type podcast that also can have tags. But I don’t really know what a baseline normal number of tags is, so maybe that is way higher than most other sites using SSP.

    @zahardoc Just to confirm, looks like it is about one error every couple days (which is a lot better than it was before). So, that should be fine for us, but if you were expecting no errors at all, we do still get them occasionally.

    I upgraded to 3.9.0 on Friday and when I checked today, I only saw one error message about a “KILLED QUERY” from over the weekend. That’s significantly better than what we were experiencing before.

    When I previously reverted to 3.7.1, we stopped getting any of them, but one in three or four days is probably fine. I will keep checking it over the week and see if it increases when we have people in there actively working/posting articles.

    @vincec Good to know, thanks!

    I’m experiencing this issue as well, so I’m glad to see that a fix is on the way!

    Following… I’m having this issue too. I downgraded to 5.0.6 for now.

    Thread Starter arypneta

    (@arypneta)

    I saw that you had released version 9.2.1 after I submitted a support request, so I tried upgrading to that version and it seems to have solved the issues with 9.20. So, I think we’re good now, but thanks for following up!

    Thread Starter arypneta

    (@arypneta)

    Okay, good to know! For the generative AI filter, does that filter all of them out for the whole account? We would ideally be able to filter or not on each search. I know we have some of our users who prefer having non-generative AI for their photos, but a few who use them on occasion and might not want them filtered out. I’d have to check, but thanks for letting me know how to go about doing that!

    Thread Starter arypneta

    (@arypneta)

    Great, thanks! I had to change

    $image->id

    to

    $image->data->id

    to get the test snippet to work, but after that it was fine.

    Thread Starter arypneta

    (@arypneta)

    Okay, great – thanks!

    Thread Starter arypneta

    (@arypneta)

    Okay, thanks. I was using that action to update the description and other things already, but I wasn’t sure if that was the best way to update the file name.

    After testing, I can pretty easy update the post_title and post_name (slug) fields for the attachment post using that action. But, that doesn’t actually update the underlying file name/link to the actual file. It keeps the value it was uploaded with. After further testing, it appears that I can do some more manipulation with get_attached_file, update_attached_file, wp_generate_attachment_metadata, and wp_update_attachment_metadata, but I still feel like it would be much simpler to set a custom file name at the time of upload (since that is then all handled).

    But, I do seem to have gotten it working now, so if you can’t add that option, it’s not a big deal. Thanks for your help!

    Thread Starter arypneta

    (@arypneta)

    Okay, great – thanks for the update!

    The next release is fine, I was able to get it working enough for us with the workaround of creating the tag (without assigning it to any posts).

    Thread Starter arypneta

    (@arypneta)

    Okay, thanks for the additional information and that link. It’s disappointing that they won’t allow the connection for longer periods of time, but I guess I do understand their concern.

    We seem to still be connected this morning, so hopefully the really short time was just a fluke. I do sometimes have an issue when connecting to StockPack where Adobe doesn’t like the type of account I’m currently signed into (since I have both a personal and team account attached to my work email). Usually, I can just switch it and then connect successfully. But, after connecting to StockPack, if I were to go into stock.adobe.com and switch profiles, do you think that would have any effect on the integration to cause it to timeout sooner? I don’t typically switch between my profiles, but I have been in stock.adobe.com directly in the last couple days with some other stuff I was looking into and I was switching between profiles, so I was wondering if that could have had any effect (even though I was already connected).

    Out of curiosity, is it possible (or could I request a feature) to set up an email notification to one or more people when you aren’t able to connect to Adobe Stock anymore? We currently rely on our content editors to email us when they can’t license images, which is kind of a pain because we have to go refresh right away since they are trying to use StockPack. But, if you guys could schedule a way to check in the backend (like twice a day, or every hour or something) and send us an email when you receive an error message, we might be able to stay on top of that faster. Anyway, it might not be feasible, but I thought I’d at least put out the suggestion.

    Thread Starter arypneta

    (@arypneta)

    Ahh, got it. Okay, thanks – those new changes sound great!

    Thread Starter arypneta

    (@arypneta)

    You would or you wouldn’t recommend having multiple recipes?

    I guess there’s nothing wrong with having a single recipe, but at a certain point you can only fit so many characters in the recipe name to describe what it’s doing. If you end up with a lot of actions, you might not know at a glance what that particular recipe is accomplishing (and have to click into it instead).

    But, that’s not that big a deal, just a little different from the way I was originally thinking about it.

    Thanks for your fast response!

Viewing 15 replies - 16 through 30 (of 49 total)