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@slab.org
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