Modify

Opened 4 years ago

Closed 3 months ago

#11240 closed defect (worksforme)

Error binding parameter 5 - probably unsupported type.

Reported by: kratky@… Owned by: Ryan J Ollos
Priority: normal Component: BudgetingPlugin
Severity: normal Keywords:
Cc: Kirk Trac Release: 1.0

Description

Error upon inserting data into the BudgetingPlugin table:

2013-07-23 14:31:58,769 Trac[main] ERROR: Internal Server Error: 
Traceback (most recent call last):
  File "/Library/Python/2.7/site-packages/Trac-1.0.1-py2.7.egg/trac/web/main.py", line 497, in _dispatch_request
    dispatcher.dispatch(req)
  File "/Library/Python/2.7/site-packages/Trac-1.0.1-py2.7.egg/trac/web/main.py", line 224, in dispatch
    self._post_process_request(req, *resp)
  File "/Library/Python/2.7/site-packages/Trac-1.0.1-py2.7.egg/trac/web/main.py", line 338, in _post_process_request
    resp = f.post_process_request(req, *resp)
  File "/Library/Python/2.7/site-packages/Budgeting_Plugin-0.7.0-py2.7.egg/ticketbudgeting/ticketbudgeting.py", line 413, in post_process_request
    self._save_budget(tkt)
  File "/Library/Python/2.7/site-packages/Budgeting_Plugin-0.7.0-py2.7.egg/ticketbudgeting/ticketbudgeting.py", line 523, in _save_budget
    budget.do_action(self.env, tkt.id)
  File "/Library/Python/2.7/site-packages/Budgeting_Plugin-0.7.0-py2.7.egg/ticketbudgeting/ticketbudgeting.py", line 125, in do_action
    env.db_transaction(sql, setVals)
  File "/Library/Python/2.7/site-packages/Trac-1.0.1-py2.7.egg/trac/db/api.py", line 122, in execute
    return db.execute(query, params)
  File "/Library/Python/2.7/site-packages/Trac-1.0.1-py2.7.egg/trac/db/util.py", line 121, in execute
    cursor.execute(query, params)
  File "/Library/Python/2.7/site-packages/Trac-1.0.1-py2.7.egg/trac/db/util.py", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/Library/Python/2.7/site-packages/Trac-1.0.1-py2.7.egg/trac/db/sqlite_backend.py", line 78, in execute
    result = PyFormatCursor.execute(self, *args)
  File "/Library/Python/2.7/site-packages/Trac-1.0.1-py2.7.egg/trac/db/sqlite_backend.py", line 56, in execute
    args or [])
  File "/Library/Python/2.7/site-packages/Trac-1.0.1-py2.7.egg/trac/db/sqlite_backend.py", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
InterfaceError: Error binding parameter 5 - probably unsupported type.

Using SQLite as a database backend.

Attachments (0)

Change History (3)

comment:1 Changed 3 months ago by Ryan J Ollos

Owner: changed from Franz to Ryan J Ollos
Status: newaccepted

comment:2 Changed 3 months ago by Ryan J Ollos

Cc: Kirk added

comment:3 Changed 3 months ago by Ryan J Ollos

Resolution: worksforme
Status: acceptedclosed

The SQL is now:

INSERT INTO budgeting (ticket,position,comment,status,username,cost,estimation,type) VALUES (%s,%s,%s,%s,%s,%s,%s,%s)

There were some SQL string interpolation issues in the codebase a few years ago, and it appears a few still exist, but I don't see it for this case.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Ryan J Ollos.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment


E-mail address and name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.