DatabaseError at /erfassen/bereich/12/

ORA-01843: not a valid month
Request Method: POST
Request URL: http://lori2/lori/erfassen/bereich/12/?Datum=2013-04-09
Django Version: 1.5.1
Exception Type: DatabaseError
Exception Value:
ORA-01843: not a valid month
Exception Location: /usr/local/lib/python2.6/dist-packages/django/db/backends/oracle/base.py in execute, line 710
Python Executable: /usr/bin/python
Python Version: 2.6.5
Python Path:
['/home/lori/Zeiterfassung',
 '/usr/lib/python2.6',
 '/usr/lib/python2.6/plat-linux2',
 '/usr/lib/python2.6/lib-tk',
 '/usr/lib/python2.6/lib-old',
 '/usr/lib/python2.6/lib-dynload',
 '/usr/lib/python2.6/dist-packages',
 '/usr/lib/python2.6/dist-packages/PIL',
 '/usr/lib/python2.6/dist-packages/gst-0.10',
 '/usr/lib/pymodules/python2.6',
 '/usr/lib/python2.6/dist-packages/gtk-2.0',
 '/usr/lib/pymodules/python2.6/gtk-2.0',
 '/usr/local/lib/python2.6/dist-packages']
Server time: Mi, 10 Apr 2013 13:29:09 +0200

Traceback Switch to copy-and-paste view



Request information

GET

Variable Value
Datum
u'2013-04-09'

POST

