Skip to content

Instantly share code, notes, and snippets.

@nickretallack
Created December 6, 2013 18:59
Show Gist options
  • Save nickretallack/7830268 to your computer and use it in GitHub Desktop.
Save nickretallack/7830268 to your computer and use it in GitHub Desktop.
Flask-Admin + Flask-Security = way too many queries to render a blank page.
2013-12-06 10:56:05,034 INFO sqlalchemy.engine.base.Engine BEGIN (implicit)
2013-12-06 10:56:05,035 INFO sqlalchemy.engine.base.Engine SELECT users.id AS users_id, users.email AS users_email, users.password AS users_password, users.active AS users_active, users.confirmed_at AS users_confirmed_at, users.last_login_at AS users_last_login_at, users.current_login_at AS users_current_login_at, users.last_login_ip AS users_last_login_ip, users.current_login_ip AS users_current_login_ip, users.login_count AS users_login_count, users.first_name AS users_first_name, users.last_name AS users_last_name
FROM users
WHERE users.id = %(id_1)s
LIMIT %(param_1)s
2013-12-06 10:56:05,035 INFO sqlalchemy.engine.base.Engine {'id_1': u'bada4c26-7571-4f96-9d46-5ae511eed682', 'param_1': 1}
2013-12-06 10:56:05,037 INFO sqlalchemy.engine.base.Engine SELECT roles.id AS roles_id, roles.name AS roles_name, roles.description AS roles_description
FROM roles, roles_users
WHERE %(param_1)s = roles_users.user_id AND roles.id = roles_users.role_id
2013-12-06 10:56:05,037 INFO sqlalchemy.engine.base.Engine {'param_1': 'bada4c26-7571-4f96-9d46-5ae511eed682'}
127.0.0.1 - - [06/Dec/2013 10:56:05] "GET /admin/ HTTP/1.1" 200 -
2013-12-06 10:56:05,059 INFO sqlalchemy.engine.base.Engine BEGIN (implicit)
2013-12-06 10:56:05,060 INFO sqlalchemy.engine.base.Engine SELECT users.id AS users_id, users.email AS users_email, users.password AS users_password, users.active AS users_active, users.confirmed_at AS users_confirmed_at, users.last_login_at AS users_last_login_at, users.current_login_at AS users_current_login_at, users.last_login_ip AS users_last_login_ip, users.current_login_ip AS users_current_login_ip, users.login_count AS users_login_count, users.first_name AS users_first_name, users.last_name AS users_last_name
FROM users
WHERE users.id = %(id_1)s
LIMIT %(param_1)s
2013-12-06 10:56:05,060 INFO sqlalchemy.engine.base.Engine {'id_1': u'bada4c26-7571-4f96-9d46-5ae511eed682', 'param_1': 1}
2013-12-06 10:56:05,063 INFO sqlalchemy.engine.base.Engine SELECT roles.id AS roles_id, roles.name AS roles_name, roles.description AS roles_description
FROM roles, roles_users
WHERE %(param_1)s = roles_users.user_id AND roles.id = roles_users.role_id
2013-12-06 10:56:05,063 INFO sqlalchemy.engine.base.Engine {'param_1': 'bada4c26-7571-4f96-9d46-5ae511eed682'}
127.0.0.1 - - [06/Dec/2013 10:56:05] "GET /admin/static/bootstrap/css/bootstrap.css HTTP/1.1" 304 -
2013-12-06 10:56:05,071 INFO sqlalchemy.engine.base.Engine BEGIN (implicit)
2013-12-06 10:56:05,072 INFO sqlalchemy.engine.base.Engine SELECT users.id AS users_id, users.email AS users_email, users.password AS users_password, users.active AS users_active, users.confirmed_at AS users_confirmed_at, users.last_login_at AS users_last_login_at, users.current_login_at AS users_current_login_at, users.last_login_ip AS users_last_login_ip, users.current_login_ip AS users_current_login_ip, users.login_count AS users_login_count, users.first_name AS users_first_name, users.last_name AS users_last_name
FROM users
WHERE users.id = %(id_1)s
LIMIT %(param_1)s
2013-12-06 10:56:05,073 INFO sqlalchemy.engine.base.Engine {'id_1': u'bada4c26-7571-4f96-9d46-5ae511eed682', 'param_1': 1}
2013-12-06 10:56:05,077 INFO sqlalchemy.engine.base.Engine SELECT roles.id AS roles_id, roles.name AS roles_name, roles.description AS roles_description
FROM roles, roles_users
WHERE %(param_1)s = roles_users.user_id AND roles.id = roles_users.role_id
2013-12-06 10:56:05,090 INFO sqlalchemy.engine.base.Engine {'param_1': 'bada4c26-7571-4f96-9d46-5ae511eed682'}
127.0.0.1 - - [06/Dec/2013 10:56:05] "GET /admin/static/bootstrap/css/bootstrap-responsive.css HTTP/1.1" 304 -
2013-12-06 10:56:05,097 INFO sqlalchemy.engine.base.Engine BEGIN (implicit)
2013-12-06 10:56:05,098 INFO sqlalchemy.engine.base.Engine SELECT users.id AS users_id, users.email AS users_email, users.password AS users_password, users.active AS users_active, users.confirmed_at AS users_confirmed_at, users.last_login_at AS users_last_login_at, users.current_login_at AS users_current_login_at, users.last_login_ip AS users_last_login_ip, users.current_login_ip AS users_current_login_ip, users.login_count AS users_login_count, users.first_name AS users_first_name, users.last_name AS users_last_name
FROM users
WHERE users.id = %(id_1)s
LIMIT %(param_1)s
2013-12-06 10:56:05,098 INFO sqlalchemy.engine.base.Engine {'id_1': u'bada4c26-7571-4f96-9d46-5ae511eed682', 'param_1': 1}
2013-12-06 10:56:05,101 INFO sqlalchemy.engine.base.Engine SELECT roles.id AS roles_id, roles.name AS roles_name, roles.description AS roles_description
FROM roles, roles_users
WHERE %(param_1)s = roles_users.user_id AND roles.id = roles_users.role_id
2013-12-06 10:56:05,101 INFO sqlalchemy.engine.base.Engine {'param_1': 'bada4c26-7571-4f96-9d46-5ae511eed682'}
127.0.0.1 - - [06/Dec/2013 10:56:05] "GET /admin/static/admin/css/admin.css HTTP/1.1" 304 -
2013-12-06 10:56:05,111 INFO sqlalchemy.engine.base.Engine BEGIN (implicit)
2013-12-06 10:56:05,112 INFO sqlalchemy.engine.base.Engine SELECT users.id AS users_id, users.email AS users_email, users.password AS users_password, users.active AS users_active, users.confirmed_at AS users_confirmed_at, users.last_login_at AS users_last_login_at, users.current_login_at AS users_current_login_at, users.last_login_ip AS users_last_login_ip, users.current_login_ip AS users_current_login_ip, users.login_count AS users_login_count, users.first_name AS users_first_name, users.last_name AS users_last_name
FROM users
WHERE users.id = %(id_1)s
LIMIT %(param_1)s
2013-12-06 10:56:05,112 INFO sqlalchemy.engine.base.Engine {'id_1': u'bada4c26-7571-4f96-9d46-5ae511eed682', 'param_1': 1}
2013-12-06 10:56:05,115 INFO sqlalchemy.engine.base.Engine SELECT roles.id AS roles_id, roles.name AS roles_name, roles.description AS roles_description
FROM roles, roles_users
WHERE %(param_1)s = roles_users.user_id AND roles.id = roles_users.role_id
2013-12-06 10:56:05,115 INFO sqlalchemy.engine.base.Engine {'param_1': 'bada4c26-7571-4f96-9d46-5ae511eed682'}
127.0.0.1 - - [06/Dec/2013 10:56:05] "GET /admin/static/vendor/jquery-1.8.3.min.js HTTP/1.1" 304 -
2013-12-06 10:56:05,125 INFO sqlalchemy.engine.base.Engine BEGIN (implicit)
2013-12-06 10:56:05,128 INFO sqlalchemy.engine.base.Engine SELECT users.id AS users_id, users.email AS users_email, users.password AS users_password, users.active AS users_active, users.confirmed_at AS users_confirmed_at, users.last_login_at AS users_last_login_at, users.current_login_at AS users_current_login_at, users.last_login_ip AS users_last_login_ip, users.current_login_ip AS users_current_login_ip, users.login_count AS users_login_count, users.first_name AS users_first_name, users.last_name AS users_last_name
FROM users
WHERE users.id = %(id_1)s
LIMIT %(param_1)s
2013-12-06 10:56:05,129 INFO sqlalchemy.engine.base.Engine {'id_1': u'bada4c26-7571-4f96-9d46-5ae511eed682', 'param_1': 1}
2013-12-06 10:56:05,132 INFO sqlalchemy.engine.base.Engine SELECT roles.id AS roles_id, roles.name AS roles_name, roles.description AS roles_description
FROM roles, roles_users
WHERE %(param_1)s = roles_users.user_id AND roles.id = roles_users.role_id
2013-12-06 10:56:05,132 INFO sqlalchemy.engine.base.Engine {'param_1': 'bada4c26-7571-4f96-9d46-5ae511eed682'}
127.0.0.1 - - [06/Dec/2013 10:56:05] "GET /admin/static/bootstrap/js/bootstrap.min.js HTTP/1.1" 304 -
2013-12-06 10:56:05,146 INFO sqlalchemy.engine.base.Engine BEGIN (implicit)
2013-12-06 10:56:05,147 INFO sqlalchemy.engine.base.Engine SELECT users.id AS users_id, users.email AS users_email, users.password AS users_password, users.active AS users_active, users.confirmed_at AS users_confirmed_at, users.last_login_at AS users_last_login_at, users.current_login_at AS users_current_login_at, users.last_login_ip AS users_last_login_ip, users.current_login_ip AS users_current_login_ip, users.login_count AS users_login_count, users.first_name AS users_first_name, users.last_name AS users_last_name
FROM users
WHERE users.id = %(id_1)s
LIMIT %(param_1)s
2013-12-06 10:56:05,147 INFO sqlalchemy.engine.base.Engine {'id_1': u'bada4c26-7571-4f96-9d46-5ae511eed682', 'param_1': 1}
2013-12-06 10:56:05,149 INFO sqlalchemy.engine.base.Engine SELECT roles.id AS roles_id, roles.name AS roles_name, roles.description AS roles_description
FROM roles, roles_users
WHERE %(param_1)s = roles_users.user_id AND roles.id = roles_users.role_id
2013-12-06 10:56:05,149 INFO sqlalchemy.engine.base.Engine {'param_1': 'bada4c26-7571-4f96-9d46-5ae511eed682'}
127.0.0.1 - - [06/Dec/2013 10:56:05] "GET /admin/static/select2/select2.min.js HTTP/1.1" 304 -
@threemonks
Copy link

Were you ever able to get this issue resolved?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment