search

ASKBOT / askbot-devel

Askbot is a Django/Python Q&A forum. **Contributors README**: https://github.com/ASKBOT/askbot-devel#how-to-contribute. Commercial hosting of Askbot and support are available at https://askbot.com
Other
1.56k stars 628 forks source link

search causes server error #453

Closed nilesjohnson closed 9 years ago

nilesjohnson commented 9 years ago

We're using askbot at commit 0e09080 on http://ask.sagemath.org

When I try a search in the search box, I get the 501 internal server error. Debug output below. Is this an askbot bug, or some problem with our setup?


DatabaseError at /testing/questions/scope:all/sort:activity-desc/page:1/query:tachyon/
invalid reference to FROM-clause entry for table "askbot_thread"
LINE 1: ...d" = false  AND U1."post_type" = 'question'  AND (askbot_thr...
                                                             ^
HINT:  Perhaps you meant to reference the table alias "u0".
Request Method: GET
Request URL:    http://ask.sagemath.org/testing/questions/scope:all/sort:activity-desc/page:1/query:tachyon/
Django Version: 1.5.12
Exception Type: DatabaseError
Exception Value:    
invalid reference to FROM-clause entry for table "askbot_thread"
LINE 1: ...d" = false  AND U1."post_type" = 'question'  AND (askbot_thr...
                                                             ^
HINT:  Perhaps you meant to reference the table alias "u0".
Exception Location: /usr/local/lib/python2.7/dist-packages/Django-1.5.12-py2.7.egg/django/db/backends/postgresql_psycopg2/base.py in execute, line 54
Python Executable:  /usr/bin/python
Python Version: 2.7.6
Python Path:    
['/home/asa/test-asksage',
 '/usr/local/lib/python2.7/dist-packages/South-1.0.2-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/Coffin-0.3.8-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/lamson-1.3.4-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/Django-1.5.12-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/django_keyedcache-1.5.1-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/django_celery-3.1.16-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/oauth2-1.5.211-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/Unidecode-0.04.17-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/markdown2-2.3.0-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/django_threaded_multihost-1.4_1-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/Jinja2-2.7.3-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/pytz-2013b-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/django_compressor-1.2-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/django_robots-1.0-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/django_picklefield-0.3.0-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/python_openid-2.2.5-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/akismet-0.2.0-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/django_countries-1.0.5-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/django_kombu-0.9.4-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/django_tinymce-1.5.1b2-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/html5lib-0.90-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/django_recaptcha_works-0.3.4-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/longerusername-0.4-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/sanction-0.3.1-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/pystache-0.3.1-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/beautifulsoup4-4.3.2-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/python_modargs-1.7-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/python_daemon-2.0.5-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/nose-1.3.4-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/celery-3.1.17-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/httplib2-0.9-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/MarkupSafe-0.23-py2.7-linux-x86_64.egg',
 '/usr/local/lib/python2.7/dist-packages/django_appconf-1.0.1-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/lockfile-0.10.2-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/docutils-0.12-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/kombu-3.0.24-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/billiard-3.3.0.19-py2.7-linux-x86_64.egg',
 '/usr/local/lib/python2.7/dist-packages/amqp-1.4.6-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/anyjson-0.3.3-py2.7.egg',
 '/opt/asksage',
 '/usr/local/lib/python2.7/dist-packages/django_avatar-2.0-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/PyJWT-1.0.0-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/django_followit-0.0.7-py2.7.egg',
 '/usr/local/lib/python2.7/dist-packages/Pillow-2.7.0-py2.7-linux-x86_64.egg',
 '/usr/lib/python2.7',
 '/usr/lib/python2.7/plat-x86_64-linux-gnu',
 '/usr/lib/python2.7/lib-tk',
 '/usr/lib/python2.7/lib-old',
 '/usr/lib/python2.7/lib-dynload',
 '/usr/local/lib/python2.7/dist-packages',
 '/usr/lib/python2.7/dist-packages',
 '/home/asa/test-asksage/askbot/deps']
Server time:    Sat, 25 Apr 2015 05:10:03 -0500
Traceback Switch to copy-and-paste view

/usr/local/lib/python2.7/dist-packages/Django-1.5.12-py2.7.egg/django/core/handlers/base.py in get_response
                        response = callback(request, *callback_args, **callback_kwargs) ...
