hum... same error. Here is the relevant stuff and the error is just
that ('Field value does not belong to the table')
thanks for the help!
Mart :)
the table...
db.define_table('local_history',
Field('uuid',length=64,default=uuid.uuid4()),
Field('input_name'),
Field('input_path'),
Field('dateTime'),
Field('elemTree','blob'),
Field('content','text'),
Field('buildtype'),
Field('truncateFields','boolean'),
Field('nolocaluser','boolean'),
Field('targets','list:string'))
db.commit()
and here is the relevant script...
if root.tag=='build':
tree=ElementTree()
try:
tree.parse(self.dataSource)
except Exception as errObj:
print('setDataSource: {0}'.format(errObj))
print('{0} will be parsed as SringIO')
dSource=StringIO(self.dataSource)
tree.parse(dSource,None)
buildSpecName=os.path.splitext(os.path.split(self.dataSource)[1])
[0]
iFile=open(self.dataSource,'r')
content=iFile.read()
iFile.close()
buildType=None
truncateFields=False
nolocaluser=False
targets=None
if self.cmdArgs:
if self.cmdArgs.buildtype:buildtype=\
self.cmdArgs.buildtype
if self.cmdArgs.truncate:truncateFields=\
self.cmdArgs.truncate
if self.cmdArgs.nolocaluser:nolocaluser=\
self.cmdArgs.nolocaluser
if self.cmdArgs.targets:targets=\
self.cmdArgs.targets
targetsList=[]
if targets is not None:
try:
targetlist=string.split(targets,',')
for targ in targetlist:
if targ:stargetsList.append(targ)
else:
if targets:targetsList.append(targets)
except Exception as err:
print('can not establish target list\n{0}\
'.format(err))
self.db.local_history.insert(input_name=buildSpecName\
,input_path='{0}'.format(self.dataSource)\
,value=self.dataSource\
,content=content\
,elemTree=cPickle.dumps(tree.getroot())\
,dateTime=datetime.datetime.now()\
,nolocaluser=nolocaluser\
,truncateFields=truncateFields\
,targets=targetsList)
self.db.commit()
in the script:
On Jul 12, 5:29 pm, mart <[email protected]> wrote:
> good idea! yes, i will blow away the DB, try again and post the stack
> trace. this using DAL in script (no web or forms).
>
> thanks! :)
>
> On Jul 12, 5:15 pm, pbreit <[email protected]> wrote:
>
>
>
>
>
>
>
> > Hmmm...might need to see the model, controller and database. Are you in
> > development? Can you blow away the DB and start over? What does the full
> > error trace look like? Are you updating any other fields? Are you using
> > form.accepts?
