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

"no such table" #79

Closed
l1f opened this issue Aug 5, 2018 · 1 comment
Closed

"no such table" #79

l1f opened this issue Aug 5, 2018 · 1 comment

Comments

@l1f
Copy link

l1f commented Aug 5, 2018

Unfortunately, I'm currently getting this error during installation and I'm not sure why.

python -m sydent.sydent

2018-08-05 23:33:35,619 - __main__ - 116 - INFO - Starting Sydent server
2018-08-05 23:33:35,619 - sydent.db.sqlitedb - 29 - INFO - Using DB file sydent.db
2018-08-05 23:33:35,620 - sydent.db.sqlitedb - 43 - INFO - Running schema files...
2018-08-05 23:33:35,621 - sydent.db.sqlitedb - 73 - INFO - Migrating schema from v0 to v1
Traceback (most recent call last):
  File "/usr/lib/python2.7/runpy.py", line 174, in _run_module_as_main
    "__main__", fname, loader, pkg_name)
  File "/usr/lib/python2.7/runpy.py", line 72, in _run_code
    exec code in run_globals
  File "/root/.sydent/lib/python2.7/site-packages/sydent/sydent.py", line 216, in <module>
    syd = Sydent()
  File "/root/.sydent/lib/python2.7/site-packages/sydent/sydent.py", line 123, in __init__
    self.db = SqliteDatabase(self).db
  File "/root/.sydent/local/lib/python2.7/site-packages/sydent/db/sqlitedb.py", line 40, in __init__
    self._upgradeSchema()
  File "/root/.sydent/local/lib/python2.7/site-packages/sydent/db/sqlitedb.py", line 76, in _upgradeSchema
    cur.execute("ALTER TABLE local_threepid_associations RENAME TO old_local_threepid_associations");
sqlite3.OperationalError: no such table: local_threepid_associations
@turt2live
Copy link
Member

This appears to be caused by the sql files not making it into the package. It's best to run python -m sydent.sydent in a checkout rather than via pip.

@l1f l1f closed this as completed Aug 21, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants