FieldError at /public/499/history

Cannot resolve keyword u'trial_smodified_on' into field. Choices are: approval_date, chictr_ref_no, chictr_register_date, contact_person_address, contact_person_affiliation, contact_person_country, contact_person_email, contact_person_name, contact_person_phone, created_by, created_by_id, created_on, criteria_age_max, criteria_age_min, criteria_exclusion, criteria_gender, criteria_gender_id, criteria_inclusion, ethical_review_approval_date, ethical_review_approval_organization, ethical_review_approval_organization_id, ethical_review_approval_organization_other, ethical_review_approval_ref_no, ethical_review_approved, funding_source, id, intervention_description, intervention_dosage, intervention_dosage_form, intervention_duration, intervention_frequency, intervention_type, intervention_type_id, intervention_type_other, migration_data, modified_by, modified_by_admin, modified_by_id, modified_on, outcome_primary, outcome_secondary, publication_available, publication_link, recruitment_location, recruitment_publication_available, recruitment_publication_link, recruitment_status, recruitment_status_id, ref_no, ref_no_extra, register_date, research_contact_person_address, research_contact_person_affiliation, research_contact_person_country, research_contact_person_email, research_contact_person_name, research_contact_person_phone, sponsor_primary, sponsor_relation, sponsor_relation_id, sponsor_relation_other, sponsor_secondary, status, status_id, study_control, study_control_id, study_group_assignment, study_group_assignment_id, study_masking, study_masking_id, study_masking_party, study_masking_party_id, study_medical_condition, study_objective, study_phase, study_phase_id, study_phase_other, study_randomization, study_randomization_id, study_randomization_randomized, study_sample_size, study_start_date, study_type, study_type_id, submission_date, title_chinese, title_public, title_scientific, title_short, treatment_description, treatment_dosage, treatment_dosage_form, treatment_duration, treatment_frequency, trial, trial_created_by, trial_created_by_id, trial_created_on, trial_id, trial_modified_by, trial_modified_by_id, trial_modified_on
Request Method: GET
Request URL: https://www2.ccrb.cuhk.edu.hk/registry/public/499/history?sort=trial_smodified_on&order=asc
Django Version: 1.7
Exception Type: FieldError
Exception Value:
Cannot resolve keyword u'trial_smodified_on' into field. Choices are: approval_date, chictr_ref_no, chictr_register_date, contact_person_address, contact_person_affiliation, contact_person_country, contact_person_email, contact_person_name, contact_person_phone, created_by, created_by_id, created_on, criteria_age_max, criteria_age_min, criteria_exclusion, criteria_gender, criteria_gender_id, criteria_inclusion, ethical_review_approval_date, ethical_review_approval_organization, ethical_review_approval_organization_id, ethical_review_approval_organization_other, ethical_review_approval_ref_no, ethical_review_approved, funding_source, id, intervention_description, intervention_dosage, intervention_dosage_form, intervention_duration, intervention_frequency, intervention_type, intervention_type_id, intervention_type_other, migration_data, modified_by, modified_by_admin, modified_by_id, modified_on, outcome_primary, outcome_secondary, publication_available, publication_link, recruitment_location, recruitment_publication_available, recruitment_publication_link, recruitment_status, recruitment_status_id, ref_no, ref_no_extra, register_date, research_contact_person_address, research_contact_person_affiliation, research_contact_person_country, research_contact_person_email, research_contact_person_name, research_contact_person_phone, sponsor_primary, sponsor_relation, sponsor_relation_id, sponsor_relation_other, sponsor_secondary, status, status_id, study_control, study_control_id, study_group_assignment, study_group_assignment_id, study_masking, study_masking_id, study_masking_party, study_masking_party_id, study_medical_condition, study_objective, study_phase, study_phase_id, study_phase_other, study_randomization, study_randomization_id, study_randomization_randomized, study_sample_size, study_start_date, study_type, study_type_id, submission_date, title_chinese, title_public, title_scientific, title_short, treatment_description, treatment_dosage, treatment_dosage_form, treatment_duration, treatment_frequency, trial, trial_created_by, trial_created_by_id, trial_created_on, trial_id, trial_modified_by, trial_modified_by_id, trial_modified_on
Exception Location: /usr/local/lib/python2.7/dist-packages/django/db/models/sql/query.py in raise_field_error, line 1389
Python Executable: /usr/bin/python
Python Version: 2.7.3
Python Path:
['/var/www/django/ccrb_ctrs/lib/python2.7/site-packages/distribute-0.6.24-py2.7.egg',
 '/var/www/django/ccrb_ctrs/lib/python2.7/site-packages/pip-1.1-py2.7.egg',
 '/var/www/django/ccrb_ctrs',
 '/var/www/django/ccrb_ctrs/lib/python2.7/site-packages',
 '/usr/lib/python2.7',
 '/usr/lib/python2.7/plat-linux2',
 '/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',
 '/usr/lib/pymodules/python2.7']
