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.
