Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Bug on creating Room #161

Open
shayaniox opened this issue Nov 4, 2018 · 0 comments
Open

Bug on creating Room #161

shayaniox opened this issue Nov 4, 2018 · 0 comments
Labels
bug something isn't working

Comments

@shayaniox
Copy link
Contributor

When I try to create Room by creating Project, I get this error while I just sent a title as a form parameter :

Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
    context)
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 509, in do_execute
    cursor.execute(statement, parameters)
psycopg2.ProgrammingError: relation "member" does not exist
LINE 2: FROM member JOIN "user" ON member.id = "user".id


The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/nanohttp/application.py", line 96, in __call__
    self._hook('begin_request')
  File "/usr/local/lib/python3.6/site-packages/nanohttp/application.py", line 45, in _hook
    return getattr(self, name)(*args, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/restfulpy/application/__init__.py", line 99, in begin_request
    self.__authenticator__.authenticate_request()
  File "/usr/local/lib/python3.6/site-packages/restfulpy/authentication.py", line 162, in authenticate_request
    self.ok(self.verify_token(encoded_token))
  File "/usr/local/maestro/jaguar/jaguar/authentication.py", line 38, in verify_token
    .filter(User.reference_id == principal.reference_id) \
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2917, in one_or_none
    ret = list(self)
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2988, in __iter__
    return self._execute_and_instances(context)
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3011, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 948, in execute
    return meth(self, multiparams, params)
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
    context)
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
    exc_info
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 265, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 248, in reraise
    raise value.with_traceback(tb)
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
    context)
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 509, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) relation "member" does not exist
LINE 2: FROM member JOIN "user" ON member.id = "user".id
             ^
 [SQL: 'SELECT member.created_at AS member_created_at, member.modified_at AS member_modified_at, member.removed_at AS member_removed_at, member.activated_at AS member_activated_at, "user".id AS user_id, member.id AS member_id, member.reference_id AS member_reference_id, member.email AS member_email, member.title AS member_title, member.access_token AS member_access_token, member.type AS member_type, "user".add_to_room AS user_add_to_room, "user".username AS user_username, "user".phone AS user_phone, "user".show_email AS user_show_email, "user".show_phone AS user_show_phone \nFROM member JOIN "user" ON member.id = "user".id \nWHERE member.reference_id = %(reference_id_1)s'] [parameters: {'reference_id_1': 1}] (Background on this error at: http://sqlalche.me/e/f405)
NoneType: None

NOTE that I get this exception on the commit: ad66fad on branch Nightly.

@shayaniox shayaniox added the bug something isn't working label Nov 4, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant