Zankaria
1 follower · 1 following
  • Joined on 2025-02-18
Repositories Projects Packages Public activity Starred repositories
1
Zankaria commented on issue leftypol/leftypol#129 2025-07-07 17:25:52 -05:00
Long reported post cuts dismiss buttons

Thank you

Zankaria pushed to rework-search at leftypol/leftypol 2025-07-07 17:24:15 -05:00
30764b9b5e UserPostQueries.php: query for the body text in the non-escaped body field
Zankaria pushed to rework-search at leftypol/leftypol 2025-07-07 17:02:17 -05:00
3533d2d4e6 SearchService.php: capture free text words a separate tokens and use a fully linear regex
2bc0ef5104 search_form.html: remove bad help
fa24bdb664 search_form.html: fix naming
303c780b60 search.php: supply flag filter enablement
f6313606c3 SearchService.php: expose if the flag filter is enabled
Compare 9 commits »
Zankaria pushed to rework-search at leftypol/leftypol 2025-07-07 15:07:31 -05:00
ca5f414de4 search.php: handle query too broad error
0b972823d2 style.css: remove fieldset label css (interfered with threads in the search page)
fffce50734 docker: print PHP errors on docker log
01ff35510f search.php: refactor, use SearchService
a7fccc88f4 context.php: add SearchQueries
Compare 20 commits »
Zankaria pushed to rework-search at leftypol/leftypol 2025-07-07 15:05:30 -05:00
3e496e24a3 search.php: handle query too broad error
4bdbc8e944 style.css: remove fieldset label css (interfered with threads in the search page)
129926a8d3 docker: print PHP errors on docker log
a554e16be8 search.php: refactor, use SearchService
963d40a392 context.php: add SearchQueries
Compare 16 commits »
Zankaria pushed to rework-search at leftypol/leftypol 2025-07-07 14:58:49 -05:00
014ff0a993 search.php: handle query too broad error
b21b7cc469 style.css: remove fieldset label css (interfered with threads in the search page)
4afea9d17f docker: print PHP errors on docker log
304e22a153 search.php: refactor, use SearchService
28cde9c9a5 context.php: add SearchQueries
Compare 19 commits »
Zankaria pushed to rework-search at leftypol/leftypol 2025-07-07 14:55:52 -05:00
e4220edf0b search.php: handle query too broad error
299ebd8726 style.css: remove fieldset label css (interfered with threads in the search page)
60b6419766 docker: print PHP errors on docker log
e38a0a0999 search.php: refactor, use SearchService
1f38370d35 context.php: add SearchQueries
Compare 22 commits »
Zankaria pushed to rework-search at leftypol/leftypol 2025-07-07 14:52:32 -05:00
9f7b4aef9c search.php: handle query too broad error
72305335fb style.css: remove fieldset label css (interfered with threads in the search page)
f85514d840 docker: print PHP errors on docker log
14430cc900 search.php: refactor, use SearchService
17ebbcd0e2 context.php: add SearchQueries
Compare 6 commits »
Zankaria pushed to rework-search at leftypol/leftypol 2025-07-07 14:50:47 -05:00
551aaa160b search.php: handle query too broad error
f4b967a805 style.css: remove fieldset label css (interfered with threads in the search page)
65d5f0548d docker: print PHP errors on docker log
6c0d706955 search.php: refactor, use SearchService
24ef48da78 context.php: fix SearchService init
Compare 27 commits »
Zankaria pushed to rework-search at leftypol/leftypol 2025-07-07 14:49:12 -05:00
34abc44577 search.php: handle query too broad error
159bacdd92 style.css: remove fieldset label css (interfered with threads in the search page)
b261b66722 docker: print PHP errors on docker log
d9637332c2 search.php: refactor, use SearchService
384a2d2bc2 context.php: fix SearchService init
Compare 30 commits »
Zankaria pushed to rework-search at leftypol/leftypol 2025-07-07 14:27:54 -05:00
a1d03e2123 SearchService.php: remove spurious initialization
90a9a17323 search.php: handle query too broad error
7ca2d16cb5 style.css: remove fieldset label css (interfered with threads in the search page)
a355739bfe docker: print PHP errors on docker log
89318b13e8 SearchService.php: query too broad check
Compare 41 commits »
Zankaria pushed to fix-testing at leftypol/leftypol 2025-07-07 14:27:37 -05:00
6fd8efa8f6 composer: unfuck the compose.lock file for PHP 8.0
Zankaria commented on pull request leftypol/leftypol#134 2025-07-06 17:37:14 -05:00
Fix high CPU usage with overboard's catalog

As an additional idea: we should limit each posts_* subquery to the maximum number of posts the the overboard catalog will display

Zankaria commented on pull request leftypol/leftypol#134 2025-07-06 17:19:20 -05:00
Fix high CPU usage with overboard's catalog

Currently the query at 33af676a8d172694ebae0df17e3b0723b51c0ca9 is correct in isolation, however when used with the rest of the code, it causes a syntax error. Needs more investigation.

Zankaria pushed to ukko-catalog-sql-perf at leftypol/leftypol 2025-07-06 16:34:51 -05:00
33af676a8d config: rework query (still be perdedora)
Zankaria commented on pull request leftypol/leftypol#134 2025-07-06 16:21:51 -05:00
Fix high CPU usage with overboard's catalog

The query has a huge problem: it only counts the images in the OP

Zankaria pushed to ukko-catalog-sql-perf at leftypol/leftypol 2025-07-06 16:18:40 -05:00
9821a7420d catalog: fix SQL query sintax
Zankaria pushed to ukko-catalog-sql-perf at leftypol/leftypol 2025-07-06 16:13:20 -05:00
258e873706 catalog: fix SQL query sintax
Zankaria commented on pull request leftypol/leftypol#134 2025-07-06 16:05:33 -05:00
Fix high CPU usage with overboard's catalog

Right now it errors with

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the…

Zankaria created pull request leftypol/leftypol#134 2025-07-06 16:01:37 -05:00
Fix high CPU usage with overboard's catalog