Hello,

I just try my app with the 1.96.3 and I got a strange error :

Traceback (most recent call last):
  File "/version_196-3/web2py/gluon/restricted.py", line 184, in restricted
    exec ccode in environment
  File "/version_196-3/web2py/applications/sgddms/controllers/test.py", line
1334, in <module>
  File "/version_196-3/web2py/gluon/globals.py", line 137, in <lambda>
    self._caller = lambda f: f()
  File "/version_196-3/web2py/gluon/tools.py", line 2452, in f
    return action(*a, **b)
  File "/version_196-3/web2py/applications/sgddms/controllers/test.py", line
654, in verify
    if form.accepts(request.vars, session):
  File "/version_196-3/web2py/gluon/sqlhtml.py", line 1203, in accepts
    self.table._db(self.table.id == self.record.id).update(**fields)
  File "/version_196-3/web2py/gluon/dal.py", line 5369, in update
    fields = self.db[tablename]._listify(update_fields,update=True)
  File "/version_196-3/web2py/gluon/dal.py", line 4656, in _listify
    raise SyntaxError, 'Field %s does not belong to the table' % name
SyntaxError: Field id does not belong to the table

  def _listify(self,fields,update=False):
        new_fields = []
        new_fields_names = []
        for name in fields:
            if not name in self.fields:
                raise SyntaxError, 'Field %s does not belong to the
table' % name

            new_fields.append((self[name],fields[name]))
            new_fields_names.append(name)
        for ofield in self:
            if not ofield.name in new_fields_names:



*I use a old app and a feature for Postgres that Massimo added in the
pass that never been documented and i don't think it was official :*

*
*

*MODEL :*

*Field('table_id','id'), # My legacy database used the same name as PK
and FK so I had to define them in the model like this*

*sequence_name='test_activity_activity_id_seq' # Postgres has it on
automation rule to create the sequence name base on the PK name and
because I where using legacy database PK name I had also to define the
sequence name in my model...*

*
*

*Not sure if there is a link.*

*
*

*Thanks*

*
*

*Richard*

*
*

*
*

Reply via email to