Created the following table
mdb.define_table('syscommands',
Field('commandname', type='string',
unique=True,
label=T('Commandname')),
Field('commandline', type='string',
label=T('Command')),
Field('host_id', mdb.hoststable,
comment="Like nim or hmc server.",
label=T('Destination Host ID')),
Field('description', type='string',
label=T('Description')),
Field('fase','string',
comment="Fase 1 is storage, Fase 2 is Profile Creation, Fase 3
is VIO deployment, Fase 4 is Lpar deployment..",
label=T('Fase')),
Field('created_on','datetime',default=request.now,
label=T('Created On'),writable=False,readable=False),
Field('modified_on','datetime',default=request.now,
label=T('Modified On'),writable=False,readable=False,
update=request.now),
format='%(commandname)s',
migrate=settings.migrate)
# Table rules for command
mdb.syscommands.fase.requires = IS_IN_SET(['1', '2', '3', '4'])
#mdb.syscommands.host_id.requires = IS_NOT_EMPTY()
mdb.syscommands.commandname.requires = IS_NOT_EMPTY()
mdb.syscommands.host_id.requires = IS_IN_DB(mdb, 'hoststable.id',
'hoststable.hostname')
mdb.syscommands.commandline.requires = IS_NOT_EMPTY()
it revers to this table
mdb.define_table('hoststable',
Field('hostname', type='string',
unique=True,
label=T('Hostname')),
Field('description', type='string',
label=T('Description')),
Field('netboot', type='string',
label=T('Netboot information')),
Field('ip', type='string',
default='192.168.1.x',
label=T('IP Address')),
Field('connectcmd', type='string',
default='ssh',
label=T('Connection command')),
Field('useraccount', type='string',
default='root',
label=T('Default User')),
Field('created_on','datetime',default=request.now,
label=T('Created On'),writable=False,readable=False),
Field('modified_on','datetime',default=request.now,
label=T('Modified On'),writable=False,readable=False,
update=request.now),
format='%(hostname)s',
migrate=settings.migrate)
# Table Hosts rules
mdb.hoststable.hostname.requires = IS_NOT_EMPTY()
mdb.hoststable.ip.requires = IS_NOT_EMPTY()
Then when I create a record in appadmin and after that change this item
It throws this error.
Ticket ID
127.0.0.1.2013-03-21.17-03-38.3cfba30b-5706-4bdb-af50-faa6be3ed179
<type 'exceptions.RuntimeError'> uncaught exception when
updating rows: MongoDB can only handle up to 8-byte ints
Version
web2py^(TM) Version 2.4.5-stable+timestamp.2013.03.18.22.46.22
Python Python 2.7.3: /usr/bin/python2.7 (prefix: /usr)
Traceback
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
Traceback (most recent call last):
File
"/home/mv1965/Documents/development/eclipse/workspacejuno/w2pdeploy/gluon/restricted.py",
line 212, in restricted
exec ccode in environment
File
"/home/mv1965/Documents/development/eclipse/workspacejuno/w2pdeploy/applications/adeploy/compiled/controllers_appadmin_update.py",
line 410, in <module>
File
"/home/mv1965/Documents/development/eclipse/workspacejuno/w2pdeploy/gluon/globals.py",
line 194, in <lambda>
self._caller = lambda f: f()
File
"/home/mv1965/Documents/development/eclipse/workspacejuno/w2pdeploy/applications/adeploy/compiled/controllers_appadmin_update.py",
line 277, in update
File
"/home/mv1965/Documents/development/eclipse/workspacejuno/w2pdeploy/gluon/sqlhtml.py",
line 1527, in accepts
self.id_field_name]).update(**fields)
File
"/home/mv1965/Documents/development/eclipse/workspacejuno/w2pdeploy/gluon/dal.py",
line 9834, in update
ret = db._adapter.update(tablename,self.query,fields)
File
"/home/mv1965/Documents/development/eclipse/workspacejuno/w2pdeploy/gluon/dal.py",
line 5450, in update
raise RuntimeError("uncaught exception when updating rows: %s" % e)
RuntimeError: uncaught exception when updating rows: MongoDB can only handle up
to 8-byte ints
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
