Python keeps giving an error when execute sql request

Question

In this case, this project was writen on python 3.4, works with mysql(especially uses pymysql library). Getting this error while execute sql request: mysql error sql: unpack_from requires a buffer of at least 8 bytes. It tries to execute the sql query below:

sql = """
        SELECT n.name
        FROM %s n
        WHERE n.ID = %d """ % (globals.tbl_notification_type, notificationTypeID)

Anybody came accross simular problems?

Dylan Su · Accepted Answer · 2016-02-03 09:02:20Z

2

Try to replace %d with %s:

sql = """
    SELECT n.name
    FROM %s n
    WHERE n.ID = %s """ % (globals.tbl_notification_type, notificationTypeID)

answered Feb 3, 2016 at 9:02

Dylan Su

6,0751 gold badge18 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python keeps giving an error when execute sql request

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related