2023-11-20

Goal

To fix the DIMMiN Blog so that I can see post details. Then to access and store a user's timezone.

Pomodoro

Nah lmao just gonna go for it

Notes

I woke up this morning and realized that while Taskmaster works great, I couldn't access my blog posts. I was getting a 500 Response Error indicating something was wrong with the server. Thankfully when I checked the Blog app on the Django admin side I could still see all of the blog information so it's not like I bombed the server or anything. Either way I decided to check out the Heroku logs to get a better sense of what was going on with the

heroku logs --tail

command. Unfortunately, I ended up encountering another error where CKeditor couldn't find its static files even after running collectstatic. Specifically, at the top of the admin page I received the following error:

/static/ckeditor/ckeditor-init.js" data-ckeditor-basepath="/static/ckeditor/ckeditor/" id="ckeditor-init-script

I ended up finding out that I could Manually Backup my PostgreSQL DB and could download it. I'm trying to figure our pgadmin to access my database locally so I can try and figure out what's going on. This is turning out to be pretty difficult, but I'm thinking that might be a good way to observe what the tables look like in my database rn.

After work I was finally able to connect to pgadmin and add a live connection to my app. It's pretty cool because I can see every change that the db is making immediately after it happens. I can also see that the Taskmaster App logs look correct and are now finally accessible!!! Muhahahaha

Results

  • Downloaded a local version of my database
  • Learned how to back up my database
  • Learned that django admin view is incorrectly formatting HTML to initiate ckeditor
  • Downloaded and configured local access to my production DB to establish a live connection using pgadmin

Next Time

  • Download and configure local access to my production DB using pgadmin

Previous Note 2023-11-19 Next Note 2023-11-21