▼ Local vars
Variable    Value
e   
DatabaseError('invalid reference to FROM-clause entry for table "askbot_thread"\nLINE 1: ...d" = false  AND U1."post_type" = \'question\'  AND (askbot_thr...\n                                                             ^\nHINT:  Perhaps you meant to reference the table alias "u0".\n',)
callback_args   
()
resolver_match  
ResolverMatch(func=<function questions at 0x7f8435b71b90>, args=(), kwargs={'sort': u'activity-desc', 'tags': None, 'query': u'tachyon', 'author': None, 'scope': u'all', 'page_size': None, 'page': u'1'}, url_name='questions', app_name='None', namespace='')
middleware_method   
<bound method TransactionMiddleware.process_exception of <django.middleware.transaction.TransactionMiddleware object at 0x7f84362afe90>>
self    
<django.core.handlers.wsgi.WSGIHandler object at 0x7f843874d450>
request 
"<WSGIRequest\npath:/testing/questions/scope:all/sort:activity-desc/page:1/query:tachyon/,\nGET:<QueryDict: {}>,\nPOST:<QueryDict: {}>,\nCOOKIES:{'__utma': '89097227.1682048916.1428972274.1429821064.1429955574.9',\n '__utmb': '89097227.9.10.1429955574',\n '__utmc': '89097227',\n '__utmt': '1',\n '__utmz': '89097227.1428972274.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)',\n 'askbot_visitor': 'False',\n 'asksage_csrf': '1OKPA3IusUedvBNpMcrB0CklwYjwxbuI',\n 'sessionid': 'u54jjfcagis83zhgy4m7h3h0cy44604m'},\nMETA:{'CELERY_LOADER': 'djcelery.loaders.DjangoLoader',\n 'CONTENT_LENGTH': '',\n 'CONTENT_TYPE': 'text/plain',\n 'DJANGO_SETTINGS_MODULE': 'test-asksage.settings',\n 'GATEWAY_INTERFACE': 'CGI/1.1',\n 'HOME': '/home/asa',\n 'HTTP_ACCEPT': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8',\n 'HTTP_ACCEPT_ENCODING': 'gzip, deflate, sdch',\n 'HTTP_ACCEPT_LANGUAGE': 'en-US,en;q=0.8',\n 'HTTP_CONNECTION': 'keep-alive',\n 'HTTP_COOKIE': '__utma=138969649.469254427.1429043952.1429043952.1429049605.2; __utmz=138969649.1429043952.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); askbot_visitor=False; asksage_csrf=1OKPA3IusUedvBNpMcrB0CklwYjwxbuI; __utmt=1; __utma=89097227.1682048916.1428972274.1429821064.1429955574.9; __utmb=89097227.9.10.1429955574; __utmc=89097227; __utmz=89097227.1428972274.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); sessionid=u54jjfcagis83zhgy4m7h3h0cy44604m',\n 'HTTP_HOST': 'ask.sagemath.org',\n 'HTTP_USER_AGENT': 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/41.0.2272.76 Chrome/41.0.2272.76 Safari/537.36',\n 'LANG': 'en_US.UTF-8',\n 'LOGNAME': 'root',\n 'LS_COLORS': 'rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.bz=01;31:*.tbz=01;31:*.tbz2=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.war=01;31:*.ear=01;31:*.sar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.webm=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=00;36:*.au=00;36:*.flac=00;36:*.mid=00;36:*.midi=00;36:*.mka=00;36:*.mp3=00;36:*.mpc=00;36:*.ogg=00;36:*.ra=00;36:*.wav=00;36:*.axa=00;36:*.oga=00;36:*.spx=00;36:*.xspf=00;36:',\n 'MAIL': '/var/mail/root',\n 'PATH': '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin',\n 'PATH_INFO': u'/testing/questions/scope:all/sort:activity-desc/page:1/query:tachyon/',\n 'QUERY_STRING': '',\n 'REMOTE_ADDR': '74.140.110.179',\n 'REMOTE_HOST': '',\n 'REQUEST_METHOD': 'GET',\n 'RUN_MAIN': 'true',\n 'SCRIPT_NAME': u'',\n 'SERVER_NAME': 'ask-sagemath.asc.ohio-state.edu',\n 'SERVER_PORT': '80',\n 'SERVER_PROTOCOL': 'HTTP/1.1',\n 'SERVER_SOFTWARE': 'WSGIServer/0.1 Python/2.7.6',\n 'SHELL': '/bin/bash',\n 'SUDO_COMMAND': '/usr/bin/python manage.py runserver 140.254.118.68:80',\n 'SUDO_GID': '1002',\n 'SUDO_UID': '1002',\n 'SUDO_USER': 'asa',\n 'TERM': 'screen',\n 'TZ': 'America/Chicago',\n 'USER': 'root',\n 'USERNAME': 'root',\n 'wsgi.errors': <open file '<stderr>', mode 'w' at 0x7f8440a501e0>,\n 'wsgi.file_wrapper': <class wsgiref.util.FileWrapper at 0x7f843cfc4328>,\n 'wsgi.input': <socket._fileobject object at 0x7f84362e5050>,\n 'wsgi.multiprocess': False,\n 'wsgi.multithread': True,\n 'wsgi.run_once': False,\n 'wsgi.url_scheme': 'http',\n 'wsgi.version': (1, 0)}>"
callback    
<function questions at 0x7f8435b71b90>
resolver    
<RegexURLResolver 'test-asksage.urls' (None:None) ^/>
callback_kwargs 
{'author': None,
 'page': u'1',
 'page_size': None,
 'query': u'tachyon',
 'scope': u'all',
 'sort': u'activity-desc',
 'tags': None}
response    
None
urlconf 
'test-asksage.urls'
/home/asa/test-asksage/askbot/views/readers.py in questions
                        ignored_tag_names=meta_data.get('ignored_tag_names',[]) ...