Variable Value
form-12-Bereich
u''
form-8-BonusUrl
u''
form-10-Anfang
u''
form-9-Bereich
u''
save_and_continue
u'Sichern und weiter bearbeiten'
form-15-Datum
u'2013-04-09'
form-12-Ende
u''
form-10-Bereich
u''
form-13-Ende
u''
form-11-BonusUrl
u''
form-6-Zustand
u''
form-14-Zustand
u'-1'
form-14-Bemerkung
u''
form-3-Pause
u'01:15'
form-15-Faktor
u'60'
form-13-BonusUrl
u''
form-5-BonusUrl
u''
form-0-Bereich
u''
form-5-Bereich
u''
form-5-Anfang
u''
form-15-Bereich
u''
form-14-Datum
u'2013-04-09'
form-0-MA
u'310'
form-7-Zustand
u''
form-2-Zustand
u'-1'
form-0-Anfang
u'09:00'
form-13-Bemerkung
u''
form-3-Anfang
u'09:00'
form-10-Zustand
u''
form-11-Bemerkung
u''
form-2-Faktor
u'60'
form-1-Faktor
u'60'
form-5-Ende
u''
form-16-Faktor
u'60'
form-7-BonusUrl
u''
form-0-Faktor
u'60'
form-13-Faktor
u'60'
form-10-Ende
u''
form-15-BonusUrl
u''
form-5-Zustand
u''
form-12-Pause
u''
form-1-MA
u'387'
form-7-Bereich
u''
form-2-Datum
u'2013-04-09'
form-15-MA
u'4039'
form-7-Datum
u'2013-04-09'
form-3-Bereich
u''
form-16-Bereich
u''
form-8-Status
u'38'
form-9-Zustand
u''
form-8-Bemerkung
u''
form-0-Zustand
u'-1'
form-15-Bemerkung
u''
form-11-Anfang
u'09:00'
form-4-Pause
u'01:00'
form-3-MA
u'1629'
form-9-Pause
u''
form-5-MA
u'13296'
form-11-Pause
u'00:15'
form-1-Bemerkung
u''
form-4-Anfang
u'09:00'
form-10-Pause
u''
form-16-Datum
u'2013-04-09'
form-3-Bemerkung
u''
form-6-Speichern
u'on'
form-7-MA
u'7263'
form-10-Bemerkung
u''
form-12-Zustand
u''
form-13-Anfang
u''
form-8-Faktor
u'60'
form-9-Anfang
u''
form-11-Datum
u'2013-04-09'
form-6-MA
u'844'
form-3-BonusUrl
u''
form-13-MA
u'10411'
form-11-Status
u'1'
form-9-Status
u''
form-TOTAL_FORMS
u'17'
form-1-Zustand
u'-1'
form-8-MA
u'10410'
form-5-Datum
u'2013-04-09'
form-6-BonusUrl
u''
form-14-Pause
u'00:15'
form-9-Datum
u'2013-04-09'
form-13-Zustand
u''
form-7-Status
u''
form-9-Bemerkung
u''
form-11-Faktor
u'60'
form-8-Bereich
u''
form-14-BonusUrl
u''
form-5-Faktor
u'60'
form-9-Ende
u''
form-16-BonusUrl
u''
form-3-Zustand
u'-1'
form-16-MA
u'852'
form-6-Faktor
u'60'
form-5-Pause
u''
form-15-Status
u'1'
form-13-Bereich
u''
form-12-Bemerkung
u''
form-14-Faktor
u'60'
form-11-Ende
u'14:15'
form-4-Datum
u'2013-04-09'
form-4-Status
u'1'
form-10-Faktor
u'60'
form-16-Zustand
u'1'
form-8-Datum
u'2013-04-09'
form-16-Status
u'4'
form-7-Pause
u''
next
u'/lori/admin/'
form-2-MA
u'196'
form-11-MA
u'11496'
form-2-Bemerkung
u''
form-16-Bemerkung
u''
form-7-Faktor
u'60'
form-15-Zustand
u'-1'
form-10-BonusUrl
u''
form-INITIAL_FORMS
u'17'
form-4-Bereich
u''
form-4-MA
u'351'
form-12-MA
u'12135'
form-13-Status
u''
form-9-Faktor
u'60'
form-MAX_NUM_FORMS
u'1000'
form-4-Faktor
u'60'
form-15-Anfang
u'09:00'
form-0-Bemerkung
u''
form-2-BonusUrl
u''
form-14-Anfang
u'14:00'
form-10-MA
u'2443'
form-1-Status
u'28'
form-3-Ende
u'19:00'
form-0-Ende
u'19:30'
form-6-Bereich
u''
form-3-Faktor
u'60'
form-0-BonusUrl
u''
form-1-BonusUrl
u''
form-12-Status
u''
form-1-Bereich
u''
form-1-Datum
u'2013-04-09'
form-8-Zustand
u'-1'
form-5-Bemerkung
u''
form-11-Zustand
u'-1'
form-12-Anfang
u''
form-3-Status
u'1'
form-4-Ende
u'18:00'
form-7-Anfang
u''
form-14-Ende
u'19:30'
form-15-Ende
u'14:00'
form-4-Zustand
u'-1'
form-10-Status
u''
form-7-Ende
u''
form-4-BonusUrl
u''
form-10-Datum
u'2013-04-09'
form-14-Bereich
u''
form-7-Bemerkung
u''
form-2-Bereich
u''
form-14-Status
u'1'
csrfmiddlewaretoken
u'Z9ACbKPOLWeHXZWASWuL19Ykj3JLlNHK'
form-2-Status
u'28'
form-6-Status
u'15'
form-14-MA
u'857'
form-12-Faktor
u'60'
form-5-Status
u''
form-12-BonusUrl
u''
form-13-Pause
u''
form-9-MA
u'847'
form-13-Datum
u'2013-04-09'
form-15-Pause
u'00:15'
form-9-BonusUrl
u''
form-3-Datum
u'2013-04-09'
form-12-Datum
u'2013-04-09'
form-4-Bemerkung
u''
form-0-Datum
u'2013-04-09'
form-0-Status
u'1'
form-11-Bereich
u''
form-0-Pause
u'01:15'
form-6-Bemerkung
u'Test CF EDV'
form-6-Datum
u'2013-04-09'

