· 8 years ago · Apr 26, 2017, 05:04 PM
1ProgrammingError at /api/method/quest.list
2not all arguments converted during string formatting
3
4Request Method: GET
5Request URL: http://training.keva.su/api/method/quest.list?access_token=bi3wl84ozyqup8nm0c0ktjruuo2hyqs3y
6Django Version: 1.11
7Python Executable: /usr/local/bin/uwsgi
8Python Version: 3.5.2
9Python Path: ['.', '', '/usr/lib/python35.zip', '/usr/lib/python3.5', '/usr/lib/python3.5/plat-x86_64-linux-gnu', '/usr/lib/python3.5/lib-dynload', '/usr/local/lib/python3.5/dist-packages', '/usr/lib/python3/dist-packages']
10Server time: Wed, 26 Apr 2017 16:59:29 +0000
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 'api']
19Installed Middleware:
20['api.middleware.token_validate.TokenValidateMiddleware',
21 'django.middleware.security.SecurityMiddleware',
22 'django.contrib.sessions.middleware.SessionMiddleware',
23 'django.middleware.common.CommonMiddleware',
24 'django.contrib.auth.middleware.AuthenticationMiddleware',
25 'django.contrib.messages.middleware.MessageMiddleware',
26 'django.middleware.clickjacking.XFrameOptionsMiddleware']
27
28
29Traceback:
30
31File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py" in execute
32 238. query = query % args
33
34
35 During handling of the above exception (not all arguments converted during string formatting), another exception occurred:
36
37
38
39File "/usr/local/lib/python3.5/dist-packages/django/db/backends/utils.py" in execute
40 65. return self.cursor.execute(sql, params)
41
42File "/usr/local/lib/python3.5/dist-packages/django/db/backends/mysql/base.py" in execute
43 101. return self.cursor.execute(query, args)
44
45File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py" in execute
46 240. self.errorhandler(self, ProgrammingError, str(m))
47
48File "/usr/local/lib/python3.5/dist-packages/MySQLdb/connections.py" in defaulterrorhandler
49 52. raise errorclass(errorvalue)
50
51
52 The above exception (not all arguments converted during string formatting) was the direct cause of the following exception:
53
54
55
56File "/usr/local/lib/python3.5/dist-packages/django/core/handlers/exception.py" in inner
57 41. response = get_response(request)
58
59File "/usr/local/lib/python3.5/dist-packages/django/core/handlers/base.py" in _get_response
60 187. response = self.process_exception_by_middleware(e, request)
61
62File "/usr/local/lib/python3.5/dist-packages/django/core/handlers/base.py" in _get_response
63 185. response = wrapped_callback(request, *callback_args, **callback_kwargs)
64
65File "./api/methods/quest.py" in list_quest
66 121. for quest in quests:
67
68File "/usr/local/lib/python3.5/dist-packages/django/db/models/query.py" in __iter__
69 1217. query = iter(self.query)
70
71File "/usr/local/lib/python3.5/dist-packages/django/db/models/sql/query.py" in __iter__
72 80. self._execute_query()
73
74File "/usr/local/lib/python3.5/dist-packages/django/db/models/sql/query.py" in _execute_query
75 114. self.cursor.execute(self.sql, params)
76
77File "/usr/local/lib/python3.5/dist-packages/django/db/backends/utils.py" in execute
78 80. return super(CursorDebugWrapper, self).execute(sql, params)
79
80File "/usr/local/lib/python3.5/dist-packages/django/db/backends/utils.py" in execute
81 65. return self.cursor.execute(sql, params)
82
83File "/usr/local/lib/python3.5/dist-packages/django/db/utils.py" in __exit__
84 94. six.reraise(dj_exc_type, dj_exc_value, traceback)
85
86File "/usr/local/lib/python3.5/dist-packages/django/utils/six.py" in reraise
87 685. raise value.with_traceback(tb)
88
89File "/usr/local/lib/python3.5/dist-packages/django/db/backends/utils.py" in execute
90 65. return self.cursor.execute(sql, params)
91
92File "/usr/local/lib/python3.5/dist-packages/django/db/backends/mysql/base.py" in execute
93 101. return self.cursor.execute(query, args)
94
95File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py" in execute
96 240. self.errorhandler(self, ProgrammingError, str(m))
97
98File "/usr/local/lib/python3.5/dist-packages/MySQLdb/connections.py" in defaulterrorhandler
99 52. raise errorclass(errorvalue)
100
101Exception Type: ProgrammingError at /api/method/quest.list
102Exception Value: not all arguments converted during string formatting
103Request information:
104USER: AnonymousUser
105
106GET:
107access_token = 'bi3wl84ozyqup8nm0c0ktjruuo2hyqs3y'
108
109POST: No POST data
110
111FILES: No FILES data
112
113COOKIES:
114user_id = '13'
115token = 'bi3wl84ozyqup8nm0c0ktjruuo2hyqs3y'
116
117META:
118CONTENT_LENGTH = ''
119CONTENT_TYPE = ''
120DOCUMENT_ROOT = '/usr/share/nginx/html'
121HTTP_ACCEPT = 'application/json, text/javascript, */*; q=0.01'
122HTTP_ACCEPT_ENCODING = 'gzip, deflate'
123HTTP_ACCEPT_LANGUAGE = 'ru'
124HTTP_CONNECTION = 'keep-alive'
125HTTP_COOKIE = 'token=bi3wl84ozyqup8nm0c0ktjruuo2hyqs3y; user_id=13'
126HTTP_DNT = '1'
127HTTP_HOST = 'training.keva.su'
128HTTP_REFERER = 'http://training.keva.su/'
129HTTP_USER_AGENT = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_4) AppleWebKit/603.1.30 (KHTML, like Gecko) Version/10.1 Safari/603.1.30'
130HTTP_X_REQUESTED_WITH = 'XMLHttpRequest'
131PATH_INFO = '/api/method/quest.list'
132QUERY_STRING = 'access_token=bi3wl84ozyqup8nm0c0ktjruuo2hyqs3y'
133REMOTE_ADDR = '176.59.194.202'
134REMOTE_PORT = '45119'
135REQUEST_METHOD = 'GET'
136REQUEST_URI = '/api/method/quest.list?access_token=bi3wl84ozyqup8nm0c0ktjruuo2hyqs3y'
137SCRIPT_NAME = ''
138SERVER_NAME = 'example.com'
139SERVER_PORT = '80'
140SERVER_PROTOCOL = 'HTTP/1.1'
141uwsgi.node = b'f73931fa3ea4'
142uwsgi.version = b'2.0.15'
143wsgi.errors = <_io.TextIOWrapper name=2 mode='w' encoding='ANSI_X3.4-1968'>
144wsgi.file_wrapper = ''
145wsgi.input = <uwsgi._Input object at 0x7ff346dea438>
146wsgi.multiprocess = True
147wsgi.multithread = False
148wsgi.run_once = False
149wsgi.url_scheme = 'http'
150wsgi.version =
151
152Settings:
153Using settings module asya.settings
154ABSOLUTE_URL_OVERRIDES = {}
155ADMINS = []
156ALLOWED_HOSTS = ['*']
157APPEND_SLASH = True
158AUTHENTICATION_BACKENDS = ['django.contrib.auth.backends.ModelBackend']
159AUTH_PASSWORD_VALIDATORS = '********************'
160AUTH_USER_MODEL = 'auth.User'
161BASE_DIR = '/app/platform'
162CACHES = {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}}
163CACHE_MIDDLEWARE_ALIAS = 'default'
164CACHE_MIDDLEWARE_KEY_PREFIX = '********************'
165CACHE_MIDDLEWARE_SECONDS = 600
166CSRF_COOKIE_AGE = 31449600
167CSRF_COOKIE_DOMAIN = None
168CSRF_COOKIE_HTTPONLY = False
169CSRF_COOKIE_NAME = 'csrftoken'
170CSRF_COOKIE_PATH = '/'
171CSRF_COOKIE_SECURE = False
172CSRF_FAILURE_VIEW = 'django.views.csrf.csrf_failure'
173CSRF_HEADER_NAME = 'HTTP_X_CSRFTOKEN'
174CSRF_TRUSTED_ORIGINS = []
175CSRF_USE_SESSIONS = False
176DATABASES = {'OPTIONS': {'PORT': '', 'charset': 'utf8mb4', 'ENGINE': 'django.db.backends.dummy', 'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'OPTIONS': {}, 'USER': '', 'NAME': '', 'TIME_ZONE': None, 'CONN_MAX_AGE': 0, 'HOST': '', 'TEST': {'CHARSET': None, 'MIRROR': None, 'NAME': None, 'COLLATION': None}, 'PASSWORD': '********************'}, 'default': {'PORT': '3306', 'ENGINE': 'django.db.backends.mysql', 'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'OPTIONS': {}, 'TEST': {'CHARSET': None, 'MIRROR': None, 'NAME': None, 'COLLATION': None}, 'NAME': 'asya', 'TIME_ZONE': None, 'CONN_MAX_AGE': 0, 'HOST': 'localhost', 'USER': 'root', 'PASSWORD': '********************'}}
177DATABASE_ROUTERS = []
178DATA_UPLOAD_MAX_MEMORY_SIZE = 2621440
179DATA_UPLOAD_MAX_NUMBER_FIELDS = 1000
180DATETIME_FORMAT = 'N j, Y, P'
181DATETIME_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']
182DATE_FORMAT = 'N j, Y'
183DATE_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']
184DEBUG = True
185DEBUG_PROPAGATE_EXCEPTIONS = False
186DECIMAL_SEPARATOR = '.'
187DEFAULT_CHARSET = 'utf-8'
188DEFAULT_CONTENT_TYPE = 'text/html'
189DEFAULT_EXCEPTION_REPORTER_FILTER = 'django.views.debug.SafeExceptionReporterFilter'
190DEFAULT_FILE_STORAGE = 'django.core.files.storage.FileSystemStorage'
191DEFAULT_FROM_EMAIL = 'webmaster@localhost'
192DEFAULT_INDEX_TABLESPACE = ''
193DEFAULT_TABLESPACE = ''
194DISALLOWED_USER_AGENTS = []
195EMAIL_BACKEND = 'django.core.mail.backends.smtp.EmailBackend'
196EMAIL_HOST = 'localhost'
197EMAIL_HOST_PASSWORD = '********************'
198EMAIL_HOST_USER = ''
199EMAIL_PORT = 25
200EMAIL_SSL_CERTFILE = None
201EMAIL_SSL_KEYFILE = '********************'
202EMAIL_SUBJECT_PREFIX = '[Django] '
203EMAIL_TIMEOUT = None
204EMAIL_USE_LOCALTIME = False
205EMAIL_USE_SSL = False
206EMAIL_USE_TLS = False
207FILE_CHARSET = 'utf-8'
208FILE_UPLOAD_DIRECTORY_PERMISSIONS = None
209FILE_UPLOAD_HANDLERS = ['django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler']
210FILE_UPLOAD_MAX_MEMORY_SIZE = 2621440
211FILE_UPLOAD_PERMISSIONS = None
212FILE_UPLOAD_TEMP_DIR = None
213FIRST_DAY_OF_WEEK = 0
214FIXTURE_DIRS = []
215FORCE_SCRIPT_NAME = None
216FORMAT_MODULE_PATH = None
217FORM_RENDERER = 'django.forms.renderers.DjangoTemplates'
218IGNORABLE_404_URLS = []
219INSTALLED_APPS = ['django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'api']
220INTERNAL_IPS = []
221LANGUAGES = [('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')]
222LANGUAGES_BIDI = ['he', 'ar', 'fa', 'ur']
223LANGUAGE_CODE = 'en-us'
224LANGUAGE_COOKIE_AGE = None
225LANGUAGE_COOKIE_DOMAIN = None
226LANGUAGE_COOKIE_NAME = 'django_language'
227LANGUAGE_COOKIE_PATH = '/'
228LOCALE_PATHS = []
229LOGGING = {}
230LOGGING_CONFIG = 'logging.config.dictConfig'
231LOGIN_REDIRECT_URL = '/accounts/profile/'
232LOGIN_URL = '/accounts/login/'
233LOGOUT_REDIRECT_URL = None
234MANAGERS = []
235MEDIA_ROOT = ''
236MEDIA_URL = ''
237MESSAGE_STORAGE = 'django.contrib.messages.storage.fallback.FallbackStorage'
238MIDDLEWARE = ['api.middleware.token_validate.TokenValidateMiddleware', 'django.middleware.security.SecurityMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.common.CommonMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware']
239MIDDLEWARE_CLASSES = ['django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware']
240MIGRATION_MODULES = {}
241MONTH_DAY_FORMAT = 'F j'
242NUMBER_GROUPING = 0
243PASSWORD_HASHERS = '********************'
244PASSWORD_RESET_TIMEOUT_DAYS = '********************'
245PREPEND_WWW = False
246ROOT_URLCONF = 'asya.urls'
247SECRET_KEY = '********************'
248SECURE_BROWSER_XSS_FILTER = False
249SECURE_CONTENT_TYPE_NOSNIFF = False
250SECURE_HSTS_INCLUDE_SUBDOMAINS = False
251SECURE_HSTS_PRELOAD = False
252SECURE_HSTS_SECONDS = 0
253SECURE_PROXY_SSL_HEADER = None
254SECURE_REDIRECT_EXEMPT = []
255SECURE_SSL_HOST = None
256SECURE_SSL_REDIRECT = False
257SERVER_EMAIL = 'root@localhost'
258SESSION_CACHE_ALIAS = 'default'
259SESSION_COOKIE_AGE = 1209600
260SESSION_COOKIE_DOMAIN = None
261SESSION_COOKIE_HTTPONLY = True
262SESSION_COOKIE_NAME = 'sessionid'
263SESSION_COOKIE_PATH = '/'
264SESSION_COOKIE_SECURE = False
265SESSION_ENGINE = 'django.contrib.sessions.backends.db'
266SESSION_EXPIRE_AT_BROWSER_CLOSE = False
267SESSION_FILE_PATH = None
268SESSION_SAVE_EVERY_REQUEST = False
269SESSION_SERIALIZER = 'django.contrib.sessions.serializers.JSONSerializer'
270SETTINGS_MODULE = 'asya.settings'
271SHORT_DATETIME_FORMAT = 'm/d/Y P'
272SHORT_DATE_FORMAT = 'm/d/Y'
273SIGNING_BACKEND = 'django.core.signing.TimestampSigner'
274SILENCED_SYSTEM_CHECKS = []
275STATICFILES_DIRS = []
276STATICFILES_FINDERS = ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder']
277STATICFILES_STORAGE = 'django.contrib.staticfiles.storage.StaticFilesStorage'
278STATIC_ROOT = 'frontend/static'
279STATIC_URL = '/static/'
280TEMPLATES = [{'APP_DIRS': True, 'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': ['/app/platform/frontend/templates'], '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']}}]
281TEST_NON_SERIALIZED_APPS = []
282TEST_RUNNER = 'django.test.runner.DiscoverRunner'
283THOUSAND_SEPARATOR = ','
284TIME_FORMAT = 'P'
285TIME_INPUT_FORMATS = ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M']
286TIME_ZONE = 'UTC'
287TOKEN_EXPIRED_TIME = '********************'
288USE_ETAGS = False
289USE_I18N = True
290USE_L10N = True
291USE_THOUSAND_SEPARATOR = False
292USE_TZ = False
293USE_X_FORWARDED_HOST = False
294USE_X_FORWARDED_PORT = False
295WSGI_APPLICATION = 'asya.wsgi.application'
296X_FRAME_OPTIONS = 'SAMEORIGIN'
297YEAR_MONTH_FORMAT = 'F Y'
298
299
300You're seeing this error because you have DEBUG = True in your
301Django settings file. Change that to False, and Django will
302display a standard page generated by the handler for this status code.