erAck wrote:

Aest wrote:

Opinions?

Rather than adding yet more overhead to the query processing that slows things down I'd rather see all plugins fixed that use unquoted rank and groups fields for which these workarounds were introduced first hand.

Exactly!
The workaround i've posted doesn't do what i need. I tried some other hacks with no luck. So i strongly agree with you.
Even more. Now, just 2 "dangerous" keywords are hardcoded in the pwg_query function.
I think, this is totally wrong way. 4 instance, in the next version of mysql a new keyword would be added and again, same keyword used in piwigo's tables structure, so we'll need again add another one 'crutch' in the code. What if mariadb would add some keyword, and mysql another?
So, now, i've being studying a code and changing field names

Last edited by Aest (2020-11-14 21:31:03)

@erAck, thanks a million for your help!