[web2py] double insert.

[Nils Olofsson]

Hi,

I'm having a problem:
web2py: Version 1.96.4 (2011-06-07 21:08:15)

Running on Rocket 1.2.2

Database is mysql.

I have this code:

form
=SQLFORM(db.events,fields=['title','venue','starttime','startdate','endtime','enddate','location','image','cost','website','booking','latlng','information'])
    my_extra_element = TR("",INPUT(_id='Lookup',_value="Check
Map",_type='submit'))
    form[0].insert(6,my_extra_element)
    my_extra_element = TR("Add
Tags",SELECT(_name='tags',_multiple='multiple',*[OPTION(tags[i].name,_value=str(tags[i].id))
for i in range(len(tags))]))
    form[0].insert(-1,my_extra_element)

    if form.accepts(request.vars, session,keepvalues=True):
        db.events.insert(**db.events._filter_fields(form.vars))
        cache.ram.clear()
        response.flash = 'form accepted'
        redirect(URL('index'))
        print "form accepted"
    elif form.errors:
        response.flash = 'form has errors'
        print "form has errors"
    else:
        print "fill out form"
    return dict(form=form)

Every time I add a record it gets inserted twice.
There is a slight difference in records, 1st has no tags added while
the 2nd has the tags correctly added.

Any idea why this is happening ?

Regards,
Nils