· 5 years ago · Jan 20, 2020, 06:10 PM
1ProgrammingError at /api/maloprodaja/racuni/2/
2(1146, "Table 'obort.retail_app_retailoutgoing_refs' doesn't exist")
3
4Request Method: GET
5Request URL: https://staging.obrt.ba/api/maloprodaja/racuni/2/?date_from=2019-01-01&date_to=2019-12-31
6Django Version: 1.11.20
7Python Executable: /usr/bin/uwsgi
8Python Version: 2.7.5
9Python Path: ['.', '', '/home/obort/lib64/python27.zip', '/home/obort/lib64/python2.7', '/home/obort/lib64/python2.7/plat-linux2', '/home/obort/lib64/python2.7/lib-tk', '/home/obort/lib64/python2.7/lib-old', '/home/obort/lib64/python2.7/lib-dynload', '/usr/lib64/python2.7', '/usr/lib/python2.7', '/home/obort/lib/python2.7/site-packages']
10Server time: pon., 20 Jan. 2020 19:05:24 +0100
11Installed Applications:
12['django.contrib.admin',
13 'django.contrib.auth',
14 'django.contrib.contenttypes',
15 'django.contrib.sessions',
16 'django.contrib.messages',
17 'django.contrib.staticfiles',
18 'django.contrib.humanize',
19 'channels',
20 'business_app',
21 'codebook_app',
22 'invoice_app',
23 'region_app',
24 'core_app',
25 'income_app',
26 'claim_app',
27 'card_app',
28 'sales_app',
29 'register_app',
30 'auth_app',
31 'wage_app',
32 'retail_app',
33 'wholesale_app',
34 'bootstrap3',
35 'production_app',
36 'pos_app',
37 'import_app',
38 'asset_app',
39 'rest_framework',
40 'corsheaders',
41 'debug_toolbar',
42 'form_app',
43 'order_app',
44 'statistics_app',
45 'socket_app']
46Installed Middleware:
47['django.middleware.security.SecurityMiddleware',
48 'django.contrib.sessions.middleware.SessionMiddleware',
49 'corsheaders.middleware.CorsMiddleware',
50 'django.middleware.common.CommonMiddleware',
51 'django.middleware.csrf.CsrfViewMiddleware',
52 'django.contrib.auth.middleware.AuthenticationMiddleware',
53 'django.contrib.messages.middleware.MessageMiddleware',
54 'django.middleware.clickjacking.XFrameOptionsMiddleware',
55 'debug_toolbar.middleware.DebugToolbarMiddleware']
56
57
58Traceback:
59
60File "/home/obort/lib/python2.7/site-packages/django/core/handlers/exception.py" in inner
61 41. response = get_response(request)
62
63File "/home/obort/lib/python2.7/site-packages/django/core/handlers/base.py" in _get_response
64 187. response = self.process_exception_by_middleware(e, request)
65
66File "/home/obort/lib/python2.7/site-packages/django/core/handlers/base.py" in _get_response
67 185. response = wrapped_callback(request, *callback_args, **callback_kwargs)
68
69File "/home/obort/lib/python2.7/site-packages/django/views/decorators/csrf.py" in wrapped_view
70 58. return view_func(*args, **kwargs)
71
72File "/home/obort/lib/python2.7/site-packages/django/views/generic/base.py" in view
73 68. return self.dispatch(request, *args, **kwargs)
74
75File "./core_app/views.py" in dispatch
76 43. return self.delegate(request, *args, **kwargs)
77
78File "./core_app/views.py" in delegate
79 47. request, *args, **kwargs)
80
81File "/home/obort/lib/python2.7/site-packages/rest_framework/views.py" in dispatch
82 495. response = self.handle_exception(exc)
83
84File "/home/obort/lib/python2.7/site-packages/rest_framework/views.py" in handle_exception
85 455. self.raise_uncaught_exception(exc)
86
87File "/home/obort/lib/python2.7/site-packages/rest_framework/views.py" in dispatch
88 492. response = handler(request, *args, **kwargs)
89
90File "./retail_app/api_views.py" in get
91 851. return Response(serializer.data)
92
93File "/home/obort/lib/python2.7/site-packages/rest_framework/serializers.py" in data
94 768. ret = super(ListSerializer, self).data
95
96File "/home/obort/lib/python2.7/site-packages/rest_framework/serializers.py" in data
97 262. self._data = self.to_representation(self.instance)
98
99File "/home/obort/lib/python2.7/site-packages/rest_framework/serializers.py" in to_representation
100 686. self.child.to_representation(item) for item in iterable
101
102File "/home/obort/lib/python2.7/site-packages/rest_framework/serializers.py" in to_representation
103 530. ret[field.field_name] = field.to_representation(attribute)
104
105File "/home/obort/lib/python2.7/site-packages/rest_framework/relations.py" in to_representation
106 542. for value in iterable
107
108File "/home/obort/lib/python2.7/site-packages/django/db/models/query.py" in __iter__
109 250. self._fetch_all()
110
111File "/home/obort/lib/python2.7/site-packages/django/db/models/query.py" in _fetch_all
112 1121. self._result_cache = list(self._iterable_class(self))
113
114File "/home/obort/lib/python2.7/site-packages/django/db/models/query.py" in __iter__
115 53. results = compiler.execute_sql(chunked_fetch=self.chunked_fetch)
116
117File "/home/obort/lib/python2.7/site-packages/django/db/models/sql/compiler.py" in execute_sql
118 899. raise original_exception
119
120Exception Type: ProgrammingError at /api/maloprodaja/racuni/2/
121Exception Value: (1146, "Table 'obort.retail_app_retailoutgoing_refs' doesn't exist")
122Request information:
123USER: AnonymousUser
124
125GET:
126date_from = u'2019-01-01'
127date_to = u'2019-12-31'
128
129POST: No POST data
130
131FILES: No FILES data
132
133COOKIES:
134csrftoken = '9OVarjp638l05gT6D1IVPqHFhbujMXPk5PQ3tCpWT0jO0beXkHa0LRiLSIAOfly3'
135sessionid = '4h9pr16qxnk7xn50498x4tb100kqcm5y'
136djdt = 'show'
137
138META:
139CONTENT_LENGTH = ''
140CONTENT_TYPE = ''
141CSRF_COOKIE = '9OVarjp638l05gT6D1IVPqHFhbujMXPk5PQ3tCpWT0jO0beXkHa0LRiLSIAOfly3'
142DOCUMENT_ROOT = '/srv/html'
143HTTPS = 'on'
144HTTP_ACCEPT = 'application/json'
145HTTP_ACCEPT_ENCODING = 'gzip, deflate, br'
146HTTP_ACCEPT_LANGUAGE = 'bs,en-US;q=0.9,en;q=0.8,hr;q=0.7'
147HTTP_CONNECTION = 'keep-alive'
148HTTP_COOKIE = 'csrftoken=9OVarjp638l05gT6D1IVPqHFhbujMXPk5PQ3tCpWT0jO0beXkHa0LRiLSIAOfly3; sessionid=4h9pr16qxnk7xn50498x4tb100kqcm5y; djdt=show'
149HTTP_HOST = 'staging.obrt.ba'
150HTTP_ORIGIN = 'http://localhost:8080'
151HTTP_REFERER = 'http://localhost:8080/'
152HTTP_SEC_FETCH_MODE = 'cors'
153HTTP_SEC_FETCH_SITE = 'cross-site'
154HTTP_USER_AGENT = 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.130 Safari/537.36'
155PATH_INFO = u'/api/maloprodaja/racuni/2/'
156QUERY_STRING = 'date_from=2019-01-01&date_to=2019-12-31'
157REMOTE_ADDR = '77.239.15.62'
158REMOTE_PORT = '58316'
159REQUEST_METHOD = 'GET'
160REQUEST_SCHEME = 'https'
161REQUEST_URI = '/api/maloprodaja/racuni/2/?date_from=2019-01-01&date_to=2019-12-31'
162SCRIPT_NAME = u''
163SERVER_NAME = 'staging.obrt.ba'
164SERVER_PORT = '443'
165SERVER_PROTOCOL = 'HTTP/1.1'
166uwsgi.core = 0
167uwsgi.node = 'staging.obrt'
168uwsgi.version = '2.0.18'
169wsgi.errors = <open file 'wsgi_errors', mode 'w' at 0x7f8bae43da50>
170wsgi.file_wrapper = ''
171wsgi.input = <uwsgi._Input object at 0x7f8bac167648>
172wsgi.multiprocess = True
173wsgi.multithread = True
174wsgi.run_once = False
175wsgi.url_scheme = 'https'
176wsgi.version = u'(1, 0)'
177
178Settings:
179Using settings module obort.settings
180ABSOLUTE_URL_OVERRIDES = {}
181ADMINS = [('Haris', 'mamoun.haris@obrt.ba')]
182ALLOWED_HOSTS = ['*']
183APPEND_SLASH = True
184ASGI_APPLICATION = 'obort.asgi.channel_routing'
185AUTHENTICATION_BACKENDS = [u'django.contrib.auth.backends.ModelBackend']
186AUTH_PASSWORD_VALIDATORS = u'********************'
187AUTH_USER_MODEL = u'auth.User'
188BASE_DIR = '/home/obort/obort'
189CACHES = {u'default': {u'BACKEND': u'django.core.cache.backends.locmem.LocMemCache'}}
190CACHE_MIDDLEWARE_ALIAS = u'default'
191CACHE_MIDDLEWARE_KEY_PREFIX = u'********************'
192CACHE_MIDDLEWARE_SECONDS = 600
193CHANNEL_LAYERS = {'default': {'CONFIG': {'hosts': [('localhost', 6379)]}, 'ROUTING': 'obort.routing.channel_routing', 'BACKEND': 'asgi_redis.RedisChannelLayer'}}
194CORS_ALLOW_CREDENTIALS = True
195CORS_ORIGIN_ALLOW_ALL = True
196CORS_ORIGIN_WHITELIST = u"('https://staging.blagajna.ba',)"
197CSRF_COOKIE_AGE = 31449600
198CSRF_COOKIE_DOMAIN = None
199CSRF_COOKIE_HTTPONLY = False
200CSRF_COOKIE_NAME = u'csrftoken'
201CSRF_COOKIE_PATH = u'/'
202CSRF_COOKIE_SECURE = False
203CSRF_FAILURE_VIEW = u'django.views.csrf.csrf_failure'
204CSRF_HEADER_NAME = u'HTTP_X_CSRFTOKEN'
205CSRF_TRUSTED_ORIGINS = ['staging.blagajna.ba']
206CSRF_USE_SESSIONS = False
207DATABASES = {'default': {'ENGINE': 'django.db.backends.mysql', 'AUTOCOMMIT': True, 'ATOMIC_REQUESTS': False, 'NAME': 'obort', 'CONN_MAX_AGE': 0, 'TIME_ZONE': None, 'OPTIONS': {'sql_mode': 'traditional'}, 'HOST': 'localhost', 'USER': 'obort', 'TEST': {'COLLATION': None, 'CHARSET': None, 'NAME': None, 'MIRROR': None}, 'PASSWORD': u'********************', 'PORT': '3306'}}
208DATABASE_ROUTERS = []
209DATA_UPLOAD_MAX_MEMORY_SIZE = 2621440
210DATA_UPLOAD_MAX_NUMBER_FIELDS = 1000
211DATETIME_FORMAT = u'N j, Y, P'
212DATETIME_INPUT_FORMATS = [u'%Y-%m-%d %H:%M:%S', u'%Y-%m-%d %H:%M:%S.%f', u'%Y-%m-%d %H:%M', u'%Y-%m-%d', u'%m/%d/%Y %H:%M:%S', u'%m/%d/%Y %H:%M:%S.%f', u'%m/%d/%Y %H:%M', u'%m/%d/%Y', u'%m/%d/%y %H:%M:%S', u'%m/%d/%y %H:%M:%S.%f', u'%m/%d/%y %H:%M', u'%m/%d/%y']
213DATE_FORMAT = u'N j, Y'
214DATE_INPUT_FORMATS = [u'%Y-%m-%d', u'%m/%d/%Y', u'%m/%d/%y', u'%b %d %Y', u'%b %d, %Y', u'%d %b %Y', u'%d %b, %Y', u'%B %d %Y', u'%B %d, %Y', u'%d %B %Y', u'%d %B, %Y']
215DEBUG = True
216DEBUG_PROPAGATE_EXCEPTIONS = False
217DECIMAL_SEPARATOR = u'.'
218DEFAULT_CHARSET = u'utf-8'
219DEFAULT_CONTENT_TYPE = u'text/html'
220DEFAULT_EXCEPTION_REPORTER_FILTER = u'django.views.debug.SafeExceptionReporterFilter'
221DEFAULT_FILE_STORAGE = u'django.core.files.storage.FileSystemStorage'
222DEFAULT_FROM_EMAIL = u'webmaster@localhost'
223DEFAULT_INDEX_TABLESPACE = u''
224DEFAULT_TABLESPACE = u''
225DISALLOWED_USER_AGENTS = []
226DOMAIN = 'https://staging.obrt.ba'
227EMAIL_BACKEND = 'django.core.mail.backends.smtp.EmailBackend'
228EMAIL_HOST = 'smtp.gmail.com'
229EMAIL_HOST_PASSWORD = u'********************'
230EMAIL_HOST_USER = 'info@obrt.ba'
231EMAIL_PORT = 587
232EMAIL_SSL_CERTFILE = None
233EMAIL_SSL_KEYFILE = u'********************'
234EMAIL_SUBJECT_PREFIX = u'[Django] '
235EMAIL_TIMEOUT = None
236EMAIL_USE_LOCALTIME = False
237EMAIL_USE_SSL = False
238EMAIL_USE_TLS = True
239FILE_CHARSET = u'utf-8'
240FILE_UPLOAD_DIRECTORY_PERMISSIONS = None
241FILE_UPLOAD_HANDLERS = [u'django.core.files.uploadhandler.MemoryFileUploadHandler', u'django.core.files.uploadhandler.TemporaryFileUploadHandler']
242FILE_UPLOAD_MAX_MEMORY_SIZE = 2621440
243FILE_UPLOAD_PERMISSIONS = None
244FILE_UPLOAD_TEMP_DIR = None
245FIRST_DAY_OF_WEEK = 0
246FIXTURE_DIRS = []
247FORCE_SCRIPT_NAME = None
248FORMAT_MODULE_PATH = None
249FORM_RENDERER = u'django.forms.renderers.DjangoTemplates'
250GEOIP_PATH = '/home/obort/obort/geoip'
251IGNORABLE_404_URLS = []
252INSTALLED_APPS = ['django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'django.contrib.humanize', 'channels', 'business_app', 'codebook_app', 'invoice_app', 'region_app', 'core_app', 'income_app', 'claim_app', 'card_app', 'sales_app', 'register_app', 'auth_app', 'wage_app', 'retail_app', 'wholesale_app', 'bootstrap3', 'production_app', 'pos_app', 'import_app', 'asset_app', 'rest_framework', 'corsheaders', 'debug_toolbar', 'form_app', 'order_app', 'statistics_app', 'socket_app']
253INTERNAL_IPS = []
254LANGUAGES = [(u'af', u'Afrikaans'), (u'ar', u'Arabic'), (u'ast', u'Asturian'), (u'az', u'Azerbaijani'), (u'bg', u'Bulgarian'), (u'be', u'Belarusian'), (u'bn', u'Bengali'), (u'br', u'Breton'), (u'bs', u'Bosnian'), (u'ca', u'Catalan'), (u'cs', u'Czech'), (u'cy', u'Welsh'), (u'da', u'Danish'), (u'de', u'German'), (u'dsb', u'Lower Sorbian'), (u'el', u'Greek'), (u'en', u'English'), (u'en-au', u'Australian English'), (u'en-gb', u'British English'), (u'eo', u'Esperanto'), (u'es', u'Spanish'), (u'es-ar', u'Argentinian Spanish'), (u'es-co', u'Colombian Spanish'), (u'es-mx', u'Mexican Spanish'), (u'es-ni', u'Nicaraguan Spanish'), (u'es-ve', u'Venezuelan Spanish'), (u'et', u'Estonian'), (u'eu', u'Basque'), (u'fa', u'Persian'), (u'fi', u'Finnish'), (u'fr', u'French'), (u'fy', u'Frisian'), (u'ga', u'Irish'), (u'gd', u'Scottish Gaelic'), (u'gl', u'Galician'), (u'he', u'Hebrew'), (u'hi', u'Hindi'), (u'hr', u'Croatian'), (u'hsb', u'Upper Sorbian'), (u'hu', u'Hungarian'), (u'ia', u'Interlingua'), (u'id', u'Indonesian'), (u'io', u'Ido'), (u'is', u'Icelandic'), (u'it', u'Italian'), (u'ja', u'Japanese'), (u'ka', u'Georgian'), (u'kk', u'Kazakh'), (u'km', u'Khmer'), (u'kn', u'Kannada'), (u'ko', u'Korean'), (u'lb', u'Luxembourgish'), (u'lt', u'Lithuanian'), (u'lv', u'Latvian'), (u'mk', u'Macedonian'), (u'ml', u'Malayalam'), (u'mn', u'Mongolian'), (u'mr', u'Marathi'), (u'my', u'Burmese'), (u'nb', u'Norwegian Bokm\xe5l'), (u'ne', u'Nepali'), (u'nl', u'Dutch'), (u'nn', u'Norwegian Nynorsk'), (u'os', u'Ossetic'), (u'pa', u'Punjabi'), (u'pl', u'Polish'), (u'pt', u'Portuguese'), (u'pt-br', u'Brazilian Portuguese'), (u'ro', u'Romanian'), (u'ru', u'Russian'), (u'sk', u'Slovak'), (u'sl', u'Slovenian'), (u'sq', u'Albanian'), (u'sr', u'Serbian'), (u'sr-latn', u'Serbian Latin'), (u'sv', u'Swedish'), (u'sw', u'Swahili'), (u'ta', u'Tamil'), (u'te', u'Telugu'), (u'th', u'Thai'), (u'tr', u'Turkish'), (u'tt', u'Tatar'), (u'udm', u'Udmurt'), (u'uk', u'Ukrainian'), (u'ur', u'Urdu'), (u'vi', u'Vietnamese'), (u'zh-hans', u'Simplified Chinese'), (u'zh-hant', u'Traditional Chinese')]
255LANGUAGES_BIDI = [u'he', u'ar', u'fa', u'ur']
256LANGUAGE_CODE = 'bs'
257LANGUAGE_COOKIE_AGE = None
258LANGUAGE_COOKIE_DOMAIN = None
259LANGUAGE_COOKIE_NAME = u'django_language'
260LANGUAGE_COOKIE_PATH = u'/'
261LOCALE_PATHS = u"('/home/obort/obort/locale/',)"
262LOGGING = {}
263LOGGING_CONFIG = u'logging.config.dictConfig'
264LOGIN_REDIRECT_URL = u'/accounts/profile/'
265LOGIN_URL = u'/accounts/login/'
266LOGOUT_REDIRECT_URL = None
267MANAGERS = []
268MEDIA_ROOT = '/home/obort/obort/media'
269MEDIA_URL = '/media/'
270MESSAGE_STORAGE = u'django.contrib.messages.storage.fallback.FallbackStorage'
271MIDDLEWARE = ['django.middleware.security.SecurityMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'corsheaders.middleware.CorsMiddleware', 'django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware', 'debug_toolbar.middleware.DebugToolbarMiddleware']
272MIDDLEWARE_CLASSES = [u'django.middleware.common.CommonMiddleware', u'django.middleware.csrf.CsrfViewMiddleware']
273MIGRATION_MODULES = {}
274MONTH_DAY_FORMAT = u'F j'
275NUMBER_GROUPING = 0
276PASSWORD_HASHERS = u'********************'
277PASSWORD_RESET_TIMEOUT_DAYS = u'********************'
278PREPEND_WWW = False
279REST_FRAMEWORK = {'DEFAULT_RENDERER_CLASSES': ('rest_framework.renderers.JSONRenderer',), 'COERCE_DECIMAL_TO_STRING': False}
280ROOT_URLCONF = 'obort.urls'
281SECRET_KEY = u'********************'
282SECURE_BROWSER_XSS_FILTER = False
283SECURE_CONTENT_TYPE_NOSNIFF = False
284SECURE_HSTS_INCLUDE_SUBDOMAINS = False
285SECURE_HSTS_PRELOAD = False
286SECURE_HSTS_SECONDS = 0
287SECURE_PROXY_SSL_HEADER = None
288SECURE_REDIRECT_EXEMPT = []
289SECURE_SSL_HOST = None
290SECURE_SSL_REDIRECT = False
291SERVER_EMAIL = u'root@localhost'
292SESSION_CACHE_ALIAS = u'default'
293SESSION_COOKIE_AGE = 86400
294SESSION_COOKIE_DOMAIN = None
295SESSION_COOKIE_HTTPONLY = True
296SESSION_COOKIE_NAME = u'sessionid'
297SESSION_COOKIE_PATH = u'/'
298SESSION_COOKIE_SECURE = False
299SESSION_ENGINE = u'django.contrib.sessions.backends.db'
300SESSION_EXPIRE_AT_BROWSER_CLOSE = False
301SESSION_FILE_PATH = None
302SESSION_SAVE_EVERY_REQUEST = False
303SESSION_SERIALIZER = u'django.contrib.sessions.serializers.JSONSerializer'
304SETTINGS_MODULE = 'obort.settings'
305SHORT_DATETIME_FORMAT = u'm/d/Y P'
306SHORT_DATE_FORMAT = u'm/d/Y'
307SIGNING_BACKEND = u'django.core.signing.TimestampSigner'
308SILENCED_SYSTEM_CHECKS = []
309STATICFILES_DIRS = u"('obort/static',)"
310STATICFILES_FINDERS = u"('django.contrib.staticfiles.finders.AppDirectoriesFinder', 'django.contrib.staticfiles.finders.FileSystemFinder')"
311STATICFILES_STORAGE = u'django.contrib.staticfiles.storage.StaticFilesStorage'
312STATIC_ROOT = '/home/obort/obort/static/'
313STATIC_URL = '/static/'
314TEMPLATES = [{'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']}, 'BACKEND': 'django.template.backends.django.DjangoTemplates'}]
315TEST_NON_SERIALIZED_APPS = []
316TEST_RUNNER = u'django.test.runner.DiscoverRunner'
317THOUSAND_SEPARATOR = u','
318TIME_FORMAT = u'P'
319TIME_INPUT_FORMATS = [u'%H:%M:%S', u'%H:%M:%S.%f', u'%H:%M']
320TIME_ZONE = 'Europe/Sarajevo'
321TWILIO_ACCOUNT_SID = 'AC262498094edf0549bfdd86903785dfa2'
322TWILIO_AUTH_TOKEN = u'********************'
323TWILIO_DEFAULT_CALLERID = 'Obrt'
324USE_ETAGS = False
325USE_I18N = True
326USE_L10N = False
327USE_THOUSAND_SEPARATOR = False
328USE_TZ = True
329USE_X_FORWARDED_HOST = False
330USE_X_FORWARDED_PORT = False
331WKHTMLTOPDF_CMD = '/usr/local/bin/wkhtmltopdf'
332WKHTMLTOPDF_CMD_OPTIONS = {'use-xserver': False, 'enable-plugins': True, 'quiet': False, 'enable-forms': True, 'disable-smart-shrinking': False, 'debug-javascript': True}
333WSGI_APPLICATION = 'obort.wsgi.application'
334X_FRAME_OPTIONS = u'SAMEORIGIN'
335YEAR_MONTH_FORMAT = u'F Y'
336
337
338You're seeing this error because you have DEBUG = True in your
339Django settings file. Change that to False, and Django will
340display a standard page generated by the handler for this status code.