It is possible that different python version use different sqlite formats. If you develop with 2.5 and pack and unpack to 2.7 the sqlite file will be readable. I do not know for sure about the opposite.
massimo On Thursday, 17 May 2012 16:40:07 UTC-5, Derek wrote: > > 1. Use "Pack All". It creates a W2P file that you can send. The production > site would use the "upload and install packed..." > > 2. I believe it's developed on 2.7.x - when it says it supports 2.5.x that > means it is backwards compatible to that version. No idea what the binary > version is - I prefer to use the source version, it's easier to update (as > you might have witnessed yourself). > > On Thursday, May 17, 2012 9:59:22 AM UTC-7, Cédric Mayer wrote: >> >> 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 >> >