Server time: Fri, 29 Mar 2024 02:29:55 +0800

Traceback Switch to copy-and-paste view



Request information

GET

Variable Value
sort
u'trial_smodified_on'
order
u'asc'

POST

No POST data

FILES

No FILES data

No cookie data

META

Variable Value
mod_wsgi.listener_port
'443'
SERVER_SOFTWARE
'Apache/2.2.22 (Ubuntu)'
SCRIPT_NAME
u'/registry'
mod_wsgi.handler_script
''
SERVER_SIGNATURE
'<address>Apache/2.2.22 (Ubuntu) Server at www2.ccrb.cuhk.edu.hk Port 443</address>\n'
REQUEST_METHOD
'GET'
PATH_INFO
u'/public/499/history'
SERVER_PROTOCOL
'HTTP/1.1'
QUERY_STRING
'sort=trial_smodified_on&order=asc'
SSL_TLS_SNI
'www2.ccrb.cuhk.edu.hk'
HTTP_USER_AGENT
'claudebot'
SERVER_NAME
'www2.ccrb.cuhk.edu.hk'
REMOTE_ADDR
'3.84.7.255'
mod_wsgi.request_handler
'wsgi-script'
wsgi.url_scheme
'https'
PATH_TRANSLATED
'/var/www/html/public/499/history'
SERVER_PORT
'443'
wsgi.multiprocess
False
mod_wsgi.input_chunked
'0'
SERVER_ADDR
'123.255.65.129'
DOCUMENT_ROOT
'/var/www/html'
mod_wsgi.process_group
'ccrb_ctrs'
SCRIPT_FILENAME
'/var/www/django/ccrb_ctrs/ccrb_ctrs/wsgi.py'
SERVER_ADMIN
'support@yakoo.com.hk'
SCRIPT_URI
'https://www2.ccrb.cuhk.edu.hk/registry/public/499/history'
wsgi.input
<mod_wsgi.Input object at 0x7fce70154b70>
HTTP_HOST
'www2.ccrb.cuhk.edu.hk'
SCRIPT_URL
'/registry/public/499/history'
HTTPS
'1'
wsgi.multithread
True
mod_wsgi.callable_object
'application'
REQUEST_URI
'/registry/public/499/history?sort=trial_smodified_on&order=asc'
HTTP_ACCEPT
'*/*'
wsgi.version
(1, 1)
GATEWAY_INTERFACE
'CGI/1.1'
wsgi.run_once
False
wsgi.errors
<mod_wsgi.Log object at 0x7fce70154f70>
REMOTE_PORT
'37406'
mod_wsgi.listener_host
''
mod_wsgi.version
(3, 3)
mod_wsgi.application_group
'www2.ccrb.cuhk.edu.hk|/registry'
mod_wsgi.script_reloading
'1'
wsgi.file_wrapper
''
CSRF_COOKIE
u'EnMRtk4XDcOHkQ1Oyk2heYusBGfGhZjg'

Settings

Using settings module ccrb_ctrs.settings

Setting Value
USE_L10N
True
USE_THOUSAND_SEPARATOR
False
CSRF_COOKIE_SECURE
False
LANGUAGE_CODE
'en-us'
ROOT_URLCONF
'ccrb_ctrs.urls'
MANAGERS
()
BASE_DIR
'/var/www/django/ccrb_ctrs'
TEST_NON_SERIALIZED_APPS
[]
DEFAULT_CHARSET
'utf-8'
SESSION_SERIALIZER
'django.contrib.sessions.serializers.JSONSerializer'
EMAIL_CHICTR_CC
'marialai@cuhk.edu.hk'
ALLOWED_HOSTS
['.ccrb.cuhk.edu.hk']
MESSAGE_STORAGE
'django.contrib.messages.storage.fallback.FallbackStorage'
EMAIL_SUBJECT_PREFIX
'[Django] '
SEND_BROKEN_LINK_EMAILS
False
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:%S.%f', '%H:%M')
DATABASES
{'default': {'ATOMIC_REQUESTS': False,
             'AUTOCOMMIT': True,
             'CHARSET': 'utf8_general_ci',
             'CONN_MAX_AGE': 0,
             'ENGINE': 'django.db.backends.mysql',
             'HOST': 'localhost',
             'NAME': 'ccrb_ctrs_prd',
             'OPTIONS': {},
             'PASSWORD': u'********************',
             'PORT': '3306',
             'TEST': {'CHARSET': None,
                      'COLLATION': None,
                      'MIRROR': None,
                      'NAME': None},
             'TIME_ZONE': 'Asia/Hong_Kong',
             'USER': 'ccrb_ctrs'}}
FILE_UPLOAD_DIRECTORY_PERMISSIONS
None
STATIC_URL
'/ccrb_ctrs/static/'
FILE_UPLOAD_PERMISSIONS
None
FILE_UPLOAD_HANDLERS
('django.core.files.uploadhandler.MemoryFileUploadHandler',
 'django.core.files.uploadhandler.TemporaryFileUploadHandler')
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')
DEFAULT_CONTENT_TYPE
'text/html'
APPEND_SLASH
True
LOCALE_PATHS
()
DATABASE_ROUTERS
[]
DEFAULT_TABLESPACE
''
YEAR_MONTH_FORMAT
'F Y'
STATICFILES_STORAGE
'django.contrib.staticfiles.storage.StaticFilesStorage'
CACHES
{'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}}
SERVER_EMAIL
'root@localhost'
SESSION_COOKIE_PATH
'/'
SILENCED_SYSTEM_CHECKS
[]
MIDDLEWARE_CLASSES
('django.contrib.sessions.middleware.SessionMiddleware',
 'django.middleware.common.CommonMiddleware',
 'django.middleware.csrf.CsrfViewMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'django.contrib.messages.middleware.MessageMiddleware',
 'django.middleware.clickjacking.XFrameOptionsMiddleware')
USE_I18N
True
THOUSAND_SEPARATOR
','
SECRET_KEY
u'********************'
LANGUAGE_COOKIE_NAME
'django_language'
DEFAULT_INDEX_TABLESPACE
''
TRANSACTIONS_MANAGED
False
LOGGING_CONFIG
'logging.config.dictConfig'
TEMPLATE_LOADERS
('django.template.loaders.filesystem.Loader',
 'django.template.loaders.app_directories.Loader')
FIRST_DAY_OF_WEEK
0
WSGI_APPLICATION
'ccrb_ctrs.wsgi.application'
TEMPLATE_DEBUG
False
X_FRAME_OPTIONS
'SAMEORIGIN'
CSRF_COOKIE_NAME
'csrftoken'
FORCE_SCRIPT_NAME
None
USE_X_FORWARDED_HOST
False
SIGNING_BACKEND
'django.core.signing.TimestampSigner'
SESSION_COOKIE_SECURE
False
BASE_URL
'https://www2.ccrb.cuhk.edu.hk'
CSRF_COOKIE_DOMAIN
None
FILE_CHARSET
'utf-8'
DEBUG
True
LANGUAGE_COOKIE_DOMAIN
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.messages',
 'django.contrib.staticfiles',
 'crispy_forms',
 'widget_tweaks',
 'base',
 'users',
 'trials',
 'trials_admin',
 'public')
LANGUAGES
(('af', 'Afrikaans'),
 ('ar', 'Arabic'),
 ('ast', 'Asturian'),
 ('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-au', 'Australian 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', 'Frisian'),
 ('ga', 'Irish'),
 ('gl', 'Galician'),
 ('he', 'Hebrew'),
 ('hi', 'Hindi'),
 ('hr', 'Croatian'),
 ('hu', 'Hungarian'),
 ('ia', 'Interlingua'),
 ('id', 'Indonesian'),
 ('io', 'Ido'),
 ('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'),
 ('mr', 'Marathi'),
 ('my', 'Burmese'),
 ('nb', 'Norwegian Bokmal'),
 ('ne', 'Nepali'),
 ('nl', 'Dutch'),
 ('nn', 'Norwegian Nynorsk'),
 ('os', 'Ossetic'),
 ('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-hans', 'Simplified Chinese'),
 ('zh-hant', 'Traditional Chinese'),
 ('zh-tw', 'Traditional Chinese'))
COMMENTS_ALLOW_PROFANITIES
False
STATIC_ROOT
'/var/www/django/ccrb_ctrs/static'
STATICFILES_DIRS
()
PREPEND_WWW
False
SECURE_PROXY_SSL_HEADER
None
LANGUAGE_COOKIE_AGE
None
SESSION_COOKIE_HTTPONLY
True
DEBUG_PROPAGATE_EXCEPTIONS
False
INTERNAL_IPS
()
MONTH_DAY_FORMAT
'F j'
LOGIN_URL
<django.utils.functional.__proxy__ object at 0x7fceacd682d0>
SESSION_EXPIRE_AT_BROWSER_CLOSE
False
TIME_FORMAT
'P'
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')
EMAIL_CHICTR
'chictr@hotmail.com'
AUTHENTICATION_BACKENDS
('django.contrib.auth.backends.ModelBackend',)
EMAIL_HOST_PASSWORD
u'********************'
PASSWORD_RESET_TIMEOUT_DAYS
u'********************'
SESSION_FILE_PATH
None
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
'/accounts/profile/'
DECIMAL_SEPARATOR
'.'
IGNORABLE_404_URLS
()
EMAIL_NAME
'ccrb@cuhk.edu.hk'
MIGRATION_MODULES
{}
TEMPLATE_STRING_IF_INVALID
''
LOGOUT_URL
<django.utils.functional.__proxy__ object at 0x7fceacd68350>
EMAIL_USE_TLS
False
FIXTURE_DIRS
()
EMAIL_HOST
'localhost'
DATE_FORMAT
'N j, Y'
MEDIA_ROOT
'/var/www/django/ccrb_ctrs/media'
DEFAULT_EXCEPTION_REPORTER_FILTER
'django.views.debug.SafeExceptionReporterFilter'
ADMINS
()
FORMAT_MODULE_PATH
None
DEFAULT_FROM_EMAIL
'ccrb@cuhk.edu.hk'
MEDIA_URL
'/ccrb_ctrs/media/'
DATETIME_FORMAT
'N j, Y, P'
TEMPLATE_DIRS
()
DISALLOWED_USER_AGENTS
()
ALLOWED_INCLUDE_ROOTS
()
LOGGING
{}
SHORT_DATE_FORMAT
'm/d/Y'
TEST_RUNNER
'django.test.runner.DiscoverRunner'
CACHE_MIDDLEWARE_KEY_PREFIX
u'********************'
TIME_ZONE
'Asia/Hong_Kong'
FILE_UPLOAD_MAX_MEMORY_SIZE
2621440
EMAIL_BACKEND
'django.core.mail.backends.smtp.EmailBackend'
EMAIL_USE_SSL
False
CRISPY_TEMPLATE_PACK
'bootstrap3'
SESSION_COOKIE_AGE
1209600
SETTINGS_MODULE
'ccrb_ctrs.settings'
USE_ETAGS
False
LANGUAGES_BIDI
('he', 'ar', 'fa', 'ur')
FILE_UPLOAD_TEMP_DIR
None
CSRF_COOKIE_AGE
31449600
EMAIL_USE_TSL
True
EMAIL_PORT
25
USE_TZ
False
SHORT_DATETIME_FORMAT
'm/d/Y P'
PASSWORD_HASHERS
u'********************'
ABSOLUTE_URL_OVERRIDES
{}
LANGUAGE_COOKIE_PATH
'/'
CACHE_MIDDLEWARE_SECONDS
600
CSRF_COOKIE_HTTPONLY
False
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
''
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.