(1146, "Table 'cmsxky.information_column' doesn't exist")
| Request Method: | GET |
|---|---|
| Request URL: | http:///information/column/7/ |
| Django Version: | 1.11.7 |
| Exception Type: | ProgrammingError |
| Exception Value: | (1146, "Table 'cmsxky.information_column' doesn't exist") |
| Exception Location: | d:\python\python38\lib\site-packages\pymysql\err.py in raise_mysql_exception, line 109 |
| Python Executable: | d:\python\python38\python.exe |
| Python Version: | 3.8.10 |
| Python Path: | ['D:\\cmsxky\\extra_apps', 'D:\\cmsxky\\apps', '.', 'd:\\python\\python38\\python38.zip', 'd:\\python\\python38\\DLLs', 'd:\\python\\python38\\lib', 'd:\\python\\python38', 'd:\\python\\python38\\lib\\site-packages', 'D:\\cmsxky', 'd:\\python\\python38\\lib\\site-packages\\odf', 'd:\\python\\python38\\lib\\site-packages\\odf', 'd:\\python\\python38\\lib\\site-packages\\odf', 'd:\\python\\python38\\lib\\site-packages\\odf', 'd:\\python\\python38\\lib\\site-packages\\odf', 'd:\\python\\python38\\lib\\site-packages\\odf', 'd:\\python\\python38\\lib\\site-packages\\odf'] |
| Server time: | 星期五, 29 七月 2022 11:44:59 +0800 |
d:\python\python38\lib\site-packages\django\db\backends\utils.py in execute
def execute(self, sql, params=None):
self.db.validate_no_broken_transaction()
with self.db.wrap_database_errors:
if params is None:
return self.cursor.execute(sql)
else:
return self.cursor.execute(sql, params) ...def executemany(self, sql, param_list):
self.db.validate_no_broken_transaction()
with self.db.wrap_database_errors:
return self.cursor.executemany(sql, param_list)
| Variable | Value |
|---|---|
| params | (7,) |
| self | <django.db.backends.utils.CursorDebugWrapper object at 0x0000003075E6C6D0> |
| sql | ('SELECT `information_column`.`id`, `information_column`.`institution_id`, '
'`information_column`.`name`, `information_column`.`slug`, '
'`information_column`.`intro` FROM `information_column` WHERE '
'`information_column`.`slug` = %s') |
d:\python\python38\lib\site-packages\django\db\backends\mysql\base.py in execute
def __init__(self, cursor):
self.cursor = cursor
def execute(self, query, args=None):
try:
# args is None means no string interpolation
return self.cursor.execute(query, args) ...except Database.OperationalError as e:
# Map some error codes to IntegrityError, since they seem to be
# misclassified and Django would prefer the more logical place.
if e.args[0] in self.codes_for_integrityerror:
six.reraise(utils.IntegrityError, utils.IntegrityError(*tuple(e.args)), sys.exc_info()[2])
raise
| Variable | Value |
|---|---|
| args | (7,) |
| query | ('SELECT `information_column`.`id`, `information_column`.`institution_id`, '
'`information_column`.`name`, `information_column`.`slug`, '
'`information_column`.`intro` FROM `information_column` WHERE '
'`information_column`.`slug` = %s') |
| self | <django.db.backends.mysql.base.CursorWrapper object at 0x0000003075E6C760> |
d:\python\python38\lib\site-packages\pymysql\cursors.py in execute
If args is a dict, %(name)s can be used as a placeholder in the query.
"""
while self.nextset():
pass
query = self.mogrify(query, args)
result = self._query(query) ...self._executed = query
return result
def executemany(self, query, args):
# type: (str, list) -> int
"""Run several data against one query
| Variable | Value |
|---|---|
| args | (7,) |
| query | ('SELECT `information_column`.`id`, `information_column`.`institution_id`, '
'`information_column`.`name`, `information_column`.`slug`, '
'`information_column`.`intro` FROM `information_column` WHERE '
'`information_column`.`slug` = 7') |
| self | <pymysql.cursors.Cursor object at 0x0000003075E6C100> |
d:\python\python38\lib\site-packages\pymysql\cursors.py in _query
raise IndexError("out of range")self.rownumber = r
def _query(self, q):
conn = self._get_db()
self._last_executed = q
self._clear_result()
conn.query(q) ...self._do_get_result()
return self.rowcount
def _clear_result(self):
self.rownumber = 0
self._result = None
| Variable | Value |
|---|---|
| conn | <pymysql.connections.Connection object at 0x0000003075E6C250> |
| q | ('SELECT `information_column`.`id`, `information_column`.`institution_id`, '
'`information_column`.`name`, `information_column`.`slug`, '
'`information_column`.`intro` FROM `information_column` WHERE '
'`information_column`.`slug` = 7') |
| self | <pymysql.cursors.Cursor object at 0x0000003075E6C100> |
d:\python\python38\lib\site-packages\pymysql\connections.py in query
# print("DEBUG: sending query:", sql)if isinstance(sql, text_type) and not (JYTHON or IRONPYTHON):
if PY2:
sql = sql.encode(self.encoding)
else:
sql = sql.encode(self.encoding, 'surrogateescape')
self._execute_command(COMMAND.COM_QUERY, sql)
self._affected_rows = self._read_query_result(unbuffered=unbuffered) ...return self._affected_rows
def next_result(self, unbuffered=False):
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
return self._affected_rows
| Variable | Value |
|---|---|
| self | <pymysql.connections.Connection object at 0x0000003075E6C250> |
| sql | (b'SELECT `information_column`.`id`, `information_column`.`institution_id`, `in' b'formation_column`.`name`, `information_column`.`slug`, `information_column`.' b'`intro` FROM `information_column` WHERE `information_column`.`slug` = 7') |
| unbuffered | False |
d:\python\python38\lib\site-packages\pymysql\connections.py in _read_query_result
result.init_unbuffered_query()
except:
result.unbuffered_active = False
result.connection = None
raise
else:
result = MySQLResult(self)
result.read() ...self._result = result
if result.server_status is not None:
self.server_status = result.server_status
return result.affected_rows
def insert_id(self):
| Variable | Value |
|---|---|
| result | <pymysql.connections.MySQLResult object at 0x0000003075E6C730> |
| self | <pymysql.connections.Connection object at 0x0000003075E6C250> |
| unbuffered | False |
d:\python\python38\lib\site-packages\pymysql\connections.py in read
def __del__(self):
if self.unbuffered_active:
self._finish_unbuffered_query()
def read(self):
try:
first_packet = self.connection._read_packet() ...if first_packet.is_ok_packet():
self._read_ok_packet(first_packet)
elif first_packet.is_load_local_packet():
self._read_load_local_packet(first_packet)
else:
| Variable | Value |
|---|---|
| self | <pymysql.connections.MySQLResult object at 0x0000003075E6C730> |
d:\python\python38\lib\site-packages\pymysql\connections.py in _read_packet
# https://dev.mysql.com/doc/internals/en/sending-more-than-16mbyte.html
if bytes_to_read == 0xffffff:
continue
if bytes_to_read < MAX_PACKET_LEN:
break
packet = packet_type(buff, self.encoding)
packet.check_error() ...return packet
def _read_bytes(self, num_bytes):
self._sock.settimeout(self._read_timeout)
while True:
try:
| Variable | Value |
|---|---|
| btrh | 0 |
| btrl | 56 |
| buff | b"\xffz\x04#42S02Table 'cmsxky.information_column' doesn't exist" |
| bytes_to_read | 56 |
| packet | <pymysql.protocol.MysqlPacket object at 0x0000003075E6C7C0> |
| packet_header | b'8\x00\x00\x01' |
| packet_number | 1 |
| packet_type | <class 'pymysql.protocol.MysqlPacket'> |
| recv_data | b"\xffz\x04#42S02Table 'cmsxky.information_column' doesn't exist" |
| self | <pymysql.connections.Connection object at 0x0000003075E6C250> |
d:\python\python38\lib\site-packages\pymysql\protocol.py in check_error
def check_error(self):
if self.is_error_packet():
self.rewind()
self.advance(1) # field_count == error (we already know that)
errno = self.read_uint16()
if DEBUG: print("errno =", errno)
err.raise_mysql_exception(self._data) ...def dump(self):
dump_packet(self._data)
class FieldDescriptorPacket(MysqlPacket):
| Variable | Value |
|---|---|
| errno | 1146 |
| self | <pymysql.protocol.MysqlPacket object at 0x0000003075E6C7C0> |
d:\python\python38\lib\site-packages\pymysql\err.py in raise_mysql_exception
is_41 = data[3:4] == b"#"
if is_41:
# client protocol 4.1
errval = data[9:].decode('utf-8', 'replace')else:
errval = data[3:].decode('utf-8', 'replace')errorclass = error_map.get(errno, InternalError)
raise errorclass(errno, errval) ...| Variable | Value |
|---|---|
| data | b"\xffz\x04#42S02Table 'cmsxky.information_column' doesn't exist" |
| errno | 1146 |
| errorclass | <class 'pymysql.err.ProgrammingError'> |
| errval | "Table 'cmsxky.information_column' doesn't exist" |
| is_41 | True |
d:\python\python38\lib\site-packages\django\core\handlers\exception.py in inner
This decorator is automatically applied to all middleware to ensure that
no middleware leaks an exception and that the next middleware in the stack
can rely on getting a response instead of an exception.
"""
@wraps(get_response, assigned=available_attrs(get_response))
def inner(request):
try:
response = get_response(request) ...except Exception as exc:
response = response_for_exception(request, exc)
return response
return inner
| Variable | Value |
|---|---|
| exc | ProgrammingError(1146, "Table 'cmsxky.information_column' doesn't exist") |
| get_response | <bound method BaseHandler._get_response of <django.core.handlers.wsgi.WSGIHandler object at 0x0000003061E5F4C0>> |
| request | <WSGIRequest: GET '/information/column/7/'> |
d:\python\python38\lib\site-packages\django\core\handlers\base.py in _get_response
break
if response is None:
wrapped_callback = self.make_view_atomic(callback)
try:
response = wrapped_callback(request, *callback_args, **callback_kwargs)
except Exception as e:
response = self.process_exception_by_middleware(e, request) ...# Complain if the view returned None (a common error).
if response is None:
if isinstance(callback, types.FunctionType): # FBV
view_name = callback.__name__
else: # CBV
| Variable | Value |
|---|---|
| callback | <function list_slug at 0x00000030735A4700> |
| callback_args | () |
| callback_kwargs | {'column_slug': '7'} |
| middleware_method | <bound method CsrfViewMiddleware.process_view of <django.middleware.csrf.CsrfViewMiddleware object at 0x00000030755310D0>> |
| request | <WSGIRequest: GET '/information/column/7/'> |
| resolver | <RegexURLResolver 'cmsxky.urls' (None:None) ^/> |
| resolver_match | ResolverMatch(func=information.views.list_slug, args=(), kwargs={'column_slug': '7'}, url_name=info_column, app_names=[], namespaces=[]) |
| response | None |
| self | <django.core.handlers.wsgi.WSGIHandler object at 0x0000003061E5F4C0> |
| wrapped_callback | <function list_slug at 0x00000030735A4700> |
d:\python\python38\lib\site-packages\django\core\handlers\base.py in _get_response
response = middleware_method(request, callback, callback_args, callback_kwargs)
if response:
break
if response is None:
wrapped_callback = self.make_view_atomic(callback)
try:
response = wrapped_callback(request, *callback_args, **callback_kwargs) ...except Exception as e:
response = self.process_exception_by_middleware(e, request)
# Complain if the view returned None (a common error).
if response is None:
if isinstance(callback, types.FunctionType): # FBV
| Variable | Value |
|---|---|
| callback | <function list_slug at 0x00000030735A4700> |
| callback_args | () |
| callback_kwargs | {'column_slug': '7'} |
| middleware_method | <bound method CsrfViewMiddleware.process_view of <django.middleware.csrf.CsrfViewMiddleware object at 0x00000030755310D0>> |
| request | <WSGIRequest: GET '/information/column/7/'> |
| resolver | <RegexURLResolver 'cmsxky.urls' (None:None) ^/> |
| resolver_match | ResolverMatch(func=information.views.list_slug, args=(), kwargs={'column_slug': '7'}, url_name=info_column, app_names=[], namespaces=[]) |
| response | None |
| self | <django.core.handlers.wsgi.WSGIHandler object at 0x0000003061E5F4C0> |
| wrapped_callback | <function list_slug at 0x00000030735A4700> |
D:\cmsxky\apps\information\views.py in list_slug
if column_slug > 8:
company = u'陕西地矿工程勘察有限公司'
column_nav = Column.objects.filter(institution__slug=2).order_by('slug')else:
company = u'豪彩网站'
column_nav = Column.objects.filter(institution__slug=1).order_by('slug')
column_active = Column.objects.get(slug=column_slug) ...# 分页处理
articles = Column.objects.get(slug=column_slug).article_column.filter(published=1).order_by('-pub_date')if articles.exists():
paginator = Paginator(articles, 10) # 每页取10条数据
| Variable | Value |
|---|---|
| column_nav | Error in formatting: ProgrammingError: (1146, "Table 'cmsxky.information_column' doesn't exist") |
| column_slug | 7 |
| company | '豪彩网站' |
| request | <WSGIRequest: GET '/information/column/7/'> |
| title | '信息公开' |
d:\python\python38\lib\site-packages\django\db\models\manager.py in manager_method
def check(self, **kwargs):
return []
@classmethod
def _get_queryset_methods(cls, queryset_class):
def create_method(name, method):
def manager_method(self, *args, **kwargs):
return getattr(self.get_queryset(), name)(*args, **kwargs) ...manager_method.__name__ = method.__name__
manager_method.__doc__ = method.__doc__
return manager_method
new_methods = {}# Refs http://bugs.python.org/issue1785.
| Variable | Value |
|---|---|
| args | () |
| kwargs | {'slug': 7} |
| name | 'get' |
| self | <django.db.models.manager.Manager object at 0x0000003075C9DBB0> |
d:\python\python38\lib\site-packages\django\db\models\query.py in get
"""
Performs the query and returns a single object matching the given
keyword arguments.
"""
clone = self.filter(*args, **kwargs)
if self.query.can_filter() and not self.query.distinct_fields:
clone = clone.order_by()
num = len(clone) ...if num == 1:
return clone._result_cache[0]
if not num:
raise self.model.DoesNotExist(
"%s matching query does not exist." %
self.model._meta.object_name
| Variable | Value |
|---|---|
| args | () |
| clone | Error in formatting: ProgrammingError: (1146, "Table 'cmsxky.information_column' doesn't exist") |
| kwargs | {'slug': 7} |
| self | Error in formatting: ProgrammingError: (1146, "Table 'cmsxky.information_column' doesn't exist") |
d:\python\python38\lib\site-packages\django\db\models\query.py in __len__
def __repr__(self):
data = list(self[:REPR_OUTPUT_SIZE + 1])
if len(data) > REPR_OUTPUT_SIZE:
data[-1] = "...(remaining elements truncated)..."
return '<%s %r>' % (self.__class__.__name__, data)
def __len__(self):
self._fetch_all() ...return len(self._result_cache)
def __iter__(self):
"""
The queryset iterator protocol uses three nested iterators in the
default case:
| Variable | Value |
|---|---|
| self | Error in formatting: ProgrammingError: (1146, "Table 'cmsxky.information_column' doesn't exist") |
d:\python\python38\lib\site-packages\django\db\models\query.py in _fetch_all
clone._fields = self._fields
clone.__dict__.update(kwargs)
return clone
def _fetch_all(self):
if self._result_cache is None:
self._result_cache = list(self._iterable_class(self)) ...if self._prefetch_related_lookups and not self._prefetch_done:
self._prefetch_related_objects()
def _next_is_sticky(self):
"""
Indicates that the next filter call and the one following that should
| Variable | Value |
|---|---|
| self | Error in formatting: ProgrammingError: (1146, "Table 'cmsxky.information_column' doesn't exist") |
d:\python\python38\lib\site-packages\django\db\models\query.py in __iter__
def __iter__(self):
queryset = self.queryset
db = queryset.db
compiler = queryset.query.get_compiler(using=db)
# Execute the query. This will also fill compiler.select, klass_info,
# and annotations.
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch) ...select, klass_info, annotation_col_map = (compiler.select, compiler.klass_info,
compiler.annotation_col_map)
model_cls = klass_info['model']
select_fields = klass_info['select_fields']
model_fields_start, model_fields_end = select_fields[0], select_fields[-1] + 1
init_list = [f[0].target.attname
| Variable | Value |
|---|---|
| compiler | <django.db.backends.mysql.compiler.SQLCompiler object at 0x0000003075E6C340> |
| db | 'default' |
| queryset | Error in formatting: ProgrammingError: (1146, "Table 'cmsxky.information_column' doesn't exist") |
| self | <django.db.models.query.ModelIterable object at 0x0000003075E6C280> |
d:\python\python38\lib\site-packages\django\db\models\sql\compiler.py in execute_sql
# Might fail for server-side cursors (e.g. connection closed)
cursor.close()
except Exception:
# Ignore clean up errors and raise the original error instead.
# Python 2 doesn't chain exceptions. Remove this error
# silencing when dropping Python 2 compatibility.
pass
raise original_exception ...if result_type == CURSOR:
# Caller didn't specify a result_type, so just give them back the
# cursor to process (and close).
return cursor
if result_type == SINGLE:
| Variable | Value |
|---|---|
| chunked_fetch | False |
| cursor | <django.db.backends.utils.CursorDebugWrapper object at 0x0000003075E6C6D0> |
| params | (7,) |
| result_type | 'multi' |
| self | <django.db.backends.mysql.compiler.SQLCompiler object at 0x0000003075E6C340> |
| sql | ('SELECT `information_column`.`id`, `information_column`.`institution_id`, '
'`information_column`.`name`, `information_column`.`slug`, '
'`information_column`.`intro` FROM `information_column` WHERE '
'`information_column`.`slug` = %s') |
d:\python\python38\lib\site-packages\django\db\models\sql\compiler.py in execute_sql
else:
return
if chunked_fetch:
cursor = self.connection.chunked_cursor()
else:
cursor = self.connection.cursor()
try:
cursor.execute(sql, params) ...except Exception as original_exception:
try:
# Might fail for server-side cursors (e.g. connection closed)
cursor.close()
except Exception:
# Ignore clean up errors and raise the original error instead.
| Variable | Value |
|---|---|
| chunked_fetch | False |
| cursor | <django.db.backends.utils.CursorDebugWrapper object at 0x0000003075E6C6D0> |
| params | (7,) |
| result_type | 'multi' |
| self | <django.db.backends.mysql.compiler.SQLCompiler object at 0x0000003075E6C340> |
| sql | ('SELECT `information_column`.`id`, `information_column`.`institution_id`, '
'`information_column`.`name`, `information_column`.`slug`, '
'`information_column`.`intro` FROM `information_column` WHERE '
'`information_column`.`slug` = %s') |
d:\python\python38\lib\site-packages\django\db\backends\utils.py in execute
class CursorDebugWrapper(CursorWrapper):
# XXX callproc isn't instrumented at this time.
def execute(self, sql, params=None):
start = time()
try:
return super(CursorDebugWrapper, self).execute(sql, params) ...finally:
stop = time()
duration = stop - start
sql = self.db.ops.last_executed_query(self.cursor, sql, params)
self.db.queries_log.append({'sql': sql,
| Variable | Value |
|---|---|
| __class__ | <class 'django.db.backends.utils.CursorDebugWrapper'> |
| duration | 0.0009791851043701172 |
| params | (7,) |
| self | <django.db.backends.utils.CursorDebugWrapper object at 0x0000003075E6C6D0> |
| sql | ('SELECT `information_column`.`id`, `information_column`.`institution_id`, '
'`information_column`.`name`, `information_column`.`slug`, '
'`information_column`.`intro` FROM `information_column` WHERE '
'`information_column`.`slug` = 7') |
| start | 1659066299.3294113 |
| stop | 1659066299.3303905 |
d:\python\python38\lib\site-packages\django\db\backends\utils.py in execute
def execute(self, sql, params=None):
self.db.validate_no_broken_transaction()
with self.db.wrap_database_errors:
if params is None:
return self.cursor.execute(sql)
else:
return self.cursor.execute(sql, params) ...def executemany(self, sql, param_list):
self.db.validate_no_broken_transaction()
with self.db.wrap_database_errors:
return self.cursor.executemany(sql, param_list)
| Variable | Value |
|---|---|
| params | (7,) |
| self | <django.db.backends.utils.CursorDebugWrapper object at 0x0000003075E6C6D0> |
| sql | ('SELECT `information_column`.`id`, `information_column`.`institution_id`, '
'`information_column`.`name`, `information_column`.`slug`, '
'`information_column`.`intro` FROM `information_column` WHERE '
'`information_column`.`slug` = %s') |
d:\python\python38\lib\site-packages\django\db\utils.py in __exit__
dj_exc_value.__cause__ = exc_value
if not hasattr(exc_value, '__traceback__'):
exc_value.__traceback__ = traceback
# Only set the 'errors_occurred' flag for errors that may make
# the connection unusable.
if dj_exc_type not in (DataError, IntegrityError):
self.wrapper.errors_occurred = True
six.reraise(dj_exc_type, dj_exc_value, traceback) ...def __call__(self, func):
# Note that we are intentionally not using @wraps here for performance
# reasons. Refs #21109.
def inner(*args, **kwargs):
with self:
| Variable | Value |
|---|---|
| db_exc_type | <class 'pymysql.err.ProgrammingError'> |
| dj_exc_type | <class 'django.db.utils.ProgrammingError'> |
| dj_exc_value | ProgrammingError(1146, "Table 'cmsxky.information_column' doesn't exist") |
| exc_type | <class 'pymysql.err.ProgrammingError'> |
| exc_value | ProgrammingError(1146, "Table 'cmsxky.information_column' doesn't exist") |
| self | <django.db.utils.DatabaseErrorWrapper object at 0x000000307591E3D0> |
| traceback | <traceback object at 0x0000003075EB3180> |
d:\python\python38\lib\site-packages\django\utils\six.py in reraise
if PY3:
exec_ = getattr(moves.builtins, "exec")
def reraise(tp, value, tb=None):
if value is None:
value = tp()
if value.__traceback__ is not tb:
raise value.with_traceback(tb) ...raise value
else:
def exec_(_code_, _globs_=None, _locs_=None):
"""Execute code in a namespace."""
if _globs_ is None:
| Variable | Value |
|---|---|
| tb | <traceback object at 0x0000003075EB3180> |
| tp | <class 'django.db.utils.ProgrammingError'> |
| value | ProgrammingError(1146, "Table 'cmsxky.information_column' doesn't exist") |
d:\python\python38\lib\site-packages\django\db\backends\utils.py in execute
def execute(self, sql, params=None):
self.db.validate_no_broken_transaction()
with self.db.wrap_database_errors:
if params is None:
return self.cursor.execute(sql)
else:
return self.cursor.execute(sql, params) ...def executemany(self, sql, param_list):
self.db.validate_no_broken_transaction()
with self.db.wrap_database_errors:
return self.cursor.executemany(sql, param_list)
| Variable | Value |
|---|---|
| params | (7,) |
| self | <django.db.backends.utils.CursorDebugWrapper object at 0x0000003075E6C6D0> |
| sql | ('SELECT `information_column`.`id`, `information_column`.`institution_id`, '
'`information_column`.`name`, `information_column`.`slug`, '
'`information_column`.`intro` FROM `information_column` WHERE '
'`information_column`.`slug` = %s') |
d:\python\python38\lib\site-packages\django\db\backends\mysql\base.py in execute
def __init__(self, cursor):
self.cursor = cursor
def execute(self, query, args=None):
try:
# args is None means no string interpolation
return self.cursor.execute(query, args) ...except Database.OperationalError as e:
# Map some error codes to IntegrityError, since they seem to be
# misclassified and Django would prefer the more logical place.
if e.args[0] in self.codes_for_integrityerror:
six.reraise(utils.IntegrityError, utils.IntegrityError(*tuple(e.args)), sys.exc_info()[2])
raise
| Variable | Value |
|---|---|
| args | (7,) |
| query | ('SELECT `information_column`.`id`, `information_column`.`institution_id`, '
'`information_column`.`name`, `information_column`.`slug`, '
'`information_column`.`intro` FROM `information_column` WHERE '
'`information_column`.`slug` = %s') |
| self | <django.db.backends.mysql.base.CursorWrapper object at 0x0000003075E6C760> |
d:\python\python38\lib\site-packages\pymysql\cursors.py in execute
If args is a dict, %(name)s can be used as a placeholder in the query.
"""
while self.nextset():
pass
query = self.mogrify(query, args)
result = self._query(query) ...self._executed = query
return result
def executemany(self, query, args):
# type: (str, list) -> int
"""Run several data against one query
| Variable | Value |
|---|---|
| args | (7,) |
| query | ('SELECT `information_column`.`id`, `information_column`.`institution_id`, '
'`information_column`.`name`, `information_column`.`slug`, '
'`information_column`.`intro` FROM `information_column` WHERE '
'`information_column`.`slug` = 7') |
| self | <pymysql.cursors.Cursor object at 0x0000003075E6C100> |
d:\python\python38\lib\site-packages\pymysql\cursors.py in _query
raise IndexError("out of range")self.rownumber = r
def _query(self, q):
conn = self._get_db()
self._last_executed = q
self._clear_result()
conn.query(q) ...self._do_get_result()
return self.rowcount
def _clear_result(self):
self.rownumber = 0
self._result = None
| Variable | Value |
|---|---|
| conn | <pymysql.connections.Connection object at 0x0000003075E6C250> |
| q | ('SELECT `information_column`.`id`, `information_column`.`institution_id`, '
'`information_column`.`name`, `information_column`.`slug`, '
'`information_column`.`intro` FROM `information_column` WHERE '
'`information_column`.`slug` = 7') |
| self | <pymysql.cursors.Cursor object at 0x0000003075E6C100> |
d:\python\python38\lib\site-packages\pymysql\connections.py in query
# print("DEBUG: sending query:", sql)if isinstance(sql, text_type) and not (JYTHON or IRONPYTHON):
if PY2:
sql = sql.encode(self.encoding)
else:
sql = sql.encode(self.encoding, 'surrogateescape')
self._execute_command(COMMAND.COM_QUERY, sql)
self._affected_rows = self._read_query_result(unbuffered=unbuffered) ...return self._affected_rows
def next_result(self, unbuffered=False):
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
return self._affected_rows
| Variable | Value |
|---|---|
| self | <pymysql.connections.Connection object at 0x0000003075E6C250> |
| sql | (b'SELECT `information_column`.`id`, `information_column`.`institution_id`, `in' b'formation_column`.`name`, `information_column`.`slug`, `information_column`.' b'`intro` FROM `information_column` WHERE `information_column`.`slug` = 7') |
| unbuffered | False |
d:\python\python38\lib\site-packages\pymysql\connections.py in _read_query_result
result.init_unbuffered_query()
except:
result.unbuffered_active = False
result.connection = None
raise
else:
result = MySQLResult(self)
result.read() ...self._result = result
if result.server_status is not None:
self.server_status = result.server_status
return result.affected_rows
def insert_id(self):
| Variable | Value |
|---|---|
| result | <pymysql.connections.MySQLResult object at 0x0000003075E6C730> |
| self | <pymysql.connections.Connection object at 0x0000003075E6C250> |
| unbuffered | False |
d:\python\python38\lib\site-packages\pymysql\connections.py in read
def __del__(self):
if self.unbuffered_active:
self._finish_unbuffered_query()
def read(self):
try:
first_packet = self.connection._read_packet() ...if first_packet.is_ok_packet():
self._read_ok_packet(first_packet)
elif first_packet.is_load_local_packet():
self._read_load_local_packet(first_packet)
else:
| Variable | Value |
|---|---|
| self | <pymysql.connections.MySQLResult object at 0x0000003075E6C730> |
d:\python\python38\lib\site-packages\pymysql\connections.py in _read_packet
# https://dev.mysql.com/doc/internals/en/sending-more-than-16mbyte.html
if bytes_to_read == 0xffffff:
continue
if bytes_to_read < MAX_PACKET_LEN:
break
packet = packet_type(buff, self.encoding)
packet.check_error() ...return packet
def _read_bytes(self, num_bytes):
self._sock.settimeout(self._read_timeout)
while True:
try:
| Variable | Value |
|---|---|
| btrh | 0 |
| btrl | 56 |
| buff | b"\xffz\x04#42S02Table 'cmsxky.information_column' doesn't exist" |
| bytes_to_read | 56 |
| packet | <pymysql.protocol.MysqlPacket object at 0x0000003075E6C7C0> |
| packet_header | b'8\x00\x00\x01' |
| packet_number | 1 |
| packet_type | <class 'pymysql.protocol.MysqlPacket'> |
| recv_data | b"\xffz\x04#42S02Table 'cmsxky.information_column' doesn't exist" |
| self | <pymysql.connections.Connection object at 0x0000003075E6C250> |
d:\python\python38\lib\site-packages\pymysql\protocol.py in check_error
def check_error(self):
if self.is_error_packet():
self.rewind()
self.advance(1) # field_count == error (we already know that)
errno = self.read_uint16()
if DEBUG: print("errno =", errno)
err.raise_mysql_exception(self._data) ...def dump(self):
dump_packet(self._data)
class FieldDescriptorPacket(MysqlPacket):
| Variable | Value |
|---|---|
| errno | 1146 |
| self | <pymysql.protocol.MysqlPacket object at 0x0000003075E6C7C0> |
d:\python\python38\lib\site-packages\pymysql\err.py in raise_mysql_exception
is_41 = data[3:4] == b"#"
if is_41:
# client protocol 4.1
errval = data[9:].decode('utf-8', 'replace')else:
errval = data[3:].decode('utf-8', 'replace')errorclass = error_map.get(errno, InternalError)
raise errorclass(errno, errval) ...| Variable | Value |
|---|---|
| data | b"\xffz\x04#42S02Table 'cmsxky.information_column' doesn't exist" |
| errno | 1146 |
| errorclass | <class 'pymysql.err.ProgrammingError'> |
| errval | "Table 'cmsxky.information_column' doesn't exist" |
| is_41 | True |
AnonymousUser
No GET data
No POST data
No FILES data
No cookie data
| Variable | Value |
|---|---|
| APPL_MD_PATH | '/LM/W3SVC/2/ROOT' |
| APPL_PHYSICAL_PATH | 'D:\\cmsxky\\' |
| APP_POOL_CONFIG | 'C:\\inetpub\\temp\\apppools\\cms\\cms.config' |
| APP_POOL_ID | 'cms' |
| AUTH_PASSWORD | '' |
| AUTH_TYPE | '' |
| AUTH_USER | '' |
| CERT_COOKIE | '' |
| CERT_FLAGS | '' |
| CERT_ISSUER | '' |
| CERT_SERIALNUMBER | '' |
| CERT_SUBJECT | '' |
| CONTENT_LENGTH | '0' |
| CONTENT_TYPE | 'application/x-www-form-urlencoded' |
| DOCUMENT_ROOT | 'D:\\cmsxky' |
| GATEWAY_INTERFACE | 'CGI/1.1' |
| HTTPS | 'off' |
| HTTPS_KEYSIZE | '' |
| HTTPS_SECRETKEYSIZE | '' |
| HTTPS_SERVER_ISSUER | '' |
| HTTPS_SERVER_SUBJECT | '' |
| HTTP_ACCEPT | '*/*' |
| HTTP_ACCEPT_CHARSET | 'utf-8' |
| HTTP_CONTENT_LENGTH | '0' |
| HTTP_CONTENT_TYPE | 'application/x-www-form-urlencoded' |
| HTTP_HOST | '' |
| HTTP_USER_AGENT | 'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)' |
| INSTANCE_ID | '2' |
| INSTANCE_META_PATH | '/LM/W3SVC/2' |
| INSTANCE_NAME | 'CMS' |
| LOCAL_ADDR | '192.168.0.98' |
| LOGON_USER | '' |
| PATH_INFO | '/information/column/7/' |
| PATH_TRANSLATED | 'D:\\cmsxky\\information\\column\\7\\' |
| QUERY_STRING | '' |
| REMOTE_ADDR | '154.208.220.18' |
| REMOTE_HOST | '154.208.220.18' |
| REMOTE_PORT | '46414' |
| REMOTE_USER | '' |
| REQUEST_METHOD | 'GET' |
| REQUEST_URI | '/information/column/7/' |
| SCRIPT_FILENAME | 'D:\\cmsxky\\information\\column\\7\\' |
| SCRIPT_NAME | '' |
| SERVER_NAME | '' |
| SERVER_PORT | '80' |
| SERVER_PORT_SECURE | '0' |
| SERVER_PROTOCOL | 'HTTP/1.1' |
| SERVER_SOFTWARE | 'Microsoft-IIS/8.5' |
| URL | '/information/column/7/' |
| WEBSOCKET_VERSION | '13' |
| wsgi.errors | <_io.StringIO object at 0x0000003075EBF550> |
| wsgi.input | <_io.BytesIO object at 0x0000003075FADD10> |
| wsgi.multiprocess | True |
| wsgi.multithread | False |
| wsgi.path_info | b'/information/column/7/' |
| wsgi.query_string | b'' |
| wsgi.run_once | False |
| wsgi.script_name | b'' |
| wsgi.url_scheme | 'http' |
| wsgi.version | (1, 0) |
cmsxky.settings| Setting | Value |
|---|---|
| ABSOLUTE_URL_OVERRIDES | {} |
| ADMINS | [] |
| ALLOWED_HOSTS | ['*'] |
| APPEND_SLASH | True |
| AUTHENTICATION_BACKENDS | ['django.contrib.auth.backends.ModelBackend'] |
| AUTH_PASSWORD_VALIDATORS | '********************' |
| AUTH_USER_MODEL | 'auth.User' |
| BASE_DIR | 'D:\\cmsxky' |
| CACHES | {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}} |
| CACHE_MIDDLEWARE_ALIAS | 'default' |
| CACHE_MIDDLEWARE_KEY_PREFIX | '********************' |
| CACHE_MIDDLEWARE_SECONDS | 600 |
| CRISPY_CLASS_CONVERTERS | {'fileinput': 'fileinput fileUpload form-control',
'passwordinput': '********************',
'textinput': 'textinput textInput form-control'} |
| CRISPY_TEMPLATE_PACK | 'bootstrap3' |
| CSRF_COOKIE_AGE | 31449600 |
| CSRF_COOKIE_DOMAIN | None |
| CSRF_COOKIE_HTTPONLY | False |
| CSRF_COOKIE_NAME | 'csrftoken' |
| CSRF_COOKIE_PATH | '/' |
| CSRF_COOKIE_SECURE | False |
| CSRF_FAILURE_VIEW | 'django.views.csrf.csrf_failure' |
| CSRF_HEADER_NAME | 'HTTP_X_CSRFTOKEN' |
| CSRF_TRUSTED_ORIGINS | [] |
| CSRF_USE_SESSIONS | False |
| DATABASES | {'default': {'ATOMIC_REQUESTS': False,
'AUTOCOMMIT': True,
'CONN_MAX_AGE': 0,
'ENGINE': 'django.db.backends.mysql',
'HOST': '127.0.0.1',
'NAME': 'cmsxky',
'OPTIONS': {},
'PASSWORD': '********************',
'PORT': '3306',
'TEST': {'CHARSET': None,
'COLLATION': None,
'MIRROR': None,
'NAME': None},
'TIME_ZONE': None,
'USER': 'root'}} |
| DATABASE_ROUTERS | [] |
| DATA_UPLOAD_MAX_MEMORY_SIZE | 2621440 |
| DATA_UPLOAD_MAX_NUMBER_FIELDS | 10240 |
| DATETIME_FORMAT | 'N j, Y, P' |
| DATETIME_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'] |
| DATE_FORMAT | 'N j, Y' |
| DATE_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'] |
| DEBUG | True |
| DEBUG_PROPAGATE_EXCEPTIONS | False |
| DECIMAL_SEPARATOR | '.' |
| DEFAULT_CHARSET | 'utf-8' |
| DEFAULT_CONTENT_TYPE | 'text/html' |
| DEFAULT_EXCEPTION_REPORTER_FILTER | 'django.views.debug.SafeExceptionReporterFilter' |
| DEFAULT_FILE_STORAGE | 'django.core.files.storage.FileSystemStorage' |
| DEFAULT_FROM_EMAIL | 'webmaster@localhost' |
| DEFAULT_INDEX_TABLESPACE | '' |
| DEFAULT_TABLESPACE | '' |
| DISALLOWED_USER_AGENTS | [] |
| EMAIL_BACKEND | 'django.core.mail.backends.smtp.EmailBackend' |
| EMAIL_HOST | 'localhost' |
| EMAIL_HOST_PASSWORD | '********************' |
| EMAIL_HOST_USER | '' |
| EMAIL_PORT | 25 |
| EMAIL_SSL_CERTFILE | None |
| EMAIL_SSL_KEYFILE | '********************' |
| EMAIL_SUBJECT_PREFIX | '[Django] ' |
| EMAIL_TIMEOUT | None |
| EMAIL_USE_LOCALTIME | False |
| EMAIL_USE_SSL | False |
| EMAIL_USE_TLS | False |
| FILE_CHARSET | 'utf-8' |
| FILE_UPLOAD_DIRECTORY_PERMISSIONS | None |
| FILE_UPLOAD_HANDLERS | ['django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler'] |
| FILE_UPLOAD_MAX_MEMORY_SIZE | 2621440 |
| FILE_UPLOAD_PERMISSIONS | None |
| FILE_UPLOAD_TEMP_DIR | None |
| FIRST_DAY_OF_WEEK | 0 |
| FIXTURE_DIRS | [] |
| FORCE_SCRIPT_NAME | None |
| FORMAT_MODULE_PATH | None |
| FORM_RENDERER | 'django.forms.renderers.DjangoTemplates' |
| IGNORABLE_404_URLS | [] |
| IMAGEKIT_CACHEFILE_DIR | 'CACHE/images' |
| IMAGEKIT_CACHEFILE_NAMER | 'imagekit.cachefiles.namers.hash' |
| IMAGEKIT_CACHE_BACKEND | 'default' |
| IMAGEKIT_CACHE_PREFIX | 'imagekit:' |
| IMAGEKIT_CACHE_TIMEOUT | 300 |
| IMAGEKIT_DEFAULT_CACHEFILE_BACKEND | 'imagekit.cachefiles.backends.Simple' |
| IMAGEKIT_DEFAULT_CACHEFILE_STRATEGY | 'imagekit.cachefiles.strategies.JustInTime' |
| IMAGEKIT_DEFAULT_FILE_STORAGE | 'django.core.files.storage.FileSystemStorage' |
| IMAGEKIT_SPEC_CACHEFILE_NAMER | 'imagekit.cachefiles.namers.source_name_as_path' |
| IMAGEKIT_USE_MEMCACHED_SAFE_CACHE_KEY | '********************' |
| INSTALLED_APPS | ['django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'enterprise', 'news', 'party', 'sector', 'information', 'contact', 'pages_cms', 'xadmin', 'crispy_forms', 'DjangoUeditor', 'imagekit'] |
| INTERNAL_IPS | [] |
| LANGUAGES | [('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')] |
| LANGUAGES_BIDI | ['he', 'ar', 'fa', 'ur'] |
| LANGUAGE_CODE | 'zh-hans' |
| LANGUAGE_COOKIE_AGE | None |
| LANGUAGE_COOKIE_DOMAIN | None |
| LANGUAGE_COOKIE_NAME | 'django_language' |
| LANGUAGE_COOKIE_PATH | '/' |
| LOCALE_PATHS | [] |
| LOGGING | {} |
| LOGGING_CONFIG | 'logging.config.dictConfig' |
| LOGIN_REDIRECT_URL | '/accounts/profile/' |
| LOGIN_URL | '/accounts/login/' |
| LOGOUT_REDIRECT_URL | None |
| MANAGERS | [] |
| MEDIA_ROOT | 'D:\\cmsxky\\media' |
| MEDIA_URL | '/media/' |
| MESSAGE_STORAGE | 'django.contrib.messages.storage.fallback.FallbackStorage' |
| MIDDLEWARE | ['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'] |
| MIDDLEWARE_CLASSES | ['django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware'] |
| MIGRATION_MODULES | {} |
| MONTH_DAY_FORMAT | 'F j' |
| NUMBER_GROUPING | 0 |
| PASSWORD_HASHERS | '********************' |
| PASSWORD_RESET_TIMEOUT_DAYS | '********************' |
| PREPEND_WWW | False |
| ROOT_URLCONF | 'cmsxky.urls' |
| SECRET_KEY | '********************' |
| SECURE_BROWSER_XSS_FILTER | False |
| SECURE_CONTENT_TYPE_NOSNIFF | False |
| SECURE_HSTS_INCLUDE_SUBDOMAINS | False |
| SECURE_HSTS_PRELOAD | False |
| SECURE_HSTS_SECONDS | 0 |
| SECURE_PROXY_SSL_HEADER | None |
| SECURE_REDIRECT_EXEMPT | [] |
| SECURE_SSL_HOST | None |
| SECURE_SSL_REDIRECT | False |
| SERVER_EMAIL | 'root@localhost' |
| SESSION_CACHE_ALIAS | 'default' |
| SESSION_COOKIE_AGE | 1209600 |
| SESSION_COOKIE_DOMAIN | None |
| SESSION_COOKIE_HTTPONLY | True |
| SESSION_COOKIE_NAME | 'sessionid' |
| SESSION_COOKIE_PATH | '/' |
| SESSION_COOKIE_SECURE | False |
| SESSION_ENGINE | 'django.contrib.sessions.backends.db' |
| SESSION_EXPIRE_AT_BROWSER_CLOSE | False |
| SESSION_FILE_PATH | None |
| SESSION_SAVE_EVERY_REQUEST | False |
| SESSION_SERIALIZER | 'django.contrib.sessions.serializers.JSONSerializer' |
| SETTINGS_MODULE | 'cmsxky.settings' |
| SHORT_DATETIME_FORMAT | 'm/d/Y P' |
| SHORT_DATE_FORMAT | 'm/d/Y' |
| SIGNING_BACKEND | 'django.core.signing.TimestampSigner' |
| SILENCED_SYSTEM_CHECKS | [] |
| STATICFILES_DIRS | ('D:\\cmsxky\\static',) |
| STATICFILES_FINDERS | ('django.contrib.staticfiles.finders.AppDirectoriesFinder',
'django.contrib.staticfiles.finders.FileSystemFinder') |
| STATICFILES_STORAGE | 'django.contrib.staticfiles.storage.StaticFilesStorage' |
| STATIC_ROOT | 'D:\\cmsxky\\static' |
| STATIC_URL | '/static/' |
| TEMPLATES | [{'APP_DIRS': True,
'BACKEND': 'django.template.backends.django.DjangoTemplates',
'DIRS': ['D:\\cmsxky\\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',
'django.template.context_processors.media']}}] |
| TEST_NON_SERIALIZED_APPS | [] |
| TEST_RUNNER | 'django.test.runner.DiscoverRunner' |
| THOUSAND_SEPARATOR | ',' |
| TIME_FORMAT | 'P' |
| TIME_INPUT_FORMATS | ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M'] |
| TIME_ZONE | 'Asia/Shanghai' |
| USE_ETAGS | False |
| USE_I18N | True |
| USE_L10N | True |
| USE_THOUSAND_SEPARATOR | False |
| USE_TZ | True |
| USE_X_FORWARDED_HOST | False |
| USE_X_FORWARDED_PORT | False |
| WSGI_APPLICATION | 'cmsxky.wsgi.application' |
| X_FRAME_OPTIONS | 'SAMEORIGIN' |
| YEAR_MONTH_FORMAT | 'F Y' |
You're seeing this error because you have DEBUG = True in your
Django settings file. Change that to False, and Django will
display a standard page generated by the handler for this status code.