10sexyapples

So sorry … somehow missed the notification … will put it to the test tomorrow right away!! Thanks for the bump!

What you’re saying is even more interesting because I tested the logic by making changes in the default arguments and it was very responsive, like you said, forcing cache out and recreating the tree. … and the only change I’ve had to make in years to customize your plugin code is to simply change:

line 22
WHERE {$wpdb->posts}.post_type = 'my_custom_post_type' AND {$wpdb->posts}.post_status = 'publish'

and line 75
WHERE post_type = 'my_custom_post_type' AND post_status = 'publish'

in wp-dtree-arc.php

… and all has worked flawlessly being called directly in the template like so:
if(function_exists('wpdt_list_archives')){ wpdt_list_archives('type=yearly&showcount=0'); }

Those are my only edits these days~

I followed all the logic and wasn’t able to figure out how it was caching the post_type “post” before getting the direction to use my_custom_post_type. From what I can ascertain, the query in my use case is only made once in wp-dtree-arc.php and I’ve changed it there. Truly baffling ??

Excellent. Good to know ;-)Thanks~

Thanks mc_d … hey, do you know exactly what that IP is though and who it belongs to? I ask because it is on several blacklists, which is why it gets refused. What does it provide that the https://sopresto.socialize-this.com 50.97.194.22 doesn’t? Do you know?

Whitelisted that other IP I just mentioned and the error has ceased … so, for anyone else fiddling around with IPs … that 50.23.108.137 IP is key ??

Also … I checked the error message that I sent and it shows as having gone out to the right address so let me know if you still haven’t received it please … sending another right now~

Hi mc_cabe … I thought we might be on to something with the fsockopen because I do have all php functions like that disabled unless I know they are needed for functionality … I enabled it, but, still getting error … however, I looked into some more logging and this IP address looked similar to the other Mailchimp one, so, I checked it and found this … https://www.spambotsecurity.com/forum/viewtopic.php?f=33&t=1663 … my server is in fact blocking 50.23.108.137 .. more than likely for the user-agent issue mentioned here … can anyone else confirm this as well? And can you let me know if that IP address is in fact required for functionality?

Thanks for the response mc_dominic … heh … I’m a developer too, so, totally aware that you guys and autochimp are two different entities … just trying to give helpful information to suss this out .. as in “it’s all plugins that are accessing the Mailchimp API” type stuff … this plugin has worked on my server for well over a year without issue as have the other … the server software is all the same … the difference was an automatic update that wordpress put through before I disabled auto updating … and potentially some changed mod_sec and firewall settings … but, as I have ruled out the firewall and mod_sec I believe … checking mod_sec again tomorrow … it seems to come down to something in wordpress conflicting with all plugins that access an API like this for syncing/posting etc. … another clue would be that the woocommerce mailchimp one actually prevents the WP media uploader from working at all. I’ll send the error now~

The plugin Autochimp on another of my client’s sites also is not working fyi

I’ve also now gone in and completely disabled mod-sec on the site in question where the error is happening with

<IfModule mod_security.c>
  SecFilterEngine Off
  SecFilterScanPOST Off
</IfModule>

and the error persists … at this point, I am officially completely baffled, so help would be greatly appreciated~

Hi mc_gabe … yes, I whitelisted the IP so it should be good incoming and outgoing … it made no difference at all … still received the 403 … and as long as it uses standard ports, those should be good as well … the only thing I can think of at this time is perhaps some sort of mod-sec rule creating the 403 … do you know of any particular rules that would cause a problem for the API? or that have in the past?
When the Woocommerce Mailchimp plugin is activated it prevents the WP media upload from working as well if that is a clue … and WP to Twitter can’t do it’s thing either … so, it is looking more and more like a conflict with something in WP that has to do with Ajax, or the media uploader or a mod-sec rule in my opinion~

Okay … just realized that the initial -99 error of not being able to load lists was actually coming from the Mailchimp Woocommerce integration plugin, so, basically all things Mailchimp are having this issue, it isn’t specific to this plugin~ for me anyway~ I’m sure we get one figured out and the other should follow … if something in php.ini or .htaccess, mod-sec etc. were creating this error do you know which specific rule it might be? I could test it if so~

Hi guys … experiencing similar issue on recent upgrades. Initially I was getting the err -99 can’t load Mailchimp lists … I then logged out of Mailchimp from within the WP Mailchimp plugin interface and logged back in and got a 403 … then I deactivated all other plugins and the err-99 can’t load lists was gone, but, when I try to connect again I get the following from https://sopresto.socialize-this.com/mailchimp/confirm?code=yadda yadda

error!

POST to https://yaddayadda.com/index.php?mcsf_action=authorized&salt=yaddayadda&user_id=yadda failed: couldn’t connect to host

just jumping on board to try to help solve this mystery … I run a dedicated server, so, if there is anything I can check on this end please ask and I’ll do it~ need to get this running again~

Hi there … just wanted to report back to you that I installed your code and it basically marked all images ( over 2800 ) on my site as unreferenced/unused … heh … I was in a hurry but moved all 29 pages of them ( would be really great to be able to batch process more than what is on one page at a time currently ) … only to find that all of my images were gone … even my featured images in regular post excerpts … and had to quickly go back through and restore them all. Thank you so much for having the restore feature … although on one of the 29 pages, when I hit apply for whatever reason, it would not change to restored, just the check mark showed … very odd indeed.
I’d be happy to answer any questions you may have about my setup if it would help to determine why this is. I use custom built meta boxes and roll my own custom post types etc., and build upon the roots theme~
Would be fantastic to have this code work in my setup~

Sorry … I accidentally responded to this in the wrong place …

I only kept one of them … and, I think I may have even changed the post_status to published to test when I got this error … but, here is an example

WordPress database error: [Incorrect usage/placement of 'SQL_CALC_FOUND_ROWS']

SELECT wp_posts.*, wp_p2p.* FROM wp_posts INNER JOIN wp_p2p LEFT JOIN wp_p2pmeta AS p2pm_order ON ( wp_p2p.p2p_id = p2pm_order.p2p_id AND p2pm_order.meta_key = '_order_from' ) WHERE 1=1 AND wp_posts.post_type IN ('post') AND (wp_posts.post_status = 'publish' OR wp_posts.post_author = 43 AND wp_posts.post_status = 'private') AND (wp_p2p.p2p_type = 'news_and_announcements' AND wp_posts.ID = wp_p2p.p2p_to AND wp_p2p.p2p_from IN (SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (3723) AND wp_posts.post_type IN ('tsa_announcement') AND (wp_posts.post_status = 'publish' OR wp_posts.post_author = 43 AND wp_posts.post_status = 'private') ORDER BY wp_posts.post_date DESC LIMIT 0, 1)) ORDER BY p2pm_order.meta_value+0 ASC, wp_posts.post_date DESC