Hello all,
I'm developping over web2py source (1.99.7) using Eclipse, with Python (I 
used to use the version 2.7.2, but now because of my problem I use version 
2.5.4 but...).
When I think my application is worth it, I zip its folder and I give it to 
someone else in order to test it. This person uses a compiled Web2py server 
for Windows (current version too) which uses embarked Python (2.5.x ?) 
binaries.

The issue I have is that I always have problems with the "exported" 
database.
With my old use of version 2.7 I had problems with the "ON DELETE CASCADE" 
directive.
My current problem with version 2.5.4 is the following one (when I try to 
log in) (I did not tamper with the definitions of auth tables, which are 
defined with auth.define_tables() ):

Traceback (most recent call last):
  File "gluon/restricted.py", line 205, in restricted
  File 
"C:/Users/cedric/projets/LACT/devWeb2py/lact_web2py/applications/lact/controllers/default.py"
 <http://127.0.0.1:8000/admin/default/edit/lact/controllers/default.py>, line 
74, in <module>
  File "gluon/globals.py", line 173, in <lambda>
  File 
"C:/Users/cedric/projets/LACT/devWeb2py/lact_web2py/applications/lact/controllers/default.py"
 <http://127.0.0.1:8000/admin/default/edit/lact/controllers/default.py>, line 
33, in user
  File "gluon/tools.py", line 1161, in __call__
  File "gluon/tools.py", line 1729, in login
  File "gluon/dal.py", line 7578, in select
  File "gluon/dal.py", line 1315, in select
  File "gluon/dal.py", line 1305, in response
  File "gluon/dal.py", line 1392, in execute
  File "gluon/dal.py", line 1386, in log_execute
OperationalError: no such column: auth_user.registration_id



So my questions are (at least one answer to any one would please me) :
1) what is the correct way to export a web2py application from a 
development environment to a Windows "production" environment, without 
deleting the entire database ?
2) what is the correct source execution environment compatible with 
compiled version ?
Thank you a lot,

Cédric

Reply via email to