Spyke

Posts

lemmy_support·Lemmy Supportbynick

Query to fix modlog

The modlog page can break if anyone has been banned with an expiry too far into the future, I grabbed this query to fix it from the github issue a while back and refined it a little if it's useful to anyone:

BEGIN;
-- The modlog UI breaks for bans too far in the future
SELECT * FROM mod_ban WHERE expires > now() + INTERVAL '10 years';
-- Lets just make them permanent as an easy fix lol
UPDATE mod_ban SET expires = NULL WHERE expires > now() + INTERVAL '10 years';
-- See our changes
SELECT * FROM mod_ban WHERE expires > now() + INTERVAL '10 years';
ROLLBACK;
-- replace ROLBACK; with COMMIT; if you're happy

This will make any ban with an expiry >10 years into the future permanent and fix your modlog. If this happens a lot it might be worth making this a trigger in your lemmy db.

View original on campfyre.nickwebster.dev
newcommunities·New Communitiesbynick

(TrueSTL) The Elder Scrolls Lore - A place to shitpost about the insane lore around The Elder Scrolls

Links

/c/[email protected]
![email protected]
https://campfyre.nickwebster.dev/c/truestl

About

(not officially affiliated with /r/TrueSTL)

Do you often find yourself wondering about the true nature of Ogrim nipple-piercings? Does the mythology of Space Pirate Captain Harlock make your head spin? Do you want to learn more about the metaphysics of Sword Art Online, your favorite Cambodian Silent Film? Do you find your questions, concerns, and philosophical quandaries unaddressed by Final Fantasy: Online?

Worry not. ![email protected] is a place that encourages discussion on any and all facets of CHIM, Dragon Breaks and the Hist, the greater bodies of Elder Scrolls fiction, without judgement or prejudice.

Here at ![email protected], every Muatra is big enough to achieve CHIM.

View original on campfyre.nickwebster.dev