TemplateSyntaxError at /pm/projects/my_overview/

Caught an exception while rendering: Incorrect integer value: 'AnonymousUser' for column 'member_id' at row 1

Original Traceback (most recent call last):
  File "C:\Python25\Lib\site-packages\django\template\debug.py", line 71, in render_node
    result = node.render(context)
  File "C:\Python25\lib\site-packages\django\template\defaulttags.py", line 155, in render
    nodelist.append(node.render(context))
  File "C:\Python25\Lib\site-packages\django\template\debug.py", line 87, in render
    output = force_unicode(self.filter_expression.resolve(context))
  File "C:\Python25\lib\site-packages\django\utils\encoding.py", line 71, in force_unicode
    s = unicode(s)
  File "C:\Python25\lib\site-packages\django\forms\forms.py", line 356, in __unicode__
    return self.as_widget()
  File "C:\Python25\lib\site-packages\django\forms\forms.py", line 391, in as_widget
    return widget.render(name, data, attrs=attrs)
  File "C:\Python25\lib\site-packages\django\forms\widgets.py", line 404, in render
    options = self.render_options(choices, [value])
  File "C:\Python25\lib\site-packages\django\forms\widgets.py", line 420, in render_options
    for option_value, option_label in chain(self.choices, choices):
  File "C:\Python25\lib\site-packages\django\forms\models.py", line 914, in __iter__
    for obj in self.queryset.all():
  File "C:\Python25\lib\site-packages\django\db\models\query.py", line 106, in _result_iter
    self._fill_cache()
  File "C:\Python25\lib\site-packages\django\db\models\query.py", line 692, in _fill_cache
    self._result_cache.append(self._iter.next())
  File "C:\Python25\lib\site-packages\django\db\models\query.py", line 238, in iterator
    for row in self.query.results_iter():
  File "C:\Python25\lib\site-packages\django\db\models\sql\query.py", line 287, in results_iter
    for rows in self.execute_sql(MULTI):
  File "C:\Python25\lib\site-packages\django\db\models\sql\query.py", line 2369, in execute_sql
    cursor.execute(sql, params)
  File "C:\Python25\Lib\site-packages\django\db\backends\util.py", line 19, in execute
    return self.cursor.execute(sql, params)
  File "C:\Python25\lib\site-packages\django\db\backends\mysql\base.py", line 84, in execute
    return self.cursor.execute(query, args)
  File "C:\Python25\Lib\site-packages\MySQLdb\cursors.py", line 168, in execute
    if not self._defer_warnings: self._warning_check()
  File "C:\Python25\Lib\site-packages\MySQLdb\cursors.py", line 82, in _warning_check
    warn(w[-1], self.Warning, 3)
  File "C:\Python25\lib\warnings.py", line 62, in warn
    globals)
  File "C:\Python25\lib\warnings.py", line 102, in warn_explicit
    raise message
Warning: Incorrect integer value: 'AnonymousUser' for column 'member_id' at row 1
Request Method: GET
Request URL: http://127.0.0.1:8000/pm/projects/my_overview/
Exception Type: TemplateSyntaxError
Exception Value:
Caught an exception while rendering: Incorrect integer value: 'AnonymousUser' for column 'member_id' at row 1