FILES

No FILES data

Variable Value
csrftoken
'Z9ACbKPOLWeHXZWASWuL19Ykj3JLlNHK'
sessionid
'a11fwl7jrqiiz58iv4omhfjk1amqn62g'

META

Variable Value
mod_wsgi.reload_mechanism
'1'
mod_wsgi.listener_port
'80'
HTTP_COOKIE
'csrftoken=Z9ACbKPOLWeHXZWASWuL19Ykj3JLlNHK; sessionid=a11fwl7jrqiiz58iv4omhfjk1amqn62g'
mod_wsgi.listener_host
''
SERVER_SOFTWARE
'Apache/2.2.14 (Ubuntu)'
SCRIPT_NAME
u'/lori'
SERVER_SIGNATURE
'<address>Apache/2.2.14 (Ubuntu) Server at lori2 Port 80</address>\n'
REQUEST_METHOD
'POST'
PATH_INFO
u'/erfassen/bereich/12/'
SERVER_PROTOCOL
'HTTP/1.1'
QUERY_STRING
'Datum=2013-04-09'
PATH
'/usr/local/bin:/usr/bin:/bin'
CONTENT_LENGTH
'3302'
HTTP_USER_AGENT
'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:15.0) Gecko/20100101 Firefox/15.0.1'
HTTP_CONNECTION
'keep-alive'
HTTP_REFERER
'http://lori2/lori/erfassen/bereich/12/?Datum=2013-04-09'
SERVER_NAME
'lori2'
REMOTE_ADDR
'10.1.254.66'
wsgi.url_scheme
'http'
PATH_TRANSLATED
'/var/www/erfassen/bereich/12/'
SERVER_PORT
'80'
wsgi.multiprocess
False
SERVER_ADDR
'10.1.254.47'
DOCUMENT_ROOT
'/var/www'
mod_wsgi.process_group
'rofu-ze-site'
SCRIPT_FILENAME
'/home/lori/Zeiterfassung/Zeiterfassung/wsgi.py'
SERVER_ADMIN
'webmaster@localhost'
wsgi.input
<mod_wsgi.Input object at 0xa690db10>
HTTP_HOST
'lori2'
wsgi.multithread
True
mod_wsgi.callable_object
'application'
REQUEST_URI
'/lori/erfassen/bereich/12/?Datum=2013-04-09'
HTTP_ACCEPT
'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8'
wsgi.version
(1, 0)
GATEWAY_INTERFACE
'CGI/1.1'
wsgi.run_once
False
wsgi.errors
<mod_wsgi.Log object at 0xa690e940>
REMOTE_PORT
'61663'
HTTP_ACCEPT_LANGUAGE
'de-de,de;q=0.8,en-us;q=0.5,en;q=0.3'
mod_wsgi.version
(2, 8)
CONTENT_TYPE
'application/x-www-form-urlencoded'
mod_wsgi.application_group
'127.0.1.1|/lori'
mod_wsgi.script_reloading
'1'
wsgi.file_wrapper
''
CSRF_COOKIE
u'Z9ACbKPOLWeHXZWASWuL19Ykj3JLlNHK'
HTTP_ACCEPT_ENCODING
'gzip, deflate'

Settings

Using settings module Zeiterfassung.settings

Setting Value
USE_L10N
False
USE_THOUSAND_SEPARATOR
False
CSRF_COOKIE_SECURE
False
LANGUAGE_CODE
'de-DE'
ROOT_URLCONF
'Zeiterfassung.urls'
MANAGERS
(('Carsten Fuchs', 'info@cafu.de'),)
DEFAULT_CHARSET
'utf-8'
STATIC_ROOT
'/var/www/Lori-static/'
ALLOWED_HOSTS
['localhost',
 '127.0.0.1',
 'keep-surfing',
 'paranormalactivity',
 'lori1',
 'lori1.rofu.de',
 'lori2',
 'lori2.rofu.de']
