I had a pretty frustrating experience today. It goes a little something like this:
Working on client website Realizes that database needs to be setup Creates some migrations and models ...runs them
What the hell?
Um, what? Of course the damn table isn't going to be found, it's supposed to create it!
Tries the same command several times in hopes of a different outcome...nothing
Sigh, okay. Maybe the maintainer screwed something up.
Creates an issue ...few hours lateeeeer
this.table is for altering the table.
After bashing self for blatant idiocy, thanks maintainer and closes issue
Makes changes to code
Runs the migrations
OH MY FUCKING GOD, WHAT THE HELL!
Column name is too long
Er..okay.. Simple fix I guess.
Quick trip to Stack Overflow reveals I just need to change a setting
Completely ambiguous error
What. The. Fuck.
...few hours lateeer [after many failures...]
FUCK YOU MARIADB, FUCK EVERYTHING, DAMMIT MYSQL HERE I FUCKING COME!
...installing... ...installing... ...installing...
Oh my god, I really don't have time for this!
...few hours later [after taking multiple trips to Stack Overflow, mysql installed]
FU....- Oh. Just missing the database. Okay. Alright. Simple Fix
Logs into phpmyadmin, goes to create database
Oh my god, what the hell could it be now??
phpmyadmin was specifically configured for mariadb
Alright. Fine. Let's just reinstall it then.
Okay. How about now?
phpmyadmin never invoked dbconfig-common so the main database is missing
Ah okay. Let's just run it ourselves then
Tries creating database again
dbcommon-config only created the database, none of the core tables
Quick trip to Stack Overflow
Oh right. I can just run the bootstrap SQL code myself.
Finds the file, copy pastes into phpmyadmin and runs
Specific table doesn't exist
WELL OF FUCKING COURSE THE GOD DAMN TABLE DOESN'T EXIST, I HAVEN'T MADE IT YET!
Runs SQL code again
... ... ...
OH THANK GOD!
Already lost all motivation for what needed to be done originally
Story of my life. Every. Fucking. Time.
Thanks for reading, hope you enjoyed!
(PS. This is a true story.)