FieldDoesNotExist at /django/api/find/

Request Method:	POST
Request URL:	http://www.theclustr.com/django/api/find/
Exception Type:	FieldDoesNotExist
Exception Value:	Video has no field named 'title'
Exception Location:	/usr/lib/python2.4/site-packages/django/db/models/options.py in get_field, line 236
Python Executable:	/usr/bin/python
Python Version:	2.4.3
Python Path:	['/var/www.theclustr.com/django', '/var/www.theclustr.com/django/lib', '/var/www.theclustr.com/django/mtvskate', '/usr/lib/python2.4/site-packages/setuptools-0.6c5-py2.4.egg', '/usr/lib/python2.4/site-packages/MySQL_python-1.2.2-py2.4-linux-i686.egg', '/usr/lib/python24.zip', '/usr/lib/python2.4', '/usr/lib/python2.4/plat-linux2', '/usr/lib/python2.4/lib-tk', '/usr/lib/python2.4/lib-dynload', '/usr/lib/python2.4/site-packages', '/usr/lib/python2.4/site-packages/Numeric', '/usr/lib/python2.4/site-packages/PIL', '/usr/lib/python2.4/site-packages/gtk-2.0']
Server time:	Tue, 15 Jul 2008 10:39:55 +0000

Traceback Switch to copy-and-paste view

/usr/lib/python2.4/site-packages/django/core/handlers/base.py in get_response

# Apply view middleware
for middleware_method in self._view_middleware:
response = middleware_method(request, callback, callback_args, callback_kwargs)
if response:
return response
try:

response = callback(request, *callback_args, **callback_kwargs) ...

except Exception, e:
# If the view raised an exception, run it through exception
# middleware, and if the exception middleware returns a
# response, use that. Otherwise, reraise the exception.
for middleware_method in self._exception_middleware:
response = middleware_method(request, e)

▶ Local vars

Variable	Value
callback	<function api_find at 0x9c6948c>
callback_args	()
callback_kwargs	{}
debug	<module 'django.views.debug' from '/usr/lib/python2.4/site-packages/django/views/debug.pyc'>
e	<django.db.models.fields.FieldDoesNotExist instance at 0x9f827ec>
exc_info	(<class django.db.models.fields.FieldDoesNotExist at 0xb79adc2c>, <django.db.models.fields.FieldDoesNotExist instance at 0x9f827ec>, <traceback object at 0x9edd824>)
exceptions	<module 'django.core.exceptions' from '/usr/lib/python2.4/site-packages/django/core/exceptions.pyc'>
mail_admins	<function mail_admins at 0xb7bd356c>
middleware_method	<bound method XViewMiddleware.process_view of <django.middleware.doc.XViewMiddleware object at 0x9f82cec>>
receivers	[(<function _rollback_on_exception at 0xb7a79df4>, None)]
request	<ModPythonRequest path:/django/api/find/, GET:<QueryDict: {}>, POST:<QueryDict: {u'search': [u'gendertest'], u'type': [u'all']}>, COOKIES:{}, META:{'AUTH_TYPE': None, 'CONTENT_LENGTH': 0L, 'CONTENT_TYPE': None, 'GATEWAY_INTERFACE': 'CGI/1.1', 'HTTP_ACCEPT': '/', 'HTTP_AUTHORIZATION': 'Basic YWRtaW46YWRtaW4=', 'HTTP_CONTENT_LENGTH': '26', 'HTTP_CONTENT_TYPE': 'application/x-www-form-urlencoded', 'HTTP_HOST': 'www.theclustr.com', 'HTTP_USER_AGENT': 'curl/7.15.5 (x86_64-pc-linux-gnu) libcurl/7.15.5 OpenSSL/0.9.8c zlib/1.2.3 libidn/0.6.5', 'PATH_INFO': '/api/find/', 'PATH_TRANSLATED': None, 'QUERY_STRING': None, 'REMOTE_ADDR': '208.78.103.245', 'REMOTE_HOST': None, 'REMOTE_IDENT': None, 'REMOTE_USER': None, 'REQUEST_METHOD': 'POST', 'SCRIPT_NAME': None, 'SERVER_NAME': 'web1.theclustr.com', 'SERVER_PORT': 0, 'SERVER_PROTOCOL': 'HTTP/1.1', 'SERVER_SOFTWARE': 'mod_python'}>
resolver	<RegexURLResolver mtvskate.urls ^/>
response	None
self	<django.core.handlers.modpython.ModPythonHandler object at 0x9db6b0c>
settings	<django.conf.LazySettings object at 0xb7b9b7cc>
urlconf	'mtvskate.urls'
urlresolvers	<module 'django.core.urlresolvers' from '/usr/lib/python2.4/site-packages/django/core/urlresolvers.pyc'>

