Please submit a google code ticket.

On Sunday, 15 April 2012 06:09:19 UTC-5, weheh wrote:
>
> If smartgrid is used to edit the values of fields in auth_user that are 
> designated unique=True, smartgrid will crash when a duplicate value is 
> entered. Here's a ticket trace. SQLite is the underlying db. Incidentally, 
> this is my first go at grid and smartgrid and I'm very impressed. Kudos.
>
>   File "N:\web2py\gluon\sqlhtml.py", line 1962, in smartgrid
>     user_signature=user_signature,**kwargs)
>   File "N:\web2py\gluon\sqlhtml.py", line 1584, in grid
>     next=referrer)
>   File "N:\web2py\gluon\html.py", line 1951, in process
>     self.validate(**kwargs)
>   File "N:\web2py\gluon\html.py", line 1898, in validate
>     if self.accepts(**kwargs):
>   File "N:\web2py\gluon\sqlhtml.py", line 1265, in accepts
>     self.table._db(self.table._id == self.record.id).update(**fields)
>   File "N:\web2py\gluon\dal.py", line 6346, in update
>     return self.db._adapter.update(tablename,self.query,fields)
>   File "N:\web2py\gluon\dal.py", line 1093, in update
>     self.execute(sql)
>   File "N:\web2py\gluon\dal.py", line 1359, in execute
>     return self.log_execute(*a, **b)
>   File "N:\web2py\gluon\dal.py", line 1353, in log_execute
>     ret = self.cursor.execute(*a, **b)
> IntegrityError: column username is not unique
>
>

Reply via email to