Hi
I have customized the Jobsite appliance. In the _ah/admin the
following tables are created:
web2py_session_init
web2py_tickets_init
The other tables defined in the model are not getting created.
On most of the pages, an Internal error is being generated. This is
one of the entries from web2py_tickets_init:
******************************************
(dp0
S'output'
p1
S''
p2
sS'layer'
p3
S'/home/sujith/Desktop/wcj/applications/init/controllers/default.py'
p4
sS'code'
p5
S'<code object <module> at 0xa8ddf50, file "/home/sujith/Desktop/wcj/
applications/init/controllers/default.py:viewcompany", line 8>'
p6
sS'snapshot'
p7
(dp8
S'exception'
p9
(dp10
S'__hash__'
p11
S"<method-wrapper '__hash__' of exceptions.IndexError object at
0xa988cac>"
p12
sS'__setattr__'
p13
S"<method-wrapper '__setattr__' of exceptions.IndexError object at
0xa988cac>"
p14
sS'__reduce_ex__'
p15
S'<built-in method __reduce_ex__ of exceptions.IndexError object at
0xa988cac>'
p16
sS'__getslice__'
p17
S"<method-wrapper '__getslice__' of exceptions.IndexError object at
0xa988cac>"
p18
sS'__getitem__'
p19
S"<method-wrapper '__getitem__' of exceptions.IndexError object at
0xa988cac>"
p20
sS'__setstate__'
p21
S'<built-in method __setstate__ of exceptions.IndexError object at
0xa988cac>'
p22
sS'__reduce__'
p23
S'<built-in method __reduce__ of exceptions.IndexError object at
0xa988cac>'
p24
sS'__str__'
p25
S"<method-wrapper '__str__' of exceptions.IndexError object at
0xa988cac>"
p26
sS'args'
p27
S"('list index out of range',)"
p28
sS'__getattribute__'
p29
S"<method-wrapper '__getattribute__' of exceptions.IndexError object
at 0xa988cac>"
p30
sS'__class__'
p31
S"<type 'exceptions.IndexError'>"
p32
sS'__delattr__'
p33
S"<method-wrapper '__delattr__' of exceptions.IndexError object at
0xa988cac>"
p34
sS'__repr__'
p35
S"<method-wrapper '__repr__' of exceptions.IndexError object at
0xa988cac>"
p36
sS'__dict__'
p37
S'{}'
p38
sS'__doc__'
p39
S"'Sequence index out of range.'"
p40
sS'__init__'
p41
S"<method-wrapper '__init__' of exceptions.IndexError object at
0xa988cac>"
p42
sS'__new__'
p43
S'<built-in method __new__ of type object at 0x8142e60>'
p44
ssS'evalue'
p45
S'list index out of range'
p46
sS'request'
p47
(dp48
S'function'
p49
S"'viewcompany'"
p50
sS'body'
p51
S'<cStringIO.StringO object at 0xa3cd8c0>'
p52
sS'wsgi'
p53
S"<Storage {'start_response': <function <lambda> a...UTC',
'PATH_INFO': '/init/default/viewcompany'}}>"
p54
sS'extension'
p55
S"'html'"
p56
sS'vars'
p57
S'<Storage {}>'
p58
sS'cid'
p59
S'None'
p60
sS'url'
p61
S'<gluon.html.XML object at 0xa40362c>'
p62
sg27
S'[]'
p63
sS'controller'
p64
S"'default'"
p65
sS'cookies'
p66
S"<SimpleCookie: csrftoken='9ffde5a05fb91ec51c4699...82'
sessionid='6ec993cc1ed48ab0c32215570c0854e7'>"
p67
sS'tickets_db'
p68
S"<SQLDB {'_lastsql': 'SELECT WHERE id = 1', '_db_...eobj': <class
'gluon.contrib.gql.applicants'>}>}>"
p69
sS'application'
p70
S"'init'"
p71
sS'ajax'
p72
S'False'
p73
sS'client'
p74
S"'127.0.0.1'"
p75
sS'env'
p76
S"<Storage {'content_length': '', 'http_user_agent...': '',
'path_info': '/init/default/viewcompany'}>"
p77
sS'raw_args'
p78
S'None'
p79
sS'get_vars'
p80
S'<Storage {}>'
p81
sS'folder'
p82
S"'/home/sujith/Desktop/wcj/applications/init/'"
p83
sS'now'
p84
S'datetime.datetime(2010, 10, 9, 4, 21, 27, 744517)'
p85
sS'post_vars'
p86
S'<Storage {}>'
p87
ssS'frames'
p88
(lp89
(dp90
S'file'
p91
S'/home/sujith/Desktop/wcj/gluon/restricted.py'
p92
sS'dump'
p93
(dp94
S'environment'
p95
S"{'A': <class 'gluon.html.A'>, 'B': <class 'gluon.html.B'>,
'BEAUTIFY': <class 'gluon.html.BEAUTIFY'>, 'BODY': <class
'gluon.html.BODY'>, 'BR': <class 'gluon.html.BR'>, 'CENTER': <class
'gluon.html.CENTER'>, 'CLEANUP': <class 'gluon.validators.CLEANUP'>,
'CODE': <class 'gluon.html.CODE'>, 'CRYPT': <class
'gluon.validators.CRYPT'>, 'DAL': <function DAL at 0xa719304>, ...}"
p96
sS'ccode'
p97
S'<code object <module> at 0xa8ddf50, file "/home/...init/controllers/
default.py:viewcompany", line 8>'
p98
ssS'lnum'
p99
I188
sS'lines'
p100
(dp101
I192
S' # XXX Show exception in Wing IDE if running in debugger'
p102
sI183
S' if type(code) == types.CodeType:'
p103
sI184
S' ccode = code'
p104
sI185
S' else:'
p105
sI186
S' ccode = compile2(code,layer)'
p106
sI187
g2
sI188
S' exec ccode in environment'
p107
sI189
S' except HTTP:'
p108
sI190
S' raise'
p109
sI191
S' except Exception:'
p110
ssS'call'
p111
S'(code=<code object <module> at 0xa8ddf50, file "/home/...init/
controllers/default.py:viewcompany", line 8>, environment={\'A\':
<class \'gluon.html.A\'>, \'B\': <class \'gluon.html.B\'>, \'BEAUTIFY
\': <class \'gluon.html.BEAUTIFY\'>, \'BODY\': <class \'gluon.html.BODY
\'>, \'BR\': <class \'gluon.html.BR\'>, \'CENTER\': <class
\'gluon.html.CENTER\'>, \'CLEANUP\': <class \'gluon.validators.CLEANUP
\'>, \'CODE\': <class \'gluon.html.CODE\'>, \'CRYPT\': <class
\'gluon.validators.CRYPT\'>, \'DAL\': <function DAL at
0xa719304>, ...}, layer=\'/home/sujith/Desktop/wcj/applications/init/
controllers/default.py\')'
p112
sS'func'
p113
S'restricted'
p114
sa(dp115
g91
S'/home/sujith/Desktop/wcj/applications/init/controllers/
default.py:viewcompany'
p116
sg93
(dp117
sg99
I222
sg100
(dp118
sg111
S'()'
p119
sg113
S'<module>'
p120
sa(dp121
g91
S'/home/sujith/Desktop/wcj/gluon/globals.py'
p122
sg93
(dp123
S'self'
p124
S'undefined'
p125
sS'f'
p126
S'<function viewcompany at 0xa8c879c>'
p127
ssg99
I96
sg100
(dp128
I96
S' self._caller = lambda f: f()'
p129
sI97
S' self._view_environment = None'
p130
sI98
S' self._custom_commit = None'
p131
sI99
S' self._custom_rollback = None'
p132
sI100
g2
sI91
S" self.flash = '' # used by the default view layout"
p133
sI92
S' self.meta = Storage() # used by web2py_ajax.html'
p134
sI93
S' self.menu = [] # used by the default view layout'
p135
sI94
S' self.files = [] # used by web2py_ajax.html'
p136
sI95
S' self._vars = None'
p137
ssg111
S'(f=<function viewcompany at 0xa8c879c>)'
p138
sg113
S'<lambda>'
p139
sa(dp140
g91
S'/home/sujith/Desktop/wcj/applications/init/controllers/
default.py:viewcompany'
p141
sg93
(dp142
sg99
I22
sg100
(dp143
sg111
S'()'
p144
sg113
S'viewcompany'
p145
sa(dp146
g91
S'/home/sujith/Desktop/wcj/gluon/sql.py'
p147
sg93
(dp148
S'i'
p149
S'0'
p150
sS'self'
p151
S'<gluon.sql.Rows object at 0xa98896c>'
p152
sS'self.records'
p153
S'[]'
p154
sS'row'
p155
g125
ssg99
I3605
sg100
(dp156
I3600
S' returns a list of sorted elements (not sorted in place)'
p157
sI3601
S' """'
p158
sI3602
S' return
Rows(self.db,sorted(self,key=f,reverse=reverse),self.colnames)'
p159
sI3603
g2
sI3604
S' def __getitem__(self, i):'
p160
sI3605
S' row = self.records[i]'
p161
sI3606
S' keys = row.keys()'
p162
sI3607
S" if self.compact and len(keys) == 1 and keys[0] != '_extra':"
p163
sI3608
S' return row[row.keys()[0]]'
p164
sI3609
S' return row'
p165
ssg111
S'(self=<gluon.sql.Rows object at 0xa98896c>, i=0)'
p166
sg113
g19
sasS'pyver'
p167
S'Python 2.5.5: /usr/bin/python2.5'
p168
sS'session'
p169
(dp170
sS'etype'
p171
S"<type 'exceptions.IndexError'>"
p172
sS'date'
p173
S'Sat Oct 9 04:21:27 2010'
p174
sS'response'
p175
(dp176
S'status'
p177
S'200'
p178
sg51
S'<cStringIO.StringO object at 0xaa6c520>'
p179
sg66
S"<SimpleCookie: session_id_init='1:c69a55b4-58b1-4d94-a89d-
bc0229214182'>"
p180
sS'_vars'
p181
S'None'
p182
sS'_dbtable_and_field'
p183
S"('session_id_init', <Table {'client_ip': <gluon.contrib.gql.Field
ob...: <gluon.contrib.gql.Field object at 0xaa69a6c>}>, '1',
'c69a55b4-58b1-4d94-a89d-bc0229214182')"
p184
sS'menu'
p185
S'[]'
p186
sS'flash'
p187
S"'Select companies from the lower right.'"
p188
sS'session_new'
p189
S'True'
p190
sS'_custom_rollback'
p191
S'None'
p192
sS'session_id'
p193
S"'1:c69a55b4-58b1-4d94-a89d-bc0229214182'"
p194
sS'headers'
p195
S"<Storage {'Expires': 'Sat, 09 Oct 2010 04:21:27 ...he, must-
revalidate, post-check=0, pre-check=0'}>"
p196
sS'meta'
p197
S'<Storage {}>'
p198
sS'session_filename'
p199
S"'/home/sujith/Desktop/wcj/applications/init/sessions/
127-0-0-1-39a7f7f0-7ad5-4ec2-83ae-73923950fdac'"
p200
sS'postprocessing'
p201
S'[]'
p202
sS'_caller'
p203
S'<function <lambda> at 0xa98b10c>'
p204
sS'_view_environment'
p205
S"{'A': <class 'gluon.html.A'>, 'B': <class 'gluon.html.B'>,
'BEAUTIFY': <class 'gluon.html.BEAUTIFY'>, 'BODY': <class
'gluon.html.BODY'>, 'BR': <class 'gluon.html.BR'>, 'CENTER': <class
'gluon.html.CENTER'>, 'CLEANUP': <class 'gluon.validators.CLEANUP'>,
'CODE': <class 'gluon.html.CODE'>, 'CRYPT': <class
'gluon.validators.CRYPT'>, 'DAL': <function DAL at 0xa719304>, ...}"
p206
sS'session_id_name'
p207
S"'session_id_init'"
p208
sS'_custom_commit'
p209
S'None'
p210
sS'files'
p211
S'[]'
p212
sS'view'
p213
S"'default/viewcompany.html'"
p214
ssS'locals'
p215
(dp216
g149
g150
sS'self'
p217
S'<gluon.sql.Rows object at 0xa98896c>'
p218
sssS'traceback'
p219
S'Traceback (most recent call last):\n File "/home/sujith/Desktop/wcj/
gluon/restricted.py", line 188, in restricted\n exec ccode in
environment\n File "/home/sujith/Desktop/wcj/applications/init/
controllers/default.py:viewcompany", line 222, in <module>\n File "/
home/sujith/Desktop/wcj/gluon/globals.py", line 96, in <lambda>\n
self._caller = lambda f: f()\n File "/home/sujith/Desktop/wcj/
applications/init/controllers/default.py:viewcompany", line 22, in
viewcompany\n File "/home/sujith/Desktop/wcj/gluon/sql.py", line
3605, in __getitem__\n row = self.records[i]\nIndexError: list
index out of range\n'
p220
s.
******************************************
Thanks
Sujith
On Oct 8, 11:45 pm, mdipierro <[email protected]> wrote:
> On Oct 8, 1:28 pm, Sujith <[email protected]> wrote:
>
> > Hi Massimo,
>
> > Thanks for the superfast response.
> > The views and controllers seem to be working now. But i cannot see any
> > data on the website.
>
> can you explain which url shows the data and which one does not? This
> is probably an application error.
>
> > The appliance seems to be working fine and i can see the data when
> > running under web2py.
>
> > Thanks a lot. :)
> > Sujith
>
> > On Oct 8, 11:22 pm, mdipierro <[email protected]> wrote:
>
> > > You should not have this line:
>
> > > from gluon.dal import *
>
> > > that module is experimental and it is not the proper way of using it.
> > > It does not support GAE at all.
>
> > > If you remove that line everything else I see should work fine on GAE.
>
> > > Massimo
>
> > > On Oct 8, 1:20 pm, Sujith <[email protected]> wrote:
>
> > > > Hi all,
>
> > > > I am trying to make the "jobsite" appliance work on GAE. I edited the
> > > > model(db.py) of jobsite to suit GAE.
> > > > I am getting the following error when running under devappserver of
> > > > gae sdk.
> > > > ***************************************
> > > > WARNING 2010-10-08 18:10:40,069 datastore_file_stub.py:657] Could not
> > > > read datastore data from /tmp/dev_appserver.datastore
> > > > WARNING 2010-10-08 18:10:40,080 dev_appserver.py:3637] Could not
> > > > initialize images API; you are likely missing the Python "PIL" module.
> > > > ImportError: No module named _imaging
> > > > INFO 2010-10-08 18:10:40,108 dev_appserver_main.py:431] Running
> > > > application wcj on port 8080:http://localhost:8080
> > > > WARNING 2010-10-08 18:12:29,440 portalocker.py:92] no file locking
> > > > ERROR 2010-10-08 18:12:30,790 restricted.py:151] Traceback (most
> > > > recent call last):
> > > > File "/home/sujith/Desktop/wcj/gluon/restricted.py", line 188, in
> > > > restricted
> > > > exec ccode in environment
> > > > File "/home/sujith/Desktop/wcj/applications/init/models/db.py", line
> > > > 7, in <module>
> > > > session.connect(request,response,db)
> > > > File "/home/sujith/Desktop/wcj/gluon/globals.py", line 298, in
> > > > connect
> > > > migrate=table_migrate,
> > > > File "/home/sujith/Desktop/wcj/gluon/dal.py", line 2117, in
> > > > define_table
> > > > t._create(migrate=migrate, fake_migrate=fake_migrate)
> > > > File "/home/sujith/Desktop/wcj/gluon/dal.py", line 2555, in _create
> > > > elif not field.type in self._db._adapter.types:
> > > > AttributeError: 'BaseAdapter' object has no attribute 'types'
> > > > *************************************
>
> > > > This is the model
> > > > *************************************
> > > > import datetime
> > > > now=datetime.datetime.today()
>
> > > > if request.env.web2py_runtime_gae:
> > > > from gluon.dal import *
> > > > db = DAL('gae')
> > > > session.connect(request,response,db)
> > > > else:
> > > > db = DAL('sqlite://storage.sqlite')
>
> > > > db.define_table('user',
> > > > Field('name'),
> > > > Field('email'),
> > > > Field('phone_country_code',default='1'),
> > > > Field('phone'),
> > > > Field('user_type'),
> > > > Field('password','password'),
> > > > Field('authorized',default='True'),
> > > > Field('verification',default=''))
>
> > > > db.user.name.requires=IS_NOT_EMPTY()
> > > > db.user.user_type.requires=IS_IN_SET('Administrator','Applicant','Recruiter')
> > > > db.user.email.requires=[IS_EMAIL(), IS_NOT_IN_DB(db,'user.email'),
> > > > IS_NOT_EMPTY()]
>
> > > > db.define_table('country',
> > > > Field('country_code'),
> > > > Field('country_name'))
>
> > > > db.country.country_code.requires=IS_NOT_EMPTY()
> > > > db.country.country_name.requires=IS_NOT_EMPTY()
>
> > > > db.define_table('state',
> > > > Field('country_code'),
> > > > Field('state_code'),
> > > > Field('state_name'))
>
> > > > db.state.country_code.requires=IS_IN_DB(db,'country.country_code')
> > > > db.state.state_code.requires=IS_NOT_EMPTY()
> > > > db.state.state_name.requires=IS_NOT_EMPTY()
>
> > > > db.define_table('company',
> > > > Field('company_name'),
> > > > Field('profile','text'),
> > > > Field('address1'),
> > > > Field('address2'),
> > > > Field('city'),
> > > > Field('state'),
> > > > Field('zip'),
> > > > Field('country'),
> > > > Field('owner',db.user,default=session.user_id))
>
> > > > db.company.company_name.requires=IS_NOT_EMPTY()
> > > > db.company.profile.requires=IS_NOT_EMPTY()
> > > > db.company.country.requires=IS_IN_DB(db,'country.country_name')
> > > > db.company.owner.requires=IS_IN_DB(db,'user.id','%(name)s')
> > > > db.company.state.requires=IS_IN_DB(db,'state.state_name')
> > > > db.company.owner.requires=IS_NOT_EMPTY()
>
> > > > db.define_table('categories',
> > > > Field('cat_name'),
> > > > Field('cat_descr','text'))
>
> > > > db.categories.cat_name.requires=IS_NOT_EMPTY()
>
> > > > db.define_table('positions',
> > > > Field('company_name'),
> > > > Field('title'),
> > > > Field('category'),
> > > > Field('description','text',default=''),
> > > > Field('timestamp','datetime',default=now),
> > > > Field('expires_on','datetime'),
> > > > Field('access',default='Private'),
> > > > Field('owner','integer',default=session.user_id))
>
> > > > #db.positions.access.requires=IS_IN_SET('P','R','A')
> > > > db.positions.company_name.requires=IS_IN_DB(db,'company.company_name')
> > > > db.positions.category.requires=IS_IN_DB(db,'categories.cat_name')
> > > > #db.positions.expires_on.requires=IS_NOT_EMPTY()
> > > > db.company.owner.requires=IS_NOT_EMPTY()
>
> > > > db.define_table('position_requirements',
> > > > Field('position_id'),
> > > > Field('requirement'))
>
> > > > db.position_requirements.position_id.requires=IS_IN_DB(db,'positions.id','position.title')
>
> > > > db.define_table('applicants',
> > > > Field('user_id'),
> > > > Field('applicant_name'),
> > > > Field('address1'),
> > > > Field('address2'),
> > > > Field('city'),
> > > > Field('state'),
> > > > Field('zip'),
> > > > Field('country'),
> > > > Field('phone_country_code',default='1'),
> > > > Field('phone'),
> > > > Field('email'),
> > > > Field('access',default='Public'),
> > > > Field('updated','datetime',default=now))
>
> > > > #db.applicants.access.requires=IS_IN_SET('P','R','A')
> > > > db.applicants.applicant_name.requires=IS_NOT_EMPTY()
> > > > db.applicants.email.requires=[IS_EMAIL(),IS_NOT_EMPTY()]
> > > > db.applicants.country.requires=IS_IN_DB(db,'country.country_code','country.country_name')
> > > > db.applicants.state.requires=IS_IN_DB(db,'state.state_code','state.state_name')
>
> > > > db.define_table('applied_for',
> > > > Field('position_id'),
> > > > Field('applicant'),
> > > > Field('applicant_name'),
> > > > Field('applied','datetime',default=now))
>
> > > > db.applied_for.position_id.requires=IS_IN_DB(db,'positions.id','positions.title')
> > > > #db.applied_for.applicant.requires=IS_IN_DB(db,'applicants.id','applicants.id')
> > > > #db.applied_for.applicant.requires=IS_IN_DB(db,'applicants.applicant_name','applicants.applicant_name')
>
> > > > db.define_table('resumes',
> > > > Field('user_id',db.user,default=session.user_id),
> > > > Field('title'),
> > > > Field('body','text'),
> > > > Field('keywords','text'),
> > > > Field('updated','datetime',default=now),
> > > > Field('access',default='Public'))
>
> > > > #db.resumes.access.requires=IS_IN_SET('P','R','A')
> > > > db.resumes.user_id.requires=IS_NOT_EMPTY()
> > > > ***************************************
>
> > > > I am using python2.5 on Ubuntu 10.4 (lucid). I am a noob in python and
> > > > also a newbie to web2py.
>
> > > > Thanks for the help.
>
> > > > Sujith