▼ Local vars
Variable    Value
paginator   
<django.core.paginator.Paginator object at 0x7f8434183d90>
qs  
[<Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83: Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83 object>, <Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83: Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83 object>, <Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83: Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83 object>, <Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83: Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83 object>, <Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83: Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83 object>, <Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83: Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83 object>, <Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83: Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83 object>, <Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83: Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83 object>, <Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83: Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83 object>, <Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83: Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83 object>, <Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83: Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83 object>, <Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83: Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83 object>, <Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83: Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83 object>, <Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83: Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83 object>, <Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83: Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83 object>, <Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83: Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83 object>, <Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83: Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83 object>, <Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83: Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83 object>, <Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83: Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83 object>, <Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83: Thread_Deferred_added_at_approved_close_reason_c656d2f48417116a7c4d98ca1a7051f83 object>, '...(remaining elements truncated)...']
request 
"<WSGIRequest\npath:/testing/questions/scope:all/sort:activity-desc/page:1/query:tachyon/,\nGET:<QueryDict: {}>,\nPOST:<QueryDict: {}>,\nCOOKIES:{'__utma': '89097227.1682048916.1428972274.1429821064.1429955574.9',\n '__utmb': '89097227.9.10.1429955574',\n '__utmc': '89097227',\n '__utmt': '1',\n '__utmz': '89097227.1428972274.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)',\n 'askbot_visitor': 'False',\n 'asksage_csrf': '1OKPA3IusUedvBNpMcrB0CklwYjwxbuI',\n 'sessionid': 'u54jjfcagis83zhgy4m7h3h0cy44604m'},\nMETA:{'CELERY_LOADER': 'djcelery.loaders.DjangoLoader',\n 'CONTENT_LENGTH': '',\n 'CONTENT_TYPE': 'text/plain',\n 'DJANGO_SETTINGS_MODULE': 'test-asksage.settings',\n 'GATEWAY_INTERFACE': 'CGI/1.1',\n 'HOME': '/home/asa',\n 'HTTP_ACCEPT': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8',\n 'HTTP_ACCEPT_ENCODING': 'gzip, deflate, sdch',\n 'HTTP_ACCEPT_LANGUAGE': 'en-US,en;q=0.8',\n 'HTTP_CONNECTION': 'keep-alive',\n 'HTTP_COOKIE': '__utma=138969649.469254427.1429043952.1429043952.1429049605.2; __utmz=138969649.1429043952.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); askbot_visitor=False; asksage_csrf=1OKPA3IusUedvBNpMcrB0CklwYjwxbuI; __utmt=1; __utma=89097227.1682048916.1428972274.1429821064.1429955574.9; __utmb=89097227.9.10.1429955574; __utmc=89097227; __utmz=89097227.1428972274.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); sessionid=u54jjfcagis83zhgy4m7h3h0cy44604m',\n 'HTTP_HOST': 'ask.sagemath.org',\n 'HTTP_USER_AGENT': 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/41.0.2272.76 Chrome/41.0.2272.76 Safari/537.36',\n 'LANG': 'en_US.UTF-8',\n 'LOGNAME': 'root',\n 'LS_COLORS': 'rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.bz=01;31:*.tbz=01;31:*.tbz2=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.war=01;31:*.ear=01;31:*.sar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.webm=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=00;36:*.au=00;36:*.flac=00;36:*.mid=00;36:*.midi=00;36:*.mka=00;36:*.mp3=00;36:*.mpc=00;36:*.ogg=00;36:*.ra=00;36:*.wav=00;36:*.axa=00;36:*.oga=00;36:*.spx=00;36:*.xspf=00;36:',\n 'MAIL': '/var/mail/root',\n 'PATH': '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin',\n 'PATH_INFO': u'/testing/questions/scope:all/sort:activity-desc/page:1/query:tachyon/',\n 'QUERY_STRING': '',\n 'REMOTE_ADDR': '74.140.110.179',\n 'REMOTE_HOST': '',\n 'REQUEST_METHOD': 'GET',\n 'RUN_MAIN': 'true',\n 'SCRIPT_NAME': u'',\n 'SERVER_NAME': 'ask-sagemath.asc.ohio-state.edu',\n 'SERVER_PORT': '80',\n 'SERVER_PROTOCOL': 'HTTP/1.1',\n 'SERVER_SOFTWARE': 'WSGIServer/0.1 Python/2.7.6',\n 'SHELL': '/bin/bash',\n 'SUDO_COMMAND': '/usr/bin/python manage.py runserver 140.254.118.68:80',\n 'SUDO_GID': '1002',\n 'SUDO_UID': '1002',\n 'SUDO_USER': 'asa',\n 'TERM': 'screen',\n 'TZ': 'America/Chicago',\n 'USER': 'root',\n 'USERNAME': 'root',\n 'wsgi.errors': <open file '<stderr>', mode 'w' at 0x7f8440a501e0>,\n 'wsgi.file_wrapper': <class wsgiref.util.FileWrapper at 0x7f843cfc4328>,\n 'wsgi.input': <socket._fileobject object at 0x7f84362e5050>,\n 'wsgi.multiprocess': False,\n 'wsgi.multithread': True,\n 'wsgi.run_once': False,\n 'wsgi.url_scheme': 'http',\n 'wsgi.version': (1, 0)}>"
search_state    
<askbot.search.state_manager.SearchState object at 0x7f8434296590>
meta_data   
{'non_existing_tags': []}
kwargs  
{'author': None,
 'page': u'1',
 'page_size': None,
 'query': u'tachyon',
 'scope': u'all',
 'sort': u'activity-desc',
 'tags': None}
page    
<Page 1 of 2>
/home/asa/test-asksage/askbot/models/tag.py in get_related_to_search
        return list(tags[:50]) ...
▼ Local vars
Variable    Value
self    
[<Tag: notebook>, <Tag: plot>, <Tag: sage>, <Tag: symbolic>, <Tag: matrix>, <Tag: solve>, <Tag: spam>, <Tag: function>, <Tag: polynomial>, <Tag: python>, <Tag: latex>, <Tag: algebra>, <Tag: graph>, <Tag: equation>, <Tag: install>, <Tag: numerical>, <Tag: cython>, <Tag: graphics>, <Tag: cloud.sagemath>, <Tag: confirmed_bug>, '...(remaining elements truncated)...']
tags    
Error in formatting: invalid reference to FROM-clause entry for table "askbot_thread"
LINE 1: ...d" = false  AND U1."post_type" = 'question'  AND (askbot_thr...
                                                             ^
HINT:  Perhaps you meant to reference the table alias "u0".
threads 
Error in formatting: current transaction is aborted, commands ignored until end of transaction block
ignored_tag_names   
[]
/usr/local/lib/python2.7/dist-packages/Django-1.5.12-py2.7.egg/django/db/models/query.py in __len__
            self._result_cache.extend(self._iter) ...
▼ Local vars
Variable    Value
self    
[]
/usr/local/lib/python2.7/dist-packages/Django-1.5.12-py2.7.egg/django/db/models/query.py in iterator
        for row in compiler.results_iter(): ...
▼ Local vars
Variable    Value
requested   
None
fill_cache  
False
aggregate_select    
['local_used_count']
skip    
None
self    
[]
load_fields 
[]
db  
'default'
index_start 
0
extra_select    
[]
fields  
[<django.db.models.fields.AutoField: id>,
 <django.db.models.fields.CharField: name>,
 <django.db.models.fields.related.ForeignKey: created_by>,
 <django.db.models.fields.CharField: language_code>,
 <django.db.models.fields.SmallIntegerField: status>,
 <django.db.models.fields.PositiveIntegerField: used_count>,
 <django.db.models.fields.BooleanField: deleted>,
 <django.db.models.fields.DateTimeField: deleted_at>,
 <django.db.models.fields.related.ForeignKey: deleted_by>,
 <django.db.models.fields.related.OneToOneField: tag_wiki>]
aggregate_start 
10
model   
<class 'askbot.models.tag.Tag'>
only_load   
{}
max_depth   
5
compiler    
<django.db.models.sql.compiler.SQLCompiler object at 0x7f84341aaf50>
/usr/local/lib/python2.7/dist-packages/Django-1.5.12-py2.7.egg/django/db/models/sql/compiler.py in results_iter
        for rows in self.execute_sql(MULTI): ...
▼ Local vars
Variable    Value
fields  
None
self    
<django.db.models.sql.compiler.SQLCompiler object at 0x7f84341aaf50>
has_aggregate_select    
True
resolve_columns 
False
/usr/local/lib/python2.7/dist-packages/Django-1.5.12-py2.7.egg/django/db/models/sql/compiler.py in execute_sql
        cursor.execute(sql, params) ...