/var/www.theclustr.com/django/mtvskate/views.py in api_find

mimetype='application/xml')
def api_find(request):
if request.method != 'POST':
raise Http404
p = request.POST

content_type = p.get('type', '') ...

if content_type == 'all':
count, queryset = _find_multiple(p)
elif content_type in QUERY_TO_MODEL.keys():
count, queryset = _find(QUERY_TO_MODEL[content_type], p)
else:
return render_to_response(

▶ Local vars

Variable	Value
content_type	u'all'
p	<QueryDict: {u'search': [u'gendertest'], u'type': [u'all']}>
request	<ModPythonRequest path:/django/api/find/, GET:<QueryDict: {}>, POST:<QueryDict: {u'search': [u'gendertest'], u'type': [u'all']}>, COOKIES:{}, META:{'AUTH_TYPE': None, 'CONTENT_LENGTH': 0L, 'CONTENT_TYPE': None, 'GATEWAY_INTERFACE': 'CGI/1.1', 'HTTP_ACCEPT': '/', 'HTTP_AUTHORIZATION': 'Basic YWRtaW46YWRtaW4=', 'HTTP_CONTENT_LENGTH': '26', 'HTTP_CONTENT_TYPE': 'application/x-www-form-urlencoded', 'HTTP_HOST': 'www.theclustr.com', 'HTTP_USER_AGENT': 'curl/7.15.5 (x86_64-pc-linux-gnu) libcurl/7.15.5 OpenSSL/0.9.8c zlib/1.2.3 libidn/0.6.5', 'PATH_INFO': '/api/find/', 'PATH_TRANSLATED': None, 'QUERY_STRING': None, 'REMOTE_ADDR': '208.78.103.245', 'REMOTE_HOST': None, 'REMOTE_IDENT': None, 'REMOTE_USER': None, 'REQUEST_METHOD': 'POST', 'SCRIPT_NAME': None, 'SERVER_NAME': 'web1.theclustr.com', 'SERVER_PORT': 0, 'SERVER_PROTOCOL': 'HTTP/1.1', 'SERVER_SOFTWARE': 'mod_python'}>

/var/www.theclustr.com/django/mtvskate/views.py in _find_multiple

cached_obj = cache.get(cache_key)
if cached_obj:
return cached_obj
else:
limit = p.get('limit', None)
offset = p.get('offset', 0)

p['offset'] = 0 ...

p['limit'] = 9999999
c1, q1 = _find(Video, p)
c2, q2 = _find(Spot, p)
c3, q3 = _find(Shop, p)
result = [y for x in map(None,q1,q2,q3) for y in x if y]

▶ Local vars

Variable	Value
cache_key	'095d762ab182116dc17c3bb5b5f02ebf'
cached_obj	None
limit	None
offset	0
p	<QueryDict: {u'limit': [9999999], u'search': [u'gendertest'], u'type': [u'all'], u'offset': [0]}>

/var/www.theclustr.com/django/mtvskate/views.py in _find

return HttpResponse(
serializers.serialize('mtvskate_xml', content, indent=1),
mimetype='application/xml')
def _find(klass, p):

search = p.get('search', None) ...

if search:
queryset = klass.objects.search(search)
else:
queryset = klass.objects.all()
if klass != UserProfile:

▶ Local vars

Variable	Value
klass	<class 'mtvskate.models.Video'>
p	<QueryDict: {u'limit': [9999999], u'search': [u'gendertest'], u'type': [u'all'], u'offset': [0]}>
search	u'gendertest'

/var/www.theclustr.com/django/mtvskate/../mtvskate/search.py in search

super(SearchManager, self).__init__(*a, **kw)
def get_query_set(self):
return SearchQuerySet(self.model, self._search_fields)
def search(self, query):

return self.get_query_set().search(query) ...

▶ Local vars

Variable	Value
query	u'gendertest'
self	<mtvskate.search.SearchManager object at 0x9b87ecc>

/var/www.theclustr.com/django/mtvskate/../mtvskate/search.py in search

def search(self, query):
meta = self.model._meta
# Get the table name and column names from the model
# in `table_name`.`column_name` style
columns = [meta.get_field(name,

many_to_many=False).column ...

for name in self._search_fields]
full_names = ["%s.%s" %
(connection.ops.quote_name(meta.db_table),
connection.ops.quote_name(column))
for column in columns]

▶ Local vars

Variable	Value
_[1]	[]
meta	<Options for Video>
name	'title'
query	u'gendertest'
self	[<Video: Gummy Bear>, <Video: Ladera Longboards>]

/usr/lib/python2.4/site-packages/django/db/models/options.py in get_field

"""
Returns the requested field by name. Raises FieldDoesNotExist on error.
"""
to_search = many_to_many and (self.fields + self.many_to_many) or self.fields
for f in to_search:
if f.name == name:
return f

raise FieldDoesNotExist, '%s has no field named %r' % (self.object_name, name) ...

def get_field_by_name(self, name):
"""
Returns the (field_object, model, direct, m2m), where field_object is
the Field instance for the given name, model is the model containing
this field (None for local fields), direct is True if the field exists

▶ Local vars

Variable	Value
f	<django.db.models.fields.IntegerField object at 0x9b8c7cc>
many_to_many	False
name	'title'
self	<Options for Video>
to_search	[<django.db.models.fields.AutoField object at 0x9b8c78c>, <django.db.models.fields.CharField object at 0x9b8454c>, <django.db.models.fields.CharField object at 0x9b8446c>, <django.db.models.fields.CharField object at 0x9b8456c>, <django.db.models.fields.BooleanField object at 0x9b845cc>, <django.db.models.fields.DateTimeField object at 0x9b8464c>, <django.db.models.fields.IntegerField object at 0x9b846ac>, <django.db.models.fields.BooleanField object at 0x9b8470c>, <django.db.models.fields.PositiveIntegerField object at 0x9b8476c>, <django.db.models.fields.CharField object at 0x9b847cc>, <django.db.models.fields.TextField object at 0x9b8482c>, <django.db.models.fields.CharField object at 0x9b8488c>, <django.db.models.fields.CharField object at 0x9b848ec>, <django.db.models.fields.BooleanField object at 0x9b8494c>, <django.db.models.fields.IntegerField object at 0x9b849ac>, <django.db.models.fields.BooleanField object at 0x9b84a0c>, <django.db.models.fields.CharField object at 0x9b84eec>, <django.db.models.fields.USStateField object at 0x9b87ccc>, <django.db.models.fields.related.ForeignKey object at 0x9b87d2c>, <django.db.models.fields.related.ForeignKey object at 0x9b87d4c>, <django.db.models.fields.PositiveIntegerField object at 0x9b8c0cc>, <django.db.models.fields.IntegerField object at 0x9b8c7cc>]

Environment:

Request Method: POST
Request URL: http://www.theclustr.com/django/api/find/
Django Version: 0.97-pre-SVN-unknown
Python Version: 2.4.3
Installed Applications:
['django.contrib.auth',
 'django.contrib.humanize',
 'django.contrib.admin',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.sites',
 'registration',
 'djangoratings',
 'threadedcomments',
 'mtvskate']
Installed Middleware:
('django.middleware.common.CommonMiddleware',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'django.middleware.doc.XViewMiddleware')

Traceback:
File "/usr/lib/python2.4/site-packages/django/core/handlers/base.py" in get_response
  82.                 response = callback(request, *callback_args, **callback_kwargs)
File "/var/www.theclustr.com/django/mtvskate/views.py" in api_find
  209.     content_type = p.get('type', '')
File "/var/www.theclustr.com/django/mtvskate/views.py" in _find_multiple
  380.         p['offset'] = 0
File "/var/www.theclustr.com/django/mtvskate/views.py" in _find
  302.     search = p.get('search', None)
File "/var/www.theclustr.com/django/mtvskate/../mtvskate/search.py" in search
  49.         return self.get_query_set().search(query)
File "/var/www.theclustr.com/django/mtvskate/../mtvskate/search.py" in search
  20.                                   many_to_many=False).column
File "/usr/lib/python2.4/site-packages/django/db/models/options.py" in get_field
  236.         raise FieldDoesNotExist, '%s has no field named %r' % (self.object_name, name)

Exception Type: FieldDoesNotExist at /django/api/find/
Exception Value: Video has no field named 'title'

Request information

GET

No GET data

POST

Variable	Value
search	u'gendertest'
type	u'all'

No cookie data

Variable	Value
AUTH_TYPE	None
CONTENT_LENGTH	0L
CONTENT_TYPE	None
GATEWAY_INTERFACE	'CGI/1.1'
HTTP_ACCEPT	'/'
HTTP_AUTHORIZATION	'Basic YWRtaW46YWRtaW4='
HTTP_CONTENT_LENGTH	'26'
HTTP_CONTENT_TYPE	'application/x-www-form-urlencoded'
HTTP_HOST	'www.theclustr.com'
HTTP_USER_AGENT	'curl/7.15.5 (x86_64-pc-linux-gnu) libcurl/7.15.5 OpenSSL/0.9.8c zlib/1.2.3 libidn/0.6.5'
PATH_INFO	'/api/find/'
PATH_TRANSLATED	None
QUERY_STRING	None
REMOTE_ADDR	'208.78.103.245'
REMOTE_HOST	None
REMOTE_IDENT	None
REMOTE_USER	None
REQUEST_METHOD	'POST'
SCRIPT_NAME	None
SERVER_NAME	'web1.theclustr.com'
SERVER_PORT	0
SERVER_PROTOCOL	'HTTP/1.1'
SERVER_SOFTWARE	'mod_python'

Settings

Using settings module `mtvskate.settings`

Setting	Value
ABSOLUTE_URL_OVERRIDES	{}
ACCOUNT_ACTIVATION_DAYS	30
ADMINS	(('Daniel', 'daniel@localhost'),)
ADMIN_FOR	()
ADMIN_MEDIA_PREFIX	'/admin-media/'
ALLOWED_INCLUDE_ROOTS	()
APPEND_SLASH	True
AUTHENTICATION_BACKENDS	('django.contrib.auth.backends.ModelBackend',)
AUTH_PROFILE_MODULE	'mtvskate.UserProfile'
BANNED_IPS	()
CACHE_BACKEND	'dummy://'
CACHE_MIDDLEWARE_KEY_PREFIX	''
CACHE_MIDDLEWARE_SECONDS	600
COMMENTS_ALLOW_PROFANITIES	False
COMMENTS_BANNED_USERS_GROUP	None
COMMENTS_FIRST_FEW	0
COMMENTS_MODERATORS_GROUP	None
COMMENTS_SKETCHY_USERS_GROUP	None
DATABASE_ENGINE	'mysql'
DATABASE_HOST	'192.168.100.134'
DATABASE_NAME	'theclustr'
DATABASE_OPTIONS	{}
DATABASE_PASSWORD	'********************'
DATABASE_PORT	''
DATABASE_USER	'cbrant'
DATETIME_FORMAT	'N j, Y, P'
DATE_FORMAT	'N j, Y'
DEBUG	True
DEBUG_PROPAGATE_EXCEPTIONS	False
DEFAULT_CHARSET	'utf-8'
DEFAULT_CONTENT_TYPE	'text/html'
DEFAULT_FROM_EMAIL	'webmaster@localhost'
DEFAULT_INDEX_TABLESPACE	''
DEFAULT_TABLESPACE	''
DISALLOWED_USER_AGENTS	()
EMAIL_HOST	'localhost'
EMAIL_HOST_PASSWORD	'********************'
EMAIL_HOST_USER	''
EMAIL_PORT	25
EMAIL_SUBJECT_PREFIX	'[Django] '
EMAIL_USE_TLS	False
FILE_CHARSET	'utf-8'
FIXTURE_DIRS	()
GITHOME	'/var/www.theclustr.com/django/'
IGNORABLE_404_ENDS	('mail.pl', 'mailform.pl', 'mail.cgi', 'mailform.cgi', 'favicon.ico', '.php')
IGNORABLE_404_STARTS	('/cgi-bin/', '/_vti_bin', '/_vti_inf')
INSTALLED_APPS	['django.contrib.auth', 'django.contrib.humanize', 'django.contrib.admin', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.sites', 'registration', 'djangoratings', 'threadedcomments', 'mtvskate']
INTERNAL_IPS	()
JING_PATH	'/usr/bin/jing'
LANGUAGES	(('ar', 'Arabic'), ('bn', 'Bengali'), ('bg', 'Bulgarian'), ('ca', 'Catalan'), ('cs', 'Czech'), ('cy', 'Welsh'), ('da', 'Danish'), ('de', 'German'), ('el', 'Greek'), ('en', 'English'), ('es', 'Spanish'), ('et', 'Estonian'), ('es-ar', 'Argentinean Spanish'), ('eu', 'Basque'), ('fa', 'Persian'), ('fi', 'Finnish'), ('fr', 'French'), ('ga', 'Irish'), ('gl', 'Galician'), ('hu', 'Hungarian'), ('he', 'Hebrew'), ('hr', 'Croatian'), ('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'), ('ka', 'Georgian'), ('ko', 'Korean'), ('km', 'Khmer'), ('kn', 'Kannada'), ('lv', 'Latvian'), ('lt', 'Lithuanian'), ('mk', 'Macedonian'), ('nl', 'Dutch'), ('no', 'Norwegian'), ('pl', 'Polish'), ('pt', 'Portugese'), ('pt-br', 'Brazilian Portuguese'), ('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'), ('sl', 'Slovenian'), ('sr', 'Serbian'), ('sv', 'Swedish'), ('ta', 'Tamil'), ('te', 'Telugu'), ('tr', 'Turkish'), ('uk', 'Ukrainian'), ('zh-cn', 'Simplified Chinese'), ('zh-tw', 'Traditional Chinese'))
LANGUAGES_BIDI	('he', 'ar', 'fa')
LANGUAGE_CODE	'en-us'
LANGUAGE_COOKIE_NAME	'django_language'
LOCALE_PATHS	()
LOGIN_REDIRECT_URL	'/accounts/profile/'
LOGIN_URL	'/accounts/login/'
LOGOUT_URL	'/accounts/logout/'
MANAGERS	(('Daniel', 'daniel@localhost'),)
MEDIA_ROOT	'/var/www.theclustr.com/django/mtvskate/media/'
MEDIA_URL	'/site_media/'
MIDDLEWARE_CLASSES	('django.middleware.common.CommonMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.middleware.doc.XViewMiddleware')
MONTH_DAY_FORMAT	'F j'
PREPEND_WWW	False
PROFANITIES_LIST	'********************'
ROOT_URLCONF	'mtvskate.urls'
SECRET_KEY	'********************'
SEND_BROKEN_LINK_EMAILS	False
SERVER_EMAIL	'root@localhost'
SESSION_COOKIE_AGE	1209600
SESSION_COOKIE_DOMAIN	None
SESSION_COOKIE_NAME	'sessionid'
SESSION_COOKIE_PATH	'/'
SESSION_COOKIE_SECURE	False
SESSION_ENGINE	'django.contrib.sessions.backends.db'
SESSION_EXPIRE_AT_BROWSER_CLOSE	False
SESSION_FILE_PATH	None
SESSION_SAVE_EVERY_REQUEST	False
SETTINGS_MODULE	'mtvskate.settings'
SITE_ID	1
TEMPLATE_CONTEXT_PROCESSORS	('django.core.context_processors.auth', 'django.core.context_processors.debug', 'django.core.context_processors.i18n', 'django.core.context_processors.media')
TEMPLATE_DEBUG	True
TEMPLATE_DIRS	('/var/www.theclustr.com/django/templates/',)
TEMPLATE_LOADERS	('django.template.loaders.filesystem.load_template_source', 'django.template.loaders.app_directories.load_template_source')
TEMPLATE_STRING_IF_INVALID	''
TEST_DATABASE_CHARSET	None
TEST_DATABASE_COLLATION	None
TEST_DATABASE_NAME	None
TEST_RUNNER	'django.test.simple.run_tests'
TIME_FORMAT	'P'
TIME_ZONE	'America/LosAngeles'
TRANSACTIONS_MANAGED	False
URL_SUBDIRECTORY	'django'
URL_VALIDATOR_USER_AGENT	u'Django/0.97-pre-SVN-unknown (http://www.djangoproject.com)'
USE_ETAGS	False
USE_I18N	True
YEAR_MONTH_FORMAT	'F Y'

FieldDoesNotExist at /django/api/find/

Video has no field named 'title'

Traceback Switch to copy-and-paste view

Request information

GET

POST

COOKIES

META

Settings

Using settings module mtvskate.settings

Using settings module `mtvskate.settings`