before db.user_jogo.insert(**db.user_jogo._filter_fields(form.vars))
please add print db.user_jogo._insert(**db.user_jogo._filter_fields(form.vars)) What does it print when the problem occurs? On Dec 17, 11:14 pm, Bruno Rocha <rochacbr...@gmail.com> wrote: > 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 Rochahttp://about.me/rochacbruno/bio