▼ Local vars
Variable    Value
cursor  
<django.db.backends.util.CursorDebugWrapper object at 0x7f8434183090>
self    
<django.db.models.sql.compiler.SQLCompiler object at 0x7f84341aaf50>
params  
(False, 'question', 'english', u'tachyon', True)
result_type 
'multi'
sql 
u'SELECT "tag"."id", "tag"."name", "tag"."created_by_id", "tag"."language_code", "tag"."status", "tag"."used_count", "tag"."deleted", "tag"."deleted_at", "tag"."deleted_by_id", "tag"."tag_wiki_id", COUNT("tag"."id") AS "local_used_count" FROM "tag" INNER JOIN "askbot_thread_tags" ON ("tag"."id" = "askbot_thread_tags"."tag_id") WHERE ("askbot_thread_tags"."thread_id" IN (SELECT DISTINCT U0."id" FROM "askbot_thread" U0 INNER JOIN "askbot_post" U1 ON (U0."id" = U1."thread_id") WHERE (U1."deleted" = %s  AND U1."post_type" = %s  AND (askbot_thread.text_search_vector @@ plainto_tsquery(%s, %s)))) AND NOT ("tag"."deleted" = %s )) GROUP BY "tag"."id", "tag"."name", "tag"."created_by_id", "tag"."language_code", "tag"."status", "tag"."used_count", "tag"."deleted", "tag"."deleted_at", "tag"."deleted_by_id", "tag"."tag_wiki_id" ORDER BY "local_used_count" DESC, "tag"."name" ASC LIMIT 50'
/usr/local/lib/python2.7/dist-packages/Django-1.5.12-py2.7.egg/django/db/backends/util.py in execute
            return self.cursor.execute(sql, params) ...
▼ Local vars
Variable    Value
self    
<django.db.backends.util.CursorDebugWrapper object at 0x7f8434183090>
stop    
1429956603.061731
start   
1429956603.048935
params  
(False, 'question', 'english', u'tachyon', True)
sql 
u'SELECT "tag"."id", "tag"."name", "tag"."created_by_id", "tag"."language_code", "tag"."status", "tag"."used_count", "tag"."deleted", "tag"."deleted_at", "tag"."deleted_by_id", "tag"."tag_wiki_id", COUNT("tag"."id") AS "local_used_count" FROM "tag" INNER JOIN "askbot_thread_tags" ON ("tag"."id" = "askbot_thread_tags"."tag_id") WHERE ("askbot_thread_tags"."thread_id" IN (SELECT DISTINCT U0."id" FROM "askbot_thread" U0 INNER JOIN "askbot_post" U1 ON (U0."id" = U1."thread_id") WHERE (U1."deleted" = false  AND U1."post_type" = \'question\'  AND (askbot_thread.text_search_vector @@ plainto_tsquery(\'english\', \'tachyon\')))) AND NOT ("tag"."deleted" = true )) GROUP BY "tag"."id", "tag"."name", "tag"."created_by_id", "tag"."language_code", "tag"."status", "tag"."used_count", "tag"."deleted", "tag"."deleted_at", "tag"."deleted_by_id", "tag"."tag_wiki_id" ORDER BY "local_used_count" DESC, "tag"."name" ASC LIMIT 50'
duration    
0.012796163558959961
/usr/local/lib/python2.7/dist-packages/Django-1.5.12-py2.7.egg/django/db/backends/postgresql_psycopg2/base.py in execute
            six.reraise(utils.DatabaseError, utils.DatabaseError(*tuple(e.args)), sys.exc_info()[2]) ...
▼ Local vars
Variable    Value
query   
u'SELECT "tag"."id", "tag"."name", "tag"."created_by_id", "tag"."language_code", "tag"."status", "tag"."used_count", "tag"."deleted", "tag"."deleted_at", "tag"."deleted_by_id", "tag"."tag_wiki_id", COUNT("tag"."id") AS "local_used_count" FROM "tag" INNER JOIN "askbot_thread_tags" ON ("tag"."id" = "askbot_thread_tags"."tag_id") WHERE ("askbot_thread_tags"."thread_id" IN (SELECT DISTINCT U0."id" FROM "askbot_thread" U0 INNER JOIN "askbot_post" U1 ON (U0."id" = U1."thread_id") WHERE (U1."deleted" = %s  AND U1."post_type" = %s  AND (askbot_thread.text_search_vector @@ plainto_tsquery(%s, %s)))) AND NOT ("tag"."deleted" = %s )) GROUP BY "tag"."id", "tag"."name", "tag"."created_by_id", "tag"."language_code", "tag"."status", "tag"."used_count", "tag"."deleted", "tag"."deleted_at", "tag"."deleted_by_id", "tag"."tag_wiki_id" ORDER BY "local_used_count" DESC, "tag"."name" ASC LIMIT 50'
self    
<django.db.backends.postgresql_psycopg2.base.CursorWrapper object at 0x7f84341aaf90>
args    
(False, 'question', 'english', u'tachyon', True)
e   
ProgrammingError('invalid reference to FROM-clause entry for table "askbot_thread"\nLINE 1: ...d" = false  AND U1."post_type" = \'question\'  AND (askbot_thr...\n                                                             ^\nHINT:  Perhaps you meant to reference the table alias "u0".\n',)
/usr/local/lib/python2.7/dist-packages/Django-1.5.12-py2.7.egg/django/db/backends/postgresql_psycopg2/base.py in execute
            return self.cursor.execute(query, args) ...
