Issue with canonical url, when using mysql

Currently I'm using Ubuntu 18.04, I'm trying to develop blogging websites using django. I'm trying to use canonical url for displaying more meaningful url format. Every things i fine when I'm using dajngo default database i.e sqlite3. But when I shift from sqlite3 to mysql, post_detail page is not dispalying.

For better explanation of my problem screenshot is given below, what i'm facing.

But I'm not facing any types of error while using sqlite3.. So, Please help me out from this problem