It does the problem on update... My create form work well, deletion also works.
Richard On Mon, Jun 6, 2011 at 3:29 PM, Richard Vézina <ml.richard.vez...@gmail.com>wrote: > Nop! Still there... > > Maybe I have wrong build : > Version 1.96.3 (2011-06-06 13:58:28) > > Richard > > > On Mon, Jun 6, 2011 at 3:04 PM, Massimo Di Pierro < > massimo.dipie...@gmail.com> wrote: > >> I think I fixed this in trunk. Can you please check it? >> >> On Jun 6, 1:03 pm, Richard Vézina <ml.richard.vez...@gmail.com> wrote: >> > 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* >> > >> > * >> > * >> > >> > * >> > * > > >