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)}>
}}}
It looks like a similar issue has been reported upstream: http://askbot.org/en/question/10042/database-error-when-searching/
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!
Log in to comment on this ticket.