no such table: manufacturer_bar
Request Method: | GET |
---|---|
Request URL: | http://thecoffeeoutlets.com/accounts/login/?next=/store/urnex/urnex-rinza/ |
Django Version: | 2.2.2 |
Exception Type: | OperationalError |
Exception Value: | no such table: manufacturer_bar |
Exception Location: | /app/.heroku/python/lib/python3.6/site-packages/django/db/backends/sqlite3/base.py in execute, line 383 |
Python Executable: | /app/.heroku/python/bin/python |
Python Version: | 3.6.7 |
Python Path: | ['/app/.heroku/python/bin', '/app', '/app/.heroku/python/lib/python36.zip', '/app/.heroku/python/lib/python3.6', '/app/.heroku/python/lib/python3.6/lib-dynload', '/app/.heroku/python/lib/python3.6/site-packages'] |
Server time: | Thu, 28 Mar 2024 12:30:59 +0000 |
/app/.heroku/python/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.sqlite3.base.DatabaseWrapper object at 0x7fb73de29da0>, 'cursor': <django.db.backends.utils.CursorDebugWrapper object at 0x7fb73c981b38>}) |
params | (False,) |
self | <django.db.backends.utils.CursorDebugWrapper object at 0x7fb73c981b38> |
sql | ('SELECT "manufacturer_bar"."id", "manufacturer_bar"."user_id", ' '"manufacturer_bar"."purchased", "manufacturer_bar"."created_date", ' '"manufacturer_bar"."last_edit_date" FROM "manufacturer_bar" WHERE ' '("manufacturer_bar"."purchased" = %s AND "manufacturer_bar"."user_id" IS ' 'NULL)') |
/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/sqlite3/base.py
in execute
This fixes it -- but note that if you want to use a literal "%s" in a query,
you'll need to use "%%s".
"""
def execute(self, query, params=None):
if params is None:
return Database.Cursor.execute(self, query)
query = self.convert_query(query)
return Database.Cursor.execute(self, query, params)…
def executemany(self, query, param_list):
query = self.convert_query(query)
return Database.Cursor.executemany(self, query, param_list)
def convert_query(self, query):
Variable | Value |
---|---|
params | (False,) |
query | ('SELECT "manufacturer_bar"."id", "manufacturer_bar"."user_id", ' '"manufacturer_bar"."purchased", "manufacturer_bar"."created_date", ' '"manufacturer_bar"."last_edit_date" FROM "manufacturer_bar" WHERE ' '("manufacturer_bar"."purchased" = ? AND "manufacturer_bar"."user_id" IS ' 'NULL)') |
self | <django.db.backends.sqlite3.base.SQLiteCursorWrapper object at 0x7fb73cb99af8> |
/app/.heroku/python/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 | OperationalError('no such table: manufacturer_bar',) |
get_response | <bound method BaseHandler._get_response of <django.core.handlers.wsgi.WSGIHandler object at 0x7fb73d1b49b0>> |
request | <WSGIRequest: GET '/accounts/login/?next=/store/urnex/urnex-rinza/'> |
/app/.heroku/python/lib/python3.6/site-packages/django/core/handlers/base.py
in _get_response
"HttpResponse object. It returned None instead."
% (middleware_method.__self__.__class__.__name__)
)
try:
response = response.render()
except Exception as e:
response = self.process_exception_by_middleware(e, request)…
return response
def process_exception_by_middleware(self, exception, request):
"""
Pass the exception to the exception middleware. If no middleware
Variable | Value |
---|---|
callback | <function LoginView at 0x7fb73cdbf2f0> |
callback_args | () |
callback_kwargs | {} |
middleware_method | <bound method CsrfViewMiddleware.process_view of <django.middleware.csrf.CsrfViewMiddleware object at 0x7fb73ce0b710>> |
request | <WSGIRequest: GET '/accounts/login/?next=/store/urnex/urnex-rinza/'> |
resolver | <URLResolver 'thecoffeeoutlets.urls' (None:None) '^/'> |
resolver_match | ResolverMatch(func=django.contrib.auth.views.LoginView, args=(), kwargs={}, url_name=login, app_names=[], namespaces=[], route=accounts/login/) |
response | <TemplateResponse status_code=200, "text/html; charset=utf-8"> |
self | <django.core.handlers.wsgi.WSGIHandler object at 0x7fb73d1b49b0> |
wrapped_callback | <function LoginView at 0x7fb73cdbf2f0> |
/app/.heroku/python/lib/python3.6/site-packages/django/core/handlers/base.py
in _get_response
raise ValueError(
"%s.process_template_response didn't return an "
"HttpResponse object. It returned None instead."
% (middleware_method.__self__.__class__.__name__)
)
try:
response = response.render()…
except Exception as e:
response = self.process_exception_by_middleware(e, request)
return response
def process_exception_by_middleware(self, exception, request):
Variable | Value |
---|---|
callback | <function LoginView at 0x7fb73cdbf2f0> |
callback_args | () |
callback_kwargs | {} |
middleware_method | <bound method CsrfViewMiddleware.process_view of <django.middleware.csrf.CsrfViewMiddleware object at 0x7fb73ce0b710>> |
request | <WSGIRequest: GET '/accounts/login/?next=/store/urnex/urnex-rinza/'> |
resolver | <URLResolver 'thecoffeeoutlets.urls' (None:None) '^/'> |
resolver_match | ResolverMatch(func=django.contrib.auth.views.LoginView, args=(), kwargs={}, url_name=login, app_names=[], namespaces=[], route=accounts/login/) |
response | <TemplateResponse status_code=200, "text/html; charset=utf-8"> |
self | <django.core.handlers.wsgi.WSGIHandler object at 0x7fb73d1b49b0> |
wrapped_callback | <function LoginView at 0x7fb73cdbf2f0> |
/app/.heroku/python/lib/python3.6/site-packages/django/template/response.py
in render
If the content has already been rendered, this is a no-op.
Return the baked response instance.
"""
retval = self
if not self._is_rendered:
self.content = self.rendered_content…
for post_callback in self._post_render_callbacks:
newretval = post_callback(retval)
if newretval is not None:
retval = newretval
return retval
Variable | Value |
---|---|
retval | <TemplateResponse status_code=200, "text/html; charset=utf-8"> |
self | <TemplateResponse status_code=200, "text/html; charset=utf-8"> |
/app/.heroku/python/lib/python3.6/site-packages/django/template/response.py
in rendered_content
This *does not* set the final content of the response. To set the
response content, you must either call render(), or set the
content explicitly using the value of this property.
"""
template = self.resolve_template(self.template_name)
context = self.resolve_context(self.context_data)
content = template.render(context, self._request)…
return content
def add_post_render_callback(self, callback):
"""Add a new post-rendering callback.
If the response has already been rendered,
Variable | Value |
---|---|
context | {'form': <AuthenticationForm bound=False, valid=Unknown, fields=(username;password)>, 'next': '/store/urnex/urnex-rinza/', 'site': <django.contrib.sites.requests.RequestSite object at 0x7fb73c981550>, 'site_name': 'thecoffeeoutlets.com', 'view': <django.contrib.auth.views.LoginView object at 0x7fb73c9812e8>} |
self | <TemplateResponse status_code=200, "text/html; charset=utf-8"> |
template | <django.template.backends.django.Template object at 0x7fb73c9810f0> |
/app/.heroku/python/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 | [{'True': True, 'False': False, 'None': None}, {}, {}, {'form': <AuthenticationForm bound=False, valid=Unknown, fields=(username;password)>, 'view': <django.contrib.auth.views.LoginView object at 0x7fb73c9812e8>, 'next': '/store/urnex/urnex-rinza/', 'site': <django.contrib.sites.requests.RequestSite object at 0x7fb73c981550>, 'site_name': 'thecoffeeoutlets.com'}] |
request | <WSGIRequest: GET '/accounts/login/?next=/store/urnex/urnex-rinza/'> |
self | <django.template.backends.django.Template object at 0x7fb73c9810f0> |
/app/.heroku/python/lib/python3.6/site-packages/django/template/base.py
in render
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):…
context.template_name = self.name
return self._render(context)
else:
return self._render(context)
def compile_nodelist(self):
Variable | Value |
---|---|
context | [{'True': True, 'False': False, 'None': None}, {}, {}, {'form': <AuthenticationForm bound=False, valid=Unknown, fields=(username;password)>, 'view': <django.contrib.auth.views.LoginView object at 0x7fb73c9812e8>, 'next': '/store/urnex/urnex-rinza/', 'site': <django.contrib.sites.requests.RequestSite object at 0x7fb73c981550>, 'site_name': 'thecoffeeoutlets.com'}] |
self | <django.template.base.Template object at 0x7fb73c981fd0> |
/app/.heroku/python/lib/python3.6/contextlib.py
in __enter__
# _GCM instances are one-shot context managers, so the
# CM must be recreated each time a decorated function is
# called
return self.__class__(self.func, self.args, self.kwds)
def __enter__(self):
try:
return next(self.gen)…
except StopIteration:
raise RuntimeError("generator didn't yield") from None
def __exit__(self, type, value, traceback):
if type is None:
try:
Variable | Value |
---|---|
self | <contextlib._GeneratorContextManager object at 0x7fb73c981908> |
/app/.heroku/python/lib/python3.6/site-packages/django/template/context.py
in bind_template
self.template = template
# Set context processors according to the template engine's settings.
processors = (template.engine.template_context_processors +
self._processors)
updates = {}
for processor in processors:
updates.update(processor(self.request))…
self.dicts[self._processors_index] = updates
try:
yield
finally:
self.template = None
Variable | Value |
---|---|
processor | <function show_bar at 0x7fb73cb97bf8> |
processors | (<function csrf at 0x7fb73cc7c598>, <function debug at 0x7fb73cb97268>, <function request at 0x7fb73cb97510>, <function auth at 0x7fb73cb97598>, <function messages at 0x7fb73cb97ae8>, <function show_store_menu at 0x7fb73cb97b70>, <function show_bar at 0x7fb73cb97bf8>) |
self | [{'True': True, 'False': False, 'None': None}, {}, {}, {'form': <AuthenticationForm bound=False, valid=Unknown, fields=(username;password)>, 'view': <django.contrib.auth.views.LoginView object at 0x7fb73c9812e8>, 'next': '/store/urnex/urnex-rinza/', 'site': <django.contrib.sites.requests.RequestSite object at 0x7fb73c981550>, 'site_name': 'thecoffeeoutlets.com'}] |
template | <django.template.base.Template object at 0x7fb73c981fd0> |
updates | Error in formatting: OperationalError: no such table: manufacturer_manufacturer |
/app/base/menu_context.py
in show_bar
the_user = None
if request.user.is_authenticated == True:
the_user = request.user
try:
bar = Bar.objects.get(user=the_user, purchased=False)…
except Bar.DoesNotExist:
bar = None
return {'bar': bar}
if bar != None:
baritems = BarItems.objects.filter(bar=bar)
Variable | Value |
---|---|
bar | None |
request | <WSGIRequest: GET '/accounts/login/?next=/store/urnex/urnex-rinza/'> |
the_user | None |
/app/.heroku/python/lib/python3.6/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 = {}
for name, method in inspect.getmembers(queryset_class, predicate=inspect.isfunction):
Variable | Value |
---|---|
args | () |
kwargs | {'purchased': False, 'user': None} |
name | 'get' |
self | <django.db.models.manager.Manager object at 0x7fb73cb96ac8> |
/app/.heroku/python/lib/python3.6/site-packages/django/db/models/query.py
in get
"""
Perform the query and return 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: OperationalError: no such table: manufacturer_bar |
kwargs | {'purchased': False, 'user': None} |
self | Error in formatting: OperationalError: no such table: manufacturer_bar |
/app/.heroku/python/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: OperationalError: no such table: manufacturer_bar |
/app/.heroku/python/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: OperationalError: no such table: manufacturer_bar |
/app/.heroku/python/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.models.sql.compiler.SQLCompiler object at 0x7fb73c98f208> |
db | 'default' |
queryset | Error in formatting: OperationalError: no such table: manufacturer_bar |
self | <django.db.models.query.ModelIterable object at 0x7fb73c98f5f8> |
/app/.heroku/python/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 0x7fb73c981b38> |
params | (False,) |
result_type | 'multi' |
self | <django.db.models.sql.compiler.SQLCompiler object at 0x7fb73c98f208> |
sql | ('SELECT "manufacturer_bar"."id", "manufacturer_bar"."user_id", ' '"manufacturer_bar"."purchased", "manufacturer_bar"."created_date", ' '"manufacturer_bar"."last_edit_date" FROM "manufacturer_bar" WHERE ' '("manufacturer_bar"."purchased" = %s AND "manufacturer_bar"."user_id" IS ' 'NULL)') |
/app/.heroku/python/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.00011157989501953125 |
params | (False,) |
self | <django.db.backends.utils.CursorDebugWrapper object at 0x7fb73c981b38> |
sql | ('SELECT "manufacturer_bar"."id", "manufacturer_bar"."user_id", ' '"manufacturer_bar"."purchased", "manufacturer_bar"."created_date", ' '"manufacturer_bar"."last_edit_date" FROM "manufacturer_bar" WHERE ' '("manufacturer_bar"."purchased" = 0 AND "manufacturer_bar"."user_id" IS ' 'NULL)') |
start | 1711629059.368347 |
stop | 1711629059.3684585 |
/app/.heroku/python/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 | (False,) |
self | <django.db.backends.utils.CursorDebugWrapper object at 0x7fb73c981b38> |
sql | ('SELECT "manufacturer_bar"."id", "manufacturer_bar"."user_id", ' '"manufacturer_bar"."purchased", "manufacturer_bar"."created_date", ' '"manufacturer_bar"."last_edit_date" FROM "manufacturer_bar" WHERE ' '("manufacturer_bar"."purchased" = %s AND "manufacturer_bar"."user_id" IS ' 'NULL)') |
/app/.heroku/python/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.sqlite3.base.DatabaseWrapper object at 0x7fb73de29da0>, 'cursor': <django.db.backends.utils.CursorDebugWrapper object at 0x7fb73c981b38>} |
executor | <bound method CursorWrapper._execute of <django.db.backends.utils.CursorDebugWrapper object at 0x7fb73c981b38>> |
many | False |
params | (False,) |
self | <django.db.backends.utils.CursorDebugWrapper object at 0x7fb73c981b38> |
sql | ('SELECT "manufacturer_bar"."id", "manufacturer_bar"."user_id", ' '"manufacturer_bar"."purchased", "manufacturer_bar"."created_date", ' '"manufacturer_bar"."last_edit_date" FROM "manufacturer_bar" WHERE ' '("manufacturer_bar"."purchased" = %s AND "manufacturer_bar"."user_id" IS ' 'NULL)') |
/app/.heroku/python/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.sqlite3.base.DatabaseWrapper object at 0x7fb73de29da0>, 'cursor': <django.db.backends.utils.CursorDebugWrapper object at 0x7fb73c981b38>}) |
params | (False,) |
self | <django.db.backends.utils.CursorDebugWrapper object at 0x7fb73c981b38> |
sql | ('SELECT "manufacturer_bar"."id", "manufacturer_bar"."user_id", ' '"manufacturer_bar"."purchased", "manufacturer_bar"."created_date", ' '"manufacturer_bar"."last_edit_date" FROM "manufacturer_bar" WHERE ' '("manufacturer_bar"."purchased" = %s AND "manufacturer_bar"."user_id" IS ' 'NULL)') |
/app/.heroku/python/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 'sqlite3.OperationalError'> |
dj_exc_type | <class 'django.db.utils.OperationalError'> |
dj_exc_value | OperationalError('no such table: manufacturer_bar',) |
exc_type | <class 'sqlite3.OperationalError'> |
exc_value | OperationalError('no such table: manufacturer_bar',) |
self | <django.db.utils.DatabaseErrorWrapper object at 0x7fb73cb22208> |
traceback | <traceback object at 0x7fb73cd29ac8> |
/app/.heroku/python/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.sqlite3.base.DatabaseWrapper object at 0x7fb73de29da0>, 'cursor': <django.db.backends.utils.CursorDebugWrapper object at 0x7fb73c981b38>}) |
params | (False,) |
self | <django.db.backends.utils.CursorDebugWrapper object at 0x7fb73c981b38> |
sql | ('SELECT "manufacturer_bar"."id", "manufacturer_bar"."user_id", ' '"manufacturer_bar"."purchased", "manufacturer_bar"."created_date", ' '"manufacturer_bar"."last_edit_date" FROM "manufacturer_bar" WHERE ' '("manufacturer_bar"."purchased" = %s AND "manufacturer_bar"."user_id" IS ' 'NULL)') |
/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/sqlite3/base.py
in execute
This fixes it -- but note that if you want to use a literal "%s" in a query,
you'll need to use "%%s".
"""
def execute(self, query, params=None):
if params is None:
return Database.Cursor.execute(self, query)
query = self.convert_query(query)
return Database.Cursor.execute(self, query, params)…
def executemany(self, query, param_list):
query = self.convert_query(query)
return Database.Cursor.executemany(self, query, param_list)
def convert_query(self, query):
Variable | Value |
---|---|
params | (False,) |
query | ('SELECT "manufacturer_bar"."id", "manufacturer_bar"."user_id", ' '"manufacturer_bar"."purchased", "manufacturer_bar"."created_date", ' '"manufacturer_bar"."last_edit_date" FROM "manufacturer_bar" WHERE ' '("manufacturer_bar"."purchased" = ? AND "manufacturer_bar"."user_id" IS ' 'NULL)') |
self | <django.db.backends.sqlite3.base.SQLiteCursorWrapper object at 0x7fb73cb99af8> |
AnonymousUser
Variable | Value |
---|---|
next | '/store/urnex/urnex-rinza/' |
No POST data
No FILES data
No cookie data
Variable | Value |
---|---|
HTTP_ACCEPT | '*/*' |
HTTP_ACCEPT_ENCODING | 'gzip' |
HTTP_CDN_LOOP | 'cloudflare' |
HTTP_CF_CONNECTING_IP | '54.210.126.232' |
HTTP_CF_IPCOUNTRY | 'US' |
HTTP_CF_RAY | '86b7a274dd9487b0-IAD' |
HTTP_CF_VISITOR | '{"scheme":"http"}' |
HTTP_CONNECTION | 'close' |
HTTP_CONNECT_TIME | '0' |
HTTP_HOST | 'thecoffeeoutlets.com' |
HTTP_TOTAL_ROUTE_TIME | '0' |
HTTP_USER_AGENT | 'claudebot' |
HTTP_VIA | '1.1 vegur' |
HTTP_X_FORWARDED_FOR | '54.210.126.232, 162.158.79.136' |
HTTP_X_FORWARDED_PORT | '80' |
HTTP_X_FORWARDED_PROTO | 'http' |
HTTP_X_REQUEST_ID | '09bb3631-f016-4352-a665-e88cfadae123' |
HTTP_X_REQUEST_START | '1711629059355' |
PATH_INFO | '/accounts/login/' |
QUERY_STRING | 'next=/store/urnex/urnex-rinza/' |
RAW_URI | '/accounts/login/?next=/store/urnex/urnex-rinza/' |
REMOTE_ADDR | '10.1.1.48' |
REMOTE_PORT | '30827' |
REQUEST_METHOD | 'GET' |
SCRIPT_NAME | '' |
SERVER_NAME | '0.0.0.0' |
SERVER_PORT | '30864' |
SERVER_PROTOCOL | 'HTTP/1.1' |
SERVER_SOFTWARE | 'gunicorn/19.9.0' |
gunicorn.socket | <socket.socket fd=10, family=AddressFamily.AF_INET, type=SocketKind.SOCK_STREAM, proto=0, laddr=('172.19.22.46', 30864), raddr=('10.1.1.48', 30827)> |
wsgi.errors | <gunicorn.http.wsgi.WSGIErrorsWrapper object at 0x7fb73c981240> |
wsgi.file_wrapper | '' |
wsgi.input | <gunicorn.http.body.Body object at 0x7fb73c981400> |
wsgi.multiprocess | True |
wsgi.multithread | False |
wsgi.run_once | False |
wsgi.url_scheme | 'http' |
wsgi.version | (1, 0) |
thecoffeeoutlets.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' |
AWS_ACCESS_KEY_ID | '********************' |
AWS_HEADERS | {'Cache-Control': 'max-age=94608000', 'Expires': 'Thu, 31 Dec 2099 20:00:00 GMT'} |
AWS_QUERYSTRING_AUTH | False |
AWS_S3_CUSTOM_DOMAIN | 'thecoffeeoutlet.s3.amazonaws.com' |
AWS_SECRET_ACCESS_KEY | '********************' |
AWS_STORAGE_BUCKET_NAME | 'thecoffeeoutlet' |
BASE_DIR | '/app' |
CACHES | {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}} |
CACHE_MIDDLEWARE_ALIAS | 'default' |
CACHE_MIDDLEWARE_KEY_PREFIX | '********************' |
CACHE_MIDDLEWARE_SECONDS | 600 |
CKEDITOR_ALLOW_NONIMAGE_FILES | True |
CKEDITOR_CONFIGS | {'default': {'extraPlugins': 'uploadimage,div,autolink,autoembed,embedsemantic,autogrow,widget,lineutils,clipboard,dialog,dialogui,elementspath', 'skin': 'moono', 'tabSpaces': 4, 'toolbar': 'YourCustomToolbarConfig', 'toolbar_Basic': [['Source', '-', 'Bold', 'Italic']], 'toolbar_YourCustomToolbarConfig': [{'items': ['Source', '-', 'Save', 'NewPage', 'Preview', 'Print', '-', 'Templates'], 'name': 'document'}, {'items': ['Cut', 'Copy', 'Paste', 'PasteText', 'PasteFromWord', '-', 'Undo', 'Redo'], 'name': 'clipboard'}, {'items': ['Find', 'Replace', '-', 'SelectAll'], 'name': 'editing'}, {'items': ['Form', 'Checkbox', 'Radio', 'TextField', 'Textarea', 'Select', 'Button', 'ImageButton', 'HiddenField'], 'name': 'forms'}, '/', {'items': ['Bold', 'Italic', 'Underline', 'Strike', 'Subscript', 'Superscript', '-', 'RemoveFormat'], 'name': 'basicstyles'}, {'items': ['NumberedList', 'BulletedList', '-', 'Outdent', 'Indent', '-', 'Blockquote', 'CreateDiv', '-', 'JustifyLeft', 'JustifyCenter', 'JustifyRight', 'JustifyBlock', '-', 'BidiLtr', 'BidiRtl', 'Language'], 'name': 'paragraph'}, {'items': ['Link', 'Unlink', 'Anchor'], 'name': 'links'}, {'items': ['Image', 'Flash', 'Table', 'HorizontalRule', 'Smiley', 'SpecialChar', 'PageBreak', 'Iframe'], 'name': 'insert'}, '/', {'items': ['Styles', 'Format', 'Font', 'FontSize'], 'name': 'styles'}, {'items': ['TextColor', 'BGColor'], 'name': 'colors'}, {'items': ['Maximize', 'ShowBlocks'], 'name': 'tools'}, {'items': ['About'], 'name': 'about'}, '/', {'items': ['Preview', 'Maximize'], 'name': 'yourcustomtools'}]}} |
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 |
CURRENCIES | ('USD', 'EUR') |
DATABASES | {'default': {'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'CONN_MAX_AGE': 0, 'ENGINE': 'django.db.backends.sqlite3', 'HOST': '', 'NAME': '/app/db.sqlite3', 'OPTIONS': {}, 'PASSWORD': '********************', 'PORT': '', 'TEST': {'CHARSET': None, 'COLLATION': None, 'MIRROR': None, 'NAME': None}, 'TIME_ZONE': None, 'USER': ''}} |
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 | 'storages.backends.s3boto.S3BotoStorage' |
DEFAULT_FROM_EMAIL | 'webmaster@localhost' |
DEFAULT_INDEX_TABLESPACE | '' |
DEFAULT_TABLESPACE | '' |
DISALLOWED_USER_AGENTS | [] |
DJSTRIPE_WEBHOOK_SECRET | '********************' |
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', 'whitenoise.runserver_nostatic', 'django.contrib.staticfiles', 'django.contrib.humanize', 'djmoney', 'storages', 'djstripe', 'embed_video', 'ckeditor', 'base', 'manufacturer'] |
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 | 'en-us' |
LANGUAGE_COOKIE_AGE | None |
LANGUAGE_COOKIE_DOMAIN | None |
LANGUAGE_COOKIE_NAME | 'django_language' |
LANGUAGE_COOKIE_PATH | '/' |
LOCALE_PATHS | [] |
LOGGING | {'disable_existing_loggers': False, 'formatters': {'simple': {'format': '%(levelname)s %(message)s'}, 'verbose': {'datefmt': '%Y-%m-%d %H:%M:%S', 'format': '%(asctime)s [%(process)d] ' '[%(levelname)s] pathname=%(pathname)s ' 'lineno=%(lineno)s funcname=%(funcName)s ' '%(message)s'}}, 'handlers': {'console': {'class': 'logging.StreamHandler', 'formatter': 'verbose', 'level': 'DEBUG'}, 'null': {'class': 'logging.NullHandler', 'level': 'DEBUG'}}, 'loggers': {'testlogger': {'handlers': ['console'], 'level': 'INFO'}}, 'version': 1} |
LOGGING_CONFIG | 'logging.config.dictConfig' |
LOGIN_REDIRECT_URL | '/' |
LOGIN_URL | '/accounts/login/' |
LOGOUT_REDIRECT_URL | None |
MANAGERS | [] |
MEDIA_ROOT | '' |
MEDIA_URL | 'https://thecoffeeoutlet.s3.amazonaws.com/' |
MESSAGE_STORAGE | 'django.contrib.messages.storage.fallback.FallbackStorage' |
MIDDLEWARE | ('whitenoise.middleware.WhiteNoiseMiddleware', 'django.middleware.security.SecurityMiddleware', 'whitenoise.middleware.WhiteNoiseMiddleware', '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 |
PROJECT_ROOT | '/app/thecoffeeoutlets' |
ROOT_URLCONF | 'thecoffeeoutlets.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 | ('HTTP_X_FORWARDED_PROTO', 'https') |
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 | 'thecoffeeoutlets.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 | ['/app/thecoffeeoutlets/static'] |
STATICFILES_FINDERS | ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder'] |
STATICFILES_STORAGE | 'whitenoise.storage.CompressedManifestStaticFilesStorage' |
STATIC_ROOT | '/app/staticfiles' |
STATIC_URL | '/static/' |
STRIPE_LIVE_MODE | True |
STRIPE_LIVE_PUBLIC_KEY | '********************' |
STRIPE_LIVE_SECRET_KEY | '********************' |
STRIPE_TEST_PUBLIC_KEY | '********************' |
STRIPE_TEST_SECRET_KEY | '********************' |
TEMPLATES | [{'APP_DIRS': True, 'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': ['/app/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', 'base.menu_context.show_store_menu', 'base.menu_context.show_bar'], 'debug': True}}] |
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 | 'UTC' |
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 | 'thecoffeeoutlets.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.