I ran with the same issue with the new dal. https://groups.google.com/forum/#!topic/web2py-developers/RU5yUhu_2pU
Jus to to remember: Also Virtual fields: https://groups.google.com/forum/#!topic/web2py-developers/IPoWmlKoFOQ And the load charts on applet: https://groups.google.com/forum/#!topic/web2py-developers/eOW2wktnlsQ 2010/12/18 Tito Garrido <titogarr...@gmail.com> > When I try to create record that has an list:reference field I'm getting > the following error: > > MODEL: > Field('troco_por', 'list:reference jogo', label='Troco por qualquer um > destes jogos', comment='Use a tecla Ctrl para selecionar mais de um jogo'), > > CONTROLLER: > db.user_jogo.insert(**db.user_jogo._filter_fields(form.vars)) > > > File > "/Users/titogarrido/Documents/Projetos/GAE/gametroca/web2py/applications/init/controllers/default.py" > <http://127.0.0.1:8000/admin/default/edit/init/controllers/default.py>, line > 103, in meus_jogos > > > form.vars.id = > db.user_jogo.insert(**db.user_jogo._filter_fields(form.vars)) > > > File > "/Users/titogarrido/Documents/Projetos/GAE/gametroca/web2py/gluon/dal.py", > line 3750, in insert > > > return self._db._adapter.insert(self,self._listify(fields)) > > > File > "/Users/titogarrido/Documents/Projetos/GAE/gametroca/web2py/gluon/dal.py", > line 701, in insert > > > raise e > OperationalError: near ",": syntax error > > > > > And when I try to update: > > db(db.user_jogo.id > ==anuncio_id).update(**db.user_jogo._filter_fields(form.vars)) > > It raises an error: > File > "/Users/titogarrido/Documents/Projetos/GAE/gametroca/web2py/applications/init/controllers/default.py", > line 127, in anunciar > form.vars.id = db(db.user_jogo.id > ==anuncio_id).update(**db.user_jogo._filter_fields(form.vars)) > File > "/Users/titogarrido/Documents/Projetos/GAE/gametroca/web2py/gluon/dal.py", > line 4389, in update > return self.db._adapter.update(tablename,self.query,fields) > File > "/Users/titogarrido/Documents/Projetos/GAE/gametroca/web2py/gluon/dal.py", > line 848, in update > self.execute(sql) > File > "/Users/titogarrido/Documents/Projetos/GAE/gametroca/web2py/gluon/dal.py", > line 1055, in execute > return self.log_execute(*a, **b) > File > "/Users/titogarrido/Documents/Projetos/GAE/gametroca/web2py/gluon/dal.py", > line 1052, in log_execute > return self.cursor.execute(*a,**b) > OperationalError: near "WHERE": syntax error > > > It was working before I update web2py... so probably something wrong on new > dal? > > Regards, > > Tito > > -- > > Linux User #387870 > .........____ > .... _/_õ|__| > ..º[ .-.___.-._| . . . . > .__( o)__( o).:_______ > -- Bruno Rocha http://about.me/rochacbruno/bio