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?
--