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@lists.fedorahosted.org
https://lists.fedorahosted.org/mailman/listinfo/hyperkitty-devel