summaryrefslogtreecommitdiffstats
path: root/web/lib/acctfuncs.inc.php
diff options
context:
space:
mode:
authorEli Schwartz <eschwartz@archlinux.org>2021-02-17 03:42:23 +0100
committerLukas Fleischer <lfleischer@archlinux.org>2021-02-20 17:22:11 +0100
commitd92dd69aa3c23acc7e2e409decf42c3b3e37749c (patch)
tree53ddceef5e3d60ea076e1541c2bddd1183f91f4a /web/lib/acctfuncs.inc.php
parentd5e308550ad4682829c01feb32212540a6699100 (diff)
downloadaur-d92dd69aa3c23acc7e2e409decf42c3b3e37749c.tar.gz
aur-d92dd69aa3c23acc7e2e409decf42c3b3e37749c.tar.xz
fix broken SQL query that always failed
Due to missing whitespace at the end of strings during joining, we ended up with the query fragment "DelTS IS NULLAND NOT PinnedTS" which should be "DelTS IS NULL AND NOT PinnedTS" So the check for pinned comments > 5 likely always failed. In php 7, a completely broken query that raises exceptions in the database engine was silently ignored... in php 8, it raises Uncaught PDOException: SQLSTATE[HY000]: General error: 1 near "PinnedTS": syntax error in <file> and aborts the page building. End result: users with permission to pin comments cannot see any comments, or indeed page content below the first comment header Signed-off-by: Eli Schwartz <eschwartz@archlinux.org> Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
Diffstat (limited to 'web/lib/acctfuncs.inc.php')
0 files changed, 0 insertions, 0 deletions