· 7 years ago · Jul 09, 2018, 09:18 PM
1ProgrammingError at /api/albums/
2SELECT DISTINCT ON expressions must match initial ORDER BY expressions
3LINE 1: SELECT COUNT(*) FROM (SELECT DISTINCT ON ("albums_album"."ye...
4 ^
5
6
7Request Method: GET
8Request URL: http://127.0.0.1:8000/api/albums/?format=datatables&draw=1&columns%5B0%5D%5Bdata%5D=rank&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=false&columns%5B0%5D%5Borderable%5D=true&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=artist.name&columns%5B1%5D%5Bname%5D=artist.name&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=true&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B2%5D%5Bdata%5D=name&columns%5B2%5D%5Bname%5D=&columns%5B2%5D%5Bsearchable%5D=true&columns%5B2%5D%5Borderable%5D=true&columns%5B2%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B2%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B3%5D%5Bdata%5D=year&columns%5B3%5D%5Bname%5D=&columns%5B3%5D%5Bsearchable%5D=true&columns%5B3%5D%5Borderable%5D=true&columns%5B3%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B3%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B4%5D%5Bdata%5D=genres&columns%5B4%5D%5Bname%5D=genres.name&columns%5B4%5D%5Bsearchable%5D=true&columns%5B4%5D%5Borderable%5D=false&columns%5B4%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B4%5D%5Bsearch%5D%5Bregex%5D=false&order%5B0%5D%5Bcolumn%5D=0&order%5B0%5D%5Bdir%5D=asc&start=0&length=10&search%5Bvalue%5D=&search%5Bregex%5D=false&_=1531170631897
9Django Version: 2.0.7
10Python Executable: /home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/bin/python
11Python Version: 3.6.5
12Python Path: ['/home/watervize/example/django-rest-framework-datatables', '/home/watervize/example/django-rest-framework-datatables/example', '/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python36.zip', '/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6', '/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/lib-dynload', '/usr/local/lib/python3.6', '/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages']
13Server time: Mon, 9 Jul 2018 21:10:36 +0000
14Installed Applications:
15['django.contrib.admin',
16 'django.contrib.auth',
17 'django.contrib.contenttypes',
18 'django.contrib.sessions',
19 'django.contrib.messages',
20 'django.contrib.staticfiles',
21 'rest_framework',
22 'rest_framework_datatables',
23 'albums']
24Installed Middleware:
25['django.middleware.security.SecurityMiddleware',
26 'django.contrib.sessions.middleware.SessionMiddleware',
27 'django.middleware.common.CommonMiddleware',
28 'django.middleware.csrf.CsrfViewMiddleware',
29 'django.contrib.auth.middleware.AuthenticationMiddleware',
30 'django.contrib.messages.middleware.MessageMiddleware',
31 'django.middleware.clickjacking.XFrameOptionsMiddleware']
32
33
34Traceback:
35
36File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/django/db/backends/utils.py" in _execute
37 85. return self.cursor.execute(sql, params)
38
39The above exception (SELECT DISTINCT ON expressions must match initial ORDER BY expressions
40LINE 1: SELECT COUNT(*) FROM (SELECT DISTINCT ON ("albums_album"."ye...
41 ^
42) was the direct cause of the following exception:
43
44File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/django/core/handlers/exception.py" in inner
45 35. response = get_response(request)
46
47File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/django/core/handlers/base.py" in _get_response
48 128. response = self.process_exception_by_middleware(e, request)
49
50File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/django/core/handlers/base.py" in _get_response
51 126. response = wrapped_callback(request, *callback_args, **callback_kwargs)
52
53File "/usr/local/lib/python3.6/contextlib.py" in inner
54 52. return func(*args, **kwds)
55
56File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/django/views/decorators/csrf.py" in wrapped_view
57 54. return view_func(*args, **kwargs)
58
59File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/rest_framework/viewsets.py" in view
60 103. return self.dispatch(request, *args, **kwargs)
61
62File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/rest_framework/views.py" in dispatch
63 483. response = self.handle_exception(exc)
64
65File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/rest_framework/views.py" in handle_exception
66 443. self.raise_uncaught_exception(exc)
67
68File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/rest_framework/views.py" in dispatch
69 480. response = handler(request, *args, **kwargs)
70
71File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/rest_framework/mixins.py" in list
72 42. page = self.paginate_queryset(queryset)
73
74File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/rest_framework/generics.py" in paginate_queryset
75 173. return self.paginator.paginate_queryset(queryset, self.request, view=self)
76
77File "/home/watervize/example/django-rest-framework-datatables/rest_framework_datatables/pagination.py" in paginate_queryset
78 61. self.page = paginator.page(page_number)
79
80File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/django/core/paginator.py" in page
81 65. number = self.validate_number(number)
82
83File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/django/core/paginator.py" in validate_number
84 43. if number > self.num_pages:
85
86File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/django/utils/functional.py" in __get__
87 36. res = instance.__dict__[self.name] = self.func(instance)
88
89File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/django/core/paginator.py" in num_pages
90 95. if self.count == 0 and not self.allow_empty_first_page:
91
92File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/django/utils/functional.py" in __get__
93 36. res = instance.__dict__[self.name] = self.func(instance)
94
95File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/django/core/paginator.py" in count
96 85. return self.object_list.count()
97
98File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/django/db/models/query.py" in count
99 387. return self.query.get_count(using=self.db)
100
101File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/django/db/models/sql/query.py" in get_count
102 491. number = obj.get_aggregation(using, ['__count'])['__count']
103
104File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/django/db/models/sql/query.py" in get_aggregation
105 476. result = compiler.execute_sql(SINGLE)
106
107File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/django/db/models/sql/compiler.py" in execute_sql
108 1068. cursor.execute(sql, params)
109
110File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/django/db/backends/utils.py" in execute
111 100. return super().execute(sql, params)
112
113File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/django/db/backends/utils.py" in execute
114 68. return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
115
116File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/django/db/backends/utils.py" in _execute_with_wrappers
117 77. return executor(sql, params, many, context)
118
119File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/django/db/backends/utils.py" in _execute
120 85. return self.cursor.execute(sql, params)
121
122File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/django/db/utils.py" in __exit__
123 89. raise dj_exc_value.with_traceback(traceback) from exc_value
124
125File "/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/lib/python3.6/site-packages/django/db/backends/utils.py" in _execute
126 85. return self.cursor.execute(sql, params)
127
128Exception Type: ProgrammingError at /api/albums/
129Exception Value: SELECT DISTINCT ON expressions must match initial ORDER BY expressions
130LINE 1: SELECT COUNT(*) FROM (SELECT DISTINCT ON ("albums_album"."ye...
131 ^
132
133Request information:
134USER: jack
135
136GET:
137format = 'datatables'
138draw = '1'
139columns[0][data] = 'rank'
140columns[0][name] = ''
141columns[0][searchable] = 'false'
142columns[0][orderable] = 'true'
143columns[0][search][value] = ''
144columns[0][search][regex] = 'false'
145columns[1][data] = 'artist.name'
146columns[1][name] = 'artist.name'
147columns[1][searchable] = 'true'
148columns[1][orderable] = 'true'
149columns[1][search][value] = ''
150columns[1][search][regex] = 'false'
151columns[2][data] = 'name'
152columns[2][name] = ''
153columns[2][searchable] = 'true'
154columns[2][orderable] = 'true'
155columns[2][search][value] = ''
156columns[2][search][regex] = 'false'
157columns[3][data] = 'year'
158columns[3][name] = ''
159columns[3][searchable] = 'true'
160columns[3][orderable] = 'true'
161columns[3][search][value] = ''
162columns[3][search][regex] = 'false'
163columns[4][data] = 'genres'
164columns[4][name] = 'genres.name'
165columns[4][searchable] = 'true'
166columns[4][orderable] = 'false'
167columns[4][search][value] = ''
168columns[4][search][regex] = 'false'
169order[0][column] = '0'
170order[0][dir] = 'asc'
171start = '0'
172length = '10'
173search[value] = ''
174search[regex] = 'false'
175_ = '1531170631897'
176
177POST: No POST data
178
179FILES: No FILES data
180
181COOKIES:
182djdt = 'hide'
183tabstyle = 'raw-tab'
184csrftoken = 'JQImhuOKoqSTDkpSeb2pM6ESpEmdoMOt25ECC30lOA8haXP7fy6IhTpmsquxX2t9'
185sessionid = 'h4b5qd51e4yynl5pqa60ybu6w4fjgdcp'
186
187META:
188CLUTTER_IM_MODULE = 'xim'
189COLORTERM = 'truecolor'
190CONTENT_LENGTH = ''
191CONTENT_TYPE = 'text/plain'
192CSRF_COOKIE = 'JQImhuOKoqSTDkpSeb2pM6ESpEmdoMOt25ECC30lOA8haXP7fy6IhTpmsquxX2t9'
193DBUS_SESSION_BUS_ADDRESS = 'unix:path=/run/user/1001/bus'
194DEFAULTS_PATH = '/usr/share/gconf/ubuntu.default.path'
195DESKTOP_SESSION = 'ubuntu'
196DISPLAY = ':0'
197DJANGO_SETTINGS_MODULE = 'example.settings'
198GATEWAY_INTERFACE = 'CGI/1.1'
199GDMSESSION = 'ubuntu'
200GJS_DEBUG_OUTPUT = 'stderr'
201GJS_DEBUG_TOPICS = 'JS ERROR;JS LOG'
202GNOME_DESKTOP_SESSION_ID = 'this-is-deprecated'
203GNOME_SHELL_SESSION_MODE = 'ubuntu'
204GNOME_TERMINAL_SCREEN = '/org/gnome/Terminal/screen/5d803a47_bd36_4207_9937_e6a76faad6b7'
205GNOME_TERMINAL_SERVICE = ':1.189'
206GPG_AGENT_INFO = '/run/user/1001/gnupg/S.gpg-agent:0:1'
207GTK_IM_MODULE = 'ibus'
208GTK_MODULES = 'gail:atk-bridge'
209HOME = '/home/watervize'
210HTTP_ACCEPT = 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8'
211HTTP_ACCEPT_ENCODING = 'gzip, deflate, br'
212HTTP_ACCEPT_LANGUAGE = 'en-US,en;q=0.9'
213HTTP_CONNECTION = 'keep-alive'
214HTTP_COOKIE = 'djdt=hide; tabstyle=raw-tab; csrftoken=JQImhuOKoqSTDkpSeb2pM6ESpEmdoMOt25ECC30lOA8haXP7fy6IhTpmsquxX2t9; sessionid=h4b5qd51e4yynl5pqa60ybu6w4fjgdcp'
215HTTP_HOST = '127.0.0.1:8000'
216HTTP_UPGRADE_INSECURE_REQUESTS = '1'
217HTTP_USER_AGENT = 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.99 Safari/537.36'
218IM_CONFIG_PHASE = '2'
219LANG = 'en_US.UTF-8'
220LESSCLOSE = '/usr/bin/lesspipe %s %s'
221LESSOPEN = '| /usr/bin/lesspipe %s'
222LOGNAME = 'watervize'
223LS_COLORS = 'rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=00:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arc=01;31:*.arj=01;31:*.taz=01;31:*.lha=01;31:*.lz4=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.tzo=01;31:*.t7z=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lrz=01;31:*.lz=01;31:*.lzo=01;31:*.xz=01;31:*.zst=01;31:*.tzst=01;31:*.bz2=01;31:*.bz=01;31:*.tbz=01;31:*.tbz2=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.war=01;31:*.ear=01;31:*.sar=01;31:*.rar=01;31:*.alz=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.cab=01;31:*.wim=01;31:*.swm=01;31:*.dwm=01;31:*.esd=01;31:*.jpg=01;35:*.jpeg=01;35:*.mjpg=01;35:*.mjpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.webm=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=00;36:*.au=00;36:*.flac=00;36:*.m4a=00;36:*.mid=00;36:*.midi=00;36:*.mka=00;36:*.mp3=00;36:*.mpc=00;36:*.ogg=00;36:*.ra=00;36:*.wav=00;36:*.oga=00;36:*.opus=00;36:*.spx=00;36:*.xspf=00;36:'
224MANDATORY_PATH = '/usr/share/gconf/ubuntu.mandatory.path'
225OLDPWD = '/home/watervize/example/django-rest-framework-datatables'
226PATH = '/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin'
227PATH_INFO = '/api/albums/'
228PIPENV_ACTIVE = '1'
229PIP_PYTHON_PATH = '/usr/local/bin/python3.6'
230PS1 = '(django-rest-framework-datatables-0mGRhC6T) \\[\\e]0;\\u@\\h: \\w\\a\\]${debian_chroot:+($debian_chroot)}\\[\\033[01;32m\\]\\u@\\h\\[\\033[00m\\]:\\[\\033[01;34m\\]\\w\\[\\033[00m\\]\\$ '
231PWD = '/home/watervize/example/django-rest-framework-datatables/example'
232PYTHONDONTWRITEBYTECODE = '1'
233QT4_IM_MODULE = 'xim'
234QT_ACCESSIBILITY = '1'
235QT_IM_MODULE = 'ibus'
236QUERY_STRING = 'format=datatables&draw=1&columns%5B0%5D%5Bdata%5D=rank&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=false&columns%5B0%5D%5Borderable%5D=true&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=artist.name&columns%5B1%5D%5Bname%5D=artist.name&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=true&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B2%5D%5Bdata%5D=name&columns%5B2%5D%5Bname%5D=&columns%5B2%5D%5Bsearchable%5D=true&columns%5B2%5D%5Borderable%5D=true&columns%5B2%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B2%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B3%5D%5Bdata%5D=year&columns%5B3%5D%5Bname%5D=&columns%5B3%5D%5Bsearchable%5D=true&columns%5B3%5D%5Borderable%5D=true&columns%5B3%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B3%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B4%5D%5Bdata%5D=genres&columns%5B4%5D%5Bname%5D=genres.name&columns%5B4%5D%5Bsearchable%5D=true&columns%5B4%5D%5Borderable%5D=false&columns%5B4%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B4%5D%5Bsearch%5D%5Bregex%5D=false&order%5B0%5D%5Bcolumn%5D=0&order%5B0%5D%5Bdir%5D=asc&start=0&length=10&search%5Bvalue%5D=&search%5Bregex%5D=false&_=1531170631897'
237REMOTE_ADDR = '127.0.0.1'
238REMOTE_HOST = ''
239REQUEST_METHOD = 'GET'
240RUN_MAIN = 'true'
241SCRIPT_NAME = ''
242SERVER_NAME = 'localhost'
243SERVER_PORT = '8000'
244SERVER_PROTOCOL = 'HTTP/1.1'
245SERVER_SOFTWARE = 'WSGIServer/0.2'
246SESSION_MANAGER = 'local/raven-genesis:@/tmp/.ICE-unix/1604,unix/raven-genesis:/tmp/.ICE-unix/1604'
247SHELL = '/bin/bash'
248SHLVL = '2'
249SSH_AGENT_PID = '1698'
250SSH_AUTH_SOCK = '/run/user/1001/keyring/ssh'
251S_COLORS = 'auto'
252TERM = 'xterm-256color'
253TEXTDOMAIN = 'im-config'
254TEXTDOMAINDIR = '/usr/share/locale/'
255TZ = 'UTC'
256USER = 'watervize'
257USERNAME = 'watervize'
258VIRTUAL_ENV = '/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T'
259VTE_VERSION = '5202'
260WINDOWPATH = '2'
261XAUTHORITY = '/run/user/1001/gdm/Xauthority'
262XDG_CONFIG_DIRS = '/etc/xdg/xdg-ubuntu:/etc/xdg'
263XDG_CURRENT_DESKTOP = 'ubuntu:GNOME'
264XDG_DATA_DIRS = '/usr/share/ubuntu:/usr/local/share:/usr/share:/var/lib/snapd/desktop'
265XDG_MENU_PREFIX = 'gnome-'
266XDG_RUNTIME_DIR = '/run/user/1001'
267XDG_SEAT = 'seat0'
268XDG_SESSION_DESKTOP = 'ubuntu'
269XDG_SESSION_ID = '2'
270XDG_SESSION_TYPE = 'x11'
271XDG_VTNR = '2'
272XMODIFIERS = '@im=ibus'
273_ = '/home/watervize/.local/share/virtualenvs/django-rest-framework-datatables-0mGRhC6T/bin/python'
274wsgi.errors = <_io.TextIOWrapper name='<stderr>' mode='w' encoding='UTF-8'>
275wsgi.file_wrapper = ''
276wsgi.input = <_io.BufferedReader name=9>
277wsgi.multiprocess = False
278wsgi.multithread = True
279wsgi.run_once = False
280wsgi.url_scheme = 'http'
281wsgi.version = '(1, 0)'
282
283Settings:
284Using settings module example.settings
285ABSOLUTE_URL_OVERRIDES = {}
286ADMINS = []
287ALLOWED_HOSTS = []
288APPEND_SLASH = True
289AUTHENTICATION_BACKENDS = ['django.contrib.auth.backends.ModelBackend']
290AUTH_PASSWORD_VALIDATORS = '********************'
291AUTH_USER_MODEL = 'auth.User'
292BASE_DIR = '/home/watervize/example/django-rest-framework-datatables/example'
293CACHES = {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}}
294CACHE_MIDDLEWARE_ALIAS = 'default'
295CACHE_MIDDLEWARE_KEY_PREFIX = '********************'
296CACHE_MIDDLEWARE_SECONDS = 600
297CSRF_COOKIE_AGE = 31449600
298CSRF_COOKIE_DOMAIN = None
299CSRF_COOKIE_HTTPONLY = False
300CSRF_COOKIE_NAME = 'csrftoken'
301CSRF_COOKIE_PATH = '/'
302CSRF_COOKIE_SECURE = False
303CSRF_FAILURE_VIEW = 'django.views.csrf.csrf_failure'
304CSRF_HEADER_NAME = 'HTTP_X_CSRFTOKEN'
305CSRF_TRUSTED_ORIGINS = []
306CSRF_USE_SESSIONS = False
307DATABASES = {'default': {'ENGINE': 'django.db.backends.postgresql', 'NAME': 'newdb', 'USER': 'newdb', 'PASSWORD': '********************', 'HOST': 'localhost', 'PORT': '5432', 'ATOMIC_REQUESTS': True, 'AUTOCOMMIT': True, 'CONN_MAX_AGE': 0, 'OPTIONS': {}, 'TIME_ZONE': None, 'TEST': {'CHARSET': None, 'COLLATION': None, 'NAME': None, 'MIRROR': None}}}
308DATABASE_ROUTERS = []
309DATA_UPLOAD_MAX_MEMORY_SIZE = 2621440
310DATA_UPLOAD_MAX_NUMBER_FIELDS = 1000
311DATETIME_FORMAT = 'N j, Y, P'
312DATETIME_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']
313DATE_FORMAT = 'N j, Y'
314DATE_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']
315DEBUG = True
316DEBUG_PROPAGATE_EXCEPTIONS = False
317DECIMAL_SEPARATOR = '.'
318DEFAULT_CHARSET = 'utf-8'
319DEFAULT_CONTENT_TYPE = 'text/html'
320DEFAULT_EXCEPTION_REPORTER_FILTER = 'django.views.debug.SafeExceptionReporterFilter'
321DEFAULT_FILE_STORAGE = 'django.core.files.storage.FileSystemStorage'
322DEFAULT_FROM_EMAIL = 'webmaster@localhost'
323DEFAULT_INDEX_TABLESPACE = ''
324DEFAULT_TABLESPACE = ''
325DISALLOWED_USER_AGENTS = []
326EMAIL_BACKEND = 'django.core.mail.backends.smtp.EmailBackend'
327EMAIL_HOST = 'localhost'
328EMAIL_HOST_PASSWORD = '********************'
329EMAIL_HOST_USER = ''
330EMAIL_PORT = 25
331EMAIL_SSL_CERTFILE = None
332EMAIL_SSL_KEYFILE = '********************'
333EMAIL_SUBJECT_PREFIX = '[Django] '
334EMAIL_TIMEOUT = None
335EMAIL_USE_LOCALTIME = False
336EMAIL_USE_SSL = False
337EMAIL_USE_TLS = False
338FILE_CHARSET = 'utf-8'
339FILE_UPLOAD_DIRECTORY_PERMISSIONS = None
340FILE_UPLOAD_HANDLERS = ['django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler']
341FILE_UPLOAD_MAX_MEMORY_SIZE = 2621440
342FILE_UPLOAD_PERMISSIONS = None
343FILE_UPLOAD_TEMP_DIR = None
344FIRST_DAY_OF_WEEK = 0
345FIXTURE_DIRS = []
346FORCE_SCRIPT_NAME = None
347FORMAT_MODULE_PATH = None
348FORM_RENDERER = 'django.forms.renderers.DjangoTemplates'
349IGNORABLE_404_URLS = []
350INSTALLED_APPS = ['django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'rest_framework', 'rest_framework_datatables', 'albums']
351INTERNAL_IPS = []
352LANGUAGES = [('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'), ('kab', 'Kabyle'), ('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')]
353LANGUAGES_BIDI = ['he', 'ar', 'fa', 'ur']
354LANGUAGE_CODE = 'en-us'
355LANGUAGE_COOKIE_AGE = None
356LANGUAGE_COOKIE_DOMAIN = None
357LANGUAGE_COOKIE_NAME = 'django_language'
358LANGUAGE_COOKIE_PATH = '/'
359LOCALE_PATHS = []
360LOGGING = {}
361LOGGING_CONFIG = 'logging.config.dictConfig'
362LOGIN_REDIRECT_URL = '/accounts/profile/'
363LOGIN_URL = '/accounts/login/'
364LOGOUT_REDIRECT_URL = None
365MANAGERS = []
366MEDIA_ROOT = ''
367MEDIA_URL = ''
368MESSAGE_STORAGE = 'django.contrib.messages.storage.fallback.FallbackStorage'
369MIDDLEWARE = ['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']
370MIGRATION_MODULES = {}
371MONTH_DAY_FORMAT = 'F j'
372NUMBER_GROUPING = 0
373PASSWORD_HASHERS = '********************'
374PASSWORD_RESET_TIMEOUT_DAYS = '********************'
375PREPEND_WWW = False
376REST_FRAMEWORK = {'DEFAULT_RENDERER_CLASSES': ('rest_framework.renderers.JSONRenderer', 'rest_framework.renderers.BrowsableAPIRenderer', 'rest_framework_datatables.renderers.DatatablesRenderer'), 'DEFAULT_FILTER_BACKENDS': ('rest_framework_datatables.filters.DatatablesFilterBackend',), 'DEFAULT_PAGINATION_CLASS': 'rest_framework_datatables.pagination.DatatablesPageNumberPagination', 'PAGE_SIZE': 50, 'DEFAULT_PERMISSION_CLASSES': ['rest_framework.permissions.DjangoModelPermissionsOrAnonReadOnly']}
377ROOT_URLCONF = 'example.urls'
378SECRET_KEY = '********************'
379SECURE_BROWSER_XSS_FILTER = False
380SECURE_CONTENT_TYPE_NOSNIFF = False
381SECURE_HSTS_INCLUDE_SUBDOMAINS = False
382SECURE_HSTS_PRELOAD = False
383SECURE_HSTS_SECONDS = 0
384SECURE_PROXY_SSL_HEADER = None
385SECURE_REDIRECT_EXEMPT = []
386SECURE_SSL_HOST = None
387SECURE_SSL_REDIRECT = False
388SERVER_EMAIL = 'root@localhost'
389SESSION_CACHE_ALIAS = 'default'
390SESSION_COOKIE_AGE = 1209600
391SESSION_COOKIE_DOMAIN = None
392SESSION_COOKIE_HTTPONLY = True
393SESSION_COOKIE_NAME = 'sessionid'
394SESSION_COOKIE_PATH = '/'
395SESSION_COOKIE_SECURE = False
396SESSION_ENGINE = 'django.contrib.sessions.backends.db'
397SESSION_EXPIRE_AT_BROWSER_CLOSE = False
398SESSION_FILE_PATH = None
399SESSION_SAVE_EVERY_REQUEST = False
400SESSION_SERIALIZER = 'django.contrib.sessions.serializers.JSONSerializer'
401SETTINGS_MODULE = 'example.settings'
402SHORT_DATETIME_FORMAT = 'm/d/Y P'
403SHORT_DATE_FORMAT = 'm/d/Y'
404SIGNING_BACKEND = 'django.core.signing.TimestampSigner'
405SILENCED_SYSTEM_CHECKS = []
406STATICFILES_DIRS = []
407STATICFILES_FINDERS = ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder']
408STATICFILES_STORAGE = 'django.contrib.staticfiles.storage.StaticFilesStorage'
409STATIC_ROOT = None
410STATIC_URL = '/static/'
411TEMPLATES = [{'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']}}]
412TEST_NON_SERIALIZED_APPS = []
413TEST_RUNNER = 'django.test.runner.DiscoverRunner'
414THOUSAND_SEPARATOR = ','
415TIME_FORMAT = 'P'
416TIME_INPUT_FORMATS = ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M']
417TIME_ZONE = 'UTC'
418USE_ETAGS = False
419USE_I18N = True
420USE_L10N = True
421USE_THOUSAND_SEPARATOR = False
422USE_TZ = True
423USE_X_FORWARDED_HOST = False
424USE_X_FORWARDED_PORT = False
425WSGI_APPLICATION = 'example.wsgi.application'
426X_FRAME_OPTIONS = 'SAMEORIGIN'
427YEAR_MONTH_FORMAT = 'F Y'
428
429
430You're seeing this error because you have DEBUG = True in your
431Django settings file. Change that to False, and Django will
432display a standard page generated by the handler for this status code.