search

farcepest / MySQLdb1

MySQL database connector for Python (legacy version)
https://sourceforge.net/projects/mysql-python/
667 stars 318 forks source link

typeError in 1.25, not in earlier versions. #49

Open eppye opened 10 years ago

eppye commented 10 years ago

Trace: File "/home/hje/Bots/botsdev/bots/botslib.py", line 208, in changeq cursor.execute(querystring,*args) File "build/bdist.linux-x86_64/egg/MySQLdb/cursors.py", line 185, in execute for key, item in args.iteritems()) File "build/bdist.linux-x86_64/egg/MySQLdb/cursors.py", line 185, in for key, item in args.iteritems()) File "build/bdist.linux-x86_64/egg/MySQLdb/connections.py", line 278, in literal return self.escape(o, self.encoders) File "build/bdist.linux-x86_64/egg/MySQLdb/converters.py", line 133, in quote_tuple return "(%s)" % (','.join(escape_sequence(t, d))) File "build/bdist.linux-x86_64/egg/MySQLdb/converters.py", line 133, in quote_tuple return "(%s)" % (','.join(escape_sequence(t, d))) File "build/bdist.linux-x86_64/egg/MySQLdb/converters.py", line 133, in quote_tuple return "(%s)" % (','.join(escape_sequence(t, d))) File "build/bdist.linux-x86_64/egg/MySQLdb/converters.py", line 133, in quote_tuple return "(%s)" % (','.join(escape_sequence(t, d))) File "build/bdist.linux-x86_64/egg/MySQLdb/converters.py", line 133, in quote_tuple return "(%s)" % (','.join(escape_sequence(t, d))) File "build/bdist.linux-x86_64/egg/MySQLdb/converters.py", line 133, in quote_tuple return "(%s)" % (','.join(escape_sequence(t, d))) File "build/bdist.linux-x86_64/egg/MySQLdb/converters.py", line 133, in quote_tuple return "(%s)" % (','.join(escape_sequence(t, d))) File "build/bdist.linux-x86_64/egg/MySQLdb/converters.py", line 133, in quote_tuple return "(%s)" % (','.join(escape_sequence(t, d))) TypeError: sequence item 0: expected string, dict found

This error does not occur in earlier version (1.2.2, 1.2.4). Statement where error occurs is something like: '''INSERT INTO filereport (idta,statust) VALUES (%(idta)s,%(statust)s ) ''', tmp_dict problem here is in the content of the dict (I think). The error happens for key/values of the dict that are not actually used in the query; when I remove this unused key/value from the dict the errro does not occur.

farcepest commented 10 years ago

That particular change is going to be reverted for 1.2.6, though it may remain in 1.3.0.

eppye commented 10 years ago 
thanks.kind regards,

Henk-Jan Ebbers www.ebbersconsult.com t: 0031 30 2888358

Bots Open Source EDI Translator: http://bots.sourceforge.net

  On 01/16/2014 07:25 PM, Andy Dustman wrote:

  That particular change is going to be reverted for 1.2.6,
    though it may remain in 1.3.0.
  —
    Reply to this email directly or view
      it on GitHub.
s7v7nislands commented 10 years ago

any plan to release 1.2.6?