Issue with Simple Map plugin and cache not clearing

[samstevens]

Describe the bug

When Blitz automatically clears the cache, the queue task can fail for certain queries when using the Simple Map plugin. This will result in the site being partially cleared.

To reproduce

When using the Simple Map plugin and the ORDER BY distance feature, Blitz will store the original SQL query it saw, however, the plugin is doing some extra work under the hood:

https://github.com/ethercreative/simplemap/blob/v3/src/services/MapService.php#L392

This results in an error in the SQL query blitz stores.

Expected behaviour / potential fix

These queries could be ignored.

Versions

• Plugin version: Latest
• Craft version: Latest

Thanks,
Sam

[bencroker]

Thanks for reporting this. I made the refresh cache job ignore exceptions when executing element queries in 867bcb8, which should prevent the queue job from failing in the next release.

[samstevens]

Thanks Ben – that makes sense.

Cheers,
Sam

[bencroker]

Released in version 3.11.1.