Skip to content

sql panel failures (after #347) #377

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
w-diesel opened this issue Apr 25, 2013 · 5 comments
Closed

sql panel failures (after #347) #377

w-diesel opened this issue Apr 25, 2013 · 5 comments

Comments

@w-diesel
Copy link
Contributor

Tried current trunk branch, with #347. I've got the HTTP/500 error, on some sql queries, when I wanted see the 'select'/'explain'.

Traceback:
File "/home/www/env_py26_dj14/lib/python2.6/site-packages/django/core/handlers/base.py" in get_response
  111.                         response = callback(request, *callback_args, **callback_kwargs)
File "/home/www/env_py26_dj14/lib/python2.6/site-packages/django/views/decorators/csrf.py" in wrapped_view
  77.         return view_func(*args, **kwargs)
File "/home/www/env_py26_dj14/lib/python2.6/site-packages/django_debug_toolbar-0.9.4_default_master-py2.6.egg/debug_toolbar/views.py" in sql_select
  33.         cursor.execute(sql, params)
File "/home/www/env_py26_dj14/lib/python2.6/site-packages/django_debug_toolbar-0.9.4_default_master-py2.6.egg/debug_toolbar/utils/tracking/db.py" in execute
  153.                                                 self._quote_params(params)),
File "/home/www/env_py26_dj14/lib/python2.6/site-packages/django/db/backends/__init__.py" in last_executed_query
  614.         return smart_unicode(sql) % u_params

Exception Type: TypeError at /__debug__/sql_select/
Exception Value: not all arguments converted during string formatting
@w-diesel
Copy link
Contributor Author

I did not mentioned this before:
this occurs when using SQLite, with any SQL-query.

@w-diesel
Copy link
Contributor Author

There is another problem with current trunk.
SQL queries with 'LIKE' statement will fail when you try see the "select"/"explain".
(tested with postgresql)
e.g. LIKE '445%'

ValueError at /__debug__/sql_select/
unsupported format character ''' (0x27) at index 284

@w-diesel
Copy link
Contributor Author

@midiotthimble Do you use mysql?

@nuklea
Copy link
Contributor

nuklea commented Apr 27, 2013

@w-diesel don't.

@apollo13
Copy link
Contributor

Fixed with #417

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants