{"draw": 6, "recordsTotal": 0, "recordsFiltered": 0, "result": "ok", "error": "\nOperationalError\n(1054, \"Unknown column 'T7.title' in 'having clause'\")\n\nDjango Version: 1.8.4\nPython Executable: /home/pavel/work/npoed/npoed-plp-edx/.env/bin/python\nPython Version: 2.7.6\nPython Path: ['/home/pavel/work/npoed/npoed-plp-edx/npoed_plp', '/home/pavel/work/npoed/npoed-plp-edx', '/home/pavel/work/npoed/npoed-plp-edx/.env/lib/python2.7', '/home/pavel/work/npoed/npoed-plp-edx/.env/lib/python2.7/plat-x86_64-linux-gnu', '/home/pavel/work/npoed/npoed-plp-edx/.env/lib/python2.7/lib-tk', '/home/pavel/work/npoed/npoed-plp-edx/.env/lib/python2.7/lib-old', '/home/pavel/work/npoed/npoed-plp-edx/.env/lib/python2.7/lib-dynload', '/usr/lib/python2.7', '/usr/lib/python2.7/plat-x86_64-linux-gnu', '/usr/lib/python2.7/lib-tk', '/home/pavel/work/npoed/npoed-plp-edx/.env/local/lib/python2.7/site-packages']\nServer time: \u0412\u0442, 23 \u0410\u0432\u0433 2016 16:50:23 +0300\nInstalled Applications:\n('debug_toolbar',\n 'dal',\n 'dal_select2',\n 'django.contrib.admin',\n 'django.contrib.auth',\n 'django.contrib.contenttypes',\n 'django.contrib.sessions',\n 'django.contrib.messages',\n 'django.contrib.staticfiles',\n 'django.contrib.sites',\n 'django.contrib.flatpages',\n 'django.contrib.sitemaps',\n 'plp',\n 'statistics',\n 'payments',\n 'metadata',\n 'pytils',\n 'imagekit',\n 'social.apps.django_app.default',\n 'meta',\n 'rest_framework',\n 'djcelery',\n 'djcelery_email',\n 'post_office',\n 'simple_history',\n 'django_user_agents',\n 'widget_tweaks',\n 'djangoformsetjs',\n 'pagination')\nInstalled Middleware:\n('django.contrib.sessions.middleware.SessionMiddleware',\n 'django.middleware.locale.LocaleMiddleware',\n 'django.middleware.common.CommonMiddleware',\n 'django.middleware.csrf.CsrfViewMiddleware',\n 'django.contrib.auth.middleware.AuthenticationMiddleware',\n 'django.contrib.auth.middleware.SessionAuthenticationMiddleware',\n 'django.contrib.messages.middleware.MessageMiddleware',\n 'django.middleware.clickjacking.XFrameOptionsMiddleware',\n 'django.middleware.security.SecurityMiddleware',\n 'django.contrib.flatpages.middleware.FlatpageFallbackMiddleware',\n 'plp.middleware.UTMTrackingMiddleware',\n 'django_user_agents.middleware.UserAgentMiddleware',\n 'pagination.middleware.PaginationMiddleware',\n 'http_errors.middleware.HTTPErrorsMiddleware',\n 'debug_toolbar.middleware.DebugToolbarMiddleware')\n\nTraceback:\nFile \"/home/pavel/work/npoed/npoed-plp-edx/npoed_plp/plp/views/datatables/base.py\" in get_context_data\n  218.             data = self.prepare_results(qs)\nFile \"/home/pavel/work/npoed/npoed-plp-edx/npoed_plp/plp/views/datatables/base.py\" in prepare_results\n  260.         for obj in qs:\nFile \"/home/pavel/work/npoed/npoed-plp-edx/.env/local/lib/python2.7/site-packages/django/db/models/query.py\" in __iter__\n  162.         self._fetch_all()\nFile \"/home/pavel/work/npoed/npoed-plp-edx/.env/local/lib/python2.7/site-packages/django/db/models/query.py\" in _fetch_all\n  965.             self._result_cache = list(self.iterator())\nFile \"/home/pavel/work/npoed/npoed-plp-edx/.env/local/lib/python2.7/site-packages/django/db/models/query.py\" in iterator\n  238.         results = compiler.execute_sql()\nFile \"/home/pavel/work/npoed/npoed-plp-edx/.env/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py\" in execute_sql\n  840.             cursor.execute(sql, params)\nFile \"/home/pavel/work/npoed/npoed-plp-edx/.env/local/lib/python2.7/site-packages/debug_toolbar/panels/sql/tracking.py\" in execute\n  159.         return self._record(self.cursor.execute, sql, params)\nFile \"/home/pavel/work/npoed/npoed-plp-edx/.env/local/lib/python2.7/site-packages/debug_toolbar/panels/sql/tracking.py\" in _record\n  101.             return method(sql, params)\nFile \"/home/pavel/work/npoed/npoed-plp-edx/.env/local/lib/python2.7/site-packages/django/db/backends/utils.py\" in execute\n  79.             return super(CursorDebugWrapper, self).execute(sql, params)\nFile \"/home/pavel/work/npoed/npoed-plp-edx/.env/local/lib/python2.7/site-packages/django/db/backends/utils.py\" in execute\n  64.                 return self.cursor.execute(sql, params)\nFile \"/home/pavel/work/npoed/npoed-plp-edx/.env/local/lib/python2.7/site-packages/django/db/utils.py\" in __exit__\n  97.                 six.reraise(dj_exc_type, dj_exc_value, traceback)\nFile \"/home/pavel/work/npoed/npoed-plp-edx/.env/local/lib/python2.7/site-packages/django/db/backends/utils.py\" in execute\n  64.                 return self.cursor.execute(sql, params)\nFile \"/home/pavel/work/npoed/npoed-plp-edx/.env/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py\" in execute\n  124.             return self.cursor.execute(query, args)\nFile \"/home/pavel/work/npoed/npoed-plp-edx/.env/local/lib/python2.7/site-packages/MySQLdb/cursors.py\" in execute\n  205.             self.errorhandler(self, exc, value)\nFile \"/home/pavel/work/npoed/npoed-plp-edx/.env/local/lib/python2.7/site-packages/MySQLdb/connections.py\" in defaulterrorhandler\n  36.     raise errorclass, errorvalue\n\nException Type: OperationalError\nException Value: (1054, \"Unknown column 'T7.title' in 'having clause'\")\nRequest data not supplied\n\nSettings:\nUsing settings module settings.local_settings\nUSE_TZ = True\nDEBUG_TOOLBAR_PANELS = \nSECURE_BROWSER_XSS_FILTER = False\nIMAGEKIT_CACHEFILE_DIR = 'CACHE/images'\nUSE_THOUSAND_SEPARATOR = False\nPOST_OFFICE_BACKEND = 'djcelery_email.backends.CeleryEmailBackend'\nCSRF_COOKIE_SECURE = False\nLANGUAGE_CODE = 'ru'\nROOT_URLCONF = 'urls'\nMANAGERS = \nPOST_OFFICE = {'DEFAULT_PRIORITY': 'high'}\nBROKER_URL = 'amqp://myuser1:mypassword1@localhost:5672/myvhost'\nBASE_DIR = '/home/pavel/work/npoed/npoed-plp-edx/npoed_plp'\nSILENCED_SYSTEM_CHECKS = []\nDEFAULT_CHARSET = 'utf-8'\nSESSION_SERIALIZER = 'django.contrib.sessions.serializers.JSONSerializer'\nSTATIC_ROOT = '/home/pavel/work/npoed/npoed-plp-edx/npoed_plp/static/'\nSSO_API_TOKEN = u'********************'\nCELERYBEAT_SCHEDULER = 'djcelery.schedulers.DatabaseScheduler'\nIMAGEKIT_USE_MEMCACHED_SAFE_CACHE_KEY = u'********************'\nEMAIL_TO_DIRECTOR = \nALLOWED_HOSTS = []\nMESSAGE_STORAGE = 'django.contrib.messages.storage.fallback.FallbackStorage'\nEMAIL_SUBJECT_PREFIX = '[Django] '\nSERVER_EMAIL = 'root@localhost'\nSECURE_HSTS_SECONDS = 0\nSTATICFILES_FINDERS = \nEMAIL_NOTIFICATIONS_FROM = \nSESSION_CACHE_ALIAS = 'default'\nMETA_USE_OG_PROPERTIES = True\nSOCIAL_AUTH_EXCLUDE_URL_PATTERN = '^/admin'\nSESSION_COOKIE_DOMAIN = None\nEMAIL_PROCTORING = \nMETA_SITE_PROTOCOL = 'http'\nTIME_INPUT_FORMATS = \nSECURE_REDIRECT_EXEMPT = []\nDATABASES = {'default': {'ENGINE': 'django.db.backends.mysql', 'AUTOCOMMIT': True, 'ATOMIC_REQUESTS': False, 'NAME': 'npoed_plp', 'CONN_MAX_AGE': 0, 'TIME_ZONE': 'UTC', 'PORT': '3306', 'HOST': '127.0.0.1', 'USER': 'npoed', 'TEST': {'COLLATION': None, 'CHARSET': None, 'NAME': None, 'MIRROR': None}, 'PASSWORD': u'********************', 'OPTIONS': {}}, 'statistics': {'ENGINE': 'django.db.backends.sqlite3', 'AUTOCOMMIT': True, 'ATOMIC_REQUESTS': False, 'NAME': 'statistics.sqlite', 'CONN_MAX_AGE': 0, 'TIME_ZONE': 'UTC', 'OPTIONS': {}, 'HOST': '', 'USER': '', 'TEST': {'COLLATION': None, 'CHARSET': None, 'NAME': None, 'MIRROR': None}, 'PASSWORD': u'********************', 'PORT': ''}}\nEMAIL_SSL_KEYFILE = u'********************'\nTEMPLATE_DEBUG = False\nFILE_UPLOAD_DIRECTORY_PERMISSIONS = None\nSTATIC_URL = '/static/'\nFILE_UPLOAD_PERMISSIONS = None\nFILE_UPLOAD_HANDLERS = \nDEFAULT_CONTENT_TYPE = 'text/html'\nYANDEX_MONEY_DEBUG = True\nTEST_RUNNER = 'django_coverage.coverage_runner.CoverageRunner'\nTEMPLATE_LOADERS = \nAPPEND_SLASH = True\nFIRST_DAY_OF_WEEK = 0\nDATABASE_ROUTERS = ['statistics.router.EnrollmentRouter']\nDEFAULT_TABLESPACE = ''\nLOCAL_APPS = \nYEAR_MONTH_FORMAT = 'F Y'\nSSO_NPOED_BACKEND_NAME = 'npoedsso'\nSTATICFILES_STORAGE = 'django.contrib.staticfiles.storage.StaticFilesStorage'\nCACHES = {'default': {'LOCATION': '127.0.0.1:11211', 'TIMEOUT': 86400, 'BACKEND': 'django.core.cache.backends.memcached.MemcachedCache'}}\nBROKER_USER = 'myuser1'\nIMAGEKIT_CACHE_BACKEND = 'django.core.cache.backends.dummy.DummyCache'\nSESSION_COOKIE_PATH = '/'\nYANDEX_MONEY_SHOP_PASSWORD = u'********************'\nYANDEX_MONEY_FAIL_URL = 'http://localhost:8000/payment/yandex/fail-payment/'\nAUTOCOMPLETE_EXCLUDE_URL_PATTERN = '^/autocomplete'\nSECURE_CONTENT_TYPE_NOSNIFF = False\nMIDDLEWARE_CLASSES = \nEMAIL_TAG = u'Npoed'\nSITE_NAME = 'http://localhost:8000'\nSECRET_KEY = u'********************'\nLANGUAGE_COOKIE_NAME = 'django_language'\nIMAGEKIT_SPEC_CACHEFILE_NAMER = 'imagekit.cachefiles.namers.source_name_as_path'\nDEFAULT_INDEX_TABLESPACE = ''\nLOGGING_CONFIG = 'logging.config.dictConfig'\nSOCIAL_AUTH_ENABLED_BACKENDS = 'npoedsso'\nBROKER_VHOST = 'myvhost'\nSOCIAL_AUTH_LOGOUT_URL = 'http://127.0.0.1:8080/logout/'\nWSGI_APPLICATION = 'wsgi.application'\nIMAGEKIT_CACHE_PREFIX = 'imagekit:'\nX_FRAME_OPTIONS = 'SAMEORIGIN'\nCSRF_COOKIE_NAME = 'csrftoken'\nFORCE_SCRIPT_NAME = None\nUSE_X_FORWARDED_HOST = False\nUSE_ETAGS = False\nEMAIL_TIMEOUT = None\nSECURE_SSL_HOST = None\nSIGNING_BACKEND = 'django.core.signing.TimestampSigner'\nSESSION_COOKIE_SECURE = False\nYANDEX_MONEY_SCID = 123\nCSRF_COOKIE_DOMAIN = None\nFILE_CHARSET = 'utf-8'\nDEBUG = True\nBROKER_PORT = 5672\nDEFAULT_FILE_STORAGE = 'django.core.files.storage.FileSystemStorage'\nINSTALLED_APPS = \nLANGUAGES_BIDI = \nUSE_L10N = True\nEDX_API_KEY = u'********************'\nYANDEX_MONEY_SHOP_ID = 456\nSECURE_HSTS_INCLUDE_SUBDOMAINS = False\nSTATICFILES_DIRS = \nPREPEND_WWW = False\nSECURE_PROXY_SSL_HEADER = None\nSOCIAL_NEXT_URL = '/'\nLANGUAGE_COOKIE_AGE = None\nSESSION_COOKIE_HTTPONLY = True\nDEBUG_PROPAGATE_EXCEPTIONS = False\nINTERNAL_IPS = ['127.0.0.1', '192.168.1.7', '192.168.1.5']\nEMAIL_TO_SUPPORT = \nURL_PREFIX = 'http'\nMONTH_DAY_FORMAT = 'F j'\nBROKER_PASSWORD = u'********************'\nLOGIN_URL = '/login/npoedsso/'\nSESSION_EXPIRE_AT_BROWSER_CLOSE = False\nTIME_FORMAT = 'P'\nEDX_COURSE_LINK = '{edx_base}/courses/{course_id_v1}/courseware'\nDEFAULT_APPS = \nAUTH_USER_MODEL = 'plp.User'\nDATE_INPUT_FORMATS = \nAUTHENTICATION_BACKENDS = \nEMAIL_HOST_PASSWORD = u'********************'\nSSO_NPOED_URL = 'http://127.0.0.1:8080'\nPASSWORD_RESET_TIMEOUT_DAYS = u'********************'\nLANGUAGE_COOKIE_DOMAIN = None\nCACHE_MIDDLEWARE_ALIAS = 'default'\nSESSION_SAVE_EVERY_REQUEST = False\nNUMBER_GROUPING = 0\nCSV_ROOT = '/home/pavel/work/npoed/npoed-plp-edx/npoed_plp/csv_dumps/'\nSESSION_ENGINE = 'django.contrib.sessions.backends.db'\nCSRF_FAILURE_VIEW = 'django.views.csrf.csrf_failure'\nCSRF_COOKIE_PATH = '/'\nLOGIN_REDIRECT_URL = '/'\nDECIMAL_SEPARATOR = '.'\nIGNORABLE_404_URLS = \nLOCALE_PATHS = '/home/pavel/work/npoed/npoed-plp-edx/npoed_plp/locale'\nTEMPLATE_STRING_IF_INVALID = ''\nSESSION_FILE_PATH = None\nLOGOUT_URL = '/sso-logout/'\nEMAIL_USE_TLS = False\nFIXTURE_DIRS = \nEMAIL_HOST = 'ksptmail.icc.spbstu.ru'\nDATE_FORMAT = 'N j, Y'\nYANDEX_MONEY_SUCCESS_URL = 'http://localhost:8000/payment/yandex/success-payment/'\nMEDIA_ROOT = '/home/pavel/work/npoed/npoed-plp-edx/npoed_plp/media/'\nLANGUAGE_COOKIE_PATH = '/'\nDEFAULT_EXCEPTION_REPORTER_FILTER = 'django.views.debug.SafeExceptionReporterFilter'\nADMINS = \nFORMAT_MODULE_PATH = None\nDEFAULT_FROM_EMAIL = 'webmaster@localhost'\nTHOUSAND_SEPARATOR = ','\nAMQP_HOST = 'localhost'\nMEDIA_URL = '/media/'\nDATETIME_FORMAT = 'N j, Y, P'\nTEMPLATE_DIRS = \nIMAGEKIT_CACHEFILE_NAMER = 'imagekit.cachefiles.namers.hash'\nSITE_ID = 1\nDISALLOWED_USER_AGENTS = \nALLOWED_INCLUDE_ROOTS = \nUSE_I18N = True\nEDX_UNSUBSCRIBE = '/api/extended/subscriptions'\nLOGGING = {'loggers': {'': {'handlers': ['console'], 'level': 'DEBUG'}, 'django.request': {'handlers': ['console'], 'propagate': True, 'level': 'ERROR'}}, 'version': 1, 'formatters': {'main_formatter': {'datefmt': '%Y-%m-%d %H:%M:%S', 'format': '%(levelname)s:%(name)s: %(message)s (%(asctime)s; %(filename)s:%(lineno)d)'}}, 'disable_existing_loggers': True, 'handlers': {'console': {'formatter': 'main_formatter', 'class': 'logging.StreamHandler', 'level': 'DEBUG'}}}\nSHORT_DATE_FORMAT = 'm/d/Y'\nEMAIL_FROM = u'Open education, npoed@kspt.icc.spbstu.ru'\nTEMPLATES = [{'DIRS': ['/home/pavel/work/npoed/npoed-plp-edx/npoed_plp/plp/templates'], 'APP_DIRS': True, 'OPTIONS': {'debug': True, 'context_processors': ['django.template.context_processors.debug', 'django.template.context_processors.request', 'django.template.context_processors.static', 'django.contrib.auth.context_processors.auth', 'django.contrib.messages.context_processors.messages', 'django.template.context_processors.i18n', 'django.core.context_processors.media', 'plp.context_processors.upd_available_universities']}, 'BACKEND': 'django.template.backends.django.DjangoTemplates'}]\nAUTOCOMPLETE_APP = \nIMAGEKIT_DEFAULT_CACHEFILE_BACKEND = 'imagekit.cachefiles.backends.Simple'\nCACHE_MIDDLEWARE_KEY_PREFIX = u'********************'\nSECURE_SSL_REDIRECT = False\nTIME_ZONE = 'Europe/Moscow'\nFILE_UPLOAD_MAX_MEMORY_SIZE = 2621440\nEMAIL_BACKEND = 'django.core.mail.backends.smtp.EmailBackend'\nIMAGEKIT_DEFAULT_CACHEFILE_STRATEGY = 'imagekit.cachefiles.strategies.JustInTime'\nEMAIL_USE_SSL = False\nTEMPLATE_CONTEXT_PROCESSORS = \nMIGRATION_MODULES = {}\nEDX_ENROLLMENT_URL = 'http://courses.test.npoed.ru'\nSESSION_COOKIE_AGE = 1209600\nSETTINGS_MODULE = 'settings.local_settings'\nSSO_NPOED_TIMEOUT = 10\nLANGUAGES = ('ru', <django.utils.functional.__proxy__ object at 0x7fe931ba2d10>)\nFILE_UPLOAD_TEMP_DIR = None\nCSRF_COOKIE_AGE = 31449600\nSESSION_COOKIE_NAME = 'sessionid'\nBROKER_HOST = 'localhost'\nEMAIL_PORT = 25\nSSO_API_KEY = u'********************'\nMETA_USE_SITES = True\nSHORT_DATETIME_FORMAT = 'm/d/Y P'\nCELERY_RESULT_BACKEND = 'database'\nTEST_NON_SERIALIZED_APPS = []\nPASSWORD_HASHERS = u'********************'\nTHIRD_PARTY_APPS = \nABSOLUTE_URL_OVERRIDES = {}\nIMAGEKIT_DEFAULT_FILE_STORAGE = 'django.core.files.storage.FileSystemStorage'\nSOCIAL_AUTH_NPOEDSSO_KEY = u'********************'\nCACHE_MIDDLEWARE_SECONDS = 600\nEMAIL_SSL_CERTFILE = None\nCSRF_COOKIE_HTTPONLY = False\nDATETIME_INPUT_FORMATS = \nSOCIAL_AUTH_NPOEDSSO_SECRET = u'********************'\nPAGE_CACHE_TIME = 300\nEMAIL_HOST_USER = ''\n\nYou're seeing this error because you have DEBUG = True in your\nDjango settings file. Change that to False, and Django will\ndisplay a standard page generated by the handler for this status code.\n", "data": []}