(1146, "Table 'ebdb.reviews_nologinreview' doesn't exist")
Request Method: | GET |
---|---|
Request URL: | http://farms2face.com/reviews/Normal/ |
Django Version: | 1.10.5 |
Exception Type: | ProgrammingError |
Exception Value: | (1146, "Table 'ebdb.reviews_nologinreview' doesn't exist") |
Exception Location: | /opt/python/run/venv/local/lib64/python3.6/site-packages/MySQLdb/connections.py in query, line 292 |
Python Executable: | /opt/python/run/venv/bin/python3 |
Python Version: | 3.6.2 |
Python Path: | ['/opt/python/current/app', '/opt/python/current/app', '', '/opt/python/run/venv/local/lib64/python3.6/site-packages', '/opt/python/run/venv/local/lib/python3.6/site-packages', '/opt/python/run/venv/lib64/python3.6', '/opt/python/run/venv/lib/python3.6', '/opt/python/run/venv/lib64/python3.6/site-packages', '/opt/python/run/venv/lib/python3.6/site-packages', '/opt/python/run/venv/lib64/python3.6/lib-dynload', '/usr/lib64/python3.6', '/usr/lib/python3.6', '/home/ec2-user/farms2face/f2f/farms2face', '/home/ec2-user/f2f/lib/python3.6/site-packages', '/opt/python/current/app/farms2face'] |
Server time: | Mon, 18 Mar 2024 21:22:57 -0700 |
/opt/python/run/venv/local/lib/python3.6/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 | () |
self | <django.db.backends.utils.CursorDebugWrapper object at 0x7f10e65e1198> |
sql | ('SELECT `reviews_nologinreview`.`id`, `reviews_nologinreview`.`headline`, ' '`reviews_nologinreview`.`details`, `reviews_nologinreview`.`createdte` FROM ' '`reviews_nologinreview`') |
/opt/python/run/venv/local/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:
six.reraise(utils.IntegrityError, utils.IntegrityError(*tuple(e.args)), sys.exc_info()[2])
raise
Variable | Value |
---|---|
args | () |
query | ('SELECT `reviews_nologinreview`.`id`, `reviews_nologinreview`.`headline`, ' '`reviews_nologinreview`.`details`, `reviews_nologinreview`.`createdte` FROM ' '`reviews_nologinreview`') |
self | <django.db.backends.mysql.base.CursorWrapper object at 0x7f10e717eb70> |
/opt/python/run/venv/local/lib64/python3.6/site-packages/MySQLdb/cursors.py
in execute
query = query.encode(db.unicode_literal.charset, 'surrogateescape')
res = None
try:
res = self._query(query)
except Exception:
exc, value = sys.exc_info()[:2]
self.errorhandler(self, exc, value)...
self._executed = query
if not self._defer_warnings:
self._warning_check()
return res
def executemany(self, query, args):
Variable | Value |
---|---|
args | () |
db | <_mysql.connection open to 'aaoagq4nt66g1s.czng8esaei5z.us-west-1.rds.amazonaws.com' at 7f10d003d1b8> |
exc | <class '_mysql_exceptions.ProgrammingError'> |
query | (b'SELECT `reviews_nologinreview`.`id`, `reviews_nologinreview`.`headline`, `re' b'views_nologinreview`.`details`, `reviews_nologinreview`.`createdte` FROM `re' b'views_nologinreview`') |
res | None |
self | <MySQLdb.cursors.Cursor object at 0x7f10e676e748> |
value | ProgrammingError(1146, "Table 'ebdb.reviews_nologinreview' doesn't exist") |
/opt/python/run/venv/local/lib64/python3.6/site-packages/MySQLdb/connections.py
in defaulterrorhandler
if cursor:
cursor.messages.append(error)
else:
connection.messages.append(error)
del cursor
del connection
if isinstance(errorvalue, BaseException):
raise errorvalue...
if errorclass is not None:
raise errorclass(errorvalue)
else:
raise Exception(errorvalue)
Variable | Value |
---|---|
error | (<class '_mysql_exceptions.ProgrammingError'>, ProgrammingError(1146, "Table 'ebdb.reviews_nologinreview' doesn't exist")) |
errorclass | <class '_mysql_exceptions.ProgrammingError'> |
errorvalue | ProgrammingError(1146, "Table 'ebdb.reviews_nologinreview' doesn't exist") |
/opt/python/run/venv/local/lib64/python3.6/site-packages/MySQLdb/cursors.py
in execute
self.errorhandler(self, ProgrammingError, str(m))
if isinstance(query, unicode):
query = query.encode(db.unicode_literal.charset, 'surrogateescape')
res = None
try:
res = self._query(query)...
except Exception:
exc, value = sys.exc_info()[:2]
self.errorhandler(self, exc, value)
self._executed = query
if not self._defer_warnings:
self._warning_check()
Variable | Value |
---|---|
args | () |
db | <_mysql.connection open to 'aaoagq4nt66g1s.czng8esaei5z.us-west-1.rds.amazonaws.com' at 7f10d003d1b8> |
exc | <class '_mysql_exceptions.ProgrammingError'> |
query | (b'SELECT `reviews_nologinreview`.`id`, `reviews_nologinreview`.`headline`, `re' b'views_nologinreview`.`details`, `reviews_nologinreview`.`createdte` FROM `re' b'views_nologinreview`') |
res | None |
self | <MySQLdb.cursors.Cursor object at 0x7f10e676e748> |
value | ProgrammingError(1146, "Table 'ebdb.reviews_nologinreview' doesn't exist") |
/opt/python/run/venv/local/lib64/python3.6/site-packages/MySQLdb/cursors.py
in _query
result set can be very large, consider adding a LIMIT clause to your
query, or using CursorUseResultMixIn instead."""
def _get_result(self):
return self._get_db().store_result()
def _query(self, q):
rowcount = self._do_query(q)...
self._post_get_result()
return rowcount
def _post_get_result(self):
self._rows = self._fetch_row(0)
self._result = None
Variable | Value |
---|---|
q | (b'SELECT `reviews_nologinreview`.`id`, `reviews_nologinreview`.`headline`, `re' b'views_nologinreview`.`details`, `reviews_nologinreview`.`createdte` FROM `re' b'views_nologinreview`') |
self | <MySQLdb.cursors.Cursor object at 0x7f10e676e748> |
/opt/python/run/venv/local/lib64/python3.6/site-packages/MySQLdb/cursors.py
in _do_query
if not self._defer_warnings:
self._warning_check()
return args
def _do_query(self, q):
db = self._get_db()
self._last_executed = q
db.query(q)...
self._do_get_result()
return self.rowcount
def _query(self, q):
return self._do_query(q)
Variable | Value |
---|---|
db | <_mysql.connection open to 'aaoagq4nt66g1s.czng8esaei5z.us-west-1.rds.amazonaws.com' at 7f10d003d1b8> |
q | (b'SELECT `reviews_nologinreview`.`id`, `reviews_nologinreview`.`headline`, `re' b'views_nologinreview`.`details`, `reviews_nologinreview`.`createdte` FROM `re' b'views_nologinreview`') |
self | <MySQLdb.cursors.Cursor object at 0x7f10e676e748> |
/opt/python/run/venv/local/lib64/python3.6/site-packages/MySQLdb/connections.py
in query
if isinstance(query, bytearray):
query = bytes(query)
if self.waiter is not None:
self.send_query(query)
self.waiter(self.fileno())
self.read_query_result()
else:
_mysql.connection.query(self, query)...
def __enter__(self):
from warnings import warn
warn("context interface will be changed. Use explicit conn.commit() or conn.rollback().",
DeprecationWarning, 2)
if self.get_autocommit():
Variable | Value |
---|---|
query | (b'SELECT `reviews_nologinreview`.`id`, `reviews_nologinreview`.`headline`, `re' b'views_nologinreview`.`details`, `reviews_nologinreview`.`createdte` FROM `re' b'views_nologinreview`') |
self | <_mysql.connection open to 'aaoagq4nt66g1s.czng8esaei5z.us-west-1.rds.amazonaws.com' at 7f10d003d1b8> |
/opt/python/run/venv/local/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, 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 'ebdb.reviews_nologinreview' doesn't exist") |
get_response | <bound method BaseHandler._get_response of <django.core.handlers.wsgi.WSGIHandler object at 0x7f10f980c5c0>> |
request | <WSGIRequest: GET '/reviews/Normal/'> |
/opt/python/run/venv/local/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 review_page at 0x7f10e782de18> |
callback_args | () |
callback_kwargs | {'skin_type': 'Normal'} |
middleware_method | <bound method CsrfViewMiddleware.process_view of <django.middleware.csrf.CsrfViewMiddleware object at 0x7f10ea3dce48>> |
request | <WSGIRequest: GET '/reviews/Normal/'> |
resolver | <RegexURLResolver 'farms2face.urls' (None:None) ^/> |
resolver_match | ResolverMatch(func=reviews.views.review_page, args=(), kwargs={'skin_type': 'Normal'}, url_name=None, app_names=[], namespaces=[]) |
response | None |
self | <django.core.handlers.wsgi.WSGIHandler object at 0x7f10f980c5c0> |
wrapped_callback | <function review_page at 0x7f10e782de18> |
/opt/python/run/venv/local/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 review_page at 0x7f10e782de18> |
callback_args | () |
callback_kwargs | {'skin_type': 'Normal'} |
middleware_method | <bound method CsrfViewMiddleware.process_view of <django.middleware.csrf.CsrfViewMiddleware object at 0x7f10ea3dce48>> |
request | <WSGIRequest: GET '/reviews/Normal/'> |
resolver | <RegexURLResolver 'farms2face.urls' (None:None) ^/> |
resolver_match | ResolverMatch(func=reviews.views.review_page, args=(), kwargs={'skin_type': 'Normal'}, url_name=None, app_names=[], namespaces=[]) |
response | None |
self | <django.core.handlers.wsgi.WSGIHandler object at 0x7f10f980c5c0> |
wrapped_callback | <function review_page at 0x7f10e782de18> |
/opt/python/current/app/reviews/views.py
in review_page
for c in qe.wizard.customfacepack_set.all():
review_set = c.facepack.review_set
if review_set.count() > 0:
return redirect('/reviews/%s' % skin)
return redirect('/reviews/Normal')
data.update({'no_login_reviews':[{'headline':i.headline,
'details':i.details
} for i in NologinReview.objects.all()]} )...
print(data)
return render(request, "review_page.html", data)
def vote(request):
json_response = { 'success': False }
if request.method == 'POST':
Variable | Value |
---|---|
c | <CustomFacePack: CFP_029033034000006005 White Kaolin Clay_Normal Honey_Normal> |
cmd_str | "Q(question__id=7, option__name='Normal')" |
data | {'cart_size': 0, 'count': 0, 'rating_avg_empty': range(0, 5), 'rating_avg_full': range(0, 0), 'rating_avg_half': 0.0, 'rating_avg_half_dec': '0', 'reviews': [], 'skin_type': 'Normal', 'type': <class 'type'>, 'valid_user': None} |
qe | <QuestionnaireEntry: 354 What is your Skin Type? Normal> |
rating_avg | 0 |
rating_avg_empty | 5 |
rating_avg_full | 0 |
rating_avg_half | 0.0 |
request | <WSGIRequest: GET '/reviews/Normal/'> |
review_count | 0 |
review_ids | [] |
review_set | <django.db.models.fields.related_descriptors.create_reverse_many_to_one_manager.<locals>.RelatedManager object at 0x7f10e63debe0> |
reviews | [] |
skin | 'Normal' |
skin_type | 'Normal' |
/opt/python/run/venv/local/lib/python3.6/site-packages/django/db/models/query.py
in __iter__
2. sql/compiler.results_iter()
- Returns one row at time. At this point the rows are still just
tuples. In some cases the return values are converted to
Python values at this location.
3. self.iterator()
- Responsible for turning the rows into model objects.
"""
self._fetch_all()...
return iter(self._result_cache)
def __bool__(self):
self._fetch_all()
return bool(self._result_cache)
Variable | Value |
---|---|
self | Error in formatting: ProgrammingError: (1146, "Table 'ebdb.reviews_nologinreview' doesn't exist") |
/opt/python/run/venv/local/lib/python3.6/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.iterator())...
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 'ebdb.reviews_nologinreview' doesn't exist") |
/opt/python/run/venv/local/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()...
select, klass_info, annotation_col_map = (compiler.select, compiler.klass_info,
compiler.annotation_col_map)
if klass_info is None:
return
model_cls = klass_info['model']
select_fields = klass_info['select_fields']
Variable | Value |
---|---|
compiler | <django.db.backends.mysql.compiler.SQLCompiler object at 0x7f10e685b6d8> |
db | 'default' |
queryset | Error in formatting: ProgrammingError: (1146, "Table 'ebdb.reviews_nologinreview' doesn't exist") |
self | <django.db.models.query.ModelIterable object at 0x7f10e685b9b0> |
/opt/python/run/venv/local/lib/python3.6/site-packages/django/db/models/sql/compiler.py
in execute_sql
if result_type == MULTI:
return iter([])
else:
return
cursor = self.connection.cursor()
try:
cursor.execute(sql, params)...
except Exception:
cursor.close()
raise
if result_type == CURSOR:
# Caller didn't specify a result_type, so just give them back the
Variable | Value |
---|---|
cursor | <django.db.backends.utils.CursorDebugWrapper object at 0x7f10e65e1198> |
params | () |
result_type | 'multi' |
self | <django.db.backends.mysql.compiler.SQLCompiler object at 0x7f10e685b6d8> |
sql | ('SELECT `reviews_nologinreview`.`id`, `reviews_nologinreview`.`headline`, ' '`reviews_nologinreview`.`details`, `reviews_nologinreview`.`createdte` FROM ' '`reviews_nologinreview`') |
/opt/python/run/venv/local/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(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.001299142837524414 |
params | () |
self | <django.db.backends.utils.CursorDebugWrapper object at 0x7f10e65e1198> |
sql | ('SELECT `reviews_nologinreview`.`id`, `reviews_nologinreview`.`headline`, ' '`reviews_nologinreview`.`details`, `reviews_nologinreview`.`createdte` FROM ' '`reviews_nologinreview`') |
start | 1710822177.2410717 |
stop | 1710822177.2423708 |
/opt/python/run/venv/local/lib/python3.6/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 | () |
self | <django.db.backends.utils.CursorDebugWrapper object at 0x7f10e65e1198> |
sql | ('SELECT `reviews_nologinreview`.`id`, `reviews_nologinreview`.`headline`, ' '`reviews_nologinreview`.`details`, `reviews_nologinreview`.`createdte` FROM ' '`reviews_nologinreview`') |
/opt/python/run/venv/local/lib/python3.6/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 '_mysql_exceptions.ProgrammingError'> |
dj_exc_type | <class 'django.db.utils.ProgrammingError'> |
dj_exc_value | ProgrammingError(1146, "Table 'ebdb.reviews_nologinreview' doesn't exist") |
exc_type | <class '_mysql_exceptions.ProgrammingError'> |
exc_value | ProgrammingError(1146, "Table 'ebdb.reviews_nologinreview' doesn't exist") |
self | <django.db.utils.DatabaseErrorWrapper object at 0x7f10e680bd68> |
traceback | <traceback object at 0x7f10e65a4e08> |
/opt/python/run/venv/local/lib/python3.6/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 0x7f10e65a4e08> |
tp | <class 'django.db.utils.ProgrammingError'> |
value | ProgrammingError(1146, "Table 'ebdb.reviews_nologinreview' doesn't exist") |
/opt/python/run/venv/local/lib/python3.6/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 | () |
self | <django.db.backends.utils.CursorDebugWrapper object at 0x7f10e65e1198> |
sql | ('SELECT `reviews_nologinreview`.`id`, `reviews_nologinreview`.`headline`, ' '`reviews_nologinreview`.`details`, `reviews_nologinreview`.`createdte` FROM ' '`reviews_nologinreview`') |
/opt/python/run/venv/local/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:
six.reraise(utils.IntegrityError, utils.IntegrityError(*tuple(e.args)), sys.exc_info()[2])
raise
Variable | Value |
---|---|
args | () |
query | ('SELECT `reviews_nologinreview`.`id`, `reviews_nologinreview`.`headline`, ' '`reviews_nologinreview`.`details`, `reviews_nologinreview`.`createdte` FROM ' '`reviews_nologinreview`') |
self | <django.db.backends.mysql.base.CursorWrapper object at 0x7f10e717eb70> |
/opt/python/run/venv/local/lib64/python3.6/site-packages/MySQLdb/cursors.py
in execute
query = query.encode(db.unicode_literal.charset, 'surrogateescape')
res = None
try:
res = self._query(query)
except Exception:
exc, value = sys.exc_info()[:2]
self.errorhandler(self, exc, value)...
self._executed = query
if not self._defer_warnings:
self._warning_check()
return res
def executemany(self, query, args):
Variable | Value |
---|---|
args | () |
db | <_mysql.connection open to 'aaoagq4nt66g1s.czng8esaei5z.us-west-1.rds.amazonaws.com' at 7f10d003d1b8> |
exc | <class '_mysql_exceptions.ProgrammingError'> |
query | (b'SELECT `reviews_nologinreview`.`id`, `reviews_nologinreview`.`headline`, `re' b'views_nologinreview`.`details`, `reviews_nologinreview`.`createdte` FROM `re' b'views_nologinreview`') |
res | None |
self | <MySQLdb.cursors.Cursor object at 0x7f10e676e748> |
value | ProgrammingError(1146, "Table 'ebdb.reviews_nologinreview' doesn't exist") |
/opt/python/run/venv/local/lib64/python3.6/site-packages/MySQLdb/connections.py
in defaulterrorhandler
if cursor:
cursor.messages.append(error)
else:
connection.messages.append(error)
del cursor
del connection
if isinstance(errorvalue, BaseException):
raise errorvalue...
if errorclass is not None:
raise errorclass(errorvalue)
else:
raise Exception(errorvalue)
Variable | Value |
---|---|
error | (<class '_mysql_exceptions.ProgrammingError'>, ProgrammingError(1146, "Table 'ebdb.reviews_nologinreview' doesn't exist")) |
errorclass | <class '_mysql_exceptions.ProgrammingError'> |
errorvalue | ProgrammingError(1146, "Table 'ebdb.reviews_nologinreview' doesn't exist") |
/opt/python/run/venv/local/lib64/python3.6/site-packages/MySQLdb/cursors.py
in execute
self.errorhandler(self, ProgrammingError, str(m))
if isinstance(query, unicode):
query = query.encode(db.unicode_literal.charset, 'surrogateescape')
res = None
try:
res = self._query(query)...
except Exception:
exc, value = sys.exc_info()[:2]
self.errorhandler(self, exc, value)
self._executed = query
if not self._defer_warnings:
self._warning_check()
Variable | Value |
---|---|
args | () |
db | <_mysql.connection open to 'aaoagq4nt66g1s.czng8esaei5z.us-west-1.rds.amazonaws.com' at 7f10d003d1b8> |
exc | <class '_mysql_exceptions.ProgrammingError'> |
query | (b'SELECT `reviews_nologinreview`.`id`, `reviews_nologinreview`.`headline`, `re' b'views_nologinreview`.`details`, `reviews_nologinreview`.`createdte` FROM `re' b'views_nologinreview`') |
res | None |
self | <MySQLdb.cursors.Cursor object at 0x7f10e676e748> |
value | ProgrammingError(1146, "Table 'ebdb.reviews_nologinreview' doesn't exist") |
/opt/python/run/venv/local/lib64/python3.6/site-packages/MySQLdb/cursors.py
in _query
result set can be very large, consider adding a LIMIT clause to your
query, or using CursorUseResultMixIn instead."""
def _get_result(self):
return self._get_db().store_result()
def _query(self, q):
rowcount = self._do_query(q)...
self._post_get_result()
return rowcount
def _post_get_result(self):
self._rows = self._fetch_row(0)
self._result = None
Variable | Value |
---|---|
q | (b'SELECT `reviews_nologinreview`.`id`, `reviews_nologinreview`.`headline`, `re' b'views_nologinreview`.`details`, `reviews_nologinreview`.`createdte` FROM `re' b'views_nologinreview`') |
self | <MySQLdb.cursors.Cursor object at 0x7f10e676e748> |
/opt/python/run/venv/local/lib64/python3.6/site-packages/MySQLdb/cursors.py
in _do_query
if not self._defer_warnings:
self._warning_check()
return args
def _do_query(self, q):
db = self._get_db()
self._last_executed = q
db.query(q)...
self._do_get_result()
return self.rowcount
def _query(self, q):
return self._do_query(q)
Variable | Value |
---|---|
db | <_mysql.connection open to 'aaoagq4nt66g1s.czng8esaei5z.us-west-1.rds.amazonaws.com' at 7f10d003d1b8> |
q | (b'SELECT `reviews_nologinreview`.`id`, `reviews_nologinreview`.`headline`, `re' b'views_nologinreview`.`details`, `reviews_nologinreview`.`createdte` FROM `re' b'views_nologinreview`') |
self | <MySQLdb.cursors.Cursor object at 0x7f10e676e748> |
/opt/python/run/venv/local/lib64/python3.6/site-packages/MySQLdb/connections.py
in query
if isinstance(query, bytearray):
query = bytes(query)
if self.waiter is not None:
self.send_query(query)
self.waiter(self.fileno())
self.read_query_result()
else:
_mysql.connection.query(self, query)...
def __enter__(self):
from warnings import warn
warn("context interface will be changed. Use explicit conn.commit() or conn.rollback().",
DeprecationWarning, 2)
if self.get_autocommit():
Variable | Value |
---|---|
query | (b'SELECT `reviews_nologinreview`.`id`, `reviews_nologinreview`.`headline`, `re' b'views_nologinreview`.`details`, `reviews_nologinreview`.`createdte` FROM `re' b'views_nologinreview`') |
self | <_mysql.connection open to 'aaoagq4nt66g1s.czng8esaei5z.us-west-1.rds.amazonaws.com' at 7f10d003d1b8> |
AnonymousUser
No GET data
No POST data
No FILES data
No cookie data
Variable | Value |
---|---|
CONTEXT_DOCUMENT_ROOT | '/var/www/html' |
CONTEXT_PREFIX | '' |
DOCUMENT_ROOT | '/var/www/html' |
GATEWAY_INTERFACE | 'CGI/1.1' |
HTTP_ACCEPT | '*/*' |
HTTP_CONNECTION | 'keep-alive' |
HTTP_HOST | 'farms2face.com' |
HTTP_REFERER | 'http://farms2face.com/reviews/Normal' |
HTTP_USER_AGENT | 'claudebot' |
HTTP_X_FORWARDED_FOR | '34.204.181.19' |
HTTP_X_FORWARDED_PORT | '80' |
HTTP_X_FORWARDED_PROTO | 'http' |
PATH_INFO | '/reviews/Normal/' |
PATH_TRANSLATED | '/opt/python/current/app/farms2face/wsgi.py/reviews/Normal/' |
QUERY_STRING | '' |
REMOTE_ADDR | '172.31.27.198' |
REMOTE_PORT | '41808' |
REQUEST_METHOD | 'GET' |
REQUEST_SCHEME | 'http' |
REQUEST_URI | '/reviews/Normal/' |
SCRIPT_FILENAME | '/opt/python/current/app/farms2face/wsgi.py' |
SCRIPT_NAME | '' |
SERVER_ADDR | '172.31.23.169' |
SERVER_ADMIN | 'root@localhost' |
SERVER_NAME | 'farms2face.com' |
SERVER_PORT | '80' |
SERVER_PROTOCOL | 'HTTP/1.1' |
SERVER_SIGNATURE | '' |
SERVER_SOFTWARE | 'Apache/2.4.27 (Amazon) mod_wsgi/3.5 Python/3.6.2' |
mod_wsgi.application_group | 'ip-172-31-23-169.us-west-1.compute.internal|' |
mod_wsgi.callable_object | 'application' |
mod_wsgi.enable_sendfile | '0' |
mod_wsgi.handler_script | '' |
mod_wsgi.input_chunked | '0' |
mod_wsgi.listener_host | '' |
mod_wsgi.listener_port | '80' |
mod_wsgi.process_group | 'wsgi' |
mod_wsgi.queue_start | '1710822176241645' |
mod_wsgi.request_handler | 'wsgi-script' |
mod_wsgi.script_reloading | '1' |
mod_wsgi.version | (3, 5) |
wsgi.errors | <_io.TextIOWrapper encoding='utf-8'> |
wsgi.file_wrapper | '' |
wsgi.input | <mod_wsgi.Input object at 0x7f10e7ac59f0> |
wsgi.multiprocess | True |
wsgi.multithread | True |
wsgi.run_once | False |
wsgi.url_scheme | 'http' |
wsgi.version | (1, 0) |
farms2face.settings
Setting | Value |
---|---|
ABSOLUTE_URL_OVERRIDES | {} |
ADMINS | [] |
ALLOWED_HOSTS | ['127.0.0.1', '*', 'www.farms2face.com', 'farms2face.com', 'farms2face-env.us-west-1.elasticbeanstalk.com', 'farms2face-test-1.us-west-1.elasticbeanstalk.com', 'pooja.com', 'hemant.com', 'localhost'] |
APPEND_SLASH | True |
AUTHENTICATION_BACKENDS | ('userregistration.backends.FacebookOauth2Custom', 'django.contrib.auth.backends.ModelBackend') |
AUTH_PASSWORD_VALIDATORS | '********************' |
AUTH_USER_MODEL | 'auth.User' |
BASE_DIR | '/opt/python/current/app' |
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_SECURE | False |
CSRF_FAILURE_VIEW | 'django.views.csrf.csrf_failure' |
CSRF_HEADER_NAME | 'HTTP_X_CSRFTOKEN' |
CSRF_TRUSTED_ORIGINS | [] |
DATABASES | {'default': {'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'CONN_MAX_AGE': 0, 'ENGINE': 'django.db.backends.mysql', 'HOST': 'aaoagq4nt66g1s.czng8esaei5z.us-west-1.rds.amazonaws.com', 'NAME': 'ebdb', 'OPTIONS': {}, 'PASSWORD': '********************', 'PORT': '3306', 'TEST': {'CHARSET': None, 'COLLATION': None, 'MIRROR': None, 'NAME': None}, 'TIME_ZONE': None, 'USER': 'farms2face'}} |
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 | 'no-reply@farms2face.com' |
DEFAULT_INDEX_TABLESPACE | '' |
DEFAULT_TABLESPACE | '' |
DISALLOWED_USER_AGENTS | [] |
EMAIL_BACKEND | 'django.core.mail.backends.smtp.EmailBackend' |
EMAIL_HOST | '127.0.0.1' |
EMAIL_HOST_PASSWORD | '********************' |
EMAIL_HOST_USER | 'no-reply@farms2face.com' |
EMAIL_PORT | 25 |
EMAIL_SSL_CERTFILE | None |
EMAIL_SSL_KEYFILE | '********************' |
EMAIL_SUBJECT_PREFIX | '[Django] ' |
EMAIL_TIMEOUT | None |
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 |
GOOGLE_ANALYTICS | {'google_analytics_id': 'UA-131347941-2'} |
IGNORABLE_404_URLS | [] |
INSTALLED_APPS | ['social.apps.django_app.default', 'home.apps.HomeConfig', 'payments.apps.PaymentsConfig', 'facepackwizard.apps.FacepackwizardConfig', 'prepacks.apps.PrepacksConfig', 'subscriptions.apps.SubscriptionsConfig', 'userlogs.apps.UserlogsConfig', 'userregistration.apps.UserregistrationConfig', 'myaccount.apps.MyaccountConfig', 'cart.apps.CartConfig', 'story.apps.StoryConfig', 'reviews.apps.ReviewsConfig', 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'django_extensions', 'sslserver', 'google_analytics', 'django_simple_coupons'] |
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 | 'en-us' |
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 | '/opt/python/current/app/files' |
MEDIA_URL | '/images/' |
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 | 'farms2face.urls' |
SECRET_KEY | '********************' |
SECURE_BROWSER_XSS_FILTER | False |
SECURE_CONTENT_TYPE_NOSNIFF | False |
SECURE_HSTS_INCLUDE_SUBDOMAINS | 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 | 600 |
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.file' |
SESSION_EXPIRE_AT_BROWSER_CLOSE | False |
SESSION_FILE_PATH | None |
SESSION_SAVE_EVERY_REQUEST | True |
SESSION_SERIALIZER | 'django.contrib.sessions.serializers.JSONSerializer' |
SETTINGS_MODULE | 'farms2face.settings' |
SHORT_DATETIME_FORMAT | 'm/d/Y P' |
SHORT_DATE_FORMAT | 'm/d/Y' |
SIGNING_BACKEND | 'django.core.signing.TimestampSigner' |
SILENCED_SYSTEM_CHECKS | [] |
SOCIAL_AUTH_FACEBOOK_API_VERSION | '********************' |
SOCIAL_AUTH_FACEBOOK_KEY | '********************' |
SOCIAL_AUTH_FACEBOOK_PROFILE_EXTRA_PARAMS | {'fields': 'id,name,email'} |
SOCIAL_AUTH_FACEBOOK_SCOPE | ['email'] |
SOCIAL_AUTH_FACEBOOK_SECRET | '********************' |
SOCIAL_AUTH_LOGIN_ERROR_URL | '/home/' |
SOCIAL_AUTH_LOGIN_REDIRECT_URL | '/home/' |
SOCIAL_AUTH_PIPELINE | ('social.pipeline.social_auth.social_details', 'social.pipeline.social_auth.social_uid', 'social.pipeline.social_auth.auth_allowed', 'home.views.social_user', 'social.pipeline.user.get_username', 'social_core.pipeline.social_auth.associate_by_email', 'social.pipeline.user.create_user', 'social.pipeline.social_auth.associate_user', 'social.pipeline.social_auth.load_extra_data', 'social.pipeline.user.user_details', 'home.views.rename_social_anon_user', 'home.views.save_profile_picture', 'home.views.redirect_next') |
SOCIAL_AUTH_REDIRECT_IS_HTTPS | True |
SOCIAL_AUTH_USERNAME_IS_FULL_EMAIL | True |
SOCIAL_AUTH_USER_FIELDS | ['email', 'username'] |
STATICFILES_DIRS | [] |
STATICFILES_FINDERS | ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder'] |
STATICFILES_STORAGE | 'django.contrib.staticfiles.storage.StaticFilesStorage' |
STATIC_ROOT | '/opt/python/current/app/static' |
STATIC_URL | '/static/' |
STRIPE_API_KEY | '********************' |
TEMPLATES | [{'APP_DIRS': True, 'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': [], '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', 'social.apps.django_app.context_processors.backends', 'social.apps.django_app.context_processors.login_redirect']}}] |
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 | 'PST8PDT' |
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 | 'farms2face.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.