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?

-- 



Reply via email to