Can you try? crud.settings.detect_record_change = False
SQLFORM has a mechanism to prevent two users from doing this: user 1) visualize and edit record user 2) visualize and edit record user 1) save changes user 2) save changes and override changes by user 1 in SQLFORM it is disabled by default. In crud it is enabled by default. crud.settings.detect_record_change = True Still something is wrong because you should get a message about it. On Aug 28, 2:18 pm, apple <[email protected]> wrote: > If the database fails to update within CRUD is there a way I can view > the error? > > I have a controller with this code that works fine: > form=SQLFORM(table,a.id) > if form.accepts(request.vars, session): > response.flash="record updated" > > I replace it with: > form=crud.update(table, a.id) > > Now it works fine the first time the form is changed. Then the second > time it correctly calls the controller but the database is not updated > and the form reverts to the pre-change values. This continues so on > odd submits it works and even submits it does not. > > It also seems to work on all submits when I excluded certain fields. I > am thinking maybe there is a database error thrown inside CRUD but no > error message is logged.