MESSAGE_STORAGE
'django.contrib.messages.storage.fallback.FallbackStorage'
EMAIL_SUBJECT_PREFIX
'[Lori] '
FILE_UPLOAD_PERMISSIONS
None
STATICFILES_FINDERS
('django.contrib.staticfiles.finders.FileSystemFinder',
 'django.contrib.staticfiles.finders.AppDirectoriesFinder')
SESSION_CACHE_ALIAS
'default'
SESSION_COOKIE_DOMAIN
None
SESSION_COOKIE_NAME
'sessionid'
ADMIN_FOR
()
TIME_INPUT_FORMATS
('%H:%M:%S', '%H:%M')
DATABASES
{'default': {'ENGINE': 'django.db.backends.oracle',
             'HOST': u'localhost',
             'NAME': 'fixfoxytaf',
             'OPTIONS': {},
             'PASSWORD': u'********************',
             'PORT': '',
             'TEST_CHARSET': None,
             'TEST_COLLATION': None,
             'TEST_MIRROR': None,
             'TEST_NAME': None,
             'TIME_ZONE': 'Europe/Berlin',
             'USER': 'rofu'}}
SERVER_EMAIL
'lori@rofu.de'
FILE_UPLOAD_HANDLERS
('django.core.files.uploadhandler.MemoryFileUploadHandler',
 'django.core.files.uploadhandler.TemporaryFileUploadHandler')
