#3677 500 Error when trying to search Users
Closed: Fixed None Opened 11 years ago by ryanlerch.

When i try to search users, i get a 500 Error:

To recreate this, click on Users in the top Right corner
then search for something.

here is the error log:

{{{

Traceback (most recent call last):

File "/usr/lib/python2.6/site-packages/django/core/handlers/base.py", line 113, in get_response
response = callback(request, callback_args, *callback_kwargs)

File "/usr/lib/python2.6/site-packages/askbot/views/users.py", line 159, in show_users
users_page = objects_list.page(page)

File "/usr/lib/python2.6/site-packages/django/core/paginator.py", line 37, in page
number = self.validate_number(number)

File "/usr/lib/python2.6/site-packages/django/core/paginator.py", line 28, in validate_number
if number > self.num_pages:

File "/usr/lib/python2.6/site-packages/django/core/paginator.py", line 60, in _get_num_pages
if self.count == 0 and not self.allow_empty_first_page:

File "/usr/lib/python2.6/site-packages/django/core/paginator.py", line 48, in _get_count
self._count = self.object_list.count()

File "/usr/lib/python2.6/site-packages/django/db/models/query.py", line 334, in count
return self.query.get_count(using=self.db)

File "/usr/lib/python2.6/site-packages/django/db/models/sql/query.py", line 401, in get_count
number = obj.get_aggregation(using=using)[None]

File "/usr/lib/python2.6/site-packages/django/db/models/sql/query.py", line 367, in get_aggregation
result = query.get_compiler(using).execute_sql(SINGLE)

File "/usr/lib/python2.6/site-packages/django/db/models/sql/compiler.py", line 735, in execute_sql
cursor.execute(sql, params)

File "/usr/lib/python2.6/site-packages/django/db/backends/postgresql_psycopg2/base.py", line 44, in execute
return self.cursor.execute(query, args)

DatabaseError: column "language_code" does not exist
LINE 1: ...xt_search_vector @@ plainto_tsquery(E'lerch') AND language_c...
^

<WSGIRequest GET:<QueryDict: {u't': [u'user'], u'search': [u''], u'query': [u'lerch']}>,
POST:<QueryDict: {}>,
COOKIES:{'ask.fedoraproject.org': '06df8f9f9b5f89fc8cd110bc9ec91dd4',
'ask.stg.fedoraproject.org': 'fa83858b4b50906335d4270e3656e3b4',
'askbot_visitor': 'False',
'sessionid': 'e3ac06791d8a9fe6f56870b35e96e930'},
META:{'DOCUMENT_ROOT': '/var/www/html',
'GATEWAY_INTERFACE': 'CGI/1.1',
'HTTP_ACCEPT': 'text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8',
'HTTP_ACCEPT_ENCODING': 'gzip, deflate',
'HTTP_ACCEPT_LANGUAGE': 'en-US,en;q=0.5',
'HTTP_COOKIE': 'ask.stg.fedoraproject.org=fa83858b4b50906335d4270e3656e3b4; sessionid=e3ac06791d8a9fe6f56870b35e96e930; ask.fedoraproject.org=06df8f9f9b5f89fc8cd110bc9ec91dd4; askbot_visitor=False',
'HTTP_HOST': 'ask01',
'HTTP_REFERER': 'https://ask.fedoraproject.org/users/',
'HTTP_USER_AGENT': 'Mozilla/5.0 (X11; Linux x86_64; rv:18.0) Gecko/20100101 Firefox/18.0',
'HTTP_X_FORWARDED_FOR': '64.134.67.28',
'HTTP_X_FORWARDED_HOST': 'ask.fedoraproject.org',
'HTTP_X_FORWARDED_SERVER': 'ask.fedoraproject.org',
'PATH_INFO': u'/users/',
'PATH_TRANSLATED': '/usr/sbin/askbot.wsgi/users/',
'QUERY_STRING': 'search=&t=user&query=lerch',
'REMOTE_ADDR': '192.168.1.7',
'REMOTE_PORT': '32904',
'REQUEST_METHOD': 'GET',
'REQUEST_URI': '/users/?search=&t=user&query=lerch',
'SCRIPT_FILENAME': '/usr/sbin/askbot.wsgi',
'SCRIPT_NAME': u'',
'SERVER_ADDR': '192.168.1.51',
'SERVER_ADMIN': 'admin@fedoraproject.org',
'SERVER_NAME': 'ask01',
'SERVER_PORT': '80',
'SERVER_PROTOCOL': 'HTTP/1.0',
'SERVER_SIGNATURE': '<address>Apache/2.2.15 (Red Hat) Server at ask01 Port 80</address>\n',
'SERVER_SOFTWARE': 'Apache/2.2.15 (Red Hat)',
'mod_wsgi.application_group': '',
'mod_wsgi.callable_object': 'application',
'mod_wsgi.handler_script': '',
'mod_wsgi.input_chunked': '0',
'mod_wsgi.listener_host': '0.0.0.0',
'mod_wsgi.listener_port': '80',
'mod_wsgi.process_group': 'askbot',
'mod_wsgi.request_handler': 'wsgi-script',
'mod_wsgi.script_reloading': '1',
'mod_wsgi.version': (3, 2),
'wsgi.errors': <mod_wsgi.Log object at 0xb212d110>,
'wsgi.file_wrapper': <built-in method file_wrapper of mod_wsgi.Adapter object at 0xb28d1f08>,
'wsgi.input': <mod_wsgi.Input object at 0xb212df70>,
'wsgi.multiprocess': True,
'wsgi.multithread': False,
'wsgi.run_once': False,
'wsgi.url_scheme': 'http',
'wsgi.version': (1, 1)}>

}}}


I disabled the multilingual plugin which seems to have stopped the tracebacks.

We do still need the functionality. So please do report any issues upstream. You can post : ​http://askbot.org/en/questions. Tag them "askfedora" and "bug" or "enhancement" so that I can followup when necessary. Thanks!

Login to comment on this ticket.

Metadata