· 9 years ago · Mar 13, 2017, 02:32 PM
1Request Method: GET
2Request URL: http://gti525-gestionnaire-salle.herokuapp.com/api/tickets/
3Django Version: 1.10.5
4Python Executable: /app/.heroku/python/bin/python
5Python Version: 3.6.0
6Python Path: ['/app/.heroku/python/bin', '/app', '/app/.heroku/python/lib/python36.zip', '/app/.heroku/python/lib/python3.6', '/app/.heroku/python/lib/python3.6/lib-dynload', '/app/.heroku/python/lib/python3.6/site-packages', '/app/.heroku/python/lib/python3.6/site-packages/setuptools-32.1.0-py3.6.egg', '/app/.heroku/python/lib/python3.6/site-packages/pip-9.0.1-py3.6.egg', '/app/eHall']
7Server time: Mon, 13 Mar 2017 10:28:42 -0400
8Installed Applications:
9['django.contrib.admin',
10 'django.contrib.auth',
11 'django.contrib.contenttypes',
12 'django.contrib.sessions',
13 'django.contrib.messages',
14 'django.contrib.staticfiles',
15 'event.apps.EventConfig',
16 'auditorium.apps.AuditoriumConfig',
17 'accounts',
18 'api',
19 'crispy_forms',
20 'rest_framework',
21 'rest_framework_api_key']
22Installed Middleware:
23['django.middleware.security.SecurityMiddleware',
24 'django.contrib.sessions.middleware.SessionMiddleware',
25 'django.middleware.common.CommonMiddleware',
26 'django.middleware.csrf.CsrfViewMiddleware',
27 'django.contrib.auth.middleware.AuthenticationMiddleware',
28 'django.contrib.messages.middleware.MessageMiddleware',
29 'django.middleware.clickjacking.XFrameOptionsMiddleware']
30
31
32Traceback:
33
34File "/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/utils.py" in execute
35 64. return self.cursor.execute(sql, params)
36
37
38 The above exception (relation "event_ticket" does not exist
39LINE 1: ...icket"."isReserved", "event_ticket"."isSold" FROM "event_tic...
40 ^
41) was the direct cause of the following exception:
42
43
44
45File "/app/.heroku/python/lib/python3.6/site-packages/django/core/handlers/exception.py" in inner
46 39. response = get_response(request)
47
48File "/app/.heroku/python/lib/python3.6/site-packages/django/core/handlers/base.py" in _get_response
49 187. response = self.process_exception_by_middleware(e, request)
50
51File "/app/.heroku/python/lib/python3.6/site-packages/django/core/handlers/base.py" in _get_response
52 185. response = wrapped_callback(request, *callback_args, **callback_kwargs)
53
54File "/app/.heroku/python/lib/python3.6/site-packages/django/views/decorators/csrf.py" in wrapped_view
55 58. return view_func(*args, **kwargs)
56
57File "/app/.heroku/python/lib/python3.6/site-packages/django/views/generic/base.py" in view
58 68. return self.dispatch(request, *args, **kwargs)
59
60File "/app/.heroku/python/lib/python3.6/site-packages/rest_framework/views.py" in dispatch
61 483. response = self.handle_exception(exc)
62
63File "/app/.heroku/python/lib/python3.6/site-packages/rest_framework/views.py" in handle_exception
64 443. self.raise_uncaught_exception(exc)
65
66File "/app/.heroku/python/lib/python3.6/site-packages/rest_framework/views.py" in dispatch
67 480. response = handler(request, *args, **kwargs)
68
69File "/app/eHall/api/views.py" in get
70 42. return Response(serializer.data)
71
72File "/app/.heroku/python/lib/python3.6/site-packages/rest_framework/serializers.py" in data
73 729. ret = super(ListSerializer, self).data
74
75File "/app/.heroku/python/lib/python3.6/site-packages/rest_framework/serializers.py" in data
76 262. self._data = self.to_representation(self.instance)
77
78File "/app/.heroku/python/lib/python3.6/site-packages/rest_framework/serializers.py" in to_representation
79 647. self.child.to_representation(item) for item in iterable
80
81File "/app/.heroku/python/lib/python3.6/site-packages/django/db/models/query.py" in __iter__
82 256. self._fetch_all()
83
84File "/app/.heroku/python/lib/python3.6/site-packages/django/db/models/query.py" in _fetch_all
85 1087. self._result_cache = list(self.iterator())
86
87File "/app/.heroku/python/lib/python3.6/site-packages/django/db/models/query.py" in __iter__
88 54. results = compiler.execute_sql()
89
90File "/app/.heroku/python/lib/python3.6/site-packages/django/db/models/sql/compiler.py" in execute_sql
91 835. cursor.execute(sql, params)
92
93File "/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/utils.py" in execute
94 79. return super(CursorDebugWrapper, self).execute(sql, params)
95
96File "/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/utils.py" in execute
97 64. return self.cursor.execute(sql, params)
98
99File "/app/.heroku/python/lib/python3.6/site-packages/django/db/utils.py" in __exit__
100 94. six.reraise(dj_exc_type, dj_exc_value, traceback)
101
102File "/app/.heroku/python/lib/python3.6/site-packages/django/utils/six.py" in reraise
103 685. raise value.with_traceback(tb)
104
105File "/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/utils.py" in execute
106 64. return self.cursor.execute(sql, params)
107
108Exception Type: ProgrammingError at /api/tickets/
109Exception Value: relation "event_ticket" does not exist
110LINE 1: ...icket"."isReserved", "event_ticket"."isSold" FROM "event_tic...
111 ^
112
113Request information:
114USER: AnonymousUser
115
116GET: No GET data
117
118POST: No POST data
119
120FILES: No FILES data
121
122COOKIES: No cookie data
123
124META:
125HTTP_ACCEPT = '*/*'
126HTTP_ACCEPT_ENCODING = 'gzip, deflate'
127HTTP_API_KEY = 'a677abfcc88c8126deedd719202e50922'
128HTTP_CONNECTION = 'close'
129HTTP_CONNECT_TIME = '0'
130HTTP_HOST = 'gti525-gestionnaire-salle.herokuapp.com'
131HTTP_TOTAL_ROUTE_TIME = '0'
132HTTP_USER_AGENT = 'python-requests/2.13.0'
133HTTP_VIA = '1.1 vegur'
134HTTP_X_FORWARDED_FOR = '142.137.172.193'
135HTTP_X_FORWARDED_PORT = '443'
136HTTP_X_FORWARDED_PROTO = 'https'
137HTTP_X_REQUEST_ID = '126444ae-989e-4425-b76b-f71703cec8da'
138HTTP_X_REQUEST_START = '1489415322176'
139PATH_INFO = '/api/tickets/'
140QUERY_STRING = ''
141REMOTE_ADDR = '10.164.78.133'
142REQUEST_METHOD = 'GET'
143SCRIPT_NAME = ''
144SERVER_NAME = 'localhost'
145SERVER_PORT = '28668'
146SERVER_PROTOCOL = 'HTTP/1.1'
147SERVER_SOFTWARE = 'waitress'
148wsgi.errors = <_io.TextIOWrapper name='<stderr>' mode='w' encoding='UTF-8'>
149wsgi.file_wrapper = ''
150wsgi.input = <_io.BytesIO object at 0x7f1cb6ef1ca8>
151wsgi.multiprocess = False
152wsgi.multithread = True
153wsgi.run_once = False
154wsgi.url_scheme = 'http'
155wsgi.version =
156
157Settings:
158Using settings module eHall.settings.production
159ABSOLUTE_URL_OVERRIDES = {}
160ADMINS = []
161ALLOWED_HOSTS = ['gti525-gestionnaire-salle.herokuapp.com', 'powerful-garden-42109.herokuapp.com']
162APPEND_SLASH = True
163AUTHENTICATION_BACKENDS = ['django.contrib.auth.backends.ModelBackend']
164AUTH_PASSWORD_VALIDATORS = '********************'
165AUTH_USER_MODEL = 'auth.User'
166BASE_DIR = '/app/eHall'
167CACHES = {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}}
168CACHE_MIDDLEWARE_ALIAS = 'default'
169CACHE_MIDDLEWARE_KEY_PREFIX = '********************'
170CACHE_MIDDLEWARE_SECONDS = 600
171CSRF_COOKIE_AGE = 31449600
172CSRF_COOKIE_DOMAIN = None
173CSRF_COOKIE_HTTPONLY = False
174CSRF_COOKIE_NAME = 'csrftoken'
175CSRF_COOKIE_PATH = '/'
176CSRF_COOKIE_SECURE = False
177CSRF_FAILURE_VIEW = 'django.views.csrf.csrf_failure'
178CSRF_HEADER_NAME = 'HTTP_X_CSRFTOKEN'
179CSRF_TRUSTED_ORIGINS = []
180DATABASES = {'default': {'NAME': 'd9lc6i6m4rvnus', 'USER': 'bcwtbtnblsawux', 'PASSWORD': '********************', 'HOST': 'ec2-23-23-93-255.compute-1.amazonaws.com', 'PORT': 5432, 'CONN_MAX_AGE': 0, 'ENGINE': 'django.db.backends.postgresql_psycopg2', 'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'OPTIONS': {}, 'TIME_ZONE': None, 'TEST': {'CHARSET': None, 'COLLATION': None, 'NAME': None, 'MIRROR': None}}}
181DATABASE_ROUTERS = []
182DATA_UPLOAD_MAX_MEMORY_SIZE = 2621440
183DATA_UPLOAD_MAX_NUMBER_FIELDS = 1000
184DATETIME_FORMAT = 'N j, Y, P'
185DATETIME_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']
186DATE_FORMAT = 'N j, Y'
187DATE_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']
188DEBUG = True
189DEBUG_PROPAGATE_EXCEPTIONS = False
190DECIMAL_SEPARATOR = '.'
191DEFAULT_CHARSET = 'utf-8'
192DEFAULT_CONTENT_TYPE = 'text/html'
193DEFAULT_EXCEPTION_REPORTER_FILTER = 'django.views.debug.SafeExceptionReporterFilter'
194DEFAULT_FILE_STORAGE = 'django.core.files.storage.FileSystemStorage'
195DEFAULT_FROM_EMAIL = 'webmaster@localhost'
196DEFAULT_INDEX_TABLESPACE = ''
197DEFAULT_TABLESPACE = ''
198DISALLOWED_USER_AGENTS = []
199EMAIL_BACKEND = 'django.core.mail.backends.smtp.EmailBackend'
200EMAIL_HOST = 'localhost'
201EMAIL_HOST_PASSWORD = '********************'
202EMAIL_HOST_USER = ''
203EMAIL_PORT = 25
204EMAIL_SSL_CERTFILE = None
205EMAIL_SSL_KEYFILE = '********************'
206EMAIL_SUBJECT_PREFIX = '[Django] '
207EMAIL_TIMEOUT = None
208EMAIL_USE_SSL = False
209EMAIL_USE_TLS = False
210FILE_CHARSET = 'utf-8'
211FILE_UPLOAD_DIRECTORY_PERMISSIONS = None
212FILE_UPLOAD_HANDLERS = ['django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler']
213FILE_UPLOAD_MAX_MEMORY_SIZE = 2621440
214FILE_UPLOAD_PERMISSIONS = None
215FILE_UPLOAD_TEMP_DIR = None
216FIRST_DAY_OF_WEEK = 0
217FIXTURE_DIRS = []
218FORCE_SCRIPT_NAME = None
219FORMAT_MODULE_PATH = None
220IGNORABLE_404_URLS = []
221INSTALLED_APPS = ['django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'event.apps.EventConfig', 'auditorium.apps.AuditoriumConfig', 'accounts', 'api', 'crispy_forms', 'rest_framework', 'rest_framework_api_key']
222INTERNAL_IPS = []
223LANGUAGES = [('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'), ('dsb', 'Lower Sorbian'), ('el', 'Greek'), ('en', 'English'), ('en-au', 'Australian English'), ('en-gb', 'British English'), ('eo', 'Esperanto'), ('es', 'Spanish'), ('es-ar', 'Argentinian Spanish'), ('es-co', 'Colombian 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'), ('gd', 'Scottish Gaelic'), ('gl', 'Galician'), ('he', 'Hebrew'), ('hi', 'Hindi'), ('hr', 'Croatian'), ('hsb', 'Upper Sorbian'), ('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 Bokmål'), ('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-hans', 'Simplified Chinese'), ('zh-hant', 'Traditional Chinese')]
224LANGUAGES_BIDI = ['he', 'ar', 'fa', 'ur']
225LANGUAGE_CODE = 'en-us'
226LANGUAGE_COOKIE_AGE = None
227LANGUAGE_COOKIE_DOMAIN = None
228LANGUAGE_COOKIE_NAME = 'django_language'
229LANGUAGE_COOKIE_PATH = '/'
230LOCALE_PATHS = []
231LOGGING = {}
232LOGGING_CONFIG = 'logging.config.dictConfig'
233LOGIN_REDIRECT_URL = '/accounts/profile/'
234LOGIN_URL = '/accounts/login/'
235LOGOUT_REDIRECT_URL = None
236MANAGERS = []
237MEDIA_ROOT = ''
238MEDIA_URL = ''
239MESSAGE_STORAGE = 'django.contrib.messages.storage.fallback.FallbackStorage'
240MIDDLEWARE = ['django.middleware.security.SecurityMiddleware', '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']
241MIDDLEWARE_CLASSES = ['django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware']
242MIGRATION_MODULES = {}
243MONTH_DAY_FORMAT = 'F j'
244NUMBER_GROUPING = 0
245PASSWORD_HASHERS = '********************'
246PASSWORD_RESET_TIMEOUT_DAYS = '********************'
247PREPEND_WWW = False
248REST_FRAMEWORK = {'DEFAULT_PERMISSION_CLASSES': ('rest_framework_api_key.permissions.HasAPIAccess',)}
249ROOT_URLCONF = 'eHall.urls'
250SECRET_KEY = '********************'
251SECURE_BROWSER_XSS_FILTER = False
252SECURE_CONTENT_TYPE_NOSNIFF = False
253SECURE_HSTS_INCLUDE_SUBDOMAINS = False
254SECURE_HSTS_SECONDS = 0
255SECURE_PROXY_SSL_HEADER = None
256SECURE_REDIRECT_EXEMPT = []
257SECURE_SSL_HOST = None
258SECURE_SSL_REDIRECT = False
259SERVER_EMAIL = 'root@localhost'
260SESSION_CACHE_ALIAS = 'default'
261SESSION_COOKIE_AGE = 1209600
262SESSION_COOKIE_DOMAIN = None
263SESSION_COOKIE_HTTPONLY = True
264SESSION_COOKIE_NAME = 'sessionid'
265SESSION_COOKIE_PATH = '/'
266SESSION_COOKIE_SECURE = False
267SESSION_ENGINE = 'django.contrib.sessions.backends.db'
268SESSION_EXPIRE_AT_BROWSER_CLOSE = False
269SESSION_FILE_PATH = None
270SESSION_SAVE_EVERY_REQUEST = False
271SESSION_SERIALIZER = 'django.contrib.sessions.serializers.JSONSerializer'
272SETTINGS_MODULE = 'eHall.settings.production'
273SHORT_DATETIME_FORMAT = 'm/d/Y P'
274SHORT_DATE_FORMAT = 'm/d/Y'
275SIGNING_BACKEND = 'django.core.signing.TimestampSigner'
276SILENCED_SYSTEM_CHECKS = []
277STATICFILES_DIRS = '/app/eHall/staticfiles'
278STATICFILES_FINDERS = ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder']
279STATICFILES_STORAGE = 'whitenoise.django.GzipManifestStaticFilesStorage'
280STATIC_ROOT = '/app/eHall/static'
281STATIC_URL = '/static/'
282TEMPLATES = [{'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': [], 'APP_DIRS': True, 'OPTIONS': {'context_processors': ['django.template.context_processors.debug', 'django.template.context_processors.request', 'django.contrib.auth.context_processors.auth', 'django.contrib.messages.context_processors.messages']}}]
283TEST_NON_SERIALIZED_APPS = []
284TEST_RUNNER = 'django.test.runner.DiscoverRunner'
285THOUSAND_SEPARATOR = ','
286TIME_FORMAT = 'P'
287TIME_INPUT_FORMATS = ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M']
288TIME_ZONE = 'America/Montreal'
289USE_ETAGS = False
290USE_I18N = True
291USE_L10N = True
292USE_THOUSAND_SEPARATOR = False
293USE_TZ = False
294USE_X_FORWARDED_HOST = False
295USE_X_FORWARDED_PORT = False
296WSGI_APPLICATION = 'eHall.wsgi.application'
297X_FRAME_OPTIONS = 'SAMEORIGIN'
298YEAR_MONTH_FORMAT = 'F Y'
299
300
301You're seeing this error because you have DEBUG = True in your
302Django settings file. Change that to False, and Django will
303display a standard page generated by the handler for this status code