id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
21565	values() and values_list() don't work when datetime fields are specified and a GeoManager is used	brett_energysavvy	Marc Tamlyn <marc.tamlyn@…>	"I've attached an app which can be used to reproduce this as well.

{{{
from django.db import models
from django.contrib.gis.db.models.manager import GeoManager

class MyModel(models.Model):
    some_time = models.DateTimeField()
    
    objects = GeoManager()

def some_function():
    # Assuming there are instances of MyModel, this code will
    # blow up when evaluated
    list(MyModel.objects.values_list('id', 'some_time'))
}}}

This results in the following stack:
{{{
Traceback (most recent call last):
  File ""C:\Python27\lib\site-packages\django\core\handlers\base.py"", line 114, in get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File ""C:\Users\Brett\Desktop\mysite\mysite\views.py"", line 10, in repro_view
    list(MyModel.objects.values_list('id', 'some_time'))
  File ""C:\Python27\lib\site-packages\django\db\models\query.py"", line 96, in __iter__
    self._fetch_all()
  File ""C:\Python27\lib\site-packages\django\db\models\query.py"", line 854, in _fetch_all
    self._result_cache = list(self.iterator())
  File ""C:\Python27\lib\site-packages\django\db\models\query.py"", line 1068, in iterator
    for row in self.query.get_compiler(self.db).results_iter():
  File ""C:\Python27\lib\site-packages\django\db\models\sql\compiler.py"", line 746, in results_iter
    row = self.resolve_columns(row, fields)
  File ""C:\Python27\lib\site-packages\django\contrib\gis\db\models\sql\compiler.py"", line 182, in resolve_columns
    values.append(self.query.convert_values(value, field, self.connection))
  File ""C:\Python27\lib\site-packages\django\contrib\gis\db\models\sql\query.py"", line 76, in convert_values
    return super(GeoQuery, self).convert_values(value, field, connection)
  File ""C:\Python27\lib\site-packages\django\db\models\sql\query.py"", line 289, in convert_values
    return connection.ops.convert_values(value, field)
  File ""C:\Python27\lib\site-packages\django\db\backends\sqlite3\base.py"", line 267, in convert_values
    return parse_datetime_with_timezone_support(value)
  File ""C:\Python27\lib\site-packages\django\db\backends\sqlite3\base.py"", line 46, in parse_datetime_with_timezone_support
    dt = parse_datetime(value)
  File ""C:\Python27\lib\site-packages\django\utils\dateparse.py"", line 67, in parse_datetime
    match = datetime_re.match(value)
TypeError: expected string or buffer
}}}

This appears to also happen in Django 1.6. Any help on a workaround would be useful as well."	Bug	closed	GIS	1.5	Normal	fixed			Accepted	0	0	0	0	0	0