(1146, "Table 'aliweb.shops' doesn't exist")
Request Method: | GET |
---|---|
Request URL: | http://www.2uq.net/supplier-12.html |
Django Version: | 2.2.6 |
Exception Type: | ProgrammingError |
Exception Value: | (1146, "Table 'aliweb.shops' doesn't exist") |
Exception Location: | /www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/site-packages/MySQLdb/connections.py in query, line 226 |
Python Executable: | /www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/bin/uwsgi |
Python Version: | 3.6.8 |
Python Path: | ['.', '', '/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python36.zip', '/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6', '/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/lib-dynload', '/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/site-packages'] |
Server time: | 星期五, 29 三月 2024 01:36:43 +0800 |
In template /www/wwwroot/www.2uq.net/tpl_all/2uq/supplier_cate.html
, error at line 39
29 | |
---|---|
30 | {% endif %} |
31 | {% endfor %} |
32 | <div style="clear:both;"></div> |
33 | </div> |
34 | |
35 | <div class="shop-list"> |
36 | <div align="center"><h1>({{ cat_name }}批发厂家)100强排行榜</h1></div> |
37 | |
38 | <ul> |
39 | {% for one in datas %} |
40 | <li> |
41 | {% if one.shopimgurl != '' %} |
42 | |
43 | <p><a href="/a{{ one.sellerid }}.html" target="_blank"><img src="https://img.alicdn.com/shop_logo/{{ one.imageclickurl }}" height="85" width="85" alt="{{ one.companyname }}"></a></p> |
44 | {% else %} |
45 | <p><a href="/a{{ one.sellerid }}.html" target="_blank"><img src="{% static '2uq/picture/nopic2.png' %}" height="85" width="85"></a></p> |
46 | {% endif %} |
47 | |
48 | <p><a href="/a{{ one.sellerid }}.html" target="_blank" title="{{ one.companyname }}-{{ cat_name }}批发">{{ one.companyname }}</a></p> |
49 | </li> |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/site-packages/django/db/backends/utils.py
in _execute
def _execute(self, sql, params, *ignored_wrapper_args):
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, *ignored_wrapper_args):
self.db.validate_no_broken_transaction()
with self.db.wrap_database_errors:
return self.cursor.executemany(sql, param_list)
Variable | Value |
---|---|
ignored_wrapper_args | (False, {'connection': <django.db.backends.mysql.base.DatabaseWrapper object at 0x7f67346e7048>, 'cursor': <django.db.backends.utils.CursorDebugWrapper object at 0x7f67347bc1d0>}) |
params | (12,) |
self | <django.db.backends.utils.CursorDebugWrapper object at 0x7f67347bc1d0> |
sql | ('SELECT `shops`.`id`, `shops`.`pwId`, `shops`.`pkey`, `shops`.`companyName`, ' '`shops`.`linkUrl`, `shops`.`loginId`, `shops`.`logo`, `shops`.`productCnt`, ' '`shops`.`ratio`, `shops`.`sellerId`, `shops`.`tkCnt`, `shops`.`tradeGrade`, ' '`shops`.`alipayUrl`, `shops`.`imageClickUrl`, `shops`.`longClickUrl`, ' '`shops`.`searchCode`, `shops`.`shortClickUrl`, `shops`.`categoryid`, ' '`shops`.`status_code`, `shops`.`ranknum`, `shops`.`tags` FROM `shops` WHERE ' '`shops`.`categoryid` = %s ORDER BY `shops`.`tkCnt` DESC LIMIT 100') |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/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:
raise utils.IntegrityError(*tuple(e.args))
raise
Variable | Value |
---|---|
args | (12,) |
query | ('SELECT `shops`.`id`, `shops`.`pwId`, `shops`.`pkey`, `shops`.`companyName`, ' '`shops`.`linkUrl`, `shops`.`loginId`, `shops`.`logo`, `shops`.`productCnt`, ' '`shops`.`ratio`, `shops`.`sellerId`, `shops`.`tkCnt`, `shops`.`tradeGrade`, ' '`shops`.`alipayUrl`, `shops`.`imageClickUrl`, `shops`.`longClickUrl`, ' '`shops`.`searchCode`, `shops`.`shortClickUrl`, `shops`.`categoryid`, ' '`shops`.`status_code`, `shops`.`ranknum`, `shops`.`tags` FROM `shops` WHERE ' '`shops`.`categoryid` = %s ORDER BY `shops`.`tkCnt` DESC LIMIT 100') |
self | <django.db.backends.mysql.base.CursorWrapper object at 0x7f67347bc3c8> |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/site-packages/MySQLdb/cursors.py
in execute
args = tuple(map(db.literal, args))
try:
query = query % args
except TypeError as m:
raise ProgrammingError(str(m))
assert isinstance(query, (bytes, bytearray))
res = self._query(query)…
return res
def executemany(self, query, args):
# type: (str, list) -> int
"""Execute a multi-row query.
Variable | Value |
---|---|
args | (b'12',) |
db | <_mysql.connection open to '127.0.0.1' at 0x7f673017ba98> |
query | (b'SELECT `shops`.`id`, `shops`.`pwId`, `shops`.`pkey`, `shops`.`companyName`, ' b'`shops`.`linkUrl`, `shops`.`loginId`, `shops`.`logo`, `shops`.`productCnt`, ' b'`shops`.`ratio`, `shops`.`sellerId`, `shops`.`tkCnt`, `shops`.`tradeGrade`, ' b'`shops`.`alipayUrl`, `shops`.`imageClickUrl`, `shops`.`longClickUrl`, `shops' b'`.`searchCode`, `shops`.`shortClickUrl`, `shops`.`categoryid`, `shops`.`stat' b'us_code`, `shops`.`ranknum`, `shops`.`tags` FROM `shops` WHERE `shops`.`cate' b'goryid` = 12 ORDER BY `shops`.`tkCnt` DESC LIMIT 100') |
self | <MySQLdb.cursors.Cursor object at 0x7f67347d4518> |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/site-packages/MySQLdb/cursors.py
in _query
for i in range(len(args))]))
self._query(q)
return args
def _query(self, q):
db = self._get_db()
self._result = None
db.query(q)…
self._do_get_result(db)
self._post_get_result()
self._executed = q
self._last_executed = q # XXX THIS IS GARBAGE: See above.
return self.rowcount
Variable | Value |
---|---|
db | <_mysql.connection open to '127.0.0.1' at 0x7f673017ba98> |
q | (b'SELECT `shops`.`id`, `shops`.`pwId`, `shops`.`pkey`, `shops`.`companyName`, ' b'`shops`.`linkUrl`, `shops`.`loginId`, `shops`.`logo`, `shops`.`productCnt`, ' b'`shops`.`ratio`, `shops`.`sellerId`, `shops`.`tkCnt`, `shops`.`tradeGrade`, ' b'`shops`.`alipayUrl`, `shops`.`imageClickUrl`, `shops`.`longClickUrl`, `shops' b'`.`searchCode`, `shops`.`shortClickUrl`, `shops`.`categoryid`, `shops`.`stat' b'us_code`, `shops`.`ranknum`, `shops`.`tags` FROM `shops` WHERE `shops`.`cate' b'goryid` = 12 ORDER BY `shops`.`tkCnt` DESC LIMIT 100') |
self | <MySQLdb.cursors.Cursor object at 0x7f67347d4518> |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/site-packages/MySQLdb/connections.py
in query
"""
return (cursorclass or self.cursorclass)(self)
def query(self, query):
# Since _mysql releases GIL while querying, we need immutable buffer.
if isinstance(query, bytearray):
query = bytes(query)
_mysql.connection.query(self, query)…
def _bytes_literal(self, bs):
assert isinstance(bs, (bytes, bytearray))
x = self.string_literal(bs) # x is escaped and quoted bytes
if self._binary_prefix:
return b'_binary' + x
Variable | Value |
---|---|
query | (b'SELECT `shops`.`id`, `shops`.`pwId`, `shops`.`pkey`, `shops`.`companyName`, ' b'`shops`.`linkUrl`, `shops`.`loginId`, `shops`.`logo`, `shops`.`productCnt`, ' b'`shops`.`ratio`, `shops`.`sellerId`, `shops`.`tkCnt`, `shops`.`tradeGrade`, ' b'`shops`.`alipayUrl`, `shops`.`imageClickUrl`, `shops`.`longClickUrl`, `shops' b'`.`searchCode`, `shops`.`shortClickUrl`, `shops`.`categoryid`, `shops`.`stat' b'us_code`, `shops`.`ranknum`, `shops`.`tags` FROM `shops` WHERE `shops`.`cate' b'goryid` = 12 ORDER BY `shops`.`tkCnt` DESC LIMIT 100') |
self | <_mysql.connection open to '127.0.0.1' at 0x7f673017ba98> |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/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)
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 'aliweb.shops' doesn't exist") |
get_response | <bound method BaseHandler._get_response of <django.core.handlers.wsgi.WSGIHandler object at 0x7f67366ccc18>> |
request | <WSGIRequest: GET '/supplier-12.html'> |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/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 supplier_cat at 0x7f67349e1ea0> |
callback_args | ('12',) |
callback_kwargs | {} |
middleware_method | <bound method CsrfViewMiddleware.process_view of <django.middleware.csrf.CsrfViewMiddleware object at 0x7f6737e56588>> |
request | <WSGIRequest: GET '/supplier-12.html'> |
resolver | <URLResolver 'aliweb.urls' (None:None) '^/'> |
resolver_match | ResolverMatch(func=web.views.supplier_cat, args=('12',), kwargs={}, url_name=None, app_names=[], namespaces=[], route=supplier-(\d*).html$) |
response | None |
self | <django.core.handlers.wsgi.WSGIHandler object at 0x7f67366ccc18> |
wrapped_callback | <function supplier_cat at 0x7f67349e1ea0> |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/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 supplier_cat at 0x7f67349e1ea0> |
callback_args | ('12',) |
callback_kwargs | {} |
middleware_method | <bound method CsrfViewMiddleware.process_view of <django.middleware.csrf.CsrfViewMiddleware object at 0x7f6737e56588>> |
request | <WSGIRequest: GET '/supplier-12.html'> |
resolver | <URLResolver 'aliweb.urls' (None:None) '^/'> |
resolver_match | ResolverMatch(func=web.views.supplier_cat, args=('12',), kwargs={}, url_name=None, app_names=[], namespaces=[], route=supplier-(\d*).html$) |
response | None |
self | <django.core.handlers.wsgi.WSGIHandler object at 0x7f67366ccc18> |
wrapped_callback | <function supplier_cat at 0x7f67349e1ea0> |
./web/views.py
in supplier_cat
except:
return HttpResponse('404 Not Found', status=404)
if cid in ali_cate:
cat_name = ali_cate[cid]
datas = Shops.objects.filter(categoryid=cid).order_by('-tkcnt')[:100]
# 随机数据配对
relate_datas = {}
return render(request,'2uq/supplier_cate.html', {'datas': datas, 'cid':cid, 'cat_name':cat_name, 'relate_datas':relate_datas, 'ali_cate':ali_cate})…
else:
return HttpResponse("404 Not Found", status=404)
else:
return HttpResponse("404 Not Found", status=404)
Variable | Value |
---|---|
cat_name | '交通运输' |
cid | 12 |
cur_time | datetime.datetime(2024, 3, 29, 1, 36, 43, 269671) |
datas | Error in formatting: ProgrammingError: (1146, "Table 'aliweb.shops' doesn't exist") |
domain_name | 'www.2uq.net' |
prefix | 'www' |
rand_num | 3230 |
relate_datas | {} |
request | <WSGIRequest: GET '/supplier-12.html'> |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/site-packages/django/shortcuts.py
in render
def render(request, template_name, context=None, content_type=None, status=None, using=None):
"""
Return a HttpResponse whose content is filled with the result of calling
django.template.loader.render_to_string() with the passed arguments.
"""
content = loader.render_to_string(template_name, context, request, using=using)…
return HttpResponse(content, content_type, status)
def redirect(to, *args, permanent=False, **kwargs):
"""
Return an HttpResponseRedirect to the appropriate URL for the arguments
Variable | Value |
---|---|
content_type | None |
context | Error in formatting: ProgrammingError: (1146, "Table 'aliweb.shops' doesn't exist") |
request | <WSGIRequest: GET '/supplier-12.html'> |
status | None |
template_name | '2uq/supplier_cate.html' |
using | None |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/site-packages/django/template/loader.py
in render_to_string
template_name may be a string or a list of strings.
"""
if isinstance(template_name, (list, tuple)):
template = select_template(template_name, using=using)
else:
template = get_template(template_name, using=using)
return template.render(context, request)…
def _engine_list(using=None):
return engines.all() if using is None else [engines[using]]
Variable | Value |
---|---|
context | Error in formatting: ProgrammingError: (1146, "Table 'aliweb.shops' doesn't exist") |
request | <WSGIRequest: GET '/supplier-12.html'> |
template | <django.template.backends.django.Template object at 0x7f6734896dd8> |
template_name | '2uq/supplier_cate.html' |
using | None |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/site-packages/django/template/backends/django.py
in render
@property
def origin(self):
return self.template.origin
def render(self, context=None, request=None):
context = make_context(context, request, autoescape=self.backend.engine.autoescape)
try:
return self.template.render(context)…
except TemplateDoesNotExist as exc:
reraise(exc, self.backend)
def copy_exception(exc, backend=None):
"""
Variable | Value |
---|---|
context | Error in formatting: ProgrammingError: (1146, "Table 'aliweb.shops' doesn't exist") |
request | <WSGIRequest: GET '/supplier-12.html'> |
self | <django.template.backends.django.Template object at 0x7f6734896dd8> |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/site-packages/django/template/base.py
in render
def render(self, context):
"Display stage -- can be called many times"
with context.render_context.push_state(self):
if context.template is None:
with context.bind_template(self):
context.template_name = self.name
return self._render(context)…
else:
return self._render(context)
def compile_nodelist(self):
"""
Parse and compile the template source into a nodelist. If debug
Variable | Value |
---|---|
context | Error in formatting: ProgrammingError: (1146, "Table 'aliweb.shops' doesn't exist") |
self | <django.template.base.Template object at 0x7f67347bc0f0> |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/site-packages/django/template/base.py
in _render
self.nodelist = self.compile_nodelist()
def __iter__(self):
for node in self.nodelist:
yield from node
def _render(self, context):
return self.nodelist.render(context)…
def render(self, context):
"Display stage -- can be called many times"
with context.render_context.push_state(self):
if context.template is None:
with context.bind_template(self):
Variable | Value |
---|---|
context | Error in formatting: ProgrammingError: (1146, "Table 'aliweb.shops' doesn't exist") |
self | <django.template.base.Template object at 0x7f67347bc0f0> |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/site-packages/django/template/base.py
in render
# extend_nodelist().
contains_nontext = False
def render(self, context):
bits = []
for node in self:
if isinstance(node, Node):
bit = node.render_annotated(context)…
else:
bit = node
bits.append(str(bit))
return mark_safe(''.join(bits))
def get_nodes_by_type(self, nodetype):
Variable | Value |
---|---|
bit | '"></script>\n</head>\n<body>\n' |
bits | ['', '\n' '<!doctype html>\n' '<html>\n' '<head>\n' '<meta charset="utf-8">\n' '<meta name="viewport" content="width=device-width, initial-scale=1.0, ' 'maximum-scale=1.0, minimum-scale=1.0, user-scalable=no">\n' '<meta name="applicable-device" content="pc,mobile">\n' '<meta http-equiv="Cache-Control" content="no-transform">\n' '<meta http-equiv="Cache-Control" content="no-siteapp">\n' '<title>', '交通运输', '批发_', '交通运输', '的批发厂家,', '交通运输', '货源-企业列表- 有趣网</title>\n<meta name="Keywords" content="', '交通运输', '批发, ', '交通运输', '厂家, ', '交通运输', '货源">\n<meta name="Description" content="', '交通运输', '批发商列表,', '交通运输', '批发厂家,找', '交通运输', '批发微商货源,', '交通运输', '的批发厂商列表">\n<link rel="stylesheet" type="text/css" href="', '/static/2uq/css/global.css', '">\n<script type="text/javascript" src="', '/static/2uq/js/jquery.min.js', '"></script>\n<script type="text/javascript" src="', '/static/2uq/js/lazyload.min.js', '"></script>\n</head>\n<body>\n'] |
context | Error in formatting: ProgrammingError: (1146, "Table 'aliweb.shops' doesn't exist") |
node | <django.template.defaulttags.SpacelessNode object at 0x7f6734896c50> |
self | [<django.template.defaulttags.LoadNode object at 0x7f6734896048>, <TextNode: '\n<!doctype html>\n<html>\n<'>, <Variable Node: cat_name>, <TextNode: '批发_'>, <Variable Node: cat_name>, <TextNode: '的批发厂家,'>, <Variable Node: cat_name>, <TextNode: '货源-企业列表- 有趣网</title>\n<met'>, <Variable Node: cat_name>, <TextNode: '批发, '>, <Variable Node: cat_name>, <TextNode: '厂家, '>, <Variable Node: cat_name>, <TextNode: '货源">\n<meta name="Descript'>, <Variable Node: cat_name>, <TextNode: '批发商列表,'>, <Variable Node: cat_name>, <TextNode: '批发厂家,找'>, <Variable Node: cat_name>, <TextNode: '批发微商货源,'>, <Variable Node: cat_name>, <TextNode: '的批发厂商列表">\n<link rel="styl'>, <django.templatetags.static.StaticNode object at 0x7f673489bf60>, <TextNode: '">\n<script type="text/jav'>, <django.templatetags.static.StaticNode object at 0x7f673489b710>, <TextNode: '"></script>\n<script type='>, <django.templatetags.static.StaticNode object at 0x7f673489b3c8>, <TextNode: '"></script>\n</head>\n<body'>, <django.template.defaulttags.SpacelessNode object at 0x7f6734896c50>, <TextNode: '\n</body>\n</html>'>] |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/site-packages/django/template/base.py
in render_annotated
"""
Render the node. If debug is True and an exception occurs during
rendering, the exception is annotated with contextual line information
where it occurred in the template. For internal usage this method is
preferred over using the render method directly.
"""
try:
return self.render(context)…
except Exception as e:
if context.template.engine.debug and not hasattr(e, 'template_debug'):
e.template_debug = context.render_context.template.get_exception_info(e, self.token)
raise
def __iter__(self):
Variable | Value |
---|---|
context | Error in formatting: ProgrammingError: (1146, "Table 'aliweb.shops' doesn't exist") |
self | <django.template.defaulttags.SpacelessNode object at 0x7f6734896c50> |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/site-packages/django/template/defaulttags.py
in render
class SpacelessNode(Node):
def __init__(self, nodelist):
self.nodelist = nodelist
def render(self, context):
from django.utils.html import strip_spaces_between_tags
return strip_spaces_between_tags(self.nodelist.render(context).strip())…
class TemplateTagNode(Node):
mapping = {
'openblock': BLOCK_TAG_START,
'closeblock': BLOCK_TAG_END,
Variable | Value |
---|---|
context | Error in formatting: ProgrammingError: (1146, "Table 'aliweb.shops' doesn't exist") |
self | <django.template.defaulttags.SpacelessNode object at 0x7f6734896c50> |
strip_spaces_between_tags | <function strip_spaces_between_tags at 0x7f67370f6488> |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/site-packages/django/template/base.py
in render
# extend_nodelist().
contains_nontext = False
def render(self, context):
bits = []
for node in self:
if isinstance(node, Node):
bit = node.render_annotated(context)…
else:
bit = node
bits.append(str(bit))
return mark_safe(''.join(bits))
def get_nodes_by_type(self, nodetype):
Variable | Value |
---|---|
bit | '批发厂家)100强排行榜</h1></div>\n\n <ul>\n ' |
bits | ['\n', '\n' '<div class="top">\n' ' <div class="cont">\n' ' <div class="logo"><a href="/"><img src="/static/2uq/images/logo.png" ' 'height="70" alt="批发厂商信息网"></a></div>\n' ' <div class="logoRight"><img src="/static/2uq/picture/zhaohuo.png" ' 'alt="有趣批发网,让采购进货变得更有趣"></div>\n' ' <div class="se">\n' ' <form class="form-ss" action="/search" method="get">\n' ' <select name="stype" id="" class="form-option">\n' ' <option value="cj">厂家</option>\n' '\n' '\n' '\n' ' </select>\n' ' <div>\n' ' <input class="form-cc" type="text" name="q" value="" ' 'placeholder="厂家搜索"></div>\n' ' <button class="btn btn-def" type="submit">搜索</button>\n' ' </form>\n' ' </div>\n' ' </div>\n' '</div>\n' '<div class="header">\n' ' <a href="/"><img src="/static/2uq/images/logo.png" alt="有趣批发网" ' 'style="height: 50px;width: auto;"></a>\n' ' <button id="dl-menu-button">Open Menu</button>\n' '</div>\n' '<div class="n">\n' ' <div>\n' ' <ul>\n' ' <li><a href="/" title="有趣网">首页</a></li>\n' ' <li><a href="/list-1-1" title="批发厂家,厂家进货">批发厂家</a></li>\n' ' <li><a href="/list-0-1" title="企业信息,联系电话">企业黄页</a></li>\n' ' <li><a href="/list-2-1" title="旗舰店大全列表">旗舰店</a></li>\n' ' <li><a href="/list-4-1" title="专卖店大全">专卖店</a></li>\n' ' <li><a href="/list-5-1" title="专营店列表">专营店</a></li>\n' ' <li><a href="/list-6-1" title="企业店大全">企业店</a></li>\n' ' <li><a href="/dianpu" title="店铺标签">店铺标签</a></li>\n' ' <li><a href="/product" title="热门批发产品">热门批发</a></li>\n' ' <li><a href="/supplier" title="批发商列表">批发商导航</a></li>\n' '\n' '\n' ' </ul>\n' ' </div>\n' '</div>', '\n' '\n' '<div class="wrap">\n' ' <div class="changjia-nav">\n' ' <a href="/supplier" title="批发厂家百强榜">全部</a>\n' ' ', '\n' ' \n' ' <a href="/supplier-0.html" title="未分类厂家,批发, 厂家列表">未分类</a>\n' '\n' ' \n' ' \n' ' \n' ' <a href="/supplier-10166.html" title="女装厂家,批发, 厂家列表">女装</a>\n' '\n' ' \n' ' \n' ' \n' ' <a href="/supplier-10165.html" title="男装厂家,批发, 厂家列表">男装</a>\n' '\n' ' \n' ' \n' ' \n' ' <a href="/supplier-311.html" title="童装厂家,批发, 厂家列表">童装</a>\n' '\n' ' \n' ' \n' ' \n' ' <a href="/supplier-312.html" title="内衣厂家,批发, 厂家列表">内衣</a>\n' '\n' ' \n' ' \n' ' \n' ' <a href="/supplier-15.html" title="日用百货厂家,批发, ' '厂家列表">日用百货</a>\n' '\n' ' \n' ' \n' ' \n' ' <a href="/supplier-54.html" title="服饰配件、饰品厂家,批发, ' '厂家列表">服饰配件、饰品</a>\n' '\n' ' \n' ' \n' ' \n' ' <a href="/supplier-7.html" title="数码、电脑厂家,批发, ' '厂家列表">数码、电脑</a>\n' '\n' ' \n' ' \n' ' \n' ' <a href="/supplier-2.html" title="食品酒水厂家,批发, 厂家列表">食品酒水</a>\n' '\n' ' \n' ' \n' ' \n' ' <a href="/supplier-13.html" title="家装建材厂家,批发, ' '厂家列表">家装建材</a>\n' '\n' ' \n' ' \n' ' \n' ' <a href="/supplier-96.html" title="家纺家饰厂家,批发, ' '厂家列表">家纺家饰</a>\n' '\n' ' \n' ' \n' ' \n' ' <a href="/supplier-130822220.html" title="个护/家清厂家,批发, ' '厂家列表">个护/家清</a>\n' '\n' ' \n' ' \n' ' \n' ' <a href="/supplier-17.html" title="工艺品、礼品厂家,批发, ' '厂家列表">工艺品、礼品</a>\n' '\n' ' \n' ' \n' ' \n' ' <a href="/supplier-1501.html" title="母婴用品厂家,批发, ' '厂家列表">母婴用品</a>\n' '\n' ' \n' ' \n' ' \n' ' <a href="/supplier-1038378.html" title="鞋厂家,批发, 厂家列表">鞋</a>\n' … <trimmed 9579 bytes string> |
context | Error in formatting: ProgrammingError: (1146, "Table 'aliweb.shops' doesn't exist") |
node | <ForNode: for one in datas, tail_len: 11> |
self | [<TextNode: '\n'>, <django.template.loader_tags.IncludeNode object at 0x7f673489b6a0>, <TextNode: '\n\n<div class="wrap">\n '>, <ForNode: for x, y in ali_cate.items, tail_len: 3>, <TextNode: '\n <div style="clea'>, <Variable Node: cat_name>, <TextNode: '批发厂家)100强排行榜</h1></div>\n\n'>, <ForNode: for one in datas, tail_len: 11>, <TextNode: '\n </ul>\n\n</div>\n<div c'>, <TextNode: '\n'>, <TextNode: '\n'>, <TextNode: '\n'>, <TextNode: '\n'>, <TextNode: '\n '>, <ForNode: for one in relate_datas, tail_len: 7>, <TextNode: '\n </div>\n </div'>, <django.template.loader_tags.IncludeNode object at 0x7f67348967f0>, <TextNode: '\n'>] |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/site-packages/django/template/base.py
in render_annotated
"""
Render the node. If debug is True and an exception occurs during
rendering, the exception is annotated with contextual line information
where it occurred in the template. For internal usage this method is
preferred over using the render method directly.
"""
try:
return self.render(context)…
except Exception as e:
if context.template.engine.debug and not hasattr(e, 'template_debug'):
e.template_debug = context.render_context.template.get_exception_info(e, self.token)
raise
def __iter__(self):
Variable | Value |
---|---|
context | Error in formatting: ProgrammingError: (1146, "Table 'aliweb.shops' doesn't exist") |
self | <ForNode: for one in datas, tail_len: 11> |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/site-packages/django/template/defaulttags.py
in render
parentloop = {}
with context.push():
values = self.sequence.resolve(context, ignore_failures=True)
if values is None:
values = []
if not hasattr(values, '__len__'):
values = list(values)
len_values = len(values)…
if len_values < 1:
return self.nodelist_empty.render(context)
nodelist = []
if self.is_reversed:
values = reversed(values)
num_loopvars = len(self.loopvars)
Variable | Value |
---|---|
context | Error in formatting: ProgrammingError: (1146, "Table 'aliweb.shops' doesn't exist") |
parentloop | {} |
self | <ForNode: for one in datas, tail_len: 11> |
values | Error in formatting: ProgrammingError: (1146, "Table 'aliweb.shops' doesn't exist") |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/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 'aliweb.shops' doesn't exist") |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/site-packages/django/db/models/query.py
in _fetch_all
c._known_related_objects = self._known_related_objects
c._iterable_class = self._iterable_class
c._fields = self._fields
return c
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):
"""
Indicate that the next filter call and the one following that should
Variable | Value |
---|---|
self | Error in formatting: ProgrammingError: (1146, "Table 'aliweb.shops' doesn't exist") |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/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, chunk_size=self.chunk_size)…
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 0x7f67347d48d0> |
db | 'default' |
queryset | Error in formatting: ProgrammingError: (1146, "Table 'aliweb.shops' doesn't exist") |
self | <django.db.models.query.ModelIterable object at 0x7f67347d44e0> |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/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:
# Might fail for server-side cursors (e.g. connection closed)
cursor.close()
raise
if result_type == CURSOR:
Variable | Value |
---|---|
chunk_size | 100 |
chunked_fetch | False |
cursor | <django.db.backends.utils.CursorDebugWrapper object at 0x7f67347bc1d0> |
params | (12,) |
result_type | 'multi' |
self | <django.db.backends.mysql.compiler.SQLCompiler object at 0x7f67347d48d0> |
sql | ('SELECT `shops`.`id`, `shops`.`pwId`, `shops`.`pkey`, `shops`.`companyName`, ' '`shops`.`linkUrl`, `shops`.`loginId`, `shops`.`logo`, `shops`.`productCnt`, ' '`shops`.`ratio`, `shops`.`sellerId`, `shops`.`tkCnt`, `shops`.`tradeGrade`, ' '`shops`.`alipayUrl`, `shops`.`imageClickUrl`, `shops`.`longClickUrl`, ' '`shops`.`searchCode`, `shops`.`shortClickUrl`, `shops`.`categoryid`, ' '`shops`.`status_code`, `shops`.`ranknum`, `shops`.`tags` FROM `shops` WHERE ' '`shops`.`categoryid` = %s ORDER BY `shops`.`tkCnt` DESC LIMIT 100') |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/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().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.00021004676818847656 |
params | (12,) |
self | <django.db.backends.utils.CursorDebugWrapper object at 0x7f67347bc1d0> |
sql | None |
start | 1711647403.296779 |
stop | 1711647403.296989 |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/site-packages/django/db/backends/utils.py
in execute
elif kparams is None:
return self.cursor.callproc(procname, params)
else:
params = params or ()
return self.cursor.callproc(procname, params, kparams)
def execute(self, sql, params=None):
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)…
def executemany(self, sql, param_list):
return self._execute_with_wrappers(sql, param_list, many=True, executor=self._executemany)
def _execute_with_wrappers(self, sql, params, many, executor):
context = {'connection': self.db, 'cursor': self}
Variable | Value |
---|---|
params | (12,) |
self | <django.db.backends.utils.CursorDebugWrapper object at 0x7f67347bc1d0> |
sql | ('SELECT `shops`.`id`, `shops`.`pwId`, `shops`.`pkey`, `shops`.`companyName`, ' '`shops`.`linkUrl`, `shops`.`loginId`, `shops`.`logo`, `shops`.`productCnt`, ' '`shops`.`ratio`, `shops`.`sellerId`, `shops`.`tkCnt`, `shops`.`tradeGrade`, ' '`shops`.`alipayUrl`, `shops`.`imageClickUrl`, `shops`.`longClickUrl`, ' '`shops`.`searchCode`, `shops`.`shortClickUrl`, `shops`.`categoryid`, ' '`shops`.`status_code`, `shops`.`ranknum`, `shops`.`tags` FROM `shops` WHERE ' '`shops`.`categoryid` = %s ORDER BY `shops`.`tkCnt` DESC LIMIT 100') |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/site-packages/django/db/backends/utils.py
in _execute_with_wrappers
def executemany(self, sql, param_list):
return self._execute_with_wrappers(sql, param_list, many=True, executor=self._executemany)
def _execute_with_wrappers(self, sql, params, many, executor):
context = {'connection': self.db, 'cursor': self}
for wrapper in reversed(self.db.execute_wrappers):
executor = functools.partial(wrapper, executor)
return executor(sql, params, many, context)…
def _execute(self, sql, params, *ignored_wrapper_args):
self.db.validate_no_broken_transaction()
with self.db.wrap_database_errors:
if params is None:
return self.cursor.execute(sql)
Variable | Value |
---|---|
context | {'connection': <django.db.backends.mysql.base.DatabaseWrapper object at 0x7f67346e7048>, 'cursor': <django.db.backends.utils.CursorDebugWrapper object at 0x7f67347bc1d0>} |
executor | <bound method CursorWrapper._execute of <django.db.backends.utils.CursorDebugWrapper object at 0x7f67347bc1d0>> |
many | False |
params | (12,) |
self | <django.db.backends.utils.CursorDebugWrapper object at 0x7f67347bc1d0> |
sql | ('SELECT `shops`.`id`, `shops`.`pwId`, `shops`.`pkey`, `shops`.`companyName`, ' '`shops`.`linkUrl`, `shops`.`loginId`, `shops`.`logo`, `shops`.`productCnt`, ' '`shops`.`ratio`, `shops`.`sellerId`, `shops`.`tkCnt`, `shops`.`tradeGrade`, ' '`shops`.`alipayUrl`, `shops`.`imageClickUrl`, `shops`.`longClickUrl`, ' '`shops`.`searchCode`, `shops`.`shortClickUrl`, `shops`.`categoryid`, ' '`shops`.`status_code`, `shops`.`ranknum`, `shops`.`tags` FROM `shops` WHERE ' '`shops`.`categoryid` = %s ORDER BY `shops`.`tkCnt` DESC LIMIT 100') |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/site-packages/django/db/backends/utils.py
in _execute
def _execute(self, sql, params, *ignored_wrapper_args):
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, *ignored_wrapper_args):
self.db.validate_no_broken_transaction()
with self.db.wrap_database_errors:
return self.cursor.executemany(sql, param_list)
Variable | Value |
---|---|
ignored_wrapper_args | (False, {'connection': <django.db.backends.mysql.base.DatabaseWrapper object at 0x7f67346e7048>, 'cursor': <django.db.backends.utils.CursorDebugWrapper object at 0x7f67347bc1d0>}) |
params | (12,) |
self | <django.db.backends.utils.CursorDebugWrapper object at 0x7f67347bc1d0> |
sql | ('SELECT `shops`.`id`, `shops`.`pwId`, `shops`.`pkey`, `shops`.`companyName`, ' '`shops`.`linkUrl`, `shops`.`loginId`, `shops`.`logo`, `shops`.`productCnt`, ' '`shops`.`ratio`, `shops`.`sellerId`, `shops`.`tkCnt`, `shops`.`tradeGrade`, ' '`shops`.`alipayUrl`, `shops`.`imageClickUrl`, `shops`.`longClickUrl`, ' '`shops`.`searchCode`, `shops`.`shortClickUrl`, `shops`.`categoryid`, ' '`shops`.`status_code`, `shops`.`ranknum`, `shops`.`tags` FROM `shops` WHERE ' '`shops`.`categoryid` = %s ORDER BY `shops`.`tkCnt` DESC LIMIT 100') |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/site-packages/django/db/utils.py
in __exit__
db_exc_type = getattr(self.wrapper.Database, dj_exc_type.__name__)
if issubclass(exc_type, db_exc_type):
dj_exc_value = dj_exc_type(*exc_value.args)
# 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
raise dj_exc_value.with_traceback(traceback) from exc_value…
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 'MySQLdb._exceptions.ProgrammingError'> |
dj_exc_type | <class 'django.db.utils.ProgrammingError'> |
dj_exc_value | ProgrammingError(1146, "Table 'aliweb.shops' doesn't exist") |
exc_type | <class 'MySQLdb._exceptions.ProgrammingError'> |
exc_value | ProgrammingError(1146, "Table 'aliweb.shops' doesn't exist") |
self | <django.db.utils.DatabaseErrorWrapper object at 0x7f67346b4ac8> |
traceback | <traceback object at 0x7f6734762d88> |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/site-packages/django/db/backends/utils.py
in _execute
def _execute(self, sql, params, *ignored_wrapper_args):
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, *ignored_wrapper_args):
self.db.validate_no_broken_transaction()
with self.db.wrap_database_errors:
return self.cursor.executemany(sql, param_list)
Variable | Value |
---|---|
ignored_wrapper_args | (False, {'connection': <django.db.backends.mysql.base.DatabaseWrapper object at 0x7f67346e7048>, 'cursor': <django.db.backends.utils.CursorDebugWrapper object at 0x7f67347bc1d0>}) |
params | (12,) |
self | <django.db.backends.utils.CursorDebugWrapper object at 0x7f67347bc1d0> |
sql | ('SELECT `shops`.`id`, `shops`.`pwId`, `shops`.`pkey`, `shops`.`companyName`, ' '`shops`.`linkUrl`, `shops`.`loginId`, `shops`.`logo`, `shops`.`productCnt`, ' '`shops`.`ratio`, `shops`.`sellerId`, `shops`.`tkCnt`, `shops`.`tradeGrade`, ' '`shops`.`alipayUrl`, `shops`.`imageClickUrl`, `shops`.`longClickUrl`, ' '`shops`.`searchCode`, `shops`.`shortClickUrl`, `shops`.`categoryid`, ' '`shops`.`status_code`, `shops`.`ranknum`, `shops`.`tags` FROM `shops` WHERE ' '`shops`.`categoryid` = %s ORDER BY `shops`.`tkCnt` DESC LIMIT 100') |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/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:
raise utils.IntegrityError(*tuple(e.args))
raise
Variable | Value |
---|---|
args | (12,) |
query | ('SELECT `shops`.`id`, `shops`.`pwId`, `shops`.`pkey`, `shops`.`companyName`, ' '`shops`.`linkUrl`, `shops`.`loginId`, `shops`.`logo`, `shops`.`productCnt`, ' '`shops`.`ratio`, `shops`.`sellerId`, `shops`.`tkCnt`, `shops`.`tradeGrade`, ' '`shops`.`alipayUrl`, `shops`.`imageClickUrl`, `shops`.`longClickUrl`, ' '`shops`.`searchCode`, `shops`.`shortClickUrl`, `shops`.`categoryid`, ' '`shops`.`status_code`, `shops`.`ranknum`, `shops`.`tags` FROM `shops` WHERE ' '`shops`.`categoryid` = %s ORDER BY `shops`.`tkCnt` DESC LIMIT 100') |
self | <django.db.backends.mysql.base.CursorWrapper object at 0x7f67347bc3c8> |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/site-packages/MySQLdb/cursors.py
in execute
args = tuple(map(db.literal, args))
try:
query = query % args
except TypeError as m:
raise ProgrammingError(str(m))
assert isinstance(query, (bytes, bytearray))
res = self._query(query)…
return res
def executemany(self, query, args):
# type: (str, list) -> int
"""Execute a multi-row query.
Variable | Value |
---|---|
args | (b'12',) |
db | <_mysql.connection open to '127.0.0.1' at 0x7f673017ba98> |
query | (b'SELECT `shops`.`id`, `shops`.`pwId`, `shops`.`pkey`, `shops`.`companyName`, ' b'`shops`.`linkUrl`, `shops`.`loginId`, `shops`.`logo`, `shops`.`productCnt`, ' b'`shops`.`ratio`, `shops`.`sellerId`, `shops`.`tkCnt`, `shops`.`tradeGrade`, ' b'`shops`.`alipayUrl`, `shops`.`imageClickUrl`, `shops`.`longClickUrl`, `shops' b'`.`searchCode`, `shops`.`shortClickUrl`, `shops`.`categoryid`, `shops`.`stat' b'us_code`, `shops`.`ranknum`, `shops`.`tags` FROM `shops` WHERE `shops`.`cate' b'goryid` = 12 ORDER BY `shops`.`tkCnt` DESC LIMIT 100') |
self | <MySQLdb.cursors.Cursor object at 0x7f67347d4518> |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/site-packages/MySQLdb/cursors.py
in _query
for i in range(len(args))]))
self._query(q)
return args
def _query(self, q):
db = self._get_db()
self._result = None
db.query(q)…
self._do_get_result(db)
self._post_get_result()
self._executed = q
self._last_executed = q # XXX THIS IS GARBAGE: See above.
return self.rowcount
Variable | Value |
---|---|
db | <_mysql.connection open to '127.0.0.1' at 0x7f673017ba98> |
q | (b'SELECT `shops`.`id`, `shops`.`pwId`, `shops`.`pkey`, `shops`.`companyName`, ' b'`shops`.`linkUrl`, `shops`.`loginId`, `shops`.`logo`, `shops`.`productCnt`, ' b'`shops`.`ratio`, `shops`.`sellerId`, `shops`.`tkCnt`, `shops`.`tradeGrade`, ' b'`shops`.`alipayUrl`, `shops`.`imageClickUrl`, `shops`.`longClickUrl`, `shops' b'`.`searchCode`, `shops`.`shortClickUrl`, `shops`.`categoryid`, `shops`.`stat' b'us_code`, `shops`.`ranknum`, `shops`.`tags` FROM `shops` WHERE `shops`.`cate' b'goryid` = 12 ORDER BY `shops`.`tkCnt` DESC LIMIT 100') |
self | <MySQLdb.cursors.Cursor object at 0x7f67347d4518> |
/www/wwwroot/www.2uq.net/178fb47f4cbbe5c0cda31f9004b28da9_venv/lib/python3.6/site-packages/MySQLdb/connections.py
in query
"""
return (cursorclass or self.cursorclass)(self)
def query(self, query):
# Since _mysql releases GIL while querying, we need immutable buffer.
if isinstance(query, bytearray):
query = bytes(query)
_mysql.connection.query(self, query)…
def _bytes_literal(self, bs):
assert isinstance(bs, (bytes, bytearray))
x = self.string_literal(bs) # x is escaped and quoted bytes
if self._binary_prefix:
return b'_binary' + x
Variable | Value |
---|---|
query | (b'SELECT `shops`.`id`, `shops`.`pwId`, `shops`.`pkey`, `shops`.`companyName`, ' b'`shops`.`linkUrl`, `shops`.`loginId`, `shops`.`logo`, `shops`.`productCnt`, ' b'`shops`.`ratio`, `shops`.`sellerId`, `shops`.`tkCnt`, `shops`.`tradeGrade`, ' b'`shops`.`alipayUrl`, `shops`.`imageClickUrl`, `shops`.`longClickUrl`, `shops' b'`.`searchCode`, `shops`.`shortClickUrl`, `shops`.`categoryid`, `shops`.`stat' b'us_code`, `shops`.`ranknum`, `shops`.`tags` FROM `shops` WHERE `shops`.`cate' b'goryid` = 12 ORDER BY `shops`.`tkCnt` DESC LIMIT 100') |
self | <_mysql.connection open to '127.0.0.1' at 0x7f673017ba98> |
AnonymousUser
No GET data
No POST data
No FILES data
No cookie data
Variable | Value |
---|---|
HTTP_ACCEPT | '*/*' |
HTTP_CONNECTION | 'close' |
HTTP_HOST | 'www.2uq.net' |
HTTP_REMOTE_HOST | '35.175.212.5' |
HTTP_USER_AGENT | 'claudebot' |
HTTP_X_FORWARDED_FOR | '35.175.212.5' |
HTTP_X_REAL_IP | '35.175.212.5' |
PATH_INFO | '/supplier-12.html' |
QUERY_STRING | '' |
REMOTE_ADDR | '127.0.0.1' |
REMOTE_PORT | '16002' |
REQUEST_METHOD | 'GET' |
REQUEST_URI | '/supplier-12.html' |
SCRIPT_NAME | '' |
SERVER_NAME | 'iZ8vb58q9tvkbyhrynx3u9Z' |
SERVER_PORT | '5080' |
SERVER_PROTOCOL | 'HTTP/1.0' |
UWSGI_ROUTER | 'http' |
uwsgi.core | 1 |
uwsgi.node | b'iZ8vb58q9tvkbyhrynx3u9Z' |
uwsgi.version | b'2.0.23' |
wsgi.errors | <_io.TextIOWrapper name=2 mode='w' encoding='UTF-8'> |
wsgi.file_wrapper | '' |
wsgi.input | <uwsgi._Input object at 0x7f673488aa50> |
wsgi.multiprocess | False |
wsgi.multithread | True |
wsgi.run_once | False |
wsgi.url_scheme | 'http' |
wsgi.version | (1, 0) |
aliweb.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 | '/www/wwwroot/www.2uq.net' |
CACHES | {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}} |
CACHE_MIDDLEWARE_ALIAS | 'default' |
CACHE_MIDDLEWARE_KEY_PREFIX | '********************' |
CACHE_MIDDLEWARE_SECONDS | 600 |
CSRF_COOKIE_AGE | 31449600 |
CSRF_COOKIE_DOMAIN | None |
CSRF_COOKIE_HTTPONLY | False |
CSRF_COOKIE_NAME | 'csrftoken' |
CSRF_COOKIE_PATH | '/' |
CSRF_COOKIE_SAMESITE | 'Lax' |
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': 'aliweb', 'OPTIONS': {}, 'PASSWORD': '********************', 'PORT': '3306', 'TEST': {'CHARSET': None, 'COLLATION': None, 'MIRROR': None, 'NAME': None}, 'TIME_ZONE': None, 'USER': 'aliweb'}} |
DATABASE_ROUTERS | [] |
DATA_UPLOAD_MAX_MEMORY_SIZE | 2621440 |
DATA_UPLOAD_MAX_NUMBER_FIELDS | 1000 |
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 | [] |
INSTALLED_APPS | ['django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'web'] |
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'), ('hy', 'Armenian'), ('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')] |
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 | '/www/wwwroot/www.2uq.net/static/media' |
MEDIA_URL | '' |
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'] |
MIGRATION_MODULES | {} |
MONTH_DAY_FORMAT | 'F j' |
NUMBER_GROUPING | 0 |
PASSWORD_HASHERS | '********************' |
PASSWORD_RESET_TIMEOUT_DAYS | '********************' |
PREPEND_WWW | False |
ROOT_URLCONF | 'aliweb.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_SAMESITE | 'Lax' |
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 | 'aliweb.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 | ('/www/wwwroot/www.2uq.net/static/web',) |
STATICFILES_FINDERS | ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder'] |
STATICFILES_STORAGE | 'django.contrib.staticfiles.storage.StaticFilesStorage' |
STATIC_ROOT | '/www/wwwroot/www.2uq.net/collect_static' |
STATIC_URL | '/static/' |
TEMPLATES | [{'APP_DIRS': True, 'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': ['/www/wwwroot/www.2uq.net/tpl_all'], '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']}}] |
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_I18N | True |
USE_L10N | True |
USE_THOUSAND_SEPARATOR | False |
USE_TZ | True |
USE_X_FORWARDED_HOST | False |
USE_X_FORWARDED_PORT | False |
WSGI_APPLICATION | 'aliweb.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.