Original Traceback (most recent call last):
  File "C:\Python25\Lib\site-packages\django\template\debug.py", line 71, in render_node
    result = node.render(context)
  File "C:\Python25\lib\site-packages\django\template\defaulttags.py", line 155, in render
    nodelist.append(node.render(context))
  File "C:\Python25\Lib\site-packages\django\template\debug.py", line 87, in render
    output = force_unicode(self.filter_expression.resolve(context))
  File "C:\Python25\lib\site-packages\django\utils\encoding.py", line 71, in force_unicode
    s = unicode(s)
  File "C:\Python25\lib\site-packages\django\forms\forms.py", line 356, in __unicode__
    return self.as_widget()
  File "C:\Python25\lib\site-packages\django\forms\forms.py", line 391, in as_widget
    return widget.render(name, data, attrs=attrs)
  File "C:\Python25\lib\site-packages\django\forms\widgets.py", line 404, in render
    options = self.render_options(choices, [value])
  File "C:\Python25\lib\site-packages\django\forms\widgets.py", line 420, in render_options
    for option_value, option_label in chain(self.choices, choices):
  File "C:\Python25\lib\site-packages\django\forms\models.py", line 914, in __iter__
    for obj in self.queryset.all():
  File "C:\Python25\lib\site-packages\django\db\models\query.py", line 106, in _result_iter
    self._fill_cache()
  File "C:\Python25\lib\site-packages\django\db\models\query.py", line 692, in _fill_cache
    self._result_cache.append(self._iter.next())
  File "C:\Python25\lib\site-packages\django\db\models\query.py", line 238, in iterator
    for row in self.query.results_iter():
  File "C:\Python25\lib\site-packages\django\db\models\sql\query.py", line 287, in results_iter
    for rows in self.execute_sql(MULTI):
  File "C:\Python25\lib\site-packages\django\db\models\sql\query.py", line 2369, in execute_sql
    cursor.execute(sql, params)
  File "C:\Python25\Lib\site-packages\django\db\backends\util.py", line 19, in execute
    return self.cursor.execute(sql, params)
  File "C:\Python25\lib\site-packages\django\db\backends\mysql\base.py", line 84, in execute
    return self.cursor.execute(query, args)
  File "C:\Python25\Lib\site-packages\MySQLdb\cursors.py", line 168, in execute
    if not self._defer_warnings: self._warning_check()
  File "C:\Python25\Lib\site-packages\MySQLdb\cursors.py", line 82, in _warning_check
    warn(w[-1], self.Warning, 3)
  File "C:\Python25\lib\warnings.py", line 62, in warn
    globals)
  File "C:\Python25\lib\warnings.py", line 102, in warn_explicit
    raise message
Warning: Incorrect integer value: 'AnonymousUser' for column 'member_id' at row 1
Exception Location: C:\Python25\Lib\site-packages\django\template\debug.py in render_node, line 81
Python Executable: C:\Python25\python.exe
Python Version: 2.5.4
Python Path: ['X:\\03_Projects\\django web development\\2009_12_31_aeon_infrastructure\\aeon_infrastructure', 'C:\\PYTHON25', 'C:\\PYTHON25\\DLLs', 'C:\\PYTHON25\\Lib', 'C:\\PYTHON25\\Lib\\lib-tk', 'X:\\03_Projects\\django web development\\2009_12_07_aeon_infrastructure', 'X:\\03_Projects\\django web development\\2009_12_07_aeon_infrastructure\\aeon_infrastructure', 'C:\\WINDOWS\\system32\\python25.zip', 'C:\\Python25\\lib\\plat-win', 'C:\\Python25\\lib\\site-packages']
Server time: Mon, 18 Jan 2010 17:00:03 +0100

Template error

In template x:\03_projects\django web development\2009_12_31_aeon_infrastructure\aeon_infrastructure\templates\project_management\tags\overview_search_form.html, error at line 9

Caught an exception while rendering: Incorrect integer value: 'AnonymousUser' for column 'member_id' at row 1

