[web2py] Re: Startup issues

2010-08-23 Thread mdipierro
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


[web2py] Re: Startup issues

2010-08-23 Thread dederocks
Sorry for coming with old hats (to be included in the book?), and
thanks for the quick help!

On 23 août, 18:20, mdipierro mdipie...@cs.depaul.edu wrote:
 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