Thread

Hi,

I’m running EE 2.2.1 on EngineHosting and I seem to be getting some strange caching problems:

First caching problem was updating entries in Structure. I used the PHPMyAdmin to run an UPDATE query on the default Structure template for a channel’s entries. It updated in the database and looked fine but editing an entry in the Control Panel did not reflect the change in the database and still displayed the previous template.

The second was updating the Entry and Expiration dates of a channel again using PHPMyAdmin, again these changes didn’t initially show in the front-end.

Finally, although the dates are now correct, using Low Yearly Archives to display the monthly archive links is showing all the entries in their original months.

If I edit an entry and re-save all seems to be fine but clearly I tried to query the database as there are too many entries to do manually. I have no caching enabled in the control panel and this is causing a little confusion…

Any ideas?

Thanks in advance

OK, so it’s not a caching, it looks like I am going to have to brush up my programming skills and learn about data serialization… got around the date problem by ‘Edit Selected’ in the CP and letting EE do the work for me.

Anyone got any pointers about a good place to start to learn about this topic?

Hi Neal,

what was your original problem? That isn’t clear to me.
Why did you resort to making manual update sin the database?

The reason for updating in the database was that there were hundreds of records that needed changes…

The Structure changes were required because the content had all been entered before the template had been set up and therefore each entry needed the correct template assigning to it. Travis pointed me in the direction of a script someone posted on Structure’s support forum which can help here (https://structure.tenderapp.com/discussions/problems/414-need-to-batch-change-entry-template-association)

The second problem was that the client wanted some functionality changed and instead of needing custom fields for dates of an event I could use the entry/expiration dates and harness archiving and plugins like Low Yearly Archives to create the navigation. I therefore needed to take the data from the custom fields and put this in the entry and expiration date fields, again on hundreds of records.

If there is a better way of updating multiple records in this manner it would be great to know as I am sure I will need to do similar things in the future.

Hi, Neal -

Updating in the database should be fine; but that won’t clear your cache.  Editing an entry does clear the cache.

If you go to /system/expressionengine/cache and empty that out, does that help alleviate the problem you’re seeing?

Thank you!