▼ Local vars
Variable    Value
query   
u'SELECT "tag"."id", "tag"."name", "tag"."created_by_id", "tag"."language_code", "tag"."status", "tag"."used_count", "tag"."deleted", "tag"."deleted_at", "tag"."deleted_by_id", "tag"."tag_wiki_id", COUNT("tag"."id") AS "local_used_count" FROM "tag" INNER JOIN "askbot_thread_tags" ON ("tag"."id" = "askbot_thread_tags"."tag_id") WHERE ("askbot_thread_tags"."thread_id" IN (SELECT DISTINCT U0."id" FROM "askbot_thread" U0 INNER JOIN "askbot_post" U1 ON (U0."id" = U1."thread_id") WHERE (U1."deleted" = %s  AND U1."post_type" = %s  AND (askbot_thread.text_search_vector @@ plainto_tsquery(%s, %s)))) AND NOT ("tag"."deleted" = %s )) GROUP BY "tag"."id", "tag"."name", "tag"."created_by_id", "tag"."language_code", "tag"."status", "tag"."used_count", "tag"."deleted", "tag"."deleted_at", "tag"."deleted_by_id", "tag"."tag_wiki_id" ORDER BY "local_used_count" DESC, "tag"."name" ASC LIMIT 50'
self    
<django.db.backends.postgresql_psycopg2.base.CursorWrapper object at 0x7f84341aaf90>
args    
(False, 'question', 'english', u'tachyon', True)
e   
ProgrammingError('invalid reference to FROM-clause entry for table "askbot_thread"\nLINE 1: ...d" = false  AND U1."post_type" = \'question\'  AND (askbot_thr...\n                                                             ^\nHINT:  Perhaps you meant to reference the table alias "u0".\n',)
Request information

GET
No GET data
POST
No POST data
FILES
No FILES data
COOKIES
Variable    Value
__utmz  
'89097227.1428972274.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)'
askbot_visitor  
'False'
__utmt  
'1'
sessionid   
'u54jjfcagis83zhgy4m7h3h0cy44604m'
__utma  
'89097227.1682048916.1428972274.1429821064.1429955574.9'
__utmb  
'89097227.9.10.1429955574'
__utmc  
'89097227'
asksage_csrf    
'1OKPA3IusUedvBNpMcrB0CklwYjwxbuI'
META
Variable    Value
RUN_MAIN    
'true'
SERVER_SOFTWARE 
'WSGIServer/0.1 Python/2.7.6'
SCRIPT_NAME 
u''
REQUEST_METHOD  
'GET'
SERVER_PROTOCOL 
'HTTP/1.1'
HOME    
'/home/asa'
LANG    
'en_US.UTF-8'
SHELL   
'/bin/bash'
SERVER_PORT 
'80'
USERNAME    
'root'
HTTP_HOST   
'ask.sagemath.org'
HTTP_ACCEPT 
'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8'
SUDO_GID    
'1002'
wsgi.version    
(1, 0)
wsgi.run_once   
False
wsgi.errors 
<open file '<stderr>', mode 'w' at 0x7f8440a501e0>
wsgi.multiprocess   
False
HTTP_ACCEPT_LANGUAGE    
'en-US,en;q=0.8'
MAIL    
'/var/mail/root'
LS_COLORS   
'rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.bz=01;31:*.tbz=01;31:*.tbz2=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.war=01;31:*.ear=01;31:*.sar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.webm=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=00;36:*.au=00;36:*.flac=00;36:*.mid=00;36:*.midi=00;36:*.mka=00;36:*.mp3=00;36:*.mpc=00;36:*.ogg=00;36:*.ra=00;36:*.wav=00;36:*.axa=00;36:*.oga=00;36:*.spx=00;36:*.xspf=00;36:'
PATH_INFO   
u'/testing/questions/scope:all/sort:activity-desc/page:1/query:tachyon/'
HTTP_COOKIE 
'__utma=138969649.469254427.1429043952.1429043952.1429049605.2; __utmz=138969649.1429043952.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); askbot_visitor=False; asksage_csrf=1OKPA3IusUedvBNpMcrB0CklwYjwxbuI; __utmt=1; __utma=89097227.1682048916.1428972274.1429821064.1429955574.9; __utmb=89097227.9.10.1429955574; __utmc=89097227; __utmz=89097227.1428972274.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); sessionid=u54jjfcagis83zhgy4m7h3h0cy44604m'
LOGNAME 
'root'
USER    
'root'
QUERY_STRING    
''
PATH    
'/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin'
TERM    
'screen'
HTTP_USER_AGENT 
'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/41.0.2272.76 Chrome/41.0.2272.76 Safari/537.36'
HTTP_CONNECTION 
'keep-alive'
SERVER_NAME 
'ask-sagemath.asc.ohio-state.edu'
REMOTE_ADDR 
'74.140.110.179'
wsgi.url_scheme 
'http'
SUDO_USER   
'asa'
CONTENT_LENGTH  
''
SUDO_UID    
'1002'
CELERY_LOADER   
'djcelery.loaders.DjangoLoader'
wsgi.input  
<socket._fileobject object at 0x7f84362e5050>
wsgi.multithread    
True
TZ  
'America/Chicago'
SUDO_COMMAND    
'/usr/bin/python manage.py runserver 140.254.118.68:80'
GATEWAY_INTERFACE   
'CGI/1.1'
DJANGO_SETTINGS_MODULE  
'test-asksage.settings'
CONTENT_TYPE    
'text/plain'
wsgi.file_wrapper   
''
REMOTE_HOST 
''
HTTP_ACCEPT_ENCODING    
'gzip, deflate, sdch'
Settings
Using settings module test-asksage.settings
Setting Value
COMPRESS_URL    
'/m/'
IMAP_PORT   
''
COMPRESS_OUTPUT_DIR 
'CACHE'
COMPRESS_TEMPLATE_FILTER_CONTEXT    
{'MEDIA_URL': '/upfiles/', 'STATIC_URL': '/m/'}
ENABLE_HAYSTACK_SEARCH  
False
TINYMCE_JS_ROOT 
'/home/asa/test-asksage/../test-asksage/static/default/media/js/tinymce/'
COMPRESS_DATA_URI_MAX_SIZE  
1024
ASKBOT_MAX_UPLOAD_FILE_SIZE 
1048576
LANGUAGE_CODE   
'en'
ROOT_URLCONF    
'test-asksage.urls'
MANAGERS    
(('Niles Johnson', 'nilesj@gmail.com'),)
COMPRESS_CSS_HASHING_METHOD 
'mtime'
IMAP_HOST_USER  
''
ASKBOT_ALLOWED_UPLOAD_FILE_TYPES    
('.jpg', '.jpeg', '.gif', '.bmp', '.png', '.tiff')
IGNORABLE_404_URLS  
()
SESSION_SERIALIZER  
'django.contrib.sessions.serializers.PickleSerializer'
STATIC_ROOT 
'/home/asa/test-asksage/../test-asksage/static'
ASKBOT_USE_STACKEXCHANGE_URLS   
False
LOG_FILENAME    
'askbot.log'
USE_THOUSAND_SEPARATOR  
False
ASKBOT_CSS_DEVEL    
False
COMPRESS_OFFLINE_MANIFEST   
'manifest.json'
CACHE_MIDDLEWARE_ANONYMOUS_ONLY 
True
ALLOWED_HOSTS   
['*']
MESSAGE_STORAGE 
'django.contrib.messages.storage.fallback.FallbackStorage'
COMPRESS_YUI_JS_ARGUMENTS   
''
SEND_BROKEN_LINK_EMAILS 
False
STATICFILES_FINDERS 
('django.contrib.staticfiles.finders.FileSystemFinder',
 'django.contrib.staticfiles.finders.AppDirectoriesFinder',
 'compressor.finders.CompressorFinder')
