I think the problem is that in mysql db(...).update(..) db(...).delete()
do not seem to return the number of affected records.... Massimo On Feb 8, 11:27 am, Peter <[email protected]> wrote: > Hi Massimo, > > The printed values are " '9' 9L " in both cases. > > Your first suggestion is ineffective, > but the second one solves this problem: > self.table._db(self.table.id==self.record.id).update(**fields) > > I have another issue that seems to be mysql related, I'll post this > separately. > > -Peter > > On Feb 8, 5:22 pm, mdipierro <[email protected]> wrote: > > > I am puzzled. Can you help me debug this? > > > Can you replace in sqlhtml.py > > > self.table[record_id] = fields > > > with > > print repr(record_id), repr(self.record.id) > > self.table[self.record.id] = fields > > > and if it still does not work with > > > print repr(record_id), repr(self.record.id) > > self.table._db > > (self.table.id==self.record.id).update(**fields) > > > Let me know what happens. > > > Massimo > > > On Feb 8, 7:23 am, Peter <[email protected]> wrote: > > > > Until now I was running trunk r660 with MySQL with few problems. With > > > 1.56.1 a few new issues popped up. Code below works OK with 1.56.1 and > > > sqlite, but not with MySQL. Sessions are on the file system (default > > > settings), not in the DB. > > > > If I submit the form without making any changes to it, I get a "no > > > such record" error from sql.py (see error msg below). If I DO make any > > > trivial change to field values in the form, it submits OK and is > > > stored in the database. If I pass t2.person_id to SQLFORM instead of > > > 'pers' , the result is the same. > > > > Could this be some dependency on the old t2 module I still use? > > > Cheers, > > > -Peter > > > > # default.py: > > > def testmysql(): > > > pers = db(db.t2_person.id==t2.person_id).select()[0] > > > form = SQLFORM(db.t2_person,pers) > > > if form.accepts(request.vars,session): > > > redirect(URL(r=request,f='index')) > > > return dict(form=form) > > > > # db.py: > > > db.define_table('t2_person', > > > SQLField('name',length=40,label='MoemID',requires=IS_NOT_EMPTY > > > (),unique=True), > > > SQLField('password','password',requires=CRYPT()), > > > SQLField('email',requires=IS_EMAIL()), > > > SQLField('registration_key',length=64), > > > SQLField('voornaam',default=''), > > > SQLField('achternaam',default='',length=50), > > > SQLField('adres',length=100,label='Straat en huisnr',default=''), > > > SQLField('postcode',length=10,default=''), > > > SQLField('plaats',length=50,default=''), > > > SQLField('land',requires=IS_IN_SET > > > ( COUNTRIES ),default='Nederland' ), > > > SQLField('telnr',length=20,label=T('06-nummer'),default=''), > > > SQLField('foto','upload',default=''), > > > SQLField('wiebenik','text',label='Over jou', default=''), > > > SQLField('created_by_ip',default='10.0.0.1'), > > > SQLField('created_on','datetime',default="1900-01-01 00:00:00")) > > > # validation business rules and widgets all disabled for this test > > > > # error message: > > > Traceback (most recent call last): > > > File "/Library/Python/2.5/site-packages/web2py-1.56.1/gluon/ > > > restricted.py", line 98, in restricted > > > exec ccode in environment > > > File "/Library/Python/2.5/site-packages/web2py-1.56.1/applications/ > > > mijnmoem/controllers/default.py", line 296, in <module> > > > File "/Library/Python/2.5/site-packages/web2py-1.56.1/gluon/ > > > globals.py", line 74, in <lambda> > > > self._caller = lambda f: f() > > > File "/Applications/web2py.app/Contents/Resources/applications/ > > > mijnmoem/modules/t2.py", line 1039, in h > > > return f(*a,**b) > > > File "/Library/Python/2.5/site-packages/web2py-1.56.1/applications/ > > > mijnmoem/controllers/default.py", line 79, in testmysql > > > if form.accepts(request.vars,session): > > > File "/Library/Python/2.5/site-packages/web2py-1.56.1/gluon/ > > > sqlhtml.py", line 529, in accepts > > > self.table[record_id] = fields > > > File "/Library/Python/2.5/site-packages/web2py-1.56.1/gluon/sql.py", > > > line 982, in __setitem__ > > > raise SyntaxError, 'No such record' > > > SyntaxError: No such record --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
