TL;DR: I have a DPL call which definitely worked prior to UCP but is now completely broken. It uses titleregexp to select pages and I am wondering if it broke because I am using an outdated syntax.
I have this user subpage on Community Central where I use DPL to list the CSS pages I created in the past. Here is the DPL call I have been using since 2019 and it definitely used to work.
{{#dpl:
| namespace = User
| titleregexp = ^Andrewds1021/.*[.period.]css$
| nottitleregexp = ^Andrewds1021/(global{{!}}common{{!}}wikia)[.period.]css$
| ordermethod = title
| format = ,#[[%PAGE% ¦ ²{#sub: %PAGE% ¦ 18}²]]\n,,
| allowcachedresults = true
| dplcacheperiod = 604800
}}It has been a while since I had to check the page to find some old CSS so I only recently noticed that it no longer functions properly. At first I thought it was odd because I use similar parameter values in other DPL calls which don't appear to have broken. However, after some careful consideration and online searching. I think it is possible that those other calls just work by coincidence rather than because they do what I want them to.
While I was searching, I couldn't find anything about the [.period.] syntax that I had been using so I was really confused. At the time I had originally written the call, I definitely recall seeing this syntax when searching how to use the parameter. I finally found something similar but it was [[.period.]] instead (note the double brackets). I have edited the page to use that but it still doesn't work. This is the documentation where I finally found the double-bracket syntax. I noticed that it is for MySQL version 5.7 whereas the current documentation is for MySQL version 8.0 and contains neither the single nor the double-bracket syntax. And yes, I am aware that SQL and MySQL are not the same. However, finding this difference, I am wondering if the reason the DPL call doesn't work any more is because it is using a deprecated syntax.
If anyone could help clarify this for me, it would be much appreciated.
