there are two issues:
1) file locking. I assume you are using windows and running from
source. You need to install the Mark Hammond win32 extensions.
2) shell error "Cannot operate on a closed database.". This is a known
problem. Do not use the web based shell to interact with the database.
Use the normall shell
python web2py.py -S yourapp -N -M
On Aug 23, 9:18 am, dederocks <dediro...@gmail.com> wrote:
> Hello,
>
> I'm trying to run web2py, but as I go into 'the real stuff', problems
> start to arise.
> Just so you know, I'm running python 2.7 on a windows 7 OS, using the
> 1.83 source code.
>
> a) I get a warning that cron is disabled because there is no file
> locking. Starting the app with administrative rights doesn't change
> anything.
>
> b) I can't create a database:
>
> In[1]:
>
> db = DAL('sqlite://storage.db')
>
> Out[1]:
>
> In[2]:
>
> db.define_table('person',Field('name'))
>
> Out[2]:
>
> Traceback (most recent call last):
> File "<input>", line 1, in <module>
> File "C:\Users\Andre\Documents\web2py\gluon\sql.py", line 1359, in
> define_table
> t._create(migrate=migrate, fake_migrate=fake_migrate)
> File "C:\Users\Andre\Documents\web2py\gluon\sql.py", line 1800, in
> _create
> self._db._execute(query)
> File "C:\Users\Andre\Documents\web2py\gluon\sql.py", line 947, in
> <lambda>
> self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
> ProgrammingError: Cannot operate on a closed database.
>
> a) trying to experiment with the web2py shell, I found a surprising
> effect: the shell works if I call it from the 'welcome' application,
> but not from the 'examples' application. In the latter case, a ticket
> is raised, with sys.exit(1) highlighted:
>
> if import_models:
> try:
> run_models_in(environment)
> except RestrictedError, e:
> sys.stderr.write(e.traceback+'\n')
> sys.exit(1)
>
> return environment
>
> def exec_pythonrc():
>
> any suggestions?
>
> Thxs & BR,
>
> Andre
