1.
Going to http://127.0.0.1:5000/roles/ results in:
sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) column roles.role_type does not exist LINE 1: ..._on_shifts, roles.company_id AS roles_company_id, roles.role...
[SQL: 'SELECT roles.id AS roles_id, roles.name AS roles_name, roles.works_on_shifts AS roles_works_on_shifts, roles.company_id AS roles_company_id, roles.role_type AS roles_role_type \nFROM roles'] (Background on this error at: http://sqlalche.me/e/f405)
roles.role_type doesn't exist in any migration
Going to http://127.0.0.1:5000/tables/ results in:
sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) column tables.created_on does not exist LINE 1: ...tables.synchronized_on AS tables_synchronized_on, tables.cre...
HINT: Perhaps you meant to reference the column "tables.created". [SQL: 'SELECT tables.poster_id AS tables_poster_id, tables.synchronized_on AS tables_synchronized_on, tables.created_on AS tables_created_on, tables.updated_on AS tables_updated_on, tables.id AS tables_id, tables.name AS tables_name, tables.floor_id AS tables_floor_id, tables.x AS tables_x, tables.y AS tables_y, tables.width AS tables_width, tables.height AS tables_height, tables.status AS tables_status, tables.max_capacity AS tables_max_capacity, tables.multiple AS tables_multiple, tables.playstation AS tables_playstation, tables.shape_id AS tables_shape_id, tables.min_capacity AS tables_min_capacity, tables.deposit_hour AS tables_deposit_hour \nFROM tables'] (Background on this error at: http://sqlalche.me/e/f405)
0crat
commented
5 years ago
Clean DB, with no changes.
1. Going to
http://127.0.0.1:5000/roles/results in:roles.role_type doesn't exist in any migration
Going to
http://127.0.0.1:5000/tables/results in:HINT: Perhaps you meant to reference the column "tables.created". [SQL: 'SELECT tables.poster_id AS tables_poster_id, tables.synchronized_on AS tables_synchronized_on, tables.created_on AS tables_created_on, tables.updated_on AS tables_updated_on, tables.id AS tables_id, tables.name AS tables_name, tables.floor_id AS tables_floor_id, tables.x AS tables_x, tables.y AS tables_y, tables.width AS tables_width, tables.height AS tables_height, tables.status AS tables_status, tables.max_capacity AS tables_max_capacity, tables.multiple AS tables_multiple, tables.playstation AS tables_playstation, tables.shape_id AS tables_shape_id, tables.min_capacity AS tables_min_capacity, tables.deposit_hour AS tables_deposit_hour \nFROM tables'] (Background on this error at: http://sqlalche.me/e/f405)