Groschi on Nostr: So, the bad news is my instance has been down for most of today. The good news is ...
So, the bad news is my instance has been down for most of today. The good news is that i learned quite a bit today about how to handle SQL databases. Pleroma refused to do the database migrations when updating, complaining about some duplicate column. Pretty straightforward, so i gotta locate the offending column and drop it. Sounds easy and it probably is for someone less green behind their ears. As for me though, i had to learn basic SQL queries from scratch. Spent most of the day doing just that. But who fucking cares, i'm fucking back and the next database woes are sure gonna feeel a lot less scary! 🤯
Published at
2023-12-23 22:58:03Event JSON
{
"id": "9151f37910431019fe405564e5629f1228d86b9bc306aa8157e42b192f25e9d2",
"pubkey": "a317963c0b98deb2ae3e28e1c11993f6f7167bdfb4d6575b411e62e523ab10d2",
"created_at": 1703372283,
"kind": 1,
"tags": [
[
"proxy",
"https://elefant.onetwoxu.de/objects/1e2e2ec7-4fb8-4df8-8859-a4e39f923db6",
"activitypub"
]
],
"content": "So, the bad news is my instance has been down for most of today. The good news is that i learned quite a bit today about how to handle SQL databases. Pleroma refused to do the database migrations when updating, complaining about some duplicate column. Pretty straightforward, so i gotta locate the offending column and drop it. Sounds easy and it probably is for someone less green behind their ears. As for me though, i had to learn basic SQL queries from scratch. Spent most of the day doing just that. But who fucking cares, i'm fucking back and the next database woes are sure gonna feeel a lot less scary! 🤯",
"sig": "d21e408f94f0f806aa8d19b5450f0150b62dd32fc35e2439945a91f6a84cf2ba3f5163ac2adbc8548c8101bd683875f2b72708984910b1e95c51fced68132740"
}