[web2py] Re: Deployment problem on dotcloud with PostgreSQL

2011-12-24 Thread Thomas Dall'Agnese
adding check_references=['user'] to the DAL() call does not solve the problem but raises a new ticket: 'user'VERSIONweb2py™(1, 99, 4, datetime.datetime(2011, 12, 14, 14, 46, 14), 'stable')PythonPython 2.6.5: /home/dotcloud/rsync-1324798764157/TRACEBACK 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 1

[web2py] Re: Deployment problem on dotcloud with PostgreSQL

2011-12-25 Thread Massimo Di Pierro
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 wrote: > Ticket report: > > syntax error at or near "user" LINE 4: > user INTEGER REFERENCES auth_user(id) ON DELETE CASCADE, ^VERSIONweb

[web2py] Re: Deployment problem on dotcloud with PostgreSQL

2011-12-25 Thread Thomas Dall'Agnese
Hi Massimo, That's what I thought, but I did not manually add any table called "user". - db.py defines tables *auth_user* - Edit db_wizard.py defines tables *balise*, *balise_archive*, * comment*, *comment_archive*, *episode*, *episode_archive*, *error_type*, *error_type_archiv

[web2py] Re: Deployment problem on dotcloud with PostgreSQL

2011-12-25 Thread Massimo Di Pierro
very strange... can you send me your app (confidently of course)? Massimo On Dec 25, 10:47 pm, Thomas Dall'Agnese wrote: > Hi Massimo, > > That's what I thought, but I did not manually add any table called "user". > >    -  db.py  defines tables *auth_user* >    -  Edit  db_wizard.py  defines ta

[web2py] Re: Deployment problem on dotcloud with PostgreSQL

2011-12-30 Thread Thomas Dall'Agnese
Sent to your DePaul e-mail address. I am looking forward to a solution to that problem as MySQL doesn't work neither on DotCloud (error creating a table, see other post).

[web2py] Re: Deployment problem on dotcloud with PostgreSQL

2012-01-02 Thread Jérôme Petazzoni
Hi Thomas, web2py used to work fine on dotCloud. I remember writing the web2py tutorial 1 year ago :-) The tutorial needs to be updated, since the CLI has evolved significantly since then. Anyway! If I remember well, when trying some web2py apps, I had the following issues: - a lot of apps defi

[web2py] Re: Deployment problem on dotcloud with PostgreSQL

2012-01-04 Thread Thomas Dall'Agnese
Hi Jérôme, Thanks for your advice. Is it possible to change the name 'user' used by web2py without changing the code in the 'gluon' folder?

[web2py] Re: Deployment problem on dotcloud with PostgreSQL

2012-01-04 Thread Massimo Di Pierro
web2py does not use "user". Some old apps may in models. On Jan 4, 6:37 am, Thomas Dall'Agnese wrote: > Hi Jérôme, > > Thanks for your advice. > Is it possible to change the name 'user'  used by web2py without changing > the code in the 'gluon' folder?