Thanks for the info - I will NOT report as a bug then. -Jim
On Thursday, September 10, 2015 at 7:33:55 PM UTC-5, Niphlod wrote: > > it probably never came up because the usecase is indeed weird .... the > only change I can think of is that record archiving used to archive a row > for every modification, even if all the fields were unchanged. The "new" > method stores an archive row only if something changes, and I guess it's in > that loop of checking differences with the current that it stumbles... > > On Thursday, September 10, 2015 at 6:31:28 PM UTC+2, Jim S wrote: >> >> Because I'm lazy. >> >> In some of my code I do this: >> >> # Set all fields as not editable >> for field in db.contact.fields: >> db.contact[field].writable = False >> >> >> # Enable the specific fields that will be editable in the form >> db.contact.first_name.writable = True >> db.contact.last_name.writable = True >> >> >> >> I can then set which fields are writable based on different access >> levels. Obviously I just need to exclude the 'id' field where I set >> writable to False. But, this is where it came from. >> >> -Jim >> >> >> >> On Thursday, September 10, 2015 at 10:07:22 AM UTC-5, Niphlod wrote: >>> >>> uhm. why the id should be set to not writable ? it is not writable by >>> default because it's an identity ..... >>> >>> On Thursday, September 10, 2015 at 4:54:35 PM UTC+2, Jim S wrote: >>>> >>>> I just fixed an issue I was having - it used to work so much be a newer >>>> version of web2py that introduced it (I think, cannot confirm that it >>>> worked on earlier version) >>>> >>>> I have a table with record versioning active. I'm updating it via >>>> SQLFORM.grid but before the SQLFORM.grid call I was making the 'id' field >>>> non-writable. db.contact.id.writable = False >>>> >>>> With that in place I'm getting this traceback... >>>> >>>> Traceback (most recent call last): >>>> File "C:\dev\web2py\gluon\restricted.py", line 227, in restricted >>>> exec ccode in environment >>>> File "C:/dev/web2py/applications/connect/controllers/contacts.py" >>>> <http://127.0.0.1:8000/admin/default/edit/connect/controllers/contacts.py>, >>>> line 892, in <module> >>>> File "C:\dev\web2py\gluon\globals.py", line 412, in <lambda> >>>> self._caller = lambda f: f() >>>> File "C:\dev\web2py\gluon\tools.py", line 3775, in f >>>> return action(*a, **b) >>>> File "C:/dev/web2py/applications/connect/controllers/contacts.py" >>>> <http://127.0.0.1:8000/admin/default/edit/connect/controllers/contacts.py>, >>>> line 231, in index >>>> paginate=15, maxtextlength=45, formstyle=my_formstyle, ui=grid_ui) >>>> File "C:\dev\web2py\gluon\sqlhtml.py", line 2308, in grid >>>> next=referrer) >>>> File "C:\dev\web2py\gluon\html.py", line 2301, in process >>>> self.validate(**kwargs) >>>> File "C:\dev\web2py\gluon\html.py", line 2238, in validate >>>> if self.accepts(**kwargs): >>>> File "C:\dev\web2py\gluon\sqlhtml.py", line 1709, in accepts >>>> self.id_field_name]).update(**fields) >>>> File "C:\dev\web2py\gluon\packages\dal\pydal\objects.py", line 2045, in >>>> update >>>> if any(f(self,update_fields) for f in table._before_update): >>>> File "C:\dev\web2py\gluon\packages\dal\pydal\objects.py", line 2045, in >>>> <genexpr> >>>> if any(f(self,update_fields) for f in table._before_update): >>>> File "C:\dev\web2py\gluon\packages\dal\pydal\objects.py", line 415, in >>>> <lambda> >>>> archive_record(qset, fs, db[an], cn)) >>>> File "C:\dev\web2py\gluon\packages\dal\pydal\helpers\methods.py", line >>>> 91, in archive_record >>>> if fields[k] != v: >>>> KeyError: 'id' >>>> >>>> >>>> With the 'id' field writable I do not get the traceback. >>>> >>>> Version 2.12.3-stable+timestamp.2015.08.18.19.14.07 >>>> >>>> Should this be reported as a bug or is it just me having issues? >>>> >>>> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
