clear_caches is caching the wrong tables

[johndwells]

Correct me if I'm wrong, but shouldn't the table names in the clear_caches.sh script be:

"templatecachecriteria"
"templatecacheelements"
"templatecaches"

And not:

"cache"
"templatecaches"

?

[khalwat]

So the cache table is used if you have set Craft's cacheMethod to db

The ./clear_caches.sh script only clears out your cache tables/directories/redis caches and the templatecaches table.

It's arguable whether it should clear out templatecacheelements and templatecachecriteria, I'd have to investigate a bit more to see if it makes a difference.

[khalwat]

Ahhhhh... Brandon Kelly just jogged my memory... if you clear the templatecaches rows, it will cascade and delete the templatecachecriteria and templatecacheelements rows as well.

I remember originally when I wrote this, I had it clearing all of those tables, but I was getting errors on the templatecachecriteria and templatecacheelements tables, because they were already deleted.