The curious case of %d in cursor.execute

mysqldb_error.py

#!/bin/python
def insert_post(post):
    try:
        cursor.execute("select max(post_id) from post_master")
        fetched = cursor.fetchone()
        if fetched is None:
            post_id=0
        else:
            post_id = fetched+1
        cursor.execute('insert into post_master\
        (post_id,post_title,post_content,posted_on,post_author,post_url) \
        values (%d,%s,%s,%s,%s,%s)',[ post_id, post['title'], post['text'], \
        post['date'], post['username'], post['url']])
        cursor.commit()
    except:
        app.logger.error("Couldn't execute insert_posts")
#instead of %d you need to use %s irrespective of the data type