Hello,
I have a form created by CRUD with some extra fields. assets_label field is
a dropdown consisting of all old labels. Beside that I add an normal text
field where user can enter a new label.
I have then crud.settings.create_onaccept = insert_assets where I update
the label name if there is some text in the textfield. This works great.
The problem comes with crud.settings.update_onaccept = update_assets
and
def update_assets(form):
if form.request_vars.asset_name_2 != '':
row = db(db.assets.asset_id == form.vars.id).update(asset_name =
form.request_vars.asset_name_2)
I get an error ticket containg:
<class '_mysql_exceptions.IntegrityError'> (1062, "Duplicate entry
'275-2012-12-07 10:26:41' for key 'asset_id'")
File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in execute
self.errorhandler(self, exc, value)
File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in
defaulterrorhandler
raise errorclass, errorvalue
IntegrityError: (1062, "Duplicate entry '275-2012-12-07 10:26:41' for key
'asset_id'")
Any ideas what I'm doing wrong?
Kenneth
--