DEFAULT_CONTENT_TYPE
'text/html'
APPEND_SLASH
True
FIRST_DAY_OF_WEEK
0
DATABASE_ROUTERS
[]
YEAR_MONTH_FORMAT
'F Y'
STATICFILES_STORAGE
'django.contrib.staticfiles.storage.StaticFilesStorage'
CACHES
{'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}}
SESSION_COOKIE_PATH
'/'
MIDDLEWARE_CLASSES
('django.middleware.common.CommonMiddleware',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'django.middleware.csrf.CsrfViewMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'django.contrib.messages.middleware.MessageMiddleware',
 'django.middleware.transaction.TransactionMiddleware')
USE_I18N
True
THOUSAND_SEPARATOR
','
SECRET_KEY
u'********************'
LANGUAGE_COOKIE_NAME
'django_language'
DEFAULT_INDEX_TABLESPACE
''
TRANSACTIONS_MANAGED
False
LOGGING_CONFIG
'django.utils.log.dictConfig'
SEND_BROKEN_LINK_EMAILS
True
TEMPLATE_LOADERS
(('django.template.loaders.cached.Loader',
  ('django.template.loaders.filesystem.Loader',
   'django.template.loaders.app_directories.Loader')),)
WSGI_APPLICATION
'Zeiterfassung.wsgi.application'
TEMPLATE_DEBUG
True
X_FRAME_OPTIONS
'SAMEORIGIN'
AUTHENTICATION_BACKENDS
('django.contrib.auth.backends.ModelBackend',)
FORCE_SCRIPT_NAME
None
USE_X_FORWARDED_HOST
False
SIGNING_BACKEND
'django.core.signing.TimestampSigner'
SESSION_COOKIE_SECURE
False
CSRF_COOKIE_DOMAIN
None
FILE_CHARSET
'utf-8'
DEBUG
True
SESSION_FILE_PATH
None
DEFAULT_FILE_STORAGE
'django.core.files.storage.FileSystemStorage'
INSTALLED_APPS
('django.contrib.admin',
 'django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.staticfiles',
 'Lori')
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'))
COMMENTS_ALLOW_PROFANITIES
False
STATICFILES_DIRS
()
PREPEND_WWW
False
SECURE_PROXY_SSL_HEADER
None
AUTH_PROFILE_MODULE
'Lori.UserProfile'
SESSION_COOKIE_HTTPONLY
True
DEBUG_PROPAGATE_EXCEPTIONS
False
MONTH_DAY_FORMAT
'F j'
LOGIN_URL
'/lori/login/'
SESSION_EXPIRE_AT_BROWSER_CLOSE
True
TIME_FORMAT
'H:i'
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')
CSRF_COOKIE_NAME
'csrftoken'
EMAIL_HOST_PASSWORD
u'********************'
PASSWORD_RESET_TIMEOUT_DAYS
u'********************'
CACHE_MIDDLEWARE_ALIAS
'default'
SESSION_SAVE_EVERY_REQUEST
False
NUMBER_GROUPING
0
SESSION_ENGINE
'django.contrib.sessions.backends.db'
CSRF_FAILURE_VIEW
'django.views.csrf.csrf_failure'
CSRF_COOKIE_PATH
'/'
LOGIN_REDIRECT_URL
'/lori/admin/'
DECIMAL_SEPARATOR
'.'
IGNORABLE_404_URLS
()
LOCALE_PATHS
()
TEMPLATE_STRING_IF_INVALID
''
LOGOUT_URL
'/accounts/logout/'
EMAIL_USE_TLS
False
FIXTURE_DIRS
()
EMAIL_HOST
'apollo11'
DATE_FORMAT
'Y-m-d'
MEDIA_ROOT
''
DEFAULT_EXCEPTION_REPORTER_FILTER
'django.views.debug.SafeExceptionReporterFilter'
ADMINS
(('Carsten Fuchs', 'info@cafu.de'),)
FORMAT_MODULE_PATH
None
DEFAULT_FROM_EMAIL
'webmaster@localhost'
MEDIA_URL
''
DATETIME_FORMAT
'N j, Y, P'
TEMPLATE_DIRS
('/home/lori/Zeiterfassung/templates',)
SITE_ID
1
DISALLOWED_USER_AGENTS
()
ALLOWED_INCLUDE_ROOTS
()
LOGGING
{'disable_existing_loggers': False,
 'filters': {'require_debug_false': {'()': 'django.utils.log.RequireDebugFalse'}},
 'handlers': {'mail_admins': {'class': 'django.utils.log.AdminEmailHandler',
                              'filters': ['require_debug_false'],
                              'include_html': True,
                              'level': 'ERROR'}},
 'loggers': {'django.request': {'handlers': ['mail_admins'],
                                'level': 'ERROR',
                                'propagate': True}},
 'version': 1}
SHORT_DATE_FORMAT
'm/d/Y'
TEST_RUNNER
'django.test.simple.DjangoTestSuiteRunner'
CACHE_MIDDLEWARE_KEY_PREFIX
u'********************'
TIME_ZONE
'Europe/Berlin'
FILE_UPLOAD_MAX_MEMORY_SIZE
2621440
EMAIL_BACKEND
'django.core.mail.backends.smtp.EmailBackend'
DEFAULT_TABLESPACE
''
TEMPLATE_CONTEXT_PROCESSORS
('django.contrib.auth.context_processors.auth',
 'django.core.context_processors.debug',
 'django.core.context_processors.i18n',
 'django.core.context_processors.media',
 'django.core.context_processors.static',
 'django.core.context_processors.tz',
 'django.contrib.messages.context_processors.messages')
SESSION_COOKIE_AGE
1209600
SETTINGS_MODULE
'Zeiterfassung.settings'
USE_ETAGS
False
LANGUAGES_BIDI
('he', 'ar', 'fa')
FILE_UPLOAD_TEMP_DIR
None
INTERNAL_IPS
()
STATIC_URL
'/static/'
EMAIL_PORT
25
USE_TZ
False
SHORT_DATETIME_FORMAT
'm/d/Y P'
PASSWORD_HASHERS
u'********************'
ABSOLUTE_URL_OVERRIDES
{}
CACHE_MIDDLEWARE_SECONDS
600
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')
EMAIL_HOST_USER
'lori@rofu.de'
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.