1 <div>
2 {% if context.user_switch %}
3 <form action="/pm/projects/my_overview" method="get">
4 {% else %}
5 <form action="/pm/projects/overview" method="get">
6 {% endif %}
7 <table>
8 <tr>
9 {% for field in context.overview_search_form.visible_fields %}
10 {# Include the hidden fields in the pform #}
11 {% if forloop.first %}
12 {% for hidden in context.overview_search_form.hidden_fields %}
13 {{ hidden }}
14 {% endfor %}
15 {% endif %}
16 {% ifequal forloop.counter 4 %}
17 </tr><tr><td style="width:30px;"></td><td style="width:30px;">By:
18 {% else %}
19 {% ifequal forloop.counter 6 %}

Traceback Switch to copy-and-paste view

Request information

GET

No GET data

POST

No POST data

FILES

No FILES data

Variable Value
sessionid
'2225c248ee643e994b14a63f498b1874'

META

Variable Value
ALLUSERSPROFILE
'C:\\Documents and Settings\\All Users'
APPDATA
'C:\\Documents and Settings\\Thomas\\Application Data'
CLIENTNAME
'Console'
COMMONPROGRAMFILES
'C:\\Program Files\\Common Files'
COMPUTERNAME
'DJ9F054J'
COMSPEC
'C:\\WINDOWS\\system32\\cmd.exe'
CONTENT_LENGTH
''
CONTENT_TYPE
'text/plain'
DJANGO_SETTINGS_MODULE
'aeon_infrastructure.settings'
FP_NO_HOST_CHECK
'NO'
GATEWAY_INTERFACE
'CGI/1.1'
HOMEDRIVE
'C:'
HOMEPATH
'\\Documents and Settings\\Thomas'
HTTP_ACCEPT
'application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5'
HTTP_ACCEPT_CHARSET
'ISO-8859-1,utf-8;q=0.7,*;q=0.3'
HTTP_ACCEPT_ENCODING
'gzip,deflate,sdch'
HTTP_ACCEPT_LANGUAGE
'de-DE,de;q=0.8,en-US;q=0.6,en;q=0.4'
HTTP_CONNECTION
'keep-alive'
HTTP_COOKIE
'sessionid=2225c248ee643e994b14a63f498b1874'
HTTP_HOST
'127.0.0.1:8000'
HTTP_REFERER
'http://127.0.0.1:8000/pm/projects/'
HTTP_USER_AGENT
'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/532.0 (KHTML, like Gecko) Chrome/3.0.195.38 Safari/532.0'
JAVA_HOME
'C:\\Program Files\\Java\\jdk1.6.0_12'
LOGONSERVER
'\\\\DJ9F054J'
NUMBER_OF_PROCESSORS
'2'
OS
'Windows_NT'
PATH
'C:\\Program Files\\ActiveState Komodo Edit 5\\;C:\\WINDOWS\\system32;C:\\WINDOWS;C:\\WINDOWS\\System32\\Wbem;C:\\Program Files\\Intel\\DMIX;C:\\Program Files\\NTRU Cryptosystems\\NTRU TCG Software Stack\\bin\\;C:\\Program Files\\Wave Systems Corp\\Gemalto\\Access Client\\v5\\;C:\\Program Files\\Intel\\WiFi\\bin\\;C:\\Program Files\\Common Files\\Roxio Shared\\DLLShared\\;C:\\Program Files\\Common Files\\Roxio Shared\\9.0\\DLLShared\\;C:\\Program Files\\maven-2.0.9\\bin;C:\\Program Files\\Java\\jdk1.6.0_12\\bin;C:\\Program Files\\ImageConverter Plus;C:\\Python25;C:\\Python25\\Scripts;C:\\django_trunk\\;C:\\Python25\\Lib\\site-packages\\django\\bin;C:\\Program Files\\TortoiseSVN\\bin'
PATHEXT
'.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH'
PATH_INFO
u'/pm/projects/my_overview/'
PROCESSOR_ARCHITECTURE
'x86'
PROCESSOR_IDENTIFIER
'x86 Family 6 Model 23 Stepping 6, GenuineIntel'
PROCESSOR_LEVEL
'6'
PROCESSOR_REVISION
'1706'
PROGRAMFILES
'C:\\Program Files'
PROMPT
'$P$G'
PYTHONPATH
'C:\\PYTHON25;C:\\PYTHON25\\DLLs;C:\\PYTHON25\\Lib;C:\\PYTHON25\\Lib\\lib-tk;X:\\03_Projects\\django web development\\2009_12_07_aeon_infrastructure;X:\\03_Projects\\django web development\\2009_12_07_aeon_infrastructure\\aeon_infrastructure'
QUERY_STRING
''
REMOTE_ADDR
'127.0.0.1'
REMOTE_HOST
''
REQUEST_METHOD
'GET'
ROXIOCENTRAL
'C:\\Program Files\\Common Files\\Roxio Shared\\9.0\\Roxio Central33\\'
RUN_MAIN
'true'
SCRIPT_NAME
u''
SERVER_NAME
'localhost'
SERVER_PORT
'8000'
SERVER_PROTOCOL
'HTTP/1.1'
SERVER_SOFTWARE
'WSGIServer/0.1 Python/2.5.4'
SESSIONNAME
'Console'
SYSTEMDRIVE
'C:'
SYSTEMROOT
'C:\\WINDOWS'
TEMP
'C:\\DOCUME~1\\Thomas\\LOCALS~1\\Temp'
TMP
'C:\\DOCUME~1\\Thomas\\LOCALS~1\\Temp'
USERDOMAIN
'DJ9F054J'
USERNAME
'Thomas'
USERPROFILE
'C:\\Documents and Settings\\Thomas'
WINDIR
'C:\\WINDOWS'
wsgi.errors
<open file '<stderr>', mode 'w' at 0x00C000B0>
wsgi.file_wrapper
<class 'django.core.servers.basehttp.FileWrapper'>
wsgi.input
<socket._fileobject object at 0x0198AEB0>
wsgi.multiprocess
False
wsgi.multithread
True
wsgi.run_once
False
wsgi.url_scheme
'http'
wsgi.version
(1, 0)

Settings

Using settings module aeon_infrastructure.settings

Setting Value
ABSOLUTE_URL_OVERRIDES
{}
ADMINS
()
ADMIN_FOR
()
ADMIN_MEDIA_PREFIX
'http://localhost:8000/media/admin/'
ALLOWED_INCLUDE_ROOTS
()
APPEND_SLASH
True
AUTHENTICATION_BACKENDS
('django.contrib.auth.backends.ModelBackend',)
BANNED_IPS
()
CACHE_BACKEND
'locmem://'
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
CRM_DATE_FORMAT
'%d.%m.%Y'
DATABASE_ENGINE
'mysql'
DATABASE_HOST
''
DATABASE_NAME
'aeon_infrastructure'
DATABASE_OPTIONS
{}
DATABASE_PASSWORD
'********************'
DATABASE_PORT
''
DATABASE_USER
'thomas'
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_FILE_STORAGE
'django.core.files.storage.FileSystemStorage'
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'
FILE_UPLOAD_HANDLERS
('django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler')
FILE_UPLOAD_MAX_MEMORY_SIZE
2621440
FILE_UPLOAD_PERMISSIONS
None
FILE_UPLOAD_TEMP_DIR
None
FIXTURE_DIRS
()
FORCE_SCRIPT_NAME
None
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.contenttypes', 'django.contrib.sessions', 'django.contrib.sites', 'django.contrib.admin', 'django.contrib.webdesign', 'lib', 'crm', 'project_management', 'django_evolution', 'ajax_filtered_fields', 'django_extensions']
INTERNAL_IPS
()
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'), ('hi', 'Hindi'), ('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', 'Portuguese'), ('pt-br', 'Brazilian Portuguese'), ('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'), ('sl', 'Slovenian'), ('sr', 'Serbian'), ('sv', 'Swedish'), ('ta', 'Tamil'), ('te', 'Telugu'), ('th', 'Thai'), ('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
'/crm/'
LOGIN_URL
'/accounts/login/'
LOGOUT_URL
'/accounts/logout/'
MANAGERS
()
MEDIA_ROOT
'X:\\03_Projects\\django web development\\2009_12_31_aeon_infrastructure\\aeon_infrastructure\\..\\aeon_infrastructure\\media'
MEDIA_URL
'http://localhost:8000/media/'
MIDDLEWARE_CLASSES
('django.middleware.common.CommonMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'lib.middleware.request_middleware.AcceptMiddleware', 'crm.middleware.session_hooks.ThreadLocals')
MONTH_DAY_FORMAT
'F j'
PASSWORD_RESET_TIMEOUT_DAYS
'********************'
PREPEND_WWW
False
PROFANITIES_LIST
'********************'
PROJECT_DIR
'X:\\03_Projects\\django web development\\2009_12_31_aeon_infrastructure\\aeon_infrastructure\\..\\aeon_infrastructure'
ROOT_URLCONF
'aeon_infrastructure.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
'aeon_infrastructure.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', 'django.core.context_processors.request', 'crm.context_processors.media_url')
TEMPLATE_DEBUG
True
TEMPLATE_DIRS
('X:\\03_Projects\\django web development\\2009_12_31_aeon_infrastructure\\aeon_infrastructure\\..\\aeon_infrastructure\\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/Chicago'
TRANSACTIONS_MANAGED
False
URL_VALIDATOR_USER_AGENT
'Django/1.1.1 (http://www.djangoproject.com)'
USE_ETAGS
False
USE_I18N
True
YEAR_MONTH_FORMAT
'F Y'

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.