I get this error when trying to insert a record manually from a sqlform: SyntaxError: Field _autocomplete_name_aux does not belong to the table
Controller line is:
form.vars.id = table.insert(**dict(form.vars))
Model definition has a field using the autocomplete widget:
db.define_table('order',
Field('product', db.product,
widget = SQLFORM.widgets.autocomplete(request,
db.product.name, id_field=db.product.id)),

