Results 1 to 1 of 1
  1. #1
    Join Date
    Apr 2011
    Posts
    1

    Unanswered: mysqldb interfaceError

    Hi all,

    I have a very weird problem with mysqldb (mysql module for python). I have a file with queries for inserting records in tables. If I call the functions from the file, it works just fine. But when I try to call one of the functions from another file it throws me a

    Code:
    _mysql_exception.InterfaceError: (0, '')
    I really don't get what I'm doing wrong here..

    I call the function from buildDB.py :
    Code:
    import create
    
    create.newFormat("HD", 0,0,0)
    The function newFormat(..) is in create.py (imported) :
    Code:
    from Database import Database
    
    db = Database()
    
    def newFormat(name, width=0, height=0, fps=0):
    format_query = "INSERT INTO Format (form_name, form_width, form_height, form_fps) VALUES ('"+name+"',"+str(width)+","+str(height)+","+str(fps)+");"
    db.execute(format_query)
    And the class Databse is the following :
    Code:
    import MySQLdb from MySQLdb.constants import FIELD_TYPE
    
    class Database():
    def __init__(self):
    server = "localhost"
    login = "seq"
    password = "seqmanager"
    database = "Sequence"
    my_conv = { FIELD_TYPE.LONG: int }
    
    self.conn = MySQLdb.connection(host=server, user=login, passwd=password, db=database, conv=my_conv)
    # self.cursor = self.conn.cursor()
    
    def close(self):
    self.conn.close()
    
    def execute(self, query):
    self.conn.query(query)
    (I put only relevant code)
    Code:
    Traceback :
    
    Z:\sequenceManager\mysql>python buildDB.py
    D:\ProgramFiles\Python26\lib\site-packages\MySQLdb\__init__.py:34: DeprecationWa
    rning: the sets module is deprecated
    from sets import ImmutableSet
    INSERT INTO Format (form_name, form_width, form_height, form_fps) VALUES ('HD',0
    ,0,0);
    Traceback (most recent call last):
    File "buildDB.py", line 182, in <module>
    create.newFormat("HD")
    File "Z:\sequenceManager\mysql\create.py", line 52, in newFormat
    db.execute(format_query)
    File "Z:\sequenceManager\mysql\Database.py", line 19, in execute
    self.conn.query(query)
    _mysql_exceptions.InterfaceError: (0, '')
    The warning has never been a problem before so I don't think it's related.
    Last edited by elanari; 04-20-11 at 06:21.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •