hi,
I know .90 is not supported, but if any old hand could help me out I will be
grateful. I migrated an old .90 site to postgres8.3, python2.5. No problems,
it worked. Only in one model I am unable to save or modify in admin. The model
is:
class Match(meta.Model):
name = meta.CharField('Tournament Name',maxlength=200)
club = meta.ForeignKey(Club)
year = meta.IntegerField('Year')
startdate = meta.DateField('Start Date',blank=True,null=True)
enddate = meta.DateField('End Date',blank=True,null=True)
practice = meta.DateField('Practice',blank=True,null=True)
contact = meta.TextField('Contact Person',blank=True,null=True)
priority = meta.IntegerField('Priority',default=2)
class META:
unique_together = (("name","year"),)
ordering = ['-priority','-startdate']
admin=meta.Admin()
def __repr__(self):
return "%d %s %s" %(self.year,self.name,self.get_club())
and the error message is:
ProgrammingError at /szdb/admin/matches/matchs/1/
ERROR: operator does not exist: integer ~~* unknown LINE 1: ...OM
"matches_matchs" WHERE "matches_matchs"."year" ILIKE '200... ^ HINT: No
operator matches the given name and argument type(s). You might need to add
explicit type casts. SELECT
"matches_matchs"."id","matches_matchs"."name","matches_matchs"."club_id","matches_matchs"."year","matches_matchs"."startdate","matches_matchs"."enddate","matches_matchs"."practice","matches_matchs"."contact","matches_matchs"."priority"
FROM "matches_matchs" WHERE "matches_matchs"."year" ILIKE '2009' AND
"matches_matchs"."name" ILIKE 'OGC Junior Golf Championship'
Request Method: POST
Request URL: http://szjuniorgolf.org.in/szdb/admin/matches/matchs/1/
Exception Type: ProgrammingError
Exception Value: ERROR: operator does not exist: integer ~~* unknown
LINE 1:
...OM "matches_matchs" WHERE "matches_matchs"."year" ILIKE '200... ^ HINT: No
operator matches the given name and argument type(s). You might need to add
explicit type casts. SELECT
"matches_matchs"."id","matches_matchs"."name","matches_matchs"."club_id","matches_matchs"."year","matches_matchs"."startdate","matches_matchs"."enddate","matches_matchs"."practice","matches_matchs"."contact","matches_matchs"."priority"
FROM "matches_matchs" WHERE "matches_matchs"."year" ILIKE '2009' AND
"matches_matchs"."name" ILIKE 'OGC Junior Golf Championship'
Exception Location: /usr/lib/python2.5/site-packages/django/core/db/base.py
in execute, line 9
Traceback (innermost last)
Switch to copy-and-paste view
* /usr/lib/python2.5/site-packages/django/core/handlers/base.py in
get_response
67. # Apply view middleware
68. for middleware_method in self._view_middleware:
69. response = middleware_method(request, callback, callback_args,
callback_kwargs)
70. if response:
71. return response
72.
73. try:
74. response = callback(request, *callback_args, **callback_kwargs)
...
75. except Exception, e:
76. # If the view raised an exception, run it through exception
77. # middleware, and if the exception middleware returns a
78. # response, use that. Otherwise, reraise the exception.
79. for middleware_method in self._exception_middleware:
80. response = middleware_method(request, e)
▶ Local vars
Variable Value
DEBUG
True
INTERNAL_IPS
()
ROOT_URLCONF
'szdb.urls'
callback
<function _checklogin at 0x95e5144>
callback_args
()
callback_kwargs
{'app_label': 'matches', 'module_name': 'matchs', 'object_id': '1'}
db
<module 'django.core.db' from '/usr/lib/python2.5/site-
packages/django/core/db/__init__.pyc'>
e
ProgrammingError('ERROR: operator does not exist: integer ~~*
unknown\nLINE 1: ...OM "matches_matchs" WHERE "matches_matchs"."year" ILIKE
\'200...\n ^\nHINT: No operator matches the given name and argument type(s).
You might need to add explicit type casts.\n\nSELECT
"matches_matchs"."id","matches_matchs"."name","matches_matchs"."club_id","matches_matchs"."year","matches_matchs"."startdate","matches_matchs"."enddate","matches_matchs"."practice","matches_matchs"."contact","matches_matchs"."priority"
FROM "matches_matchs" WHERE "matches_matchs"."year" ILIKE \'2009\' AND
"matches_matchs"."name" ILIKE \'OGC Junior Golf Championship\'',)
exceptions
<module 'django.core.exceptions' from '/usr/lib/python2.5/site-
packages/django/core/exceptions.pyc'>
mail_admins
<function mail_admins at 0x9421f44>
middleware_method
<bound method CommonMiddleware.process_request of
<django.middleware.common.CommonMiddleware instance at 0x916cf8c>>
path
'/szdb/admin/matches/matchs/1/'
request
<ModPythonRequest path:/szdb/admin/matches/matchs/1/,
GET:<MultiValueDict: {}>, POST:<MultiValueDict: {'startdate': ['2009-04-21'],
'enddate': ['2009-04-22'], 'name': ['OGC Junior Golf Championship'], 'club':
['1'], 'practice': ['2009-04-20'], 'priority': ['1'], 'contact': ['Mr.Johnson
- Manager OGC.\r\n0423-2442254'], 'year': ['2009']}>, COOKIES:{'__utma':
'89463641.1630101462.1237347681.1240454598.1240458697.10', '__utmz':
'89463641.1240406182.7.2.utmccn=(referral)|utmcsr=guide.opendns.com|
utmcct=/controller.php|utmcmd=referral', 'sessionid':
'5c434341debb208990064ddc97c8c6b8'}, META:{'AUTH_TYPE': None,
'CONTENT_LENGTH': 0L, 'CONTENT_TYPE': None, 'GATEWAY_INTERFACE': 'CGI/1.1',
'HTTP_ACCEPT':
'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
'HTTP_ACCEPT_CHARSET': 'ISO-8859-1,utf-8;q=0.7,*;q=0.7',
'HTTP_ACCEPT_ENCODING': 'gzip,deflate', 'HTTP_ACCEPT_LANGUAGE': 'en-
us,en;q=0.5', 'HTTP_CONNECTION': 'keep-alive', 'HTTP_CONTENT_LENGTH': '173',
'HTTP_CONTENT_TYPE': 'application/x-www-form-urlencoded', 'HTTP_COOKIE':
'__utma=89463641.1630101462.1237347681.1240454598.1240458697.10;
__utmz=89463641.1240406182.7.2.utmccn=(referral)|utmcsr=guide.opendns.com|
utmcct=/controller.php|utmcmd=referral;
sessionid=5c434341debb208990064ddc97c8c6b8', 'HTTP_HOST':
'szjuniorgolf.org.in', 'HTTP_KEEP_ALIVE': '300', 'HTTP_REFERER':
'http://szjuniorgolf.org.in/szdb/admin/matches/matchs/1/', 'HTTP_USER_AGENT':
'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.0.6) Gecko/2009020410
Fedora/3.0.6-1.fc10 Firefox/3.0.6', 'PATH_INFO': '/admin/matches/matchs/1/',
'PATH_TRANSLATED': None, 'QUERY_STRING': None, 'REMOTE_ADDR': '59.92.124.119',
'REMOTE_HOST': None, 'REMOTE_IDENT': None, 'REMOTE_USER': None,
'REQUEST_METHOD': 'POST', 'SCRIPT_NAME': None, 'SERVER_NAME':
'www.szjuniorgolf.org.in', 'SERVER_PORT': 0, 'SERVER_PROTOCOL': 'HTTP/1.1',
'SERVER_SOFTWARE': 'mod_python'}, user:golfchap>
resolver
<django.core.urlresolvers.RegexURLResolver object at 0x916cfec>
response
None
self
<django.core.handlers.modpython.ModPythonHandler instance at 0x909408c>
urlresolvers
<module 'django.core.urlresolvers' from '/usr/lib/python2.5/site-
packages/django/core/urlresolvers.py'>
* /usr/lib/python2.5/site-
packages/django/contrib/admin/views/decorators.py in _checklogin
47. def _checklogin(request, *args, **kwargs):
48. if not request.user.is_anonymous() and request.user.is_staff:
49. # The user is valid. Continue to the admin page.
50. if request.POST.has_key('post_data'):
51. # User must have re-authenticated through a different window
52. # or tab.
53. request.POST = _decode_post_data(request.POST['post_data'])
54. return view_func(request, *args, **kwargs) ...
55.
56. assert hasattr(request, 'session'), "The Django admin requires
session middleware to be installed. Edit your MIDDLEWARE_CLASSES setting to
insert 'django.middleware.sessions.SessionMiddleware'."
57.
58. # If this isn't already the login page, display it.
59. if not request.POST.has_key(LOGIN_FORM_KEY):
60. if request.POST:
▶ Local vars
Variable Value
args
()
kwargs
{'app_label': 'matches', 'module_name': 'matchs', 'object_id': '1'}
request
<ModPythonRequest path:/szdb/admin/matches/matchs/1/,
GET:<MultiValueDict: {}>, POST:<MultiValueDict: {'startdate': ['2009-04-21'],
'enddate': ['2009-04-22'], 'name': ['OGC Junior Golf Championship'], 'club':
['1'], 'practice': ['2009-04-20'], 'priority': ['1'], 'contact': ['Mr.Johnson
- Manager OGC.\r\n0423-2442254'], 'year': ['2009']}>, COOKIES:{'__utma':
'89463641.1630101462.1237347681.1240454598.1240458697.10', '__utmz':
'89463641.1240406182.7.2.utmccn=(referral)|utmcsr=guide.opendns.com|
utmcct=/controller.php|utmcmd=referral', 'sessionid':
'5c434341debb208990064ddc97c8c6b8'}, META:{'AUTH_TYPE': None,
'CONTENT_LENGTH': 0L, 'CONTENT_TYPE': None, 'GATEWAY_INTERFACE': 'CGI/1.1',
'HTTP_ACCEPT':
'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
'HTTP_ACCEPT_CHARSET': 'ISO-8859-1,utf-8;q=0.7,*;q=0.7',
'HTTP_ACCEPT_ENCODING': 'gzip,deflate', 'HTTP_ACCEPT_LANGUAGE': 'en-
us,en;q=0.5', 'HTTP_CONNECTION': 'keep-alive', 'HTTP_CONTENT_LENGTH': '173',
'HTTP_CONTENT_TYPE': 'application/x-www-form-urlencoded', 'HTTP_COOKIE':
'__utma=89463641.1630101462.1237347681.1240454598.1240458697.10;
__utmz=89463641.1240406182.7.2.utmccn=(referral)|utmcsr=guide.opendns.com|
utmcct=/controller.php|utmcmd=referral;
sessionid=5c434341debb208990064ddc97c8c6b8', 'HTTP_HOST':
'szjuniorgolf.org.in', 'HTTP_KEEP_ALIVE': '300', 'HTTP_REFERER':
'http://szjuniorgolf.org.in/szdb/admin/matches/matchs/1/', 'HTTP_USER_AGENT':
'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.0.6) Gecko/2009020410
Fedora/3.0.6-1.fc10 Firefox/3.0.6', 'PATH_INFO': '/admin/matches/matchs/1/',
'PATH_TRANSLATED': None, 'QUERY_STRING': None, 'REMOTE_ADDR': '59.92.124.119',
'REMOTE_HOST': None, 'REMOTE_IDENT': None, 'REMOTE_USER': None,
'REQUEST_METHOD': 'POST', 'SCRIPT_NAME': None, 'SERVER_NAME':
'www.szjuniorgolf.org.in', 'SERVER_PORT': 0, 'SERVER_PROTOCOL': 'HTTP/1.1',
'SERVER_SOFTWARE': 'mod_python'}, user:golfchap>
view_func
<function change_stage at 0x95e510c>
* /usr/lib/python2.5/site-packages/django/contrib/admin/views/main.py in
change_stage
476. raise Http404
477.
478. if request.POST:
479. new_data = request.POST.copy()
480. if opts.has_field_type(meta.FileField):
481. new_data.update(request.FILES)
482.
483. errors = manipulator.get_validation_errors(new_data) ...
484.
485. manipulator.do_html2python(new_data)
486. if not errors and not request.POST.has_key("_preview"):
487. new_object = manipulator.save(new_data)
488. log_change_message(request.user,opts,manipulator,new_object)
489. msg = _('The %(name)s "%(obj)s" was changed successfully.') %
{'name': opts.verbose_name, 'obj':new_object}
▶ Local vars
Variable Value
app_label
'matches'
manipulator
<django.models.matchs.MatchManipulatorChange instance at 0x95e428c>
mod
<module 'matchs' from '/usr/lib/python2.5/site-
packages/szdb/apps/matches/models/matches.pyc'>
module_name
'matchs'
new_data
<MultiValueDict: {'startdate': ['2009-04-21'], 'enddate':
['2009-04-22'], 'name': ['OGC Junior Golf Championship'], 'club': ['1'],
'practice': ['2009-04-20'], 'priority': ['1'], 'contact': ['Mr.Johnson -
Manager OGC.\r\n0423-2442254'], 'year': ['2009']}>
object_id
'1'
opts
<Options for matchs>
request
<ModPythonRequest path:/szdb/admin/matches/matchs/1/,
GET:<MultiValueDict: {}>, POST:<MultiValueDict: {'startdate': ['2009-04-21'],
'enddate': ['2009-04-22'], 'name': ['OGC Junior Golf Championship'], 'club':
['1'], 'practice': ['2009-04-20'], 'priority': ['1'], 'contact': ['Mr.Johnson
- Manager OGC.\r\n0423-2442254'], 'year': ['2009']}>, COOKIES:{'__utma':
'89463641.1630101462.1237347681.1240454598.1240458697.10', '__utmz':
'89463641.1240406182.7.2.utmccn=(referral)|utmcsr=guide.opendns.com|
utmcct=/controller.php|utmcmd=referral', 'sessionid':
'5c434341debb208990064ddc97c8c6b8'}, META:{'AUTH_TYPE': None,
'CONTENT_LENGTH': 0L, 'CONTENT_TYPE': None, 'GATEWAY_INTERFACE': 'CGI/1.1',
'HTTP_ACCEPT':
'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
'HTTP_ACCEPT_CHARSET': 'ISO-8859-1,utf-8;q=0.7,*;q=0.7',
'HTTP_ACCEPT_ENCODING': 'gzip,deflate', 'HTTP_ACCEPT_LANGUAGE': 'en-
us,en;q=0.5', 'HTTP_CONNECTION': 'keep-alive', 'HTTP_CONTENT_LENGTH': '173',
'HTTP_CONTENT_TYPE': 'application/x-www-form-urlencoded', 'HTTP_COOKIE':
'__utma=89463641.1630101462.1237347681.1240454598.1240458697.10;
__utmz=89463641.1240406182.7.2.utmccn=(referral)|utmcsr=guide.opendns.com|
utmcct=/controller.php|utmcmd=referral;
sessionid=5c434341debb208990064ddc97c8c6b8', 'HTTP_HOST':
'szjuniorgolf.org.in', 'HTTP_KEEP_ALIVE': '300', 'HTTP_REFERER':
'http://szjuniorgolf.org.in/szdb/admin/matches/matchs/1/', 'HTTP_USER_AGENT':
'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.0.6) Gecko/2009020410
Fedora/3.0.6-1.fc10 Firefox/3.0.6', 'PATH_INFO': '/admin/matches/matchs/1/',
'PATH_TRANSLATED': None, 'QUERY_STRING': None, 'REMOTE_ADDR': '59.92.124.119',
'REMOTE_HOST': None, 'REMOTE_IDENT': None, 'REMOTE_USER': None,
'REQUEST_METHOD': 'POST', 'SCRIPT_NAME': None, 'SERVER_NAME':
'www.szjuniorgolf.org.in', 'SERVER_PORT': 0, 'SERVER_PROTOCOL': 'HTTP/1.1',
'SERVER_SOFTWARE': 'mod_python'}, user:golfchap>
* /usr/lib/python2.5/site-packages/django/core/formfields.py in
get_validation_errors
64. validator_list.append(getattr(self, 'validate_%s' %
field.field_name))
65. for validator in validator_list:
66. if field.is_required or new_data.get(field.field_name, False) or
hasattr(validator, 'always_test'):
67. try:
68. if hasattr(field, 'requires_data_list'):
69. validator(new_data.getlist(field.field_name), new_data)
70. else:
71. validator(new_data.get(field.field_name, ''), new_data) ...
72. except validators.ValidationError, e:
73. errors.setdefault(field.field_name, []).extend(e.messages)
74. # If a CriticalValidationError is raised, ignore any other
ValidationErrors
75. # for this particular field
76. except validators.CriticalValidationError, e:
77. errors.setdefault(field.field_name, []).extend(e.messages)
▶ Local vars
Variable Value
errors
{}
field
FormField "name"
new_data
<MultiValueDict: {'startdate': ['2009-04-21'], 'enddate':
['2009-04-22'], 'name': ['OGC Junior Golf Championship'], 'club': ['1'],
'practice': ['2009-04-20'], 'priority': ['1'], 'contact': ['Mr.Johnson -
Manager OGC.\r\n0423-2442254'], 'year': ['2009']}>
self
<django.models.matchs.MatchManipulatorChange instance at 0x95e428c>
validator
<bound method MatchManipulatorChange._curried of
<django.models.matchs.MatchManipulatorChange instance at 0x95e428c>>
validator_list
[<bound method TextField.isValidLength of FormField "name">, <bound
method TextField.hasNoNewlines of FormField "name">, <bound method
MatchManipulatorChange._curried of
<django.models.matchs.MatchManipulatorChange instance at 0x95e428c>>]
* /usr/lib/python2.5/site-packages/django/utils/functional.py in _curried
1. def curry(*args, **kwargs):
2. def _curried(*moreargs, **morekwargs):
3. return args[0](*(args[1:]+moreargs), **dict(kwargs.items() +
morekwargs.items())) ...
4. return _curried
5.
6. class Promise:
7. """
8. This is just a base class for the proxy class created in
9. the closure of the lazy function. It can be used to recognize
▶ Local vars
Variable Value
args
(<function manipulator_validator_unique_together at 0x9251a04>, ('name',
'year'), <Options for matchs>)
kwargs
{}
moreargs
(<django.models.matchs.MatchManipulatorChange instance at 0x95e428c>,
'OGC Junior Golf Championship', <MultiValueDict: {'startdate': ['2009-04-21'],
'enddate': ['2009-04-22'], 'name': ['OGC Junior Golf Championship'], 'club':
['1'], 'practice': ['2009-04-20'], 'priority': ['1'], 'contact': ['Mr.Johnson
- Manager OGC.\r\n0423-2442254'], 'year': ['2009']}>)
morekwargs
{}
* /usr/lib/python2.5/site-packages/django/core/meta/__init__.py in
manipulator_validator_unique_together
1932. return
1933. if isinstance(f.rel, ManyToOne):
1934. kwargs['%s__pk' % f.name] = field_val
1935. else:
1936. kwargs['%s__iexact' % f.name] = field_val
1937. mod = opts.get_model_module()
1938. try:
1939. old_obj = mod.get_object(**kwargs) ...
1940. except ObjectDoesNotExist:
1941. return
1942. if hasattr(self, 'original_object') and
getattr(self.original_object, opts.pk.attname) == getattr(old_obj,
opts.pk.attname):
1943. pass
1944. else:
1945. raise validators.ValidationError, _("%(object)s with this %(type)s
already exists for the given %(field)s.") % {
▶ Local vars
Variable Value
all_data
<MultiValueDict: {'startdate': ['2009-04-21'], 'enddate':
['2009-04-22'], 'name': ['OGC Junior Golf Championship'], 'club': ['1'],
'practice': ['2009-04-20'], 'priority': ['1'], 'contact': ['Mr.Johnson -
Manager OGC.\r\n0423-2442254'], 'year': ['2009']}>
f
<django.core.meta.fields.IntegerField object at 0x9352aac>
field_data
'OGC Junior Golf Championship'
field_list
[<django.core.meta.fields.CharField object at 0x9352a4c>,
<django.core.meta.fields.IntegerField object at 0x9352aac>]
field_name
'year'
field_name_list
('name', 'year')
field_val
'2009'
get_text_list
<function get_text_list at 0x92436bc>
kwargs
{'name__iexact': 'OGC Junior Golf Championship', 'year__iexact': '2009'}
mod
<module 'matchs' from '/usr/lib/python2.5/site-
packages/szdb/apps/matches/models/matches.pyc'>
opts
<Options for matchs>
self
<django.models.matchs.MatchManipulatorChange instance at 0x95e428c>
* /usr/lib/python2.5/site-packages/django/utils/functional.py in _curried
1. def curry(*args, **kwargs):
2. def _curried(*moreargs, **morekwargs):
3. return args[0](*(args[1:]+moreargs), **dict(kwargs.items() +
morekwargs.items())) ...
4. return _curried
5.
6. class Promise:
7. """
8. This is just a base class for the proxy class created in
9. the closure of the lazy function. It can be used to recognize
▶ Local vars
Variable Value
args
(<function function_get_object at 0x92515dc>, <Options for matchs>,
<class 'django.models.matches.Match'>, <class
'django.models.matchs.MatchDoesNotExist'>)
kwargs
{}
moreargs
()
morekwargs
{'name__iexact': 'OGC Junior Golf Championship', 'year__iexact': '2009'}
* /usr/lib/python2.5/site-packages/django/core/meta/__init__.py in
function_get_object
1349. return "%s = %%s" % db.get_date_extract_sql(lookup_type,
table_prefix + field_name)
1350. elif lookup_type == 'isnull':
1351. return "%s%s IS %sNULL" % (table_prefix, field_name, (not value and
'NOT ' or ''))
1352. raise TypeError, "Got invalid lookup_type: %s" % repr(lookup_type)
1353.
1354. def function_get_object(opts, klass, does_not_exist_exception,
**kwargs):
1355. kwargs['order_by'] = kwargs.get('order_by', ())
1356. obj_list = function_get_list(opts, klass, **kwargs) ...
1357. if len(obj_list) < 1:
1358. raise does_not_exist_exception, "%s does not exist for %s" %
(opts.object_name, kwargs)
1359. assert len(obj_list) == 1, "get_object() returned more than one %s
-- it returned %s! Lookup parameters were %s" % (opts.object_name,
len(obj_list), kwargs)
1360. return obj_list[0]
1361.
1362. def _get_cached_row(opts, row, index_start):
▶ Local vars
Variable Value
does_not_exist_exception
<class 'django.models.matchs.MatchDoesNotExist'>
klass
<class 'django.models.matches.Match'>
kwargs
{'name__iexact': 'OGC Junior Golf Championship', 'order_by': (),
'year__iexact': '2009'}
opts
<Options for matchs>
* /usr/lib/python2.5/site-packages/django/core/meta/__init__.py in
function_get_list
1389. else:
1390. obj = klass(*row[:index_end])
1391. for i, k in enumerate(kwargs['select']):
1392. setattr(obj, k[0], row[index_end+i])
1393. yield obj
1394.
1395. def function_get_list(opts, klass, **kwargs):
1396. return list(function_get_iterator(opts, klass, **kwargs)) ...
1397.
1398. def function_get_count(opts, **kwargs):
1399. kwargs['order_by'] = []
1400. kwargs['offset'] = None
1401. kwargs['limit'] = None
1402. kwargs['select_related'] = False
▶ Local vars
Variable Value
klass
<class 'django.models.matches.Match'>
kwargs
{'name__iexact': 'OGC Junior Golf Championship', 'order_by': (),
'year__iexact': '2009'}
opts
<Options for matchs>
* /usr/lib/python2.5/site-packages/django/core/meta/__init__.py in
function_get_iterator
1372. def function_get_iterator(opts, klass, **kwargs):
1373. # kwargs['select'] is a dictionary, and dictionaries' key order is
1374. # undefined, so we convert it to a list of tuples internally.
1375. kwargs['select'] = kwargs.get('select', {}).items()
1376.
1377. cursor = db.db.cursor()
1378. select, sql, params = function_get_sql_clause(opts, **kwargs)
1379. cursor.execute("SELECT " + (kwargs.get('distinct') and "DISTINCT "
or "") + ",".join(select) + sql, params) ...
1380. fill_cache = kwargs.get('select_related')
1381. index_end = len(opts.fields)
1382. while 1:
1383. rows = cursor.fetchmany(GET_ITERATOR_CHUNK_SIZE)
1384. if not rows:
1385. raise StopIteration
▶ Local vars
Variable Value
cursor
<django.core.db.base.CursorDebugWrapper instance at 0x95e454c>
klass
<class 'django.models.matches.Match'>
kwargs
{'name__iexact': 'OGC Junior Golf Championship', 'order_by': (),
'select': [], 'year__iexact': '2009'}
opts
<Options for matchs>
params
['2009', 'OGC Junior Golf Championship']
select
['"matches_matchs"."id"', '"matches_matchs"."name"',
'"matches_matchs"."club_id"', '"matches_matchs"."year"',
'"matches_matchs"."startdate"', '"matches_matchs"."enddate"',
'"matches_matchs"."practice"', '"matches_matchs"."contact"',
'"matches_matchs"."priority"']
sql
' FROM "matches_matchs" WHERE "matches_matchs"."year" ILIKE %s AND
"matches_matchs"."name" ILIKE %s'
* /usr/lib/python2.5/site-packages/django/core/db/base.py in execute
3. class CursorDebugWrapper:
4. def __init__(self, cursor, db):
5. self.cursor = cursor
6. self.db = db
7.
8. def execute(self, sql, params=[]):
9. start = time()
10. result = self.cursor.execute(sql, params) ...
11. stop = time()
12. self.db.queries.append({
13. 'sql': sql % tuple(params),
14. 'time': "%.3f" % (stop - start),
15. })
16. return result
▶ Local vars
any clues as where to start looking for a solution - any quick and dirty
workaround is fine.
--
regards
kg
http://lawgon.livejournal.com
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
