Hi Pierreth,
these tickets are not supposed to be machine readable and usually you
click on them and the web based IDE opens them nicely. In some rare
occasions like in your case the problem is not with the app but with
web2py itself and web2py may be unable to open the ticket.
Anyway the last part is a normal Python traceback escaped:
S'Traceback
... line 883, in <lambda>
self._pool_connection(lambda : sqlite3.Connection(dbpath,
NameError:global name \'sqlite3\' is not defined
as Yarko pointed out. We only need to look at this last line to see
the problem is.
Normally at startup, before you even open the browser, web2py lists
all the db drivers it found. sqlite should be there. You will find it
is not. If you installed it, it is possible you have different
versions of Python and you are not running web2py with the version of
Python that you used to install sqlite3. I suggest try to start web2py
by specifying explicitly a version of Python.
Massimo
On Dec 24, 5:09 pm, pierreth <pierre.thibau...@gmail.com> wrote:
> Sorry,
>
> I have these two tickets:
>
> (dp1
> S'output'
> p2
> S''
> sS'layer'
> p3
> S'/home/pierreth/T\xc3\xa9l\xc3\xa9chargement/web2py/applications/
> welcome/models/db.py'
> p4
> sS'code'
> p5
> S"# -*- coding: utf-8 -*- \n
> \n#########################################################################
> \n## This scaffolding model makes your app work on Google App Engine
> too
> \n#########################################################################
> \n\nif request.env.web2py_runtime_gae: # if running on
> Google App Engine\n db = DAL('gae') #
> connect to Google BigTable\n session.connect(request, response,
> db=db) # and store sessions and tickets there\n ### or use the
> following lines to store sessions in Memcache\n # from
> gluon.contrib.memdb import MEMDB\n # from
> google.appengine.api.memcache import Client\n # session.connect
> (request, response, db=MEMDB(Client())
> \nelse: # else use a normal
> relational database\n db = DAL('sqlite://storage.sqlite') #
> if not, use SQLite or other DB\n## if no need for session\n#
> session.forget()\n
> \n#########################################################################
> \n## Here is sample code if you need for \n## - email capabilities\n##
> - authentication (registration, login, logout, ... )\n## -
> authorization (role based authorization)\n## - services (xml, csv,
> json, xmlrpc, jsonrpc, amf, rss)\n## - crud actions\n## comment/
> uncomment as needed\n\nfrom gluon.tools import *\nauth=Auth(globals
> (),db) # authentication/authorization
> \nauth.settings.hmac_key='<your secret key>'\nauth.define_tables
> () # creates all needed tables\ncrud=Crud
> (globals(),db) # for CRUD helpers using auth
> \nservice=Service(globals()) # for json, xml,
> jsonrpc, xmlrpc, amfrpc\n\n#
> crud.settings.auth=auth # enforces authorization
> on crud\n# mail=Mail() # mailer\n#
> mail.settings.server='smtp.gmail.com:587' # your SMTP server\n#
> mail.settings.sender='....@gmail.com' # your email\n#
> mail.settings.login='username:password' # your credentials or None
> \n# auth.settings.mailer=mail # for user email
> verification\n# auth.settings.registration_requires_verification = True
> \n# auth.settings.registration_requires_approval = True\n#
> auth.messages.verify_email = \\\n# 'Click on the
> linkhttp://.../user/verify_email/%(key)sto verify your email'\n## more
> options discussed in gluon/tools.py
> \n#########################################################################
> \n
> \n#########################################################################
> \n## Define your tables below, for example\n##\n## >>> db.define_table
> ('mytable',Field('myfield','string'))\n##\n## Fields can be
> 'string','text','password','integer','double','boolean'\n##
> 'date','time','datetime','blob','upload', 'reference TABLENAME'\n##
> There is an implicit 'id integer autoincrement' field\n## Consult
> manual for more options, validators, etc.\n##\n## More API examples
> for controllers:\n##\n## >>> db.mytable.insert(myfield='value')\n##>>>
> rows=db(db.mytable.myfield=='value').select(db.mytable.ALL)\n##
> >>> for row in rows: print row.id, row.myfield
>
> \n#########################################################################
> \n"
> p6
> sS'traceback'
> p7
> S'Traceback (most recent call last):\n File "/home/pierreth/T\xc3\xa9l
> \xc3\xa9chargement/web2py/gluon/restricted.py", line 173, in restricted
> \n exec ccode in environment\n File "/home/pierreth/T\xc3\xa9l
> \xc3\xa9chargement/web2py/applications/welcome/models/db.py", line 15,
> in <module>\n db = DAL(\'sqlite://storage.sqlite\') # if not,
> use SQLite or other DB\n File "/home/pierreth/T\xc3\xa9l
> \xc3\xa9chargement/web2py/gluon/sql.py", line 3670, in DAL\n return
> SQLDB(uri, pool_size=pool_size, folder=folder, db_codec=db_codec)\n
> File "/home/pierreth/T\xc3\xa9l\xc3\xa9chargement/web2py/gluon/
> sql.py", line 883, in __init__\n self._pool_connection(lambda :
> sqlite3.Connection(dbpath,\n File "/home/pierreth/T\xc3\xa9l
> \xc3\xa9chargement/web2py/gluon/sql.py", line 823, in _pool_connection
> \n self._connection = f()\n File "/home/pierreth/T\xc3\xa9l
> \xc3\xa9chargement/web2py/gluon/sql.py", line 883, in <lambda>\n
> self._pool_connection(lambda : sqlite3.Connection(dbpath,\nNameError:
> global name \'sqlite3\' is not defined\n'
> p8
> s.
>
> and this one:
>
> (dp1
> S'output'
> p2
> S''
> sS'layer'
> p3
> S'/home/pierreth/T\xc3\xa9l\xc3\xa9chargement/web2py/applications/
> welcome/models/db.py'
> p4
> sS'code'
> p5
> S"# -*- coding: utf-8 -*- \n
> \n#########################################################################
> \n## This scaffolding model makes your app work on Google App Engine
> too
> \n#########################################################################
> \n\nif request.env.web2py_runtime_gae: # if running on
> Google App Engine\n db = DAL('gae') #
> connect to Google BigTable\n session.connect(request, response,
> db=db) # and store sessions and tickets there\n ### or use the
> following lines to store sessions in Memcache\n # from
> gluon.contrib.memdb import MEMDB\n # from
> google.appengine.api.memcache import Client\n # session.connect
> (request, response, db=MEMDB(Client())
> \nelse: # else use a normal
> relational database\n db = DAL('sqlite://storage.sqlite') #
> if not, use SQLite or other DB\n## if no need for session\n#
> session.forget()\n
> \n#########################################################################
> \n## Here is sample code if you need for \n## - email capabilities\n##
> - authentication (registration, login, logout, ... )\n## -
> authorization (role based authorization)\n## - services (xml, csv,
> json, xmlrpc, jsonrpc, amf, rss)\n## - crud actions\n## comment/
> uncomment as needed\n\nfrom gluon.tools import *\nauth=Auth(globals
> (),db) # authentication/authorization
> \nauth.settings.hmac_key='<your secret key>'\nauth.define_tables
> () # creates all needed tables\ncrud=Crud
> (globals(),db) # for CRUD helpers using auth
> \nservice=Service(globals()) # for json, xml,
> jsonrpc, xmlrpc, amfrpc\n\n#
> crud.settings.auth=auth # enforces authorization
> on crud\n# mail=Mail() # mailer\n#
> mail.settings.server='smtp.gmail.com:587' # your SMTP server\n#
> mail.settings.sender='....@gmail.com' # your email\n#
> mail.settings.login='username:password' # your credentials or None
> \n# auth.settings.mailer=mail # for user email
> verification\n# auth.settings.registration_requires_verification = True
> \n# auth.settings.registration_requires_approval = True\n#
> auth.messages.verify_email = \\\n# 'Click on the
> linkhttp://.../user/verify_email/%(key)sto verify your email'\n## more
> options discussed in gluon/tools.py
> \n#########################################################################
> \n
> \n#########################################################################
> \n## Define your tables below, for example\n##\n## >>> db.define_table
> ('mytable',Field('myfield','string'))\n##\n## Fields can be
> 'string','text','password','integer','double','boolean'\n##
> 'date','time','datetime','blob','upload', 'reference TABLENAME'\n##
> There is an implicit 'id integer autoincrement' field\n## Consult
> manual for more options, validators, etc.\n##\n## More API examples
> for controllers:\n##\n## >>> db.mytable.insert(myfield='value')\n##>>>
> rows=db(db.mytable.myfield=='value').select(db.mytable.ALL)\n##
> >>> for row in rows: print row.id, row.myfield
>
> \n#########################################################################
> \n"
> p6
> sS'traceback'
> p7
> S'Traceback (most recent call last):\n File "/home/pierreth/T\xc3\xa9l
> \xc3\xa9chargement/web2py/gluon/restricted.py", line 173, in restricted
> \n exec ccode in environment\n File "/home/pierreth/T\xc3\xa9l
> \xc3\xa9chargement/web2py/applications/welcome/models/db.py", line 15,
> in <module>\n db = DAL(\'sqlite://storage.sqlite\') # if not,
> use SQLite or other DB\n File "/home/pierreth/T\xc3\xa9l
> \xc3\xa9chargement/web2py/gluon/sql.py", line 3670, in DAL\n return
> SQLDB(uri, pool_size=pool_size, folder=folder, db_codec=db_codec)\n
> File "/home/pierreth/T\xc3\xa9l\xc3\xa9chargement/web2py/gluon/
> sql.py", line 883, in __init__\n self._pool_connection(lambda :
> sqlite3.Connection(dbpath,\n File "/home/pierreth/T\xc3\xa9l
> \xc3\xa9chargement/web2py/gluon/sql.py", line 823, in _pool_connection
> \n self._connection = f()\n File "/home/pierreth/T\xc3\xa9l
> \xc3\xa9chargement/web2py/gluon/sql.py", line 883, in <lambda>\n
> self._pool_connection(lambda : sqlite3.Connection(dbpath,\nNameError:
> global name \'sqlite3\' is not defined\n'
> p8
> s.
>
> It is very cryptic.
>
> On 24 déc, 08:55, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > Please check for the ticket in
>
> > web2py/applications/welcome/errors/<xxx>
>
> > This may also be a file permission issue.
>
>
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
