4fFc6UiT

1
2projetoinfodengue@gmail.com
310:25 (há 41 minutos)
4para eu
5
6Internal Server Error: /report/SP/202001
7
8TypeError at /report/SP/202001
9sequence item 18: expected str instance, NoneType found
10
11Request Method: GET
12Request URL: http://info.dengue.mat.br/report/SP/202001
13Django Version: 2.2.8
14Python Executable: /opt/miniconda/bin/python
15Python Version: 3.7.6
16Python Path: ['/srv/deploy/AlertaDengue', '/srv/deploy/AlertaDengue', '/opt/miniconda/bin', '/opt/miniconda/lib/python37.zip', '/opt/miniconda/lib/python3.7', '/opt/miniconda/lib/python3.7/lib-dynload', '/opt/miniconda/lib/python3.7/site-packages', '/opt/miniconda/lib/python3.7/site-packages/IPython/extensions']
17Server time: Sex, 24 Jan 2020 12:25:49 +0000
18
19Installed Applications:
20('django.contrib.admin',
21 'django.contrib.admindocs',
22 'django.contrib.auth',
23 'django.contrib.contenttypes',
24 'django.contrib.sessions',
25 'django.contrib.messages',
26 'django.contrib.staticfiles',
27 'django.contrib.humanize',
28 'leaflet',
29 'bootstrap4',
30 'chunked_upload',
31 'dados',
32 'gis',
33 'forecast',
34 'dbf.apps.DbfConfig',
35 'api',
36 'manager.router')
37Installed Middleware:
38('django.middleware.gzip.GZipMiddleware',
39 'django.contrib.sessions.middleware.SessionMiddleware',
40 'django.middleware.locale.LocaleMiddleware',
41 'django.middleware.common.CommonMiddleware',
42 'django.middleware.csrf.CsrfViewMiddleware',
43 'django.contrib.auth.middleware.AuthenticationMiddleware',
44 'django.contrib.messages.middleware.MessageMiddleware',
45 'django.middleware.clickjacking.XFrameOptionsMiddleware')
46
47
48Traceback:
49
50File "/opt/miniconda/lib/python3.7/site-packages/django/core/handlers/exception.py" in inner
51  34.             response = get_response(request)
52
53File "/opt/miniconda/lib/python3.7/site-packages/django/core/handlers/base.py" in _get_response
54  115.                 response = self.process_exception_by_middleware(e, request)
55
56File "/opt/miniconda/lib/python3.7/site-packages/django/core/handlers/base.py" in _get_response
57  113.                 response = wrapped_callback(request, *callback_args, **callback_kwargs)
58
59File "/opt/miniconda/lib/python3.7/site-packages/django/views/generic/base.py" in view
60  71.             return self.dispatch(request, *args, **kwargs)
61
62File "/opt/miniconda/lib/python3.7/site-packages/django/views/generic/base.py" in dispatch
63  97.         return handler(request, *args, **kwargs)
64
65File "/opt/miniconda/lib/python3.7/site-packages/django/views/generic/base.py" in get
66  158.         context = self.get_context_data(**kwargs)
67
68File "/srv/deploy/AlertaDengue/dados/views.py" in get_context_data
69  1438.                 var_climate=var_climate,
70
71File "/srv/deploy/AlertaDengue/dados/dbdata.py" in read_disease_data
72  1399.         sql = ' SELECT {} FROM ({}) AS data'.format(','.join(k), sql)
73
74Exception Type: TypeError at /report/SP/202001
75Exception Value: sequence item 18: expected str instance, NoneType found
76Request information:
77USER: esloch
78
79GET: No GET data
80
81POST: No POST data
82
83FILES: No FILES data
84
85COOKIES:
86_ga = 'GA1.3.501539528.1577748163'
87csrftoken = 'WF6rxOpKyMRnETlF8rag3xA2y01yWfAPT1EuWBLprOOnGPmvkAW1DD8Uh4XraXDb'
88sessionid = 'q3ymajwmibny3dzw72djgm3fcwi8eyxw'
89_gid = 'GA1.3.2108761760.1579818502'
90_gat = '1'
91
92META:
93CSRF_COOKIE = 'WF6rxOpKyMRnETlF8rag3xA2y01yWfAPT1EuWBLprOOnGPmvkAW1DD8Uh4XraXDb'
94HTTP_ACCEPT = 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3'
95HTTP_ACCEPT_ENCODING = 'gzip, deflate, br'
96HTTP_ACCEPT_LANGUAGE = 'pt-BR,pt;q=0.9,en-US;q=0.8,en;q=0.7'
97HTTP_CONNECTION = 'close'
98HTTP_COOKIE = '_ga=GA1.3.501539528.1577748163; csrftoken=WF6rxOpKyMRnETlF8rag3xA2y01yWfAPT1EuWBLprOOnGPmvkAW1DD8Uh4XraXDb; sessionid=q3ymajwmibny3dzw72djgm3fcwi8eyxw; _gid=GA1.3.2108761760.1579818502; _gat=1'
99HTTP_HOST = 'info.dengue.mat.br'
100HTTP_REFERER = 'https://info.dengue.mat.br/report/SP/state'
101HTTP_SEC_FETCH_MODE = 'navigate'
102HTTP_SEC_FETCH_SITE = 'same-origin'
103HTTP_SEC_FETCH_USER = '?1'
104HTTP_UPGRADE_INSECURE_REQUESTS = '1'
105HTTP_USER_AGENT = 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36'
106HTTP_X_FORWARDED_FOR = '177.74.213.65'
107HTTP_X_REAL_IP = '177.74.213.65'
108PATH_INFO = '/report/SP/202001'
109QUERY_STRING = ''
110RAW_URI = '/report/SP/202001'
111REMOTE_ADDR = '172.19.0.1'
112REMOTE_PORT = '48205'
113REQUEST_METHOD = 'GET'
114SCRIPT_NAME = ''
115SERVER_NAME = '0.0.0.0'
116SERVER_PORT = '8000'
117SERVER_PROTOCOL = 'HTTP/1.0'
118SERVER_SOFTWARE = 'gunicorn/20.0.4'
119gunicorn.socket = <socket.socket fd=9, family=AddressFamily.AF_INET, type=SocketKind.SOCK_STREAM, proto=0, laddr=('172.19.0.3', 8000), raddr=('172.19.0.1', 48205)>
120wsgi.errors = <gunicorn.http.wsgi.WSGIErrorsWrapper object at 0x7f2e507eb990>
121wsgi.file_wrapper = ''
122wsgi.input = <gunicorn.http.body.Body object at 0x7f2e507eb950>
123wsgi.input_terminated = True
124wsgi.multiprocess = True
125wsgi.multithread = False
126wsgi.run_once = False
127wsgi.url_scheme = 'http'
128wsgi.version = '(1, 0)'
129
130Settings:
131Using settings module AlertaDengue.settings
132ABSOLUTE_URL_OVERRIDES = {}
133ADMINS = [('Sandro', 'es.loch@gmail.com')]
134ALLOWED_HOSTS = ['info.dengue.mat.br', 'alerta.dengue.mat.br']
135APPEND_SLASH = True
136AUTHENTICATION_BACKENDS = ['django.contrib.auth.backends.ModelBackend']
137AUTH_PASSWORD_VALIDATORS = '********************'
138AUTH_USER_MODEL = 'auth.User'
139BASE_DIR = '/srv/deploy/AlertaDengue'
140BOOTSTRAP4 = {'form_renderers': {'default': 'dbf.forms.FormRendererWithHiddenFieldErrors'}}
141CACHES = {'default': {'BACKEND': 'django.core.cache.backends.memcached.MemcachedCache', 'LOCATION': 'memcache:11211'}}
142CACHE_MIDDLEWARE_ALIAS = 'default'
143CACHE_MIDDLEWARE_KEY_PREFIX = '********************'
144CACHE_MIDDLEWARE_SECONDS = 600
145CELERY_BROKER_URL = 'amqp://guest:guest@rabbitmq:5672'
146CELERY_TASK_ALWAYS_EAGER = None
147CSRF_COOKIE_AGE = 31449600
148CSRF_COOKIE_DOMAIN = None
149CSRF_COOKIE_HTTPONLY = False
150CSRF_COOKIE_NAME = 'csrftoken'
151CSRF_COOKIE_PATH = '/'
152CSRF_COOKIE_SAMESITE = 'Lax'
153CSRF_COOKIE_SECURE = False
154CSRF_FAILURE_VIEW = 'django.views.csrf.csrf_failure'
155CSRF_HEADER_NAME = 'HTTP_X_CSRFTOKEN'
156CSRF_TRUSTED_ORIGINS = []
157CSRF_USE_SESSIONS = False
158CURRENT_DIR = '/srv/deploy/AlertaDengue/AlertaDengue/..'
159DATABASES = {'default': {'ENGINE': 'django.db.backends.postgresql', 'NAME': 'infodengue', 'USER': 'dengueadmin', 'PASSWORD': '********************', 'HOST': '172.16.4.27', 'PORT': '5432', 'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'CONN_MAX_AGE': 0, 'OPTIONS': {}, 'TIME_ZONE': None, 'TEST': {'CHARSET': None, 'COLLATION': None, 'NAME': None, 'MIRROR': None}}, 'dados': {'ENGINE': 'django.db.backends.postgresql', 'NAME': 'dengue', 'USER': 'dengueadmin', 'PASSWORD': '********************', 'HOST': '172.16.4.27', 'PORT': '5432', 'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'CONN_MAX_AGE': 0, 'OPTIONS': {}, 'TIME_ZONE': None, 'TEST': {'CHARSET': None, 'COLLATION': None, 'NAME': None, 'MIRROR': None}}, 'forecast': {'ENGINE': 'django.db.backends.postgresql', 'NAME': 'dengue', 'USER': 'forecast', 'PASSWORD': '********************', 'HOST': '172.16.4.27', 'PORT': '5432', 'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'CONN_MAX_AGE': 0, 'OPTIONS': {}, 'TIME_ZONE': None, 'TEST': {'CHARSET': None, 'COLLATION': None, 'NAME': None, 'MIRROR': None}}}
160
161DATABASE_APPS_MAPPING = {'dados': 'dados', 'forecast': 'forecast', 'dbf': 'default'}
162DATABASE_ROUTERS = ['manager.router.DatabaseAppsRouter']
163DATA_DIR = '/srv/deploy/AlertaDengue/data'
164DATA_UPLOAD_MAX_MEMORY_SIZE = 2621440
165DATA_UPLOAD_MAX_NUMBER_FIELDS = 1000
166DATETIME_FORMAT = 'N j, Y, P'
167DATETIME_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']
168DATE_FORMAT = 'N j, Y'
169DATE_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']
170DEBUG = False
171DEBUG_PROPAGATE_EXCEPTIONS = False
172DECIMAL_SEPARATOR = '.'
173DEFAULT_CHARSET = 'utf-8'
174DEFAULT_CONTENT_TYPE = 'text/html'
175DEFAULT_EXCEPTION_REPORTER_FILTER = 'django.views.debug.SafeExceptionReporterFilter'
176DEFAULT_FILE_STORAGE = 'django.core.files.storage.FileSystemStorage'
177DEFAULT_FROM_EMAIL = 'webmaster@localhost'
178DEFAULT_INDEX_TABLESPACE = ''
179DEFAULT_TABLESPACE = ''
180DISALLOWED_USER_AGENTS = []
181EMAIL_BACKEND = 'django.core.mail.backends.smtp.EmailBackend'
182EMAIL_FROM_ADDRESS = 'no-reply@info.dengue.mat.br'
183EMAIL_HOST = 'smtp.gmail.com'
184EMAIL_HOST_PASSWORD = '********************'
185EMAIL_HOST_USER = 'projetoinfodengue@gmail.com'
186EMAIL_PORT = 587
187EMAIL_SSL_CERTFILE = None
188EMAIL_SSL_KEYFILE = '********************'
189EMAIL_SUBJECT_PREFIX = '[Django] '
190EMAIL_TIMEOUT = None
191EMAIL_USE_LOCALTIME = False
192EMAIL_USE_SSL = False
193EMAIL_USE_TLS = True
194FILE_CHARSET = 'utf-8'
195FILE_UPLOAD_DIRECTORY_PERMISSIONS = None
196FILE_UPLOAD_HANDLERS = ['django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler']
197FILE_UPLOAD_MAX_MEMORY_SIZE = 2621440
198FILE_UPLOAD_PERMISSIONS = None
199FILE_UPLOAD_TEMP_DIR = None
200FIRST_DAY_OF_WEEK = 0
201FIXTURE_DIRS = []
202FORCE_SCRIPT_NAME = None
203FORMAT_MODULE_PATH = None
204FORM_RENDERER = 'django.forms.renderers.DjangoTemplates'
205IGNORABLE_404_URLS = []
206IMPORTED_FILES_DIR = '/IMPORTED_FILES'
207INFODENGUE_TEAM_EMAIL = 'infodengue@info.dengue.mat.br'
208INSTALLED_APPS = "('django.contrib.admin', 'django.contrib.admindocs', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'django.contrib.humanize', 'leaflet', 'bootstrap4', 'chunked_upload', 'dados', 'gis', 'forecast', 'dbf.apps.DbfConfig', 'api', 'manager.router')"
209INTERNAL_IPS = []
210LANGUAGES = "(('pt-br', 'Português'), ('en-us', 'english'))"
211LANGUAGES_BIDI = ['he', 'ar', 'fa', 'ur']
212LANGUAGE_CODE = 'pt-br'
213LANGUAGE_COOKIE_AGE = None
214LANGUAGE_COOKIE_DOMAIN = None
215LANGUAGE_COOKIE_NAME = 'django_language'
216LANGUAGE_COOKIE_PATH = '/'
217LEAFLET_CONFIG = {'DEFAULT_CENTER': (-22.907, -43.431), 'DEFAULT_ZOOM': 8, 'MAXIMUM_ZOOM': 13, 'TILES': 'http://{s}.basemaps.cartocdn.com/light_all/{z}/{x}/{y}.png', 'MINIMAP': False, 'ATTRIBUTION_PREFIX': 'Fonte: <a href=http://info.dengue.mat.br>info.dengue.mat.br</a>', 'PLUGINS': {'cluster': {'js': <leaflet.utils.ListWithLazyItems object at 0x7f2e5083ec90>, 'css': <leaflet.utils.ListWithLazyItems object at 0x7f2e6a1ae8d0>, 'auto-include': True}, 'heatmap': {'js': <leaflet.utils.ListWithLazyItems object at 0x7f2e5083edd0>, 'css': <leaflet.utils.ListWithLazyItems object at 0x7f2e5083ed90>}, 'forms': {'js': <leaflet.utils.ListWithLazyItems object at 0x7f2e5083ef50>, 'css': <leaflet.utils.ListWithLazyItems object at 0x7f2e5083eed0>, 'auto-include': False}, '__default__': {'css': <leaflet.utils.ListWithLazyItems object at 0x7f2e5083ead0>, 'js': <leaflet.utils.ListWithLazyItems object at 0x7f2e5083ed10>}, 'ALL': {'css': <leaflet.utils.ListWithLazyItems object at 0x7f2e5083ec10>, 'js': <leaflet.utils.ListWithLazyItems object at 0x7f2e5083ed50>}, '__is_normalized__': True}, 'RESET_VIEW': False}
218LOCALE_PATHS = ['/srv/deploy/AlertaDengue/locale']
219LOGGING = {'version': 1, 'disable_existing_loggers': False, 'handlers': {'console': {'class': 'logging.StreamHandler'}, 'null': {'class': 'logging.NullHandler'}}, 'root': {'handlers': ['console'], 'level': 'INFO'}, 'loggers': {'django.security.DisallowedHost': {'handlers': ['null'], 'propagate': False}}}
220LOGGING_CONFIG = 'logging.config.dictConfig'
221LOGIN_REDIRECT_URL = '/accounts/profile/'
222LOGIN_URL = '/accounts/login/'
223LOGOUT_REDIRECT_URL = None
224MANAGERS = []
225MAPFILE_PATH = '/srv/deploy/maps'
226MAPSERVER_LOG_PATH = None
227MAPSERVER_URL = 'http://mapserver:80'
228MEDIA_ROOT = '/MEDIA_ROOT'
229MEDIA_URL = ''
230MEMCACHED_HOST = 'memcache'
231MEMCACHED_PORT = '11211'
232MESSAGE_STORAGE = 'django.contrib.messages.storage.fallback.FallbackStorage'
233MIDDLEWARE = "('django.middleware.gzip.GZipMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.locale.LocaleMiddleware', 'django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware')"
234MIDDLEWARE_CLASSES = "('django.middleware.gzip.GZipMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.locale.LocaleMiddleware', 'django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware')"
235MIGRATION_MODULES = {'dados': None, 'gis': None, 'api': '********************'}
236MONTH_DAY_FORMAT = 'F j'
237NUMBER_GROUPING = 0
238PARENT_BASE_DIR = '/srv/deploy'
239PASSWORD_HASHERS = '********************'
240PASSWORD_RESET_TIMEOUT_DAYS = '********************'
241PREPEND_WWW = False
242PSQL_DB = 'dengue'
243PSQL_DBF = 'infodengue'
244PSQL_HOST = '172.16.4.27'
245
246
247PSQL_PASSWORD = '********************'
248PSQL_PORT = '5432'
249PSQL_USER = 'dengueadmin'
250QUERY_CACHE_TIMEOUT = 3600
251RASTER_METEROLOGICAL_DATA_RANGE = {'ndvi': (-2000.0, 10000.0), 'lst_day_1km': (0.0, 20000.0), 'lst_night_1km': (-30.0, 30.0), 'relative_humidity_2m_above_ground': (0.0, 100.0), 'specific_humidity_2m_above_ground': (0.0, 1.0), 'precipitation': (0, 200.0)}
252RASTER_METEROLOGICAL_FACTOR_INCREASE = None
253RASTER_PATH = '/srv/deploy/tiffs'
254ROOT_URLCONF = 'AlertaDengue.urls'
255SECRET_KEY = '********************'
256SECURE_BROWSER_XSS_FILTER = False
257SECURE_CONTENT_TYPE_NOSNIFF = False
258SECURE_HSTS_INCLUDE_SUBDOMAINS = False
259SECURE_HSTS_PRELOAD = False
260SECURE_HSTS_SECONDS = 0
261SECURE_PROXY_SSL_HEADER = None
262SECURE_REDIRECT_EXEMPT = []
263SECURE_SSL_HOST = None
264SECURE_SSL_REDIRECT = False
265SERVER_EMAIL = 'root@localhost'
266SESSION_CACHE_ALIAS = 'default'
267SESSION_COOKIE_AGE = 1209600
268SESSION_COOKIE_DOMAIN = None
269SESSION_COOKIE_HTTPONLY = True
270SESSION_COOKIE_NAME = 'sessionid'
271SESSION_COOKIE_PATH = '/'
272SESSION_COOKIE_SAMESITE = 'Lax'
273SESSION_COOKIE_SECURE = False
274SESSION_ENGINE = 'django.contrib.sessions.backends.db'
275SESSION_EXPIRE_AT_BROWSER_CLOSE = False
276SESSION_FILE_PATH = None
277SESSION_SAVE_EVERY_REQUEST = False
278SESSION_SERIALIZER = 'django.contrib.sessions.serializers.JSONSerializer'
279SETTINGS_MODULE = 'AlertaDengue.settings'
280SHAPEFILE_PATH = '/srv/deploy/AlertaDengue/static/shapefile'
281SHORT_DATETIME_FORMAT = 'm/d/Y P'
282SHORT_DATE_FORMAT = 'm/d/Y'
283SIGNING_BACKEND = 'django.core.signing.TimestampSigner'
284SILENCED_SYSTEM_CHECKS = []
285STATICFILES_DIRS = "('/srv/deploy/AlertaDengue/static',)"
286STATICFILES_FINDERS = ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder']
287STATICFILES_STORAGE = 'django.contrib.staticfiles.storage.StaticFilesStorage'
288STATIC_ROOT = '/srv/deploy/AlertaDengue/AlertaDengue/../static_files'
289STATIC_URL = '/static/'
290TEMPLATES = [{'BACKEND': 'django.template.backends.django.DjangoTemplates', 'APP_DIRS': True, 'DIRS': ['/srv/deploy/AlertaDengue/templates'], 'OPTIONS': {'context_processors': ['django.contrib.auth.context_processors.auth', 'django.template.context_processors.debug', 'django.template.context_processors.i18n', 'django.template.context_processors.media', 'django.template.context_processors.static', 'django.template.context_processors.tz', 'django.contrib.messages.context_processors.messages']}}]
291TEST_NON_SERIALIZED_APPS = []
292TEST_RUNNER = 'django.test.runner.DiscoverRunner'
293THOUSAND_SEPARATOR = ','
294TIME_FORMAT = 'P'
295TIME_INPUT_FORMATS = ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M']
296TIME_ZONE = 'UTC'
297USE_I18N = True
298USE_L10N = True
299USE_THOUSAND_SEPARATOR = False
300USE_TZ = True
301USE_X_FORWARDED_HOST = False
302USE_X_FORWARDED_PORT = False
303WSGI_APPLICATION = 'AlertaDengue.wsgi.application'
304X_FRAME_OPTIONS = 'SAMEORIGIN'
305YEAR_MONTH_FORMAT = 'F Y'