SESSION_CACHE_ALIAS 
'default'
COMPRESS_CSSTIDY_ARGUMENTS  
'--template=highest'
SESSION_COOKIE_DOMAIN   
None
JINJA2_EXTENSIONS   
('compressor.contrib.jinja2ext.CompressorExtension',)
ADMIN_FOR   
()
TIME_INPUT_FORMATS  
('%H:%M:%S', '%H:%M')
DATABASES   
{'default': {'ENGINE': 'django.db.backends.postgresql_psycopg2',
             'HOST': '140.254.118.69',
             'NAME': 'testaskbotdb',
             'OPTIONS': {},
             'PASSWORD': u'********************',
             'PORT': '5432',
             'TEST_CHARSET': 'utf8',
             'TEST_COLLATION': 'utf8_general_ci',
             'TEST_MIRROR': None,
             'TEST_NAME': None,
             'TIME_ZONE': 'America/Chicago',
             'USER': 'askbot'}}
TEMPLATE_DEBUG  
False
STATIC_URL  
'/m/'
COMPRESS_YUI_BINARY 
'java -jar yuicompressor.jar'
FILE_UPLOAD_PERMISSIONS 
None
FILE_UPLOAD_HANDLERS    
('django.core.files.uploadhandler.MemoryFileUploadHandler',
 'django.core.files.uploadhandler.TemporaryFileUploadHandler')
DEFAULT_CONTENT_TYPE    
'text/html'
COMPRESS_CSS_COMPRESSOR 
'compressor.css.CssCompressor'
APPEND_SLASH    
True
CSRF_COOKIE_SECURE  
False
DATABASE_ROUTERS    
[]
YEAR_MONTH_FORMAT   
'F Y'
COMPRESS_OFFLINE_TIMEOUT    
31536000
STATICFILES_STORAGE 
'django.contrib.staticfiles.storage.StaticFilesStorage'
CACHES  
{'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache',
             'KEY_PREFIX': u'********************',
             'TIMEOUT': 6000}}
SERVER_EMAIL    
'noreply@sagemath.org'
SESSION_COOKIE_PATH 
'/'
COMPRESS_PARSER 
'compressor.parser.HtmlParser'
COMPRESS_CACHE_BACKEND  
'default'
MIDDLEWARE_CLASSES  
('django.contrib.sessions.middleware.SessionMiddleware',
 'django.contrib.messages.middleware.MessageMiddleware',
 'django.middleware.cache.UpdateCacheMiddleware',
 'django.middleware.common.CommonMiddleware',
 'django.middleware.cache.FetchFromCacheMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'stopforumspam.middleware.StopForumSpamMiddleware',
 'askbot.middleware.anon_user.ConnectToSessionMessagesMiddleware',
 'askbot.middleware.forum_mode.ForumModeMiddleware',
 'askbot.middleware.cancel.CancelActionMiddleware',
 'django.middleware.transaction.TransactionMiddleware',
 'askbot.middleware.view_log.ViewLogMiddleware',
 'askbot.middleware.spaceless.SpacelessMiddleware')
USE_I18N    
True
ASKBOT_MULTILINGUAL 
False
SECRET_KEY  
u'********************'
LANGUAGE_COOKIE_NAME    
'django_language'
DEFAULT_INDEX_TABLESPACE    
''
BROKER_TRANSPORT    
'djkombu.transport.DatabaseTransport'
SFS_SOURCE_ZIP  
'/opt/stopforumspam/listed_ip_7.zip'
LOGGING_CONFIG  
'django.utils.log.dictConfig'
SIGNING_BACKEND 
'django.core.signing.TimestampSigner'
TEMPLATE_LOADERS    
('askbot.skins.loaders.Loader',
 'django.template.loaders.app_directories.Loader',
 'django.template.loaders.filesystem.Loader')
ASKBOT_ROOT 
'/home/asa/test-asksage/askbot'
FIRST_DAY_OF_WEEK   
0
WSGI_APPLICATION    
None
ALLOW_UNICODE_SLUGS 
False
AUTO_GENERATE_AVATAR_SIZES  
(48, 16, 128)
CSRF_COOKIE_NAME    
'asksage_csrf'
FORCE_SCRIPT_NAME   
None
USE_X_FORWARDED_HOST    
False
CELERY_ALWAYS_EAGER 
True
COMPRESS_CSSTIDY_BINARY 
'csstidy'
SESSION_COOKIE_SECURE   
False
TINYMCE_SPELLCHECKER    
False
COMPRESS_DEBUG_TOGGLE   
'None'
COMPRESS_VERBOSE    
False
CSRF_COOKIE_DOMAIN  
'ask.sagemath.org'
FILE_CHARSET    
'utf-8'
DEBUG   
True
IMAP_HOST_PASSWORD  
u'********************'
CACHE_TIMEOUT   
6000
HONEYPOT_FIELD_NAME 
'phonenumber'
COMPRESS_JS_FILTERS 
[]
DEFAULT_FILE_STORAGE    
'django.core.files.storage.FileSystemStorage'
INSTALLED_APPS  
('longerusername',
 'django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.sites',
 'django.contrib.staticfiles',
 'django.contrib.admin',
 'django.contrib.humanize',
 'django.contrib.sitemaps',
 'django.contrib.messages',
 'compressor',
 'askbot',
 'askbot.deps.django_authopenid',
 'south',
 'askbot.deps.livesettings',
 'keyedcache',
 'robots',
 'django_countries',
 'djcelery',
 'djkombu',
 'followit',
 'tinymce',
 'group_messaging',
 'stopforumspam',
 'honeypot')
