[Dwight Bailey]

Thanks, Steve Z.!

Actually, I pasted your code near the top of my template itself, right below “if ( ! defined( ‘ABSPATH’ ) ) exit;” and that worked! Pretty impressive for it to work without you even having to test it LOL. This is great, because then I can easily control it, and have the comment on one page, and NOT on a different page, simply by having 2 identical templates (except that one would have your code, the other would not).

<

p>Using code snippets would be great too, except I think that would remove the comment throughout that site.</p?

Thanks!! You rock.
Steve K.
steve@chem.ufl.edu

[Dwight Bailey]

Ah well, no luck.
I updated all the zip codes using CSV import, using the entry_id field and the work address zip code. The import worked fine (gave no errors, data looks correct in DB), but the site still shows the old zip codes even though the new ones are correct in the database, and correct when you edit them one at a time in Connections.

They do still update correctly when you edit/save an individual in Connections.

The CSV has rows of data like this:
6 32611

I’m mapping the first one to entry_id, the second to work address zipcode.

Is there something I’m doing wrong? Is there perhaps another field besides zip code that must be edited to cause the caches to be refreshed (perhaps something like name in the _connections data table instead of only updating something in the connections_address table)?

BTW, we do have W3 Total Cache, but I emptied all the cache, and even turned that plugin off, with the same results.

I’m so sorry to keep bugging you with this! I thought we had it licked.
:(
Steve K.

[Dwight Bailey]

Ah, I misunderstood. Thanks for clarifying that for me!
Then I’ll just make a CSV file and re-update my zip codes that way!
Problem solved (as always:).

Thanks,
Steve K.

[Dwight Bailey]

So if there is no way for me to actually delete/remove/empty that cache (only temporarily disable it), then I’ll just have to edit/save them all one at a time so they update.

If the old data will “come back” when you re-enable the caching, then I agree with you, that it would be a bad idea to reduce performance by disabling the cache.

That sort of defeats the CSV upload feature, I imagine, since editing existing records that way would not change the “old” cached values. I look forward to seeing that update (whenever that happens:).

Thanks again for all your help,
Steve K.

[Dwight Bailey]

Ah, I see. As usual, you know exactly what is happening!

What if we disable these caches, refresh the pages in a browser, then re-enable them? Would that reset the cache to the latest version? Updating the DB directly is a rare occurrence (hopefully we won’t need to do it again LOL).

If that would work, please provide instructions for disabling the entry object caches.

Thanks again!
Steve K.

[Dwight Bailey]

OMG!!! You rock! Going to settings=>permalinks did the trick. I would NEVER have guessed to do that. I’ll definitely make a not of that! Thanks again.

As always, thank you so much for your excellent and SPEEDY solution!

Steve K.

[Dwight Bailey]

P.S. I tried removing the “home_id=663” and clicking the name changed as expected to https://www.chem.ufl.edu/faculty-and-research/divisions/analytical/name/richard-yost/ but this also gave the 404 error.

Not sure if that helps or not.
Thanks again!
Steve

[Dwight Bailey]

Ok, sorry to bring this up again, but we just went “live” and the name links are not working, when this WAS working before! Weird.
We changed the site name/url from “https://newsite.chem.ufl.edu&#8221; to “https://www.chem.ufl.edu&#8221;. Could changing the site name have “confused” Connections?

For example, check out:
https://www.chem.ufl.edu/faculty-and-research/divisions/analytical/
When you click on a name, like “Willard W. Harrison” for example, it gives you this link, which says “404 Error: file or page not found”:
https://www.chem.ufl.edu/people/name/willard-harrison/

On the analytical page is the following shortcode, as per your instructions (which worked before we went live):
[connections <b>home_id=663</b> enable_search="false" enable_category_select="false" category='74' page_limit=200 order_by='last_name|SORT_ACS,first_name|SORT_ASC' str_work_email='Email' str_work_phone='Phone' str_work_fax='Fax' str_work_addr='Address' str_other_addr='Office']

Page ID#663 is:
https://www.chem.ufl.edu/people/
which has this shortcode:
[connections enable_search="false" enable_category_select="false" page_limit=200 order_by='last_name|SORT_ACS,first_name|SORT_ASC' str_work_email='Email' str_work_phone='Phone' str_work_fax='Fax' str_work_addr='Address' str_other_addr='Office']

Any ideas as to why the link on the connections names would stop working?
If https://www.chem.ufl.edu/people/name/willard-harrison/ is supposed to access “williard-harrison” on the /people/ page (ID=663), why does it give page not found error? Could it have something to do with changing the name and url of the site?

Thank you so much for your help, Steve, as always!
Steve K. (For Dwight:)

[Dwight Bailey]

Ah, we have 2 other plugins someone installed…Query Strings Remover and Async JS and CSS!

Deactivating those solved it! So now I can work backwords and add things back so as not to break the JS again. Thanks, Steve, you rock!

Steve K. (for Dwight:)

[Dwight Bailey]

Actually, I thought it was W3TC inserting that asyncScripts stuff. I’ll have to look further.

[Author]

Posts