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/542/history?sort=trial_smodified_on&order=desc |
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 10:04:58 +0800 |
/usr/local/lib/python2.7/dist-packages/django/core/handlers/base.py
in get_response
% (callback.__module__, view_name))
# If the response supports deferred rendering, apply template
# response middleware and then render the response
if hasattr(response, 'render') and callable(response.render):
for middleware_method in self._template_response_middleware:
response = middleware_method(request, response)
response = response.render()...
except http.Http404 as e:
logger.warning('Not Found: %s', request.path,
extra={
'status_code': 404,
'request': request
Variable | Value |
---|---|
callback_args | () |
resolver_match | ResolverMatch(func=<function TrialHistoryListView at 0x7fcead89dc08>, args=(), kwargs={'pk': u'542'}, url_name='history_list', app_name='None', namespace='public') |
middleware_method | <bound method CsrfViewMiddleware.process_view of <django.middleware.csrf.CsrfViewMiddleware object at 0x7fcead4d1350>> |
self | <django.core.handlers.wsgi.WSGIHandler object at 0x7fceac8d3510> |
request | "<WSGIRequest\npath:/registry/public/542/history,\nGET:<QueryDict: {u'sort': [u'trial_smodified_on'], u'order': [u'desc']}>,\nPOST:<QueryDict: {}>,\nCOOKIES:{},\nMETA:{u'CSRF_COOKIE': u'XQf3J98BOkB2A4IzttOII1gjtcoQgqel',\n 'DOCUMENT_ROOT': '/var/www/html',\n 'GATEWAY_INTERFACE': 'CGI/1.1',\n 'HTTPS': '1',\n 'HTTP_ACCEPT': '*/*',\n 'HTTP_HOST': 'www2.ccrb.cuhk.edu.hk',\n 'HTTP_USER_AGENT': 'claudebot',\n 'PATH_INFO': u'/public/542/history',\n 'PATH_TRANSLATED': '/var/www/html/public/542/history',\n 'QUERY_STRING': 'sort=trial_smodified_on&order=desc',\n 'REMOTE_ADDR': '54.160.133.33',\n 'REMOTE_PORT': '39928',\n 'REQUEST_METHOD': 'GET',\n 'REQUEST_URI': '/registry/public/542/history?sort=trial_smodified_on&order=desc',\n 'SCRIPT_FILENAME': '/var/www/django/ccrb_ctrs/ccrb_ctrs/wsgi.py',\n 'SCRIPT_NAME': u'/registry',\n 'SCRIPT_URI': 'https://www2.ccrb.cuhk.edu.hk/registry/public/542/history',\n 'SCRIPT_URL': '/registry/public/542/history',\n 'SERVER_ADDR': '123.255.65.129',\n 'SERVER_ADMIN': 'support@yakoo.com.hk',\n 'SERVER_NAME': 'www2.ccrb.cuhk.edu.hk',\n 'SERVER_PORT': '443',\n 'SERVER_PROTOCOL': 'HTTP/1.1',\n 'SERVER_SIGNATURE': '<address>Apache/2.2.22 (Ubuntu) Server at www2.ccrb.cuhk.edu.hk Port 443</address>\\n',\n 'SERVER_SOFTWARE': 'Apache/2.2.22 (Ubuntu)',\n 'SSL_TLS_SNI': 'www2.ccrb.cuhk.edu.hk',\n 'mod_wsgi.application_group': 'www2.ccrb.cuhk.edu.hk|/registry',\n 'mod_wsgi.callable_object': 'application',\n 'mod_wsgi.handler_script': '',\n 'mod_wsgi.input_chunked': '0',\n 'mod_wsgi.listener_host': '',\n 'mod_wsgi.listener_port': '443',\n 'mod_wsgi.process_group': 'ccrb_ctrs',\n 'mod_wsgi.request_handler': 'wsgi-script',\n 'mod_wsgi.script_reloading': '1',\n 'mod_wsgi.version': (3, 3),\n 'wsgi.errors': <mod_wsgi.Log object at 0x7fcead19e930>,\n 'wsgi.file_wrapper': <built-in method file_wrapper of mod_wsgi.Adapter object at 0x7fceac647990>,\n 'wsgi.input': <mod_wsgi.Input object at 0x7fceac0a13b0>,\n 'wsgi.multiprocess': False,\n 'wsgi.multithread': True,\n 'wsgi.run_once': False,\n 'wsgi.url_scheme': 'https',\n 'wsgi.version': (1, 1)}>" |
callback | <function TrialHistoryListView at 0x7fcead89dc08> |
wrapped_callback | <function TrialHistoryListView at 0x7fcead89dc08> |
resolver | <RegexURLResolver 'ccrb_ctrs.urls' (None:None) ^/> |
callback_kwargs | {'pk': u'542'} |
response | <django.template.response.TemplateResponse object at 0x7fceadb2c110> |
urlconf | 'ccrb_ctrs.urls' |
/usr/local/lib/python2.7/dist-packages/django/template/response.py
in render
If the content has already been rendered, this is a no-op.
Returns the baked response instance.
"""
retval = self
if not self._is_rendered:
self.content = self.rendered_content...
for post_callback in self._post_render_callbacks:
newretval = post_callback(retval)
if newretval is not None:
retval = newretval
return retval
Variable | Value |
---|---|
self | <django.template.response.TemplateResponse object at 0x7fceadb2c110> |
retval | <django.template.response.TemplateResponse object at 0x7fceadb2c110> |
/usr/local/lib/python2.7/dist-packages/django/template/response.py
in rendered_content
This *does not* set the final content of the response. To set the
response content, you must either call render(), or set the
content explicitly using the value of this property.
"""
template = self.resolve_template(self.template_name)
context = self.resolve_context(self.context_data)
content = template.render(context)...
return content
def add_post_render_callback(self, callback):
"""Adds a new post-rendering callback.
If the response has already been rendered,
Variable | Value |
---|---|
self | <django.template.response.TemplateResponse object at 0x7fceadb2c110> |
context | Error in formatting: 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 |
template | <django.template.base.Template object at 0x7fceadb2cbd0> |
/usr/local/lib/python2.7/dist-packages/django/template/base.py
in render
def _render(self, context):
return self.nodelist.render(context)
def render(self, context):
"Display stage -- can be called many times"
context.render_context.push()
try:
return self._render(context)...
finally:
context.render_context.pop()
def compile_string(template_string, origin):
"Compiles template_string into NodeList ready for rendering"
Variable | Value |
---|---|
self | <django.template.base.Template object at 0x7fceadb2cbd0> |
context | Error in formatting: 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 |
/usr/local/lib/python2.7/dist-packages/django/template/base.py
in _render
def __iter__(self):
for node in self.nodelist:
for subnode in node:
yield subnode
def _render(self, context):
return self.nodelist.render(context)...
def render(self, context):
"Display stage -- can be called many times"
context.render_context.push()
try:
return self._render(context)
Variable | Value |
---|---|
self | <django.template.base.Template object at 0x7fceadb2cbd0> |
context | Error in formatting: 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 |
/usr/local/lib/python2.7/dist-packages/django/template/base.py
in render
# extend_nodelist().
contains_nontext = False
def render(self, context):
bits = []
for node in self:
if isinstance(node, Node):
bit = self.render_node(node, context)...
else:
bit = node
bits.append(force_text(bit))
return mark_safe(''.join(bits))
def get_nodes_by_type(self, nodetype):
Variable | Value |
---|---|
node | <ExtendsNode: extends "base_public.html"> |
self | [<ExtendsNode: extends "base_public.html">] |
bits | [] |
context | Error in formatting: 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 |
/usr/local/lib/python2.7/dist-packages/django/template/base.py
in render_node
"Return a list of all nodes of the given type"
nodes = []
for node in self:
nodes.extend(node.get_nodes_by_type(nodetype))
return nodes
def render_node(self, node, context):
return node.render(context)...
class TextNode(Node):
def __init__(self, s):
self.s = s
Variable | Value |
---|---|
node | <ExtendsNode: extends "base_public.html"> |
self | [<ExtendsNode: extends "base_public.html">] |
context | Error in formatting: 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 |
/usr/local/lib/python2.7/dist-packages/django/template/loader_tags.py
in render
blocks = dict((n.name, n) for n in
compiled_parent.nodelist.get_nodes_by_type(BlockNode))
block_context.add_blocks(blocks)
break
# Call Template._render explicitly so the parser context stays
# the same.
return compiled_parent._render(context)...
class IncludeNode(Node):
def __init__(self, template, *args, **kwargs):
self.template = template
self.extra_context = kwargs.pop('extra_context', {})
Variable | Value |
---|---|
node | <django.template.defaulttags.LoadNode object at 0x7fceac640b90> |
blocks | {u'body': <Block Node: body. Contents: []>, u'js': <Block Node: js. Contents: []>} |
block_context | <django.template.loader_tags.BlockContext object at 0x7fceac640590> |
context | Error in formatting: 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 |
compiled_parent | <django.template.base.Template object at 0x7fceac640350> |
self | <ExtendsNode: extends "base_public.html"> |
/usr/local/lib/python2.7/dist-packages/django/template/base.py
in _render
def __iter__(self):
for node in self.nodelist:
for subnode in node:
yield subnode
def _render(self, context):
return self.nodelist.render(context)...
def render(self, context):
"Display stage -- can be called many times"
context.render_context.push()
try:
return self._render(context)
Variable | Value |
---|---|
self | <django.template.base.Template object at 0x7fceac640350> |
context | Error in formatting: 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 |
/usr/local/lib/python2.7/dist-packages/django/template/base.py
in render
# extend_nodelist().
contains_nontext = False
def render(self, context):
bits = []
for node in self:
if isinstance(node, Node):
bit = self.render_node(node, context)...
else:
bit = node
bits.append(force_text(bit))
return mark_safe(''.join(bits))
def get_nodes_by_type(self, nodetype):
Variable | Value |
---|---|
node | <Block Node: body. Contents: []> |
bit | u'" alt="CCRB Logo" />\n \t \t \t </a>\n \t \t </p>\n </div>\n <div class="container body">\n\t ' |
bits | [u'<!DOCTYPE html>\n', u'', u'\n<html>\n <head>\n <meta charset="utf-8">\n <meta http-equiv="X-UA-Compatible" content="IE=edge">\n <meta name="viewport" content="width=device-width, initial-scale=1.0">\n <title>Centre For Clinical Research And Biostatistics (CCRB)</title>\n <!-- Bootstrap -->\n <link href="', u'/ccrb_ctrs/static/bootstrap/css/bootstrap.min.css', u'" rel="stylesheet">\n <link href="', u'/ccrb_ctrs/static/jquery-ui/jquery-ui.min.css', u'" rel="stylesheet">\n <link href="', u'/ccrb_ctrs/static/style.css', u'" rel="stylesheet">\n <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->\n <!-- WARNING: Respond.js doesn\'t work if you view the page via file:// -->\n <!--[if lt IE 9]>\n <script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>\n <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>\n <![endif]-->\n </head>\n <body>\n <div class="container header">\n \t <p class="text-center row">\n \t \t <a href="', u'/registry/', u'">\n \t \t \t <img src="', u'/ccrb_ctrs/static/images/logo.png', u'" alt="CCRB Logo" />\n \t \t \t </a>\n \t \t </p>\n </div>\n <div class="container body">\n\t '] |
self | [<Text Node: '<!DOCTYPE html> '>, <django.template.defaulttags.LoadNode object at 0x7fceac640b90>, <Text Node: ' <html> <head> <'>, <django.contrib.staticfiles.templatetags.staticfiles.StaticFilesNode object at 0x7fceac640090>, <Text Node: '" rel="stylesheet"> '>, <django.contrib.staticfiles.templatetags.staticfiles.StaticFilesNode object at 0x7fceac640650>, <Text Node: '" rel="stylesheet"> '>, <django.contrib.staticfiles.templatetags.staticfiles.StaticFilesNode object at 0x7fceac640ad0>, <Text Node: '" rel="stylesheet"> '>, <django.template.defaulttags.URLNode object at 0x7fceac640a90>, <Text Node: '"> <img sr'>, <django.contrib.staticfiles.templatetags.staticfiles.StaticFilesNode object at 0x7fceac640050>, <Text Node: '" alt="CCRB Logo" /> '>, <Block Node: body. Contents: []>, <Text Node: ' </div> <!-- '>, <django.contrib.staticfiles.templatetags.staticfiles.StaticFilesNode object at 0x7fceac640fd0>, <Text Node: '"></script> <script'>, <django.contrib.staticfiles.templatetags.staticfiles.StaticFilesNode object at 0x7fceac6409d0>, <Text Node: '"></script> <script'>, <django.contrib.staticfiles.templatetags.staticfiles.StaticFilesNode object at 0x7fceac640d50>, <Text Node: '"></script> <!-- In'>, <django.contrib.staticfiles.templatetags.staticfiles.StaticFilesNode object at 0x7fceac6407d0>, <Text Node: '"></script> '>, <Block Node: js. Contents: []>, <Text Node: ' <script> (function(i,s'>] |
context | Error in formatting: 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 |
/usr/local/lib/python2.7/dist-packages/django/template/base.py
in render_node
"Return a list of all nodes of the given type"
nodes = []
for node in self:
nodes.extend(node.get_nodes_by_type(nodetype))
return nodes
def render_node(self, node, context):
return node.render(context)...
class TextNode(Node):
def __init__(self, s):
self.s = s
Variable | Value |
---|---|
node | <Block Node: body. Contents: []> |
self | [<Text Node: '<!DOCTYPE html> '>, <django.template.defaulttags.LoadNode object at 0x7fceac640b90>, <Text Node: ' <html> <head> <'>, <django.contrib.staticfiles.templatetags.staticfiles.StaticFilesNode object at 0x7fceac640090>, <Text Node: '" rel="stylesheet"> '>, <django.contrib.staticfiles.templatetags.staticfiles.StaticFilesNode object at 0x7fceac640650>, <Text Node: '" rel="stylesheet"> '>, <django.contrib.staticfiles.templatetags.staticfiles.StaticFilesNode object at 0x7fceac640ad0>, <Text Node: '" rel="stylesheet"> '>, <django.template.defaulttags.URLNode object at 0x7fceac640a90>, <Text Node: '"> <img sr'>, <django.contrib.staticfiles.templatetags.staticfiles.StaticFilesNode object at 0x7fceac640050>, <Text Node: '" alt="CCRB Logo" /> '>, <Block Node: body. Contents: []>, <Text Node: ' </div> <!-- '>, <django.contrib.staticfiles.templatetags.staticfiles.StaticFilesNode object at 0x7fceac640fd0>, <Text Node: '"></script> <script'>, <django.contrib.staticfiles.templatetags.staticfiles.StaticFilesNode object at 0x7fceac6409d0>, <Text Node: '"></script> <script'>, <django.contrib.staticfiles.templatetags.staticfiles.StaticFilesNode object at 0x7fceac640d50>, <Text Node: '"></script> <!-- In'>, <django.contrib.staticfiles.templatetags.staticfiles.StaticFilesNode object at 0x7fceac6407d0>, <Text Node: '"></script> '>, <Block Node: js. Contents: []>, <Text Node: ' <script> (function(i,s'>] |
context | Error in formatting: 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 |
/usr/local/lib/python2.7/dist-packages/django/template/loader_tags.py
in render
push = block = block_context.pop(self.name)
if block is None:
block = self
# Create new block so we can store context without thread-safety issues.
block = type(self)(block.name, block.nodelist)
block.context = context
context['block'] = block
result = block.nodelist.render(context)...
if push is not None:
block_context.push(self.name, push)
return result
def super(self):
render_context = self.context.render_context
Variable | Value |
---|---|
push | <Block Node: body. Contents: [<Text Node: ' <ol class="breadcrumb"> '>, <django.template.defaulttags.URLNode object at 0x7fcea0118510>, <Text Node: '">CCRB Clinical Trials Re'>, <django.template.defaulttags.URLNode object at 0x7fcea0118250>, <Text Node: '">'>, <Variable Node: trial.ref_no>, <Text Node: '</a></li> <li class="ac'>, <crispy_forms.templatetags.crispy_forms_tags.CrispyFormNode object at 0x7fceadb2c310>, <Text Node: ' <div class="form-horizo'>, <Variable Node: trial.ref_no>, <Text Node: '</p> </div> </div> <'>, <Variable Node: trial.title_scientific>, <Text Node: '</p> </div> </div> <d'>, <Variable Node: trial.approval_date|date:"Y-m-d">, <Text Node: '</p> </div> </div> </d'>, <django.template.base.InclusionNode object at 0x7fceadb38250>, <Text Node: '</th> <th>'>, <django.template.base.InclusionNode object at 0x7fceadb38650>, <Text Node: '</th> <th>'>, <django.template.base.InclusionNode object at 0x7fceadb38a90>, <Text Node: '</th> <th> <'>, <For Node: for history in object_list, tail_len: 9>, <Text Node: ' </tbody> </table> '>, <django.template.base.InclusionNode object at 0x7fceadb38610>, <Text Node: ' <div> <a href="'>, <django.template.defaulttags.URLNode object at 0x7fceada51210>, <Text Node: '" class="btn btn-default"'>]> |
block_context | <django.template.loader_tags.BlockContext object at 0x7fceac640590> |
block | <Block Node: body. Contents: [<Text Node: ' <ol class="breadcrumb"> '>, <django.template.defaulttags.URLNode object at 0x7fcea0118510>, <Text Node: '">CCRB Clinical Trials Re'>, <django.template.defaulttags.URLNode object at 0x7fcea0118250>, <Text Node: '">'>, <Variable Node: trial.ref_no>, <Text Node: '</a></li> <li class="ac'>, <crispy_forms.templatetags.crispy_forms_tags.CrispyFormNode object at 0x7fceadb2c310>, <Text Node: ' <div class="form-horizo'>, <Variable Node: trial.ref_no>, <Text Node: '</p> </div> </div> <'>, <Variable Node: trial.title_scientific>, <Text Node: '</p> </div> </div> <d'>, <Variable Node: trial.approval_date|date:"Y-m-d">, <Text Node: '</p> </div> </div> </d'>, <django.template.base.InclusionNode object at 0x7fceadb38250>, <Text Node: '</th> <th>'>, <django.template.base.InclusionNode object at 0x7fceadb38650>, <Text Node: '</th> <th>'>, <django.template.base.InclusionNode object at 0x7fceadb38a90>, <Text Node: '</th> <th> <'>, <For Node: for history in object_list, tail_len: 9>, <Text Node: ' </tbody> </table> '>, <django.template.base.InclusionNode object at 0x7fceadb38610>, <Text Node: ' <div> <a href="'>, <django.template.defaulttags.URLNode object at 0x7fceada51210>, <Text Node: '" class="btn btn-default"'>]> |
context | Error in formatting: 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 |
self | <Block Node: body. Contents: []> |
/usr/local/lib/python2.7/dist-packages/django/template/base.py
in render
# extend_nodelist().
contains_nontext = False
def render(self, context):
bits = []
for node in self:
if isinstance(node, Node):
bit = self.render_node(node, context)...
else:
bit = node
bits.append(force_text(bit))
return mark_safe(''.join(bits))
def get_nodes_by_type(self, nodetype):
Variable | Value |
---|---|
node | <For Node: for history in object_list, tail_len: 9> |
bit | u'</th>\n <th> </th>\n </tr>\n </thead>\n <tbody>\n ' |
bits | [u'\n<ol class="breadcrumb">\n <li><a href="', u'/registry/public/', u'">CCRB Clinical Trials Registry, CUHK</a></li>\n <li><a href="', u'/registry/public/542', u'">', u'CUHK_CCRB00605', u'</a></li>\n <li class="active">Modification History</li>\n</ol>\n<h2>Modification History</h2>\n\n', u'\n\n<form action="compare" class="form-horizontal" method="get" ><div id="div_id_a" class="form-group"><label for="id_a" class="control-label col-sm-2 requiredField">\n Compare\n </label><div class="controls col-sm-4"><select class="select form-control" id="id_a" name="a"><option value="" selected="selected">Current Version</option><option value="2753">Version on 2022-06-02</option><option value="2743">Version on 2021-05-31</option><option value="2709">Version on 2020-05-29</option><option value="2632">Version on 2019-05-29</option><option value="2495">Version on 2019-05-29</option><option value="2494">Version on 2019-01-15</option><option value="2415">Version on 2019-01-15</option><option value="2414">Version on 2018-07-05</option><option value="2316">Version on 2018-05-02</option></select></div></div><div id="div_id_b" class="form-group"><label for="id_b" class="control-label col-sm-2 requiredField">\n with\n </label><div class="controls col-sm-4"><select class="select form-control" id="id_b" name="b"><option value="" selected="selected">Current Version</option><option value="2753">Version on 2022-06-02</option><option value="2743">Version on 2021-05-31</option><option value="2709">Version on 2020-05-29</option><option value="2632">Version on 2019-05-29</option><option value="2495">Version on 2019-05-29</option><option value="2494">Version on 2019-01-15</option><option value="2415">Version on 2019-01-15</option><option value="2414">Version on 2018-07-05</option><option value="2316">Version on 2018-05-02</option></select></div></div><div \n class="form-group" ><div class="col-sm-offset-2" class="form-actions"><button type="submit" class="btn btn-success">Compare</button> </div></div></form>\n', u'\n\n<div class="form-horizontal">\n\t<div class="form-group">\n\t\t<label class="col-sm-3 control-label">CCRBCTR Unique Trial Number</label>\n\t\t<div class="col-sm-9">\n\t\t\t<p class="form-control-static">', u'CUHK_CCRB00605', u'</p>\n\t\t</div>\n\t</div>\t\n\t<div class="form-group">\n\t\t<label class="col-sm-3 control-label">Official Scientific Title of the Study</label>\n\t\t<div class="col-sm-9">\n\t\t\t<p class="form-control-static">', u'PREhabilitation for improving QUality of recovery after ELective cardiac surgery study (PREQUEL): a randomised controlled trial', u'</p>\n\t\t</div>\n\t</div>\n\t<div class="form-group">\n\t\t<label class="col-sm-3 control-label">Trial Registration Date</label>\n\t\t<div class="col-sm-9">\n\t\t\t<p class="form-control-static">', u'2018-05-02', u'</p>\n\t\t</div>\n\t</div>\n</div>\n<table class="table table-hover table-bordered">\n <colgroup>\n <col class="col-sm-4"/> \n <col class="col-sm-4"/> \n <col class="col-sm-2"/>\n <col class="col-sm-2"/>\n </colgroup>\n\t<thead>\n <tr class="info"> \n <th>', u'\r\n<div class="btn-group pull-right">\r\n <button type="button" class="btn btn-default btn-xs dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">\r\n <span class="caret"></span>\r\n </button>\r\n <ul class="dropdown-menu">\r\n <li><a href="/registry/public/542/history?sort=trial_smodified_on&order=asc">Sort ASC</a></li>\r\n <li><a href="/registry/public/542/history?sort=trial_smodified_on&order=desc">Sort DESC</a></li>\r\n </ul>\r\n</div>\r\nUpdate Date', u'</th>\n <th>', u'\r\n<div class="btn-group pull-right">\r\n <button type="button" class="btn btn-default btn-xs dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">\r\n <span class="caret"></span>\r\n </button>\r\n <ul class="dropdown-menu">\r\n <li><a href="/registry/public/542/history?sort=recruitment_status&order=asc">Sort ASC</a></li>\r\n <li><a href="/registry/public/542/history?sort=recruitment_status&order=desc">Sort DESC</a></li>\r\n </ul>\r\n</div>\r\nRecruitment Status', u'</th>\n <th>', u'\r\n<div class="btn-group pull-right">\r\n <button type="button" class="btn btn-default btn-xs dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">\r\n <span class="caret"></span>\r\n </button>\r\n <ul class="dropdown-menu">\r\n <li><a href="/registry/public/542/history?sort=modified_by_admin&order=asc">Sort ASC</a></li>\r\n <li><a href="/registry/public/542/history?sort=modified_by_admin&order=desc">Sort DESC</a></li>\r\n </ul>\r\n</div>\r\nModified By', u'</th>\n <th> </th>\n </tr>\n </thead>\n <tbody>\n '] |
self | [<Text Node: ' <ol class="breadcrumb"> '>, <django.template.defaulttags.URLNode object at 0x7fcea0118510>, <Text Node: '">CCRB Clinical Trials Re'>, <django.template.defaulttags.URLNode object at 0x7fcea0118250>, <Text Node: '">'>, <Variable Node: trial.ref_no>, <Text Node: '</a></li> <li class="ac'>, <crispy_forms.templatetags.crispy_forms_tags.CrispyFormNode object at 0x7fceadb2c310>, <Text Node: ' <div class="form-horizo'>, <Variable Node: trial.ref_no>, <Text Node: '</p> </div> </div> <'>, <Variable Node: trial.title_scientific>, <Text Node: '</p> </div> </div> <d'>, <Variable Node: trial.approval_date|date:"Y-m-d">, <Text Node: '</p> </div> </div> </d'>, <django.template.base.InclusionNode object at 0x7fceadb38250>, <Text Node: '</th> <th>'>, <django.template.base.InclusionNode object at 0x7fceadb38650>, <Text Node: '</th> <th>'>, <django.template.base.InclusionNode object at 0x7fceadb38a90>, <Text Node: '</th> <th> <'>, <For Node: for history in object_list, tail_len: 9>, <Text Node: ' </tbody> </table> '>, <django.template.base.InclusionNode object at 0x7fceadb38610>, <Text Node: ' <div> <a href="'>, <django.template.defaulttags.URLNode object at 0x7fceada51210>, <Text Node: '" class="btn btn-default"'>] |
context | Error in formatting: 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 |
/usr/local/lib/python2.7/dist-packages/django/template/base.py
in render_node
"Return a list of all nodes of the given type"
nodes = []
for node in self:
nodes.extend(node.get_nodes_by_type(nodetype))
return nodes
def render_node(self, node, context):
return node.render(context)...
class TextNode(Node):
def __init__(self, s):
self.s = s
Variable | Value |
---|---|
node | <For Node: for history in object_list, tail_len: 9> |
self | [<Text Node: ' <ol class="breadcrumb"> '>, <django.template.defaulttags.URLNode object at 0x7fcea0118510>, <Text Node: '">CCRB Clinical Trials Re'>, <django.template.defaulttags.URLNode object at 0x7fcea0118250>, <Text Node: '">'>, <Variable Node: trial.ref_no>, <Text Node: '</a></li> <li class="ac'>, <crispy_forms.templatetags.crispy_forms_tags.CrispyFormNode object at 0x7fceadb2c310>, <Text Node: ' <div class="form-horizo'>, <Variable Node: trial.ref_no>, <Text Node: '</p> </div> </div> <'>, <Variable Node: trial.title_scientific>, <Text Node: '</p> </div> </div> <d'>, <Variable Node: trial.approval_date|date:"Y-m-d">, <Text Node: '</p> </div> </div> </d'>, <django.template.base.InclusionNode object at 0x7fceadb38250>, <Text Node: '</th> <th>'>, <django.template.base.InclusionNode object at 0x7fceadb38650>, <Text Node: '</th> <th>'>, <django.template.base.InclusionNode object at 0x7fceadb38a90>, <Text Node: '</th> <th> <'>, <For Node: for history in object_list, tail_len: 9>, <Text Node: ' </tbody> </table> '>, <django.template.base.InclusionNode object at 0x7fceadb38610>, <Text Node: ' <div> <a href="'>, <django.template.defaulttags.URLNode object at 0x7fceada51210>, <Text Node: '" class="btn btn-default"'>] |
context | Error in formatting: 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 |
/usr/local/lib/python2.7/dist-packages/django/template/defaulttags.py
in render
values = self.sequence.resolve(context, True)
except VariableDoesNotExist:
values = []
if values is None:
values = []
if not hasattr(values, '__len__'):
values = list(values)
len_values = len(values)...
if len_values < 1:
return self.nodelist_empty.render(context)
nodelist = []
if self.is_reversed:
values = reversed(values)
unpack = len(self.loopvars) > 1
Variable | Value |
---|---|
parentloop | {} |
self | <For Node: for history in object_list, tail_len: 9> |
values | Error in formatting: 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 |
context | Error in formatting: 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 |
/usr/local/lib/python2.7/dist-packages/django/db/models/query.py
in __len__
def __repr__(self):
data = list(self[:REPR_OUTPUT_SIZE + 1])
if len(data) > REPR_OUTPUT_SIZE:
data[-1] = "...(remaining elements truncated)..."
return repr(data)
def __len__(self):
self._fetch_all()...
return len(self._result_cache)
def __iter__(self):
"""
The queryset iterator protocol uses three nested iterators in the
default case:
Variable | Value |
---|---|
self | Error in formatting: 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 |
/usr/local/lib/python2.7/dist-packages/django/db/models/query.py
in _fetch_all
c.__dict__.update(kwargs)
if setup and hasattr(c, '_setup_query'):
c._setup_query()
return c
def _fetch_all(self):
if self._result_cache is None:
self._result_cache = list(self.iterator())...
if self._prefetch_related_lookups and not self._prefetch_done:
self._prefetch_related_objects()
def _next_is_sticky(self):
"""
Indicates that the next filter call and the one following that should
Variable | Value |
---|---|
self | Error in formatting: 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 |
/usr/local/lib/python2.7/dist-packages/django/db/models/query.py
in iterator
# Cache db and model outside the loop
db = self.db
model = self.model
compiler = self.query.get_compiler(using=db)
if fill_cache:
klass_info = get_klass_info(model, max_depth=max_depth,
requested=requested, only_load=only_load)
for row in compiler.results_iter():...
if fill_cache:
obj, _ = get_cached_row(row, index_start, db, klass_info,
offset=len(aggregate_select))
else:
# Omit aggregates in object creation.
row_data = row[index_start:aggregate_start]
Variable | Value |
---|---|
requested | None |
fill_cache | False |
aggregate_select | [] |
skip | None |
self | Error in formatting: 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 |
load_fields | [] |
db | 'default' |
index_start | 0 |
extra_select | [] |
fields | [<django.db.models.fields.AutoField: id>, <django.db.models.fields.related.ForeignKey: created_by>, <django.db.models.fields.DateTimeField: created_on>, <django.db.models.fields.related.ForeignKey: modified_by>, <django.db.models.fields.DateTimeField: modified_on>, <django.db.models.fields.CharField: ref_no>, <django.db.models.fields.TextField: ref_no_extra>, <django.db.models.fields.DateTimeField: register_date>, <django.db.models.fields.DateTimeField: submission_date>, <django.db.models.fields.DateTimeField: approval_date>, <django.db.models.fields.CharField: funding_source>, <django.db.models.fields.CharField: sponsor_primary>, <django.db.models.fields.CharField: sponsor_secondary>, <django.db.models.fields.related.ForeignKey: sponsor_relation>, <django.db.models.fields.CharField: sponsor_relation_other>, <django.db.models.fields.CharField: contact_person_name>, <django.db.models.fields.TextField: contact_person_address>, <django.db.models.fields.CharField: contact_person_phone>, <django.db.models.fields.EmailField: contact_person_email>, <django.db.models.fields.CharField: contact_person_affiliation>, <django.db.models.fields.CharField: contact_person_country>, <django.db.models.fields.CharField: research_contact_person_name>, <django.db.models.fields.TextField: research_contact_person_address>, <django.db.models.fields.CharField: research_contact_person_phone>, <django.db.models.fields.EmailField: research_contact_person_email>, <django.db.models.fields.CharField: research_contact_person_affiliation>, <django.db.models.fields.CharField: research_contact_person_country>, <django.db.models.fields.CharField: title_scientific>, <django.db.models.fields.CharField: title_short>, <django.db.models.fields.CharField: title_public>, <django.db.models.fields.CharField: title_chinese>, <django.db.models.fields.CharField: recruitment_location>, <django.db.models.fields.BooleanField: ethical_review_approved>, <django.db.models.fields.related.ForeignKey: ethical_review_approval_organization>, <django.db.models.fields.CharField: ethical_review_approval_organization_other>, <django.db.models.fields.DateField: ethical_review_approval_date>, <django.db.models.fields.CharField: ethical_review_approval_ref_no>, <django.db.models.fields.CharField: study_medical_condition>, <django.db.models.fields.related.ForeignKey: intervention_type>, <django.db.models.fields.CharField: intervention_type_other>, <django.db.models.fields.TextField: intervention_description>, <django.db.models.fields.CharField: intervention_dosage_form>, <django.db.models.fields.CharField: intervention_dosage>, <django.db.models.fields.CharField: intervention_frequency>, <django.db.models.fields.CharField: intervention_duration>, <django.db.models.fields.TextField: treatment_description>, <django.db.models.fields.CharField: treatment_dosage_form>, <django.db.models.fields.CharField: treatment_dosage>, <django.db.models.fields.CharField: treatment_frequency>, <django.db.models.fields.CharField: treatment_duration>, <django.db.models.fields.TextField: criteria_inclusion>, <django.db.models.fields.TextField: criteria_exclusion>, <django.db.models.fields.CharField: criteria_age_min>, <django.db.models.fields.CharField: criteria_age_max>, <django.db.models.fields.related.ForeignKey: criteria_gender>, <django.db.models.fields.related.ForeignKey: study_type>, <django.db.models.fields.related.ForeignKey: study_randomization>, <django.db.models.fields.CharField: study_randomization_randomized>, <django.db.models.fields.related.ForeignKey: study_control>, <django.db.models.fields.related.ForeignKey: study_masking>, <django.db.models.fields.related.ForeignKey: study_masking_party>, <django.db.models.fields.related.ForeignKey: study_group_assignment>, <django.db.models.fields.DateField: study_start_date>, <django.db.models.fields.CharField: study_sample_size>, <django.db.models.fields.related.ForeignKey: study_phase>, <django.db.models.fields.CharField: study_phase_other>, <django.db.models.fields.CharField: study_objective>, <django.db.models.fields.related.ForeignKey: recruitment_status>, <django.db.models.fields.BooleanField: recruitment_publication_available>, <django.db.models.fields.URLField: recruitment_publication_link>, <django.db.models.fields.BooleanField: publication_available>, <django.db.models.fields.URLField: publication_link>, <django.db.models.fields.TextField: outcome_primary>, <django.db.models.fields.TextField: outcome_secondary>, <django.db.models.fields.BooleanField: migration_data>, <django.db.models.fields.CharField: chictr_ref_no>, <django.db.models.fields.DateField: chictr_register_date>, <django.db.models.fields.related.ForeignKey: status>, <django.db.models.fields.related.ForeignKey: trial>, <django.db.models.fields.related.ForeignKey: trial_created_by>, <django.db.models.fields.DateTimeField: trial_created_on>, <django.db.models.fields.related.ForeignKey: trial_modified_by>, <django.db.models.fields.DateTimeField: trial_modified_on>, <django.db.models.fields.BooleanField: modified_by_admin>] |
aggregate_start | 84 |
model | <class 'trials.models.TrialHistory'> |
only_load | {} |
max_depth | 5 |
compiler | <django.db.backends.mysql.compiler.SQLCompiler object at 0x7fceac640610> |
/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py
in results_iter
def results_iter(self):
"""
Returns an iterator over the results from executing this query.
"""
resolve_columns = hasattr(self, 'resolve_columns')
fields = None
has_aggregate_select = bool(self.query.aggregate_select)
for rows in self.execute_sql(MULTI):...
for row in rows:
if has_aggregate_select:
loaded_fields = self.query.get_loaded_field_names().get(self.query.model, set()) or self.query.select
aggregate_start = len(self.query.extra_select) + len(loaded_fields)
aggregate_end = aggregate_start + len(self.query.aggregate_select)
if resolve_columns:
Variable | Value |
---|---|
fields | None |
self | <django.db.backends.mysql.compiler.SQLCompiler object at 0x7fceac640610> |
has_aggregate_select | False |
resolve_columns | True |
/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py
in execute_sql
subclasses such as InsertQuery). It's possible, however, that no query
is needed, as the filters describe an empty set. In that case, None is
returned, to avoid any unnecessary database interaction.
"""
if not result_type:
result_type = NO_RESULTS
try:
sql, params = self.as_sql()...
if not sql:
raise EmptyResultSet
except EmptyResultSet:
if result_type == MULTI:
return iter([])
else:
Variable | Value |
---|---|
self | <django.db.backends.mysql.compiler.SQLCompiler object at 0x7fceac640610> |
result_type | 'multi' |
/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py
in as_sql
# After executing the query, we must get rid of any joins the query
# setup created. So, take note of alias counts before the query ran.
# However we do not want to get rid of stuff done in pre_sql_setup(),
# as the pre_sql_setup will modify query state in a way that forbids
# another run of it.
self.refcounts_before = self.query.alias_refcount.copy()
out_cols, s_params = self.get_columns(with_col_aliases)
ordering, o_params, ordering_group_by = self.get_ordering()...
distinct_fields = self.get_distinct()
# This must come after 'select', 'ordering' and 'distinct' -- see
# docstring of get_from_clause() for details.
from_, f_params = self.get_from_clause()
Variable | Value |
---|---|
s_params | [] |
with_col_aliases | False |
with_limits | True |
self | <django.db.backends.mysql.compiler.SQLCompiler object at 0x7fceac640610> |
out_cols | [u'`trials_trial_history`.`id`', u'`trials_trial_history`.`created_by`', u'`trials_trial_history`.`created_on`', u'`trials_trial_history`.`modified_by`', u'`trials_trial_history`.`modified_on`', u'`trials_trial_history`.`ref_no`', u'`trials_trial_history`.`ref_no_extra`', u'`trials_trial_history`.`register_date`', u'`trials_trial_history`.`submission_date`', u'`trials_trial_history`.`approval_date`', u'`trials_trial_history`.`funding_source`', u'`trials_trial_history`.`sponsor_primary`', u'`trials_trial_history`.`sponsor_secondary`', u'`trials_trial_history`.`sponsor_relation`', u'`trials_trial_history`.`sponsor_relation_other`', u'`trials_trial_history`.`contact_person_name`', u'`trials_trial_history`.`contact_person_address`', u'`trials_trial_history`.`contact_person_phone`', u'`trials_trial_history`.`contact_person_email`', u'`trials_trial_history`.`contact_person_affiliation`', u'`trials_trial_history`.`contact_person_country`', u'`trials_trial_history`.`research_contact_person_name`', u'`trials_trial_history`.`research_contact_person_address`', u'`trials_trial_history`.`research_contact_person_phone`', u'`trials_trial_history`.`research_contact_person_email`', u'`trials_trial_history`.`research_contact_person_affiliation`', u'`trials_trial_history`.`research_contact_person_country`', u'`trials_trial_history`.`title_scientific`', u'`trials_trial_history`.`title_short`', u'`trials_trial_history`.`title_public`', u'`trials_trial_history`.`title_chinese`', u'`trials_trial_history`.`recruitment_location`', u'`trials_trial_history`.`ethical_review_approved`', u'`trials_trial_history`.`ethical_review_approval_organization`', u'`trials_trial_history`.`ethical_review_approval_organization_other`', u'`trials_trial_history`.`ethical_review_approval_date`', u'`trials_trial_history`.`ethical_review_approval_ref_no`', u'`trials_trial_history`.`study_medical_condition`', u'`trials_trial_history`.`intervention_type`', u'`trials_trial_history`.`intervention_type_other`', u'`trials_trial_history`.`intervention_description`', u'`trials_trial_history`.`intervention_dosage_form`', u'`trials_trial_history`.`intervention_dosage`', u'`trials_trial_history`.`intervention_frequency`', u'`trials_trial_history`.`intervention_duration`', u'`trials_trial_history`.`treatment_description`', u'`trials_trial_history`.`treatment_dosage_form`', u'`trials_trial_history`.`treatment_dosage`', u'`trials_trial_history`.`treatment_frequency`', u'`trials_trial_history`.`treatment_duration`', u'`trials_trial_history`.`criteria_inclusion`', u'`trials_trial_history`.`criteria_exclusion`', u'`trials_trial_history`.`criteria_age_min`', u'`trials_trial_history`.`criteria_age_max`', u'`trials_trial_history`.`criteria_gender`', u'`trials_trial_history`.`study_type`', u'`trials_trial_history`.`study_randomization`', u'`trials_trial_history`.`study_randomization_randomized`', u'`trials_trial_history`.`study_control`', u'`trials_trial_history`.`study_masking`', u'`trials_trial_history`.`study_masking_party`', u'`trials_trial_history`.`study_group_assignment`', u'`trials_trial_history`.`study_start_date`', u'`trials_trial_history`.`study_sample_size`', u'`trials_trial_history`.`study_phase`', u'`trials_trial_history`.`study_phase_other`', u'`trials_trial_history`.`study_objective`', u'`trials_trial_history`.`recruitment_status`', u'`trials_trial_history`.`recruitment_publication_available`', u'`trials_trial_history`.`recruitment_publication_link`', u'`trials_trial_history`.`publication_available`', u'`trials_trial_history`.`publication_link`', u'`trials_trial_history`.`outcome_primary`', u'`trials_trial_history`.`outcome_secondary`', u'`trials_trial_history`.`migration_data`', u'`trials_trial_history`.`chictr_ref_no`', u'`trials_trial_history`.`chictr_register_date`', u'`trials_trial_history`.`status`', u'`trials_trial_history`.`trial_id`', u'`trials_trial_history`.`trial_created_by`', u'`trials_trial_history`.`trial_created_on`', u'`trials_trial_history`.`trial_modified_by`', u'`trials_trial_history`.`trial_modified_on`', u'`trials_trial_history`.`modified_by_admin`'] |
/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py
in get_ordering
if not must_append_to_select or elt in select_aliases:
result.append('%s %s' % (elt, order))
group_by.append((elt, []))
elif not self.query._extra or get_order_dir(field)[0] not in self.query._extra:
# 'col' is of the form 'field' or 'field1__field2' or
# '-field1__field2__field', etc.
for table, cols, order in self.find_ordering_name(field,
self.query.get_meta(), default_order=asc):...
for col in cols:
if (table, col) not in processed_pairs:
elt = '%s.%s' % (qn(table), qn2(col))
processed_pairs.add((table, col))
if must_append_to_select and elt not in select_aliases:
ordering_aliases.append(elt)
Variable | Value |
---|---|
qn2 | <bound method DatabaseOperations.quote_name of <django.db.backends.mysql.base.DatabaseOperations object at 0x7fceac640e90>> |
field | u'-trial_smodified_on' |
distinct | False |
col | u'trial_smodified_on' |
self | <django.db.backends.mysql.compiler.SQLCompiler object at 0x7fceac640610> |
select_aliases | set([u'`trials_trial_history`.`approval_date`', u'`trials_trial_history`.`chictr_ref_no`', u'`trials_trial_history`.`chictr_register_date`', u'`trials_trial_history`.`contact_person_address`', u'`trials_trial_history`.`contact_person_affiliation`', u'`trials_trial_history`.`contact_person_country`', u'`trials_trial_history`.`contact_person_email`', u'`trials_trial_history`.`contact_person_name`', u'`trials_trial_history`.`contact_person_phone`', u'`trials_trial_history`.`created_by`', u'`trials_trial_history`.`created_on`', u'`trials_trial_history`.`criteria_age_max`', u'`trials_trial_history`.`criteria_age_min`', u'`trials_trial_history`.`criteria_exclusion`', u'`trials_trial_history`.`criteria_gender`', u'`trials_trial_history`.`criteria_inclusion`', u'`trials_trial_history`.`ethical_review_approval_date`', u'`trials_trial_history`.`ethical_review_approval_organization_other`', u'`trials_trial_history`.`ethical_review_approval_organization`', u'`trials_trial_history`.`ethical_review_approval_ref_no`', u'`trials_trial_history`.`ethical_review_approved`', u'`trials_trial_history`.`funding_source`', u'`trials_trial_history`.`id`', u'`trials_trial_history`.`intervention_description`', u'`trials_trial_history`.`intervention_dosage_form`', u'`trials_trial_history`.`intervention_dosage`', u'`trials_trial_history`.`intervention_duration`', u'`trials_trial_history`.`intervention_frequency`', u'`trials_trial_history`.`intervention_type_other`', u'`trials_trial_history`.`intervention_type`', u'`trials_trial_history`.`migration_data`', u'`trials_trial_history`.`modified_by_admin`', u'`trials_trial_history`.`modified_by`', u'`trials_trial_history`.`modified_on`', u'`trials_trial_history`.`outcome_primary`', u'`trials_trial_history`.`outcome_secondary`', u'`trials_trial_history`.`publication_available`', u'`trials_trial_history`.`publication_link`', u'`trials_trial_history`.`recruitment_location`', u'`trials_trial_history`.`recruitment_publication_available`', u'`trials_trial_history`.`recruitment_publication_link`', u'`trials_trial_history`.`recruitment_status`', u'`trials_trial_history`.`ref_no_extra`', u'`trials_trial_history`.`ref_no`', u'`trials_trial_history`.`register_date`', u'`trials_trial_history`.`research_contact_person_address`', u'`trials_trial_history`.`research_contact_person_affiliation`', u'`trials_trial_history`.`research_contact_person_country`', u'`trials_trial_history`.`research_contact_person_email`', u'`trials_trial_history`.`research_contact_person_name`', u'`trials_trial_history`.`research_contact_person_phone`', u'`trials_trial_history`.`sponsor_primary`', u'`trials_trial_history`.`sponsor_relation_other`', u'`trials_trial_history`.`sponsor_relation`', u'`trials_trial_history`.`sponsor_secondary`', u'`trials_trial_history`.`status`', u'`trials_trial_history`.`study_control`', u'`trials_trial_history`.`study_group_assignment`', u'`trials_trial_history`.`study_masking_party`', u'`trials_trial_history`.`study_masking`', u'`trials_trial_history`.`study_medical_condition`', u'`trials_trial_history`.`study_objective`', u'`trials_trial_history`.`study_phase_other`', u'`trials_trial_history`.`study_phase`', u'`trials_trial_history`.`study_randomization_randomized`', u'`trials_trial_history`.`study_randomization`', u'`trials_trial_history`.`study_sample_size`', u'`trials_trial_history`.`study_start_date`', u'`trials_trial_history`.`study_type`', u'`trials_trial_history`.`submission_date`', u'`trials_trial_history`.`title_chinese`', u'`trials_trial_history`.`title_public`', u'`trials_trial_history`.`title_scientific`', u'`trials_trial_history`.`title_short`', u'`trials_trial_history`.`treatment_description`', u'`trials_trial_history`.`treatment_dosage_form`', u'`trials_trial_history`.`treatment_dosage`', u'`trials_trial_history`.`treatment_duration`', u'`trials_trial_history`.`treatment_frequency`', u'`trials_trial_history`.`trial_created_by`', u'`trials_trial_history`.`trial_created_on`', u'`trials_trial_history`.`trial_id`', u'`trials_trial_history`.`trial_modified_by`', u'`trials_trial_history`.`trial_modified_on`']) |
ordering_aliases | [] |
pos | 0 |
asc | 'ASC' |
processed_pairs | set() |
ordering | [u'-trial_smodified_on'] |
group_by | [] |
must_append_to_select | False |
result | [] |
ordering_params | [] |
params | [] |
desc | 'DESC' |
order | 'DESC' |
qn | <django.db.backends.mysql.compiler.SQLCompiler object at 0x7fceac640610> |
/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py
in find_ordering_name
"""
Returns the table alias (the name might be ambiguous, the alias will
not be) and column name for ordering by the given 'name' parameter.
The 'name' is of the form 'field1__field2__...__fieldN'.
"""
name, order = get_order_dir(name, default_order)
pieces = name.split(LOOKUP_SEP)
field, targets, alias, joins, path, opts = self._setup_joins(pieces, opts, alias)...
# If we get to this point and the field is a relation to another model,
# append the default ordering for that model unless the attribute name
# of the field is specified.
if field.rel and path and opts.ordering and name != field.attname:
# Firstly, avoid infinite loops.
Variable | Value |
---|---|
name | u'trial_smodified_on' |
default_order | 'ASC' |
self | <django.db.backends.mysql.compiler.SQLCompiler object at 0x7fceac640610> |
pieces | [u'trial_smodified_on'] |
alias | None |
opts | <Options for TrialHistory> |
order | 'DESC' |
already_seen | None |
/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py
in _setup_joins
Note that get_ordering and get_distinct must produce same target
columns on same input, as the prefixes of get_ordering and get_distinct
must match. Executing SQL where this is not true is an error.
"""
if not alias:
alias = self.query.get_initial_alias()
field, targets, opts, joins, path = self.query.setup_joins(
pieces, opts, alias)...
alias = joins[-1]
return field, targets, alias, joins, path, opts
def get_from_clause(self):
"""
Returns a list of strings that are joined together to go after the
Variable | Value |
---|---|
alias | 'trials_trial_history' |
self | <django.db.backends.mysql.compiler.SQLCompiler object at 0x7fceac640610> |
opts | <Options for TrialHistory> |
pieces | [u'trial_smodified_on'] |
/usr/local/lib/python2.7/dist-packages/django/db/models/sql/query.py
in setup_joins
that value. Final field is needed for example in some value
conversions (convert 'obj' in fk__id=obj to pk val using the foreign
key field for example).
"""
joins = [alias]
# First, generate the path for the names
path, final_field, targets, rest = self.names_to_path(
names, opts, allow_many, fail_on_missing=True)...
# Then, add the path to the query's joins. Note that we can't trim
# joins at this stage - we will need the information about join type
# of the trimmed joins.
for pos, join in enumerate(path):
opts = join.to_opts
Variable | Value |
---|---|
self | <django.db.models.sql.query.Query object at 0x7fcea00fb810> |
alias | 'trials_trial_history' |
names | [u'trial_smodified_on'] |
joins | ['trials_trial_history'] |
can_reuse | None |
allow_many | True |
opts | <Options for TrialHistory> |
/usr/local/lib/python2.7/dist-packages/django/db/models/sql/query.py
in names_to_path
names_with_path.append(cur_names_with_path)
else:
# Local non-relational field.
final_field = field
targets = (field,)
break
if pos == -1 or (fail_on_missing and pos + 1 != len(names)):
self.raise_field_error(opts, name)...
return path, final_field, targets, names[pos + 1:]
def raise_field_error(self, opts, name):
available = opts.get_all_field_names() + list(self.aggregate_select)
raise FieldError("Cannot resolve keyword %r into field. "
"Choices are: %s" % (name, ", ".join(available)))
Variable | Value |
---|---|
name | u'trial_smodified_on' |
self | <django.db.models.sql.query.Query object at 0x7fcea00fb810> |
pos | -1 |
names | [u'trial_smodified_on'] |
fail_on_missing | True |
path | [] |
cur_names_with_path | (u'trial_smodified_on', []) |
names_with_path | [] |
allow_many | True |
opts | <Options for TrialHistory> |
/usr/local/lib/python2.7/dist-packages/django/db/models/sql/query.py
in raise_field_error
if pos == -1 or (fail_on_missing and pos + 1 != len(names)):
self.raise_field_error(opts, name)
return path, final_field, targets, names[pos + 1:]
def raise_field_error(self, opts, name):
available = opts.get_all_field_names() + list(self.aggregate_select)
raise FieldError("Cannot resolve keyword %r into field. "
"Choices are: %s" % (name, ", ".join(available)))...
def setup_joins(self, names, opts, alias, can_reuse=None, allow_many=True):
"""
Compute the necessary table joins for the passage through the fields
given in 'names'. 'opts' is the Options class for the current model
(which gives the table we are starting from), 'alias' is the alias for
Variable | Value |
---|---|
available | ['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', u'created_by_id', 'created_on', 'criteria_age_max', 'criteria_age_min', 'criteria_exclusion', 'criteria_gender', u'criteria_gender_id', 'criteria_inclusion', 'ethical_review_approval_date', 'ethical_review_approval_organization', u'ethical_review_approval_organization_id', 'ethical_review_approval_organization_other', 'ethical_review_approval_ref_no', 'ethical_review_approved', 'funding_source', u'id', 'intervention_description', 'intervention_dosage', 'intervention_dosage_form', 'intervention_duration', 'intervention_frequency', 'intervention_type', u'intervention_type_id', 'intervention_type_other', 'migration_data', 'modified_by', 'modified_by_admin', u'modified_by_id', 'modified_on', 'outcome_primary', 'outcome_secondary', 'publication_available', 'publication_link', 'recruitment_location', 'recruitment_publication_available', 'recruitment_publication_link', 'recruitment_status', u'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', u'sponsor_relation_id', 'sponsor_relation_other', 'sponsor_secondary', 'status', u'status_id', 'study_control', u'study_control_id', 'study_group_assignment', u'study_group_assignment_id', 'study_masking', u'study_masking_id', 'study_masking_party', u'study_masking_party_id', 'study_medical_condition', 'study_objective', 'study_phase', u'study_phase_id', 'study_phase_other', 'study_randomization', u'study_randomization_id', 'study_randomization_randomized', 'study_sample_size', 'study_start_date', 'study_type', u'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', u'trial_created_by_id', 'trial_created_on', u'trial_id', 'trial_modified_by', u'trial_modified_by_id', 'trial_modified_on'] |
self | <django.db.models.sql.query.Query object at 0x7fcea00fb810> |
name | u'trial_smodified_on' |
opts | <Options for TrialHistory> |
Variable | Value |
---|---|
sort | u'trial_smodified_on' |
order | u'desc' |
No POST data
No FILES data
No cookie data
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/542/history' |
SERVER_PROTOCOL | 'HTTP/1.1' |
QUERY_STRING | 'sort=trial_smodified_on&order=desc' |
SSL_TLS_SNI | 'www2.ccrb.cuhk.edu.hk' |
HTTP_USER_AGENT | 'claudebot' |
SERVER_NAME | 'www2.ccrb.cuhk.edu.hk' |
REMOTE_ADDR | '54.160.133.33' |
mod_wsgi.request_handler | 'wsgi-script' |
wsgi.url_scheme | 'https' |
PATH_TRANSLATED | '/var/www/html/public/542/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/542/history' |
wsgi.input | <mod_wsgi.Input object at 0x7fceac0a13b0> |
HTTP_HOST | 'www2.ccrb.cuhk.edu.hk' |
SCRIPT_URL | '/registry/public/542/history' |
HTTPS | '1' |
wsgi.multithread | True |
mod_wsgi.callable_object | 'application' |
REQUEST_URI | '/registry/public/542/history?sort=trial_smodified_on&order=desc' |
HTTP_ACCEPT | '*/*' |
wsgi.version | (1, 1) |
GATEWAY_INTERFACE | 'CGI/1.1' |
wsgi.run_once | False |
wsgi.errors | <mod_wsgi.Log object at 0x7fcead19e930> |
REMOTE_PORT | '39928' |
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'XQf3J98BOkB2A4IzttOII1gjtcoQgqel' |
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.