> raise dException.DBQueryException(errMsg) > DBQueryException: not all arguments converted during string formatting
I'm at work now, and don't have the time to dig into this. But usually that error means that the query has a parameter that isn't specified in the SQL that is being run. Unfortunately, I never added dbLogging to the MM code. I've created a ticket (http://trac.dabodev.com/ticket/1421) for doing this, but in the meantime, try this: in db/dCursorMixin.py, add the following lines: 1141 sql = "select %s from %s where %s = ?" % (self.KeyField, tbl, field) print "SQL", sql print "VAL", val 1142 aux.execute(sql, (val,)) Re-run the code as you did before, and before the traceback you should see the output from those two lines. Paste that in your reply. -- Ed Leafe ==================================== Ed, I pasted the print lines. This is what it prints--- SQL select mdlmstid from mdlmst where mdlmstid = ? VAL 1 In the debug mode, the failed sql is shown as: u'FAILED SQL: select mdlmstid from mdlmst where mdlmstid=?, PARAMS=1' Pl. tell me if you require further info for debugging my code. Thanks, Vineet --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
