Shlee shleeable
shleeable
/ gist:2064914eb4ec1b91cff3e615d0eeb3b7
Created
January 30, 2026 15:15
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ``` | |
| [2026-01-30 15:12:24] production.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1055 'loops_server.profiles.local' isn't in GROUP BY (Connection: mysql, Host: 192.168.125.251, Port: 3306, Database: loops_server, SQL: select `profiles`.`id`, `profiles`.`local`, `profiles`.`name`, `profiles`.`avatar`, `profiles`.`username`, `profiles`.`following`, `profiles`.`followers`, `profiles`.`video_count`, `profiles`.`domain`, `profiles`.`status`, `profiles`.`created_at`, MAX(CASE WHEN followers.following_id IS NOT NULL THEN 1 ELSE 0 END) as is_followed from `profiles` left join `followers` on `followers`.`following_id` = `profiles`.`id` and `followers`.`profile_id` = 243939654684254235 where `profiles`.`id` != 243939654684254235 and not exists (select `id` from `user_filters` where `user_filters`.`account_id` = `profiles`.`id` and `user_filters`.`profile_id` = 243939654684254235) and `profiles`.`username` like https://loops.video/@dansup% and `profiles`.`status` = 1 group by `profiles`.`id`, `profiles`.`u |
shleeable
/ gist:6566870801d27b22ad67114cbd629ce5
Created
July 17, 2024 09:09
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| services: | |
| es1: | |
| restart: always | |
| image: docker.elastic.co/elasticsearch/elasticsearch:8.14.1 | |
| environment: | |
| - "ES_JAVA_OPTS=-Xms512m -Xmx512m -Des.enforce.bootstrap.checks=true" | |
| - "xpack.license.self_generated.type=basic" | |
| - "xpack.security.enabled=false" | |
| - "xpack.watcher.enabled=false" | |
| - "xpack.graph.enabled=false" |
shleeable
/ gist:101b131653c0ff0e21a81bf99a31c7f0
Last active
October 31, 2023 01:08
Mastodon instances Max character length survey - 31st of Oct 2023
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 10335 | TOTAL LINES | |
| 140 | DISTINCT LINES | |
| COUNT | LINE | |
| ----------------------------------------------------- | |
| 8138 | 500 | |
| 942 | 5000 | |
| 445 | 3000 | |
| 135 | 1000 | |
| 81 | 10000 |
shleeable
/ gist:6c802263702b84b9dac0d3026ea05368
Created
April 11, 2019 06:37
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ### Keybase proof | |
| I hereby claim: | |
| * I am shleeble on github. | |
| * I am ashleyhull (https://keybase.io/ashleyhull) on keybase. | |
| * I have a public key ASBN5FKT0TERMYwjr6TkQTNNMlKo4uyqA2nqz8fy-ayr4go | |
| To claim this, I am signing this object: |