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