Skip to content

Instantly share code, notes, and snippets.

@mejariamol
Created April 21, 2017 04:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mejariamol/c3d6770a451853d1be96d1b471661de6 to your computer and use it in GitHub Desktop.
Save mejariamol/c3d6770a451853d1be96d1b471661de6 to your computer and use it in GitHub Desktop.
internal server error
Exception on / [GET]
Traceback (most recent call last):
File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1982, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1614, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python2.7/dist-packages/flask_restplus/api.py", line 557, in error_router
return original_handler(e)
File "/usr/local/lib/python2.7/dist-packages/flask_cors/extension.py", line 161, in wrapped_function
return cors_after_request(app.make_response(f(*args, **kwargs)))
File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1517, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1612, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1598, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/home/mejariamol/open-event-orga-server/app/views/home.py", line 49, in index
call_for_speakers_events = DataGetter.get_call_for_speakers_events()
File "/home/mejariamol/open-event-orga-server/app/helpers/data_getter.py", line 426, in get_call_for_speakers_events
return [event for event in events
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2855, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2878, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 945, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 263, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1053, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context
context)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1402, in _handle_dbapi_exception
exc_info
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context
context)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 470, in do_execute
cursor.execute(statement, parameters)
ProgrammingError: (psycopg2.ProgrammingError) column events.deleted_at does not exist
LINE 1: ..., events.ticket_include AS events_ticket_include, events.del...
^
[SQL: 'SELECT events.id AS events_id, events.identifier AS events_identifier, events.name AS events_name, events.event_url AS events_event_url, events.email AS events_email, events.logo AS events_logo, events.start_time AS events_start_time, events.end_time AS events_end_time, events.timezone AS events_timezone, events.latitude AS events_latitude, events.longitude AS events_longitude, events.location_name AS events_location_name, events.searchable_location_name AS events_searchable_location_name, events.description AS events_description, events.background_url AS events_background_url, events.thumbnail AS events_thumbnail, events.large AS events_large, events.icon AS events_icon, events.organizer_name AS events_organizer_name, events.show_map AS events_show_map, events.organizer_description AS events_organizer_description, events.has_session_speakers AS events_has_session_speakers, events.privacy AS events_privacy, events.state AS events_state, events.type AS events_type, events.topic AS events_topic, events.sub_topic AS events_sub_topic, events.ticket_url AS events_ticket_url, events.code_of_conduct AS events_code_of_conduct, events.schedule_published_on AS events_schedule_published_on, events.ticket_include AS events_ticket_include, events.deleted_at AS events_deleted_at, events.payment_country AS events_payment_country, events.payment_currency AS events_payment_currency, events.paypal_email AS events_paypal_email, events.tax_allow AS events_tax_allow, events.pay_by_paypal AS events_pay_by_paypal, events.pay_by_stripe AS events_pay_by_stripe, events.pay_by_cheque AS events_pay_by_cheque, events.pay_by_bank AS events_pay_by_bank, events.pay_onsite AS events_pay_onsite, events.cheque_details AS events_cheque_details, events.bank_details AS events_bank_details, events.onsite_details AS events_onsite_details, events.created_at AS events_created_at, events.discount_code_id AS events_discount_code_id \nFROM events \nWHERE events.state = %(state_1)s AND events.privacy != %(privacy_1)s AND events.end_time >= %(end_time_1)s AND events.deleted_at IS NULL'] [parameters: {'state_1': 'Published', 'end_time_1': datetime.datetime(2017, 4, 21, 9, 31, 20, 884675), 'privacy_1': 'private'}]
127.0.0.1 - - [21/Apr/2017 09:31:20] "GET / HTTP/1.1" 500 -
Error on request:
Traceback (most recent call last):
File "/usr/local/lib/python2.7/dist-packages/werkzeug/serving.py", line 209, in run_wsgi
execute(self.server.app)
File "/usr/local/lib/python2.7/dist-packages/werkzeug/serving.py", line 197, in execute
application_iter = app(environ, start_response)
File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1997, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python2.7/dist-packages/flask_socketio/__init__.py", line 37, in __call__
start_response)
File "/usr/local/lib/python2.7/dist-packages/engineio/middleware.py", line 49, in __call__
return self.wsgi_app(environ, start_response)
File "/home/mejariamol/open-event-orga-server/app/__init__.py", line 79, in __call__
return self.app(environ, start_response)
File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1985, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python2.7/dist-packages/flask_restplus/api.py", line 557, in error_router
return original_handler(e)
File "/usr/local/lib/python2.7/dist-packages/flask_cors/extension.py", line 161, in wrapped_function
return cors_after_request(app.make_response(f(*args, **kwargs)))
File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1547, in handle_exception
return self.finalize_request(handler(e), from_error_handler=True)
File "/home/mejariamol/open-event-orga-server/app/helpers/flask_ext/error_handlers.py", line 35, in server_error
return render_template('gentelella/errors/500.html'), 500
File "/usr/local/lib/python2.7/dist-packages/flask/templating.py", line 132, in render_template
ctx.app.update_template_context(context)
File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 764, in update_template_context
context.update(func())
File "/home/mejariamol/open-event-orga-server/app/helpers/flask_ext/jinja/variables.py", line 25, in template_context
settings=get_settings(),
File "/home/mejariamol/open-event-orga-server/app/settings/__init__.py", line 15, in get_settings
s = Setting.query.order_by(desc(Setting.id)).first()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2755, in first
ret = list(self[0:1])
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2547, in __getitem__
return list(res)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2855, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2878, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 945, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 263, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1053, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context
context)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1402, in _handle_dbapi_exception
exc_info
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context
context)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 470, in do_execute
cursor.execute(statement, parameters)
InternalError: (psycopg2.InternalError) current transaction is aborted, commands ignored until end of transaction block
[SQL: 'SELECT settings.id AS settings_id, settings.app_environment AS settings_app_environment, settings.app_name AS settings_app_name, settings.tagline AS settings_tagline, settings.secret AS settings_secret, settings.storage_place AS settings_storage_place, settings.aws_key AS settings_aws_key, settings.aws_secret AS settings_aws_secret, settings.aws_bucket_name AS settings_aws_bucket_name, settings.aws_region AS settings_aws_region, settings.gs_key AS settings_gs_key, settings.gs_secret AS settings_gs_secret, settings.gs_bucket_name AS settings_gs_bucket_name, settings.google_client_id AS settings_google_client_id, settings.google_client_secret AS settings_google_client_secret, settings.fb_client_id AS settings_fb_client_id, settings.fb_client_secret AS settings_fb_client_secret, settings.tw_consumer_key AS settings_tw_consumer_key, settings.tw_consumer_secret AS settings_tw_consumer_secret, settings.in_client_id AS settings_in_client_id, settings.in_client_secret AS settings_in_client_secret, settings.stripe_client_id AS settings_stripe_client_id, settings.stripe_secret_key AS settings_stripe_secret_key, settings.stripe_publishable_key AS settings_stripe_publishable_key, settings.paypal_mode AS settings_paypal_mode, settings.paypal_sandbox_username AS settings_paypal_sandbox_username, settings.paypal_sandbox_password AS settings_paypal_sandbox_password, settings.paypal_sandbox_signature AS settings_paypal_sandbox_signature, settings.paypal_live_username AS settings_paypal_live_username, settings.paypal_live_password AS settings_paypal_live_password, settings.paypal_live_signature AS settings_paypal_live_signature, settings.email_service AS settings_email_service, settings.email_from AS settings_email_from, settings.email_from_name AS settings_email_from_name, settings.sendgrid_key AS settings_sendgrid_key, settings.smtp_host AS settings_smtp_host, settings.smtp_username AS settings_smtp_username, settings.smtp_password AS settings_smtp_password, settings.smtp_port AS settings_smtp_port, settings.smtp_encryption AS settings_smtp_encryption, settings.analytics_key AS settings_analytics_key, settings.google_url AS settings_google_url, settings.github_url AS settings_github_url, settings.twitter_url AS settings_twitter_url, settings.support_url AS settings_support_url, settings.facebook_url AS settings_facebook_url, settings.youtube_url AS settings_youtube_url, settings.android_app_url AS settings_android_app_url, settings.web_app_url AS settings_web_app_url \nFROM settings ORDER BY settings.id DESC \n LIMIT %(param_1)s'] [parameters: {'param_1': 1}]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment