Re: [hyperkitty-devel] Problem with 'user' table

[Aurelien Bompard]

Oops, my mistake, this is a very recent piece of code and I didn't test it
with PostgreSQL yet.
I've just pushed a commit to fix that, thanks for reporting.

Aurélien


2014/1/14 alex <alex(a)slab.org&gt;

>  Hi all,
>
>  I'm just trying to install hyperkitty on a debian server.
>
>  I'm mostly following this:
>    https://fedorahosted.org/hyperkitty/wiki/DevelopmentSetupGuide
>
>  .. with the exception of using postgres rather than sqlite. Things
>  were going well until the following error.. It seems it is referring
>  to a table called "user", but this is a reserved word and should be
>  quoted. My django knowledge is extremely rusty, so not too sure about
>  how to fix this. Any ideas much appreciated!
>
>  (mailman)root@xxx:/usr/local/src/hyperkitty_standalone#
>  kittystore-updatedb -p /usr/local/src/hyperkitty_standalone -s
>  settings
>  Upgrading the database schema and populating the search index if
>  necessary...
>  Upgrading the schema...
>  Error running
>          CREATE TABLE "sender" (
>              email VARCHAR(255) NOT NULL,
>              name VARCHAR(255),
>              user_id VARCHAR(255),
>              PRIMARY KEY (email),
>              FOREIGN KEY (user_id) REFERENCES user(id)
>          );
>  Traceback (most recent call last):
>    File "/usr/local/mailman/bin/kittystore-updatedb", line 9, in <module>
>      load_entry_point('KittyStore==0.1.7', 'console_scripts',
>  'kittystore-updated
>  b')()
>    File "/usr/local/src/kittystore/kittystore/scripts.py", line 100, in
>  updatedb
>      store = create_store(settings, debug=opts.debug)
>    File "/usr/local/src/kittystore/kittystore/__init__.py", line 75, in
>  create_st
>  ore
>      create_storm_store(settings, debug)
>    File "/usr/local/src/kittystore/kittystore/storm/__init__.py", line 34,
>  in cre
>  ate_storm_store
>      dbschema.upgrade(store)
>    File
>  "/usr/local/mailman/local/lib/python2.7/site-packages/storm-0.20-py2.7-li
>  nux-x86_64.egg/storm/schema/schema.py", line 121, in upgrade
>      self.create(store)
>    File
>  "/usr/local/mailman/local/lib/python2.7/site-packages/storm-0.20-py2.7-li
>  nux-x86_64.egg/storm/schema/schema.py", line 93, in create
>      self._execute_statements(store, self._creates)
>    File
>  "/usr/local/mailman/local/lib/python2.7/site-packages/storm-0.20-py2.7-li
>  nux-x86_64.egg/storm/schema/schema.py", line 72, in _execute_statements
>      store.execute(statement)
>    File
>  "/usr/local/mailman/local/lib/python2.7/site-packages/storm-0.20-py2.7-li
>  nux-x86_64.egg/storm/store.py", line 108, in execute
>      return self._connection.execute(statement, params, noresult)
>    File
>  "/usr/local/mailman/local/lib/python2.7/site-packages/storm-0.20-py2.7-li
>  nux-x86_64.egg/storm/databases/postgres.py", line 266, in execute
>      return Connection.execute(self, statement, params, noresult)
>    File
>  "/usr/local/mailman/local/lib/python2.7/site-packages/storm-0.20-py2.7-li
>  nux-x86_64.egg/storm/database.py", line 241, in execute
>      raw_cursor = self.raw_execute(statement, params)
>    File
>  "/usr/local/mailman/local/lib/python2.7/site-packages/storm-0.20-py2.7-li
>  nux-x86_64.egg/storm/databases/postgres.py", line 276, in raw_execute
>      return Connection.raw_execute(self, statement, params)
>    File
>  "/usr/local/mailman/local/lib/python2.7/site-packages/storm-0.20-py2.7-li
>  nux-x86_64.egg/storm/database.py", line 374, in raw_execute
>      self._run_execution(raw_cursor, args, params, statement)
>    File
>  "/usr/local/mailman/local/lib/python2.7/site-packages/storm-0.20-py2.7-li
>  nux-x86_64.egg/storm/database.py", line 388, in _run_execution
>      self._check_disconnect(raw_cursor.execute, *args)
>    File
>  "/usr/local/mailman/local/lib/python2.7/site-packages/storm-0.20-py2.7-li
>  nux-x86_64.egg/storm/database.py", line 454, in _check_disconnect
>      return function(*args, **kwargs)
>  psycopg2.ProgrammingError: syntax error at or near "user"
>  LINE 7:             FOREIGN KEY (user_id) REFERENCES user(id)
>                                                       ^
>
>  Cheers
>
>  alex
>
>
>  --
>  http://yaxu.org/
>  _______________________________________________
>  hyperkitty-devel mailing list
>  hyperkitty-devel(a)lists.fedorahosted.org
>  https://lists.fedorahosted.org/mailman/listinfo/hyperkitty-devel
>