yes please run the mod. Email me personally if you could help me with one more mysql test.
For the fields issue. Sorry I do not understand. Could you send me a longer example? Massimo On Feb 8, 11:53 am, Peter <[email protected]> wrote: > So what is your advice, to run with your mod in sqlhtml.py for the > time being...? > > Btw, my other issue with 1.56.1 turns out not to be mysql-related. > The following function is passed as a validator to my SQLFORM > (slightly simplified): > def myvalidator(form): > for f in fields: > if form.vars[f] =='': form.errors[f]='error' > > form=SQLFORM(db.t2_person,pers,fields=fields) > > if form.accepts(request.vars, session, onvalidation=lambda form: > myvalidator(form)): > > It appears that pre-1.56 the "fields" list in the onvalidation call > included only the fields array as passed to SQLFORM, and in 1.56 it > includes all fields in the database table? Is that possible? At any > rate, I can repair this by explicitly specifying the fields to be > validated in the validator function. > > Cheers, > -Peter > > On Feb 8, 6:39 pm, mdipierro <[email protected]> wrote: > > > 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 -~----------~----~----~----~------~----~------~--~---
