You have a table or a field called user. That is not allowed in postgresql because user is a reserved keyword.
Massimo On Dec 25, 1:32 am, Thomas Dall'Agnese <thomas.dallagn...@gmail.com> wrote: > Ticket report: > > <class 'psycopg2.ProgrammingError'> syntax error at or near "user" LINE 4: > user INTEGER REFERENCES auth_user(id) ON DELETE CASCADE, ^VERSIONweb2py™(1, > 99, 4, datetime.datetime(2011, 12, 14, 14, 46, 14), 'stable')PythonPython > 2.6.5: /home/dotcloud/rsync-1324797830040/TRACEBACK > > 1. > 2. > 3. > 4. > 5. > 6. > 7. > 8. > 9. > 10. > 11. > 12. > 13. > 14. > 15. > 16. > 17. > 18. > 19. > 20. > > Traceback (most recent call last): > File "/home/dotcloud/current/gluon/restricted.py", line 204, in restricted > exec ccode in environment > File > "/home/dotcloud/rsync-1324797830040/applications/myapp/models/db_wizard.py" > <http://fansubcheck-sp00ky.dotcloud.com/admin/default/edit/fansubcheck...>, > line 52, in <module> > migrate=settings.migrate) > File "/home/dotcloud/current/gluon/dal.py", line 5097, in define_table > polymodel=polymodel) > File "/home/dotcloud/current/gluon/dal.py", line 705, in create_table > self.create_sequence_and_triggers(query,table) > File "/home/dotcloud/current/gluon/dal.py", line 1861, in > create_sequence_and_triggers > self.execute(query) > File "/home/dotcloud/current/gluon/dal.py", line 1359, in execute > return self.log_execute(*a, **b) > File "/home/dotcloud/current/gluon/dal.py", line 1353, in log_execute > ret = self.cursor.execute(*a, **b) > ProgrammingError: syntax error at or near "user" > LINE 4: user INTEGER REFERENCES auth_user(id) ON DELETE CASCADE, > ^ > > ERROR SNAPSHOT [image: help] > > <class 'psycopg2.ProgrammingError'>(syntax error at or near "user" LINE 4: > user INTEGER REFERENCES auth_user(id) ON DELETE CASCADE, ^ )
