I'm using the latest development version, and try to add a record by the administrative interface the following exception is raised: invalid <type'exceptions.SyntaxError'> select attribute: distinct
The error happens when trying to insert in squid_log table. db.define_table('squid_internal_host', Field('ip', 'text', notnull=True, unique=True), Field('hostname', 'string', length=32, unique=True,), format='%(ip)s', migrate=True) db.define_table('squid_log', Field('timestamp', 'datetime', notnull=True), Field('internal_host', db.squid_internal_host), Field('log_line', 'text', notnull=True), Field('elapsed_time', 'integer', notnull=True), Field('hash_line', 'string', notnull=True, length=64, unique=True,), Field('insert_timestamp', 'datetime', default=lambda:datetime.datetime.now()), format='%(hash_line)s') I'm doing something wrong? --