LANGUAGES_BIDI  
('he', 'ar', 'fa')
USE_L10N    
False
COMMENTS_ALLOW_PROFANITIES  
False
COMPRESS_YUI_CSS_ARGUMENTS  
''
STATICFILES_DIRS    
(('default/media', '/home/asa/test-asksage/askbot/media'),)
PREPEND_WWW 
False
SECURE_PROXY_SSL_HEADER 
None
COMPRESS_CLOSURE_COMPILER_ARGUMENTS 
''
SESSION_COOKIE_HTTPONLY 
True
DEBUG_PROPAGATE_EXCEPTIONS  
False
ASKBOT_URL  
'testing/'
MONTH_DAY_FORMAT    
'F j'
LOGIN_URL   
'/testing/account/signin/'
SESSION_EXPIRE_AT_BROWSER_CLOSE 
False
IMAP_USE_TLS    
False
SOUTH_TESTS_MIGRATE 
False
DOMAIN_NAME 
'ask.sagemath.org'
TIME_FORMAT 
'P'
LIVESETTINGS_CACHE_TIMEOUT  
6000
COMPRESS_STORAGE    
'compressor.storage.CompressorFileStorage'
AUTH_USER_MODEL 
'auth.User'
DATE_INPUT_FORMATS  
('%Y-%m-%d',
 '%m/%d/%Y',
 '%m/%d/%y',
 '%b %d %Y',
 '%b %d, %Y',
 '%d %b %Y',
 '%d %b, %Y',
 '%B %d %Y',
 '%B %d, %Y',
 '%d %B %Y',
 '%d %B, %Y')
COMPRESS_CSS_FILTERS    
['compressor.filters.css_default.CssAbsoluteFilter']
AUTHENTICATION_BACKENDS 
('django.contrib.auth.backends.ModelBackend',
 'askbot.deps.django_authopenid.backends.AuthBackend')
EMAIL_HOST_PASSWORD 
u'********************'
COMPRESS_REBUILD_TIMEOUT    
2592000
PASSWORD_RESET_TIMEOUT_DAYS 
u'********************'
NOTIFICATION_DELAY_TIME 
900
CACHE_MIDDLEWARE_ALIAS  
'default'
SESSION_SAVE_EVERY_REQUEST  
False
ADMIN_MEDIA_PREFIX  
'/m/admin/'
NUMBER_GROUPING 
0
SHORT_DATETIME_FORMAT   
'm/d/Y P'
SESSION_COOKIE_NAME 
'sessionid'
SESSION_ENGINE  
'django.contrib.sessions.backends.cached_db'
CSRF_FAILURE_VIEW   
'django.views.csrf.csrf_failure'
CSRF_COOKIE_PATH    
'/'
COMPRESS_CACHE_KEY_FUNCTION 
u'********************'
LOGIN_REDIRECT_URL  
'testing/'
PROJECT_ROOT    
'/home/asa/test-asksage/../test-asksage'
DECIMAL_SEPARATOR   
'.'
COMPRESS_PRECOMPILERS   
(('text/less', 'lessc {infile} {outfile}'),)
COMPRESS_MTIME_DELAY    
10
SITE_ID 
1
LOCALE_PATHS    
()
TEMPLATE_STRING_IF_INVALID  
''
GROUP_MESSAGING 
{'BASE_URL_GETTER_FUNCTION': 'askbot.models.user_get_profile_url',
 'BASE_URL_PARAMS': {'section': 'messages', 'sort': 'inbox'}}
SESSION_FILE_PATH   
None
LOGOUT_URL  
'/accounts/logout/'
EMAIL_USE_TLS   
False
TEMPLATE_DIRS   
()
FIXTURE_DIRS    
()
EMAIL_HOST  
'localhost'
DATE_FORMAT 
'N j, Y'
X_FRAME_OPTIONS 
'SAMEORIGIN'
MEDIA_ROOT  
'/home/asa/test-asksage/../test-asksage/askbot/upfiles'
DEFAULT_EXCEPTION_REPORTER_FILTER   
'django.views.debug.SafeExceptionReporterFilter'
ADMINS  
(('Niles Johnson', 'nilesj@gmail.com'),)
FORMAT_MODULE_PATH  
None
DEFAULT_FROM_EMAIL  
'noreply@sagemath.org'
COMPRESS_ROOT   
'/home/asa/test-asksage/static'
THOUSAND_SEPARATOR  
','
MEDIA_URL   
'/upfiles/'
DATETIME_FORMAT 
'N j, Y, P'
EMAIL_SUBJECT_PREFIX    
'[ask.sagemath] '
COMPRESS_JS_COMPRESSOR  
'compressor.js.JsCompressor'
DISALLOWED_USER_AGENTS  
()
ALLOWED_INCLUDE_ROOTS   
()
COMPRESS_MINT_DELAY 
30
LOGGING 
{}
SHORT_DATE_FORMAT   
'm/d/Y'
IMAP_HOST   
''
TEST_RUNNER 
'django.test.simple.DjangoTestSuiteRunner'
COMPRESS_ENABLED    
False
SFS_ALL_POST_REQUESTS   
True
CACHE_MIDDLEWARE_KEY_PREFIX 
u'********************'
COMPRESS_OFFLINE    
False
TIME_ZONE   
'America/Chicago'
COMPRESS_OFFLINE_CONTEXT    
{'MEDIA_URL': '/upfiles/', 'STATIC_URL': '/m/'}
VERIFIER_EXPIRE_DAYS    
3
EMAIL_BACKEND   
'django.core.mail.backends.smtp.EmailBackend'
DEFAULT_TABLESPACE  
''
TEMPLATE_CONTEXT_PROCESSORS 
('django.core.context_processors.request',
 'askbot.context.application_settings',
 'askbot.user_messages.context_processors.user_messages',
 'django.contrib.auth.context_processors.auth',
 'django.core.context_processors.csrf',
 'askbot.deps.group_messaging.context.group_messaging_context')
SESSION_COOKIE_AGE  
1209600
SETTINGS_MODULE 
'test-asksage.settings'
USE_ETAGS   
False
TINYMCE_COMPRESSOR  
True
LANGUAGES   
(('af', 'Afrikaans'),
 ('ar', 'Arabic'),
 ('az', 'Azerbaijani'),
 ('bg', 'Bulgarian'),
 ('be', 'Belarusian'),
 ('bn', 'Bengali'),
 ('br', 'Breton'),
 ('bs', 'Bosnian'),
 ('ca', 'Catalan'),
 ('cs', 'Czech'),
 ('cy', 'Welsh'),
 ('da', 'Danish'),
 ('de', 'German'),
 ('el', 'Greek'),
 ('en', 'English'),
 ('en-gb', 'British English'),
 ('eo', 'Esperanto'),
 ('es', 'Spanish'),
 ('es-ar', 'Argentinian Spanish'),
 ('es-mx', 'Mexican Spanish'),
 ('es-ni', 'Nicaraguan Spanish'),
 ('es-ve', 'Venezuelan Spanish'),
 ('et', 'Estonian'),
 ('eu', 'Basque'),
 ('fa', 'Persian'),
 ('fi', 'Finnish'),
 ('fr', 'French'),
 ('fy-nl', 'Frisian'),
 ('ga', 'Irish'),
 ('gl', 'Galician'),
 ('he', 'Hebrew'),
 ('hi', 'Hindi'),
 ('hr', 'Croatian'),
 ('hu', 'Hungarian'),
 ('ia', 'Interlingua'),
 ('id', 'Indonesian'),
 ('is', 'Icelandic'),
 ('it', 'Italian'),
 ('ja', 'Japanese'),
 ('ka', 'Georgian'),
 ('kk', 'Kazakh'),
 ('km', 'Khmer'),
 ('kn', 'Kannada'),
 ('ko', 'Korean'),
 ('lb', 'Luxembourgish'),
 ('lt', 'Lithuanian'),
 ('lv', 'Latvian'),
 ('mk', 'Macedonian'),
 ('ml', 'Malayalam'),
 ('mn', 'Mongolian'),
 ('nb', 'Norwegian Bokmal'),
 ('ne', 'Nepali'),
 ('nl', 'Dutch'),
 ('nn', 'Norwegian Nynorsk'),
 ('pa', 'Punjabi'),
 ('pl', 'Polish'),
 ('pt', 'Portuguese'),
 ('pt-br', 'Brazilian Portuguese'),
 ('ro', 'Romanian'),
 ('ru', 'Russian'),
 ('sk', 'Slovak'),
 ('sl', 'Slovenian'),
 ('sq', 'Albanian'),
 ('sr', 'Serbian'),
 ('sr-latn', 'Serbian Latin'),
 ('sv', 'Swedish'),
 ('sw', 'Swahili'),
 ('ta', 'Tamil'),
 ('te', 'Telugu'),
 ('th', 'Thai'),
 ('tr', 'Turkish'),
 ('tt', 'Tatar'),
 ('udm', 'Udmurt'),
 ('uk', 'Ukrainian'),
 ('ur', 'Urdu'),
 ('vi', 'Vietnamese'),
 ('zh-cn', 'Simplified Chinese'),
 ('zh-tw', 'Traditional Chinese'))
COMPRESS_CLOSURE_COMPILER_BINARY    
'java -jar compiler.jar'
FILE_UPLOAD_TEMP_DIR    
'/home/asa/test-asksage/../test-asksage/tmp'
INTERNAL_IPS    
('127.0.0.1',)
DEFAULT_CHARSET 
'utf-8'
ASKBOT_TRANSLATE_URL    
True
EMAIL_PORT  
'25'
USE_TZ  
False
CACHE_PREFIX    
'asksage'
RECAPTCHA_USE_SSL   
True
PASSWORD_HASHERS    
u'********************'
FILE_UPLOAD_MAX_MEMORY_SIZE 
2621440
TINYMCE_DEFAULT_CONFIG  
{'convert_urls': False,
 'force_br_newlines': True,
 'force_p_newlines': False,
 'forced_root_block': '',
 'height': '250',
 'mode': 'textareas',
 'oninit': 'TinyMCE.onInitHook',
 'plugins': 'askbot_imageuploader,askbot_attachment',
 'theme': 'advanced',
 'theme_advanced_buttons1': 'bold,italic,underline,|,bullist,numlist,|,undo,redo,|,link,unlink,askbot_imageuploader,askbot_attachment',
 'theme_advanced_buttons2': '',
 'theme_advanced_buttons3': '',
 'theme_advanced_path': False,
 'theme_advanced_resize_horizontal': False,
 'theme_advanced_resizing': True,
 'theme_advanced_statusbar_location': 'bottom',
 'theme_advanced_toolbar_align': 'left',
 'theme_advanced_toolbar_location': 'top',
 'width': '730'}
ABSOLUTE_URL_OVERRIDES  
{}
CACHE_MIDDLEWARE_SECONDS    
600
SFS_CACHE_EXPIRE    
1
SFS_ZIP_FILENAME    
'listed_ip_7.txt'
DATETIME_INPUT_FORMATS  
('%Y-%m-%d %H:%M:%S',
 '%Y-%m-%d %H:%M:%S.%f',
 '%Y-%m-%d %H:%M',
 '%Y-%m-%d',
 '%m/%d/%Y %H:%M:%S',
 '%m/%d/%Y %H:%M:%S.%f',
 '%m/%d/%Y %H:%M',
 '%m/%d/%Y',
 '%m/%d/%y %H:%M:%S',
 '%m/%d/%y %H:%M:%S.%f',
 '%m/%d/%y %H:%M',
 '%m/%d/%y')
TRANSACTIONS_MANAGED    
False
EMAIL_HOST_USER 
''
PROFANITIES_LIST    
u'********************'
You're seeing this error because you have DEBUG = True in your Django settings file. Change that to False, and Django will display a standard 500 page.
zheli commented 9 years ago

Known issue: https://github.com/ASKBOT/askbot-devel/issues/438 You can check out the latest code.

nilesjohnson commented 9 years ago

thanks!