This is becoming a show-stopper for me now as I cannot ADD fields to an
exiting table either. I'm pretty sure adding fields worked before when I
was running on Windows. Made the transition to Linux on my office desktop
recently and that was when I first encountered the problem. Adding the
field LocalMountPoint (rname='storage_local_mount'):
self.db.define_table('StorageVolume',
Field('VolumeName', rname='storage_volume_name', type='string',
length=32, label='Volume', comment='The name of the Storage Volume'),
Field('FileServerId', rname='storage_volume_server_id',
type='reference FileServer', ondelete='CASCADE', label='Server',
comment='The Server on which the Storage Volume resides'),
Field('StorageUri', rname='storage_uri', type='string',
length=256, label='Storage URI', comment='The URI of the Storage Volume'),
Field('LocalMountPoint', rname='storage_local_mount',
type='string', length=256, label='Local Mount Point', comment='The local
mount point of the Storage Volume'),
audit,
rname='storage_volume',
format='%(VolumeName)s',
singular='Volume',
plural='Volumes',
migrate=True)
self.db.commit()
results in:
ALTER TABLE storage_volume ADD localmountpoint VARCHAR(256);
success!
Aaaargh! Can anyone give feedback on how long this may take to fix? Can
someone give me some pointers so I can fix it myself? As I said, bit of a
noob to python and web2py... but how hard can it be? :)
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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/d/optout.
