This helps. I think I just fixed it in trunk. Can you check and confirm if it is fixed?
On Tuesday, 7 August 2012 04:35:33 UTC-5, Elton Pereira de Lima wrote: > > Same error. > > One detail I forgot to mention, this only happens when I use mongodb. > > Follows the traceback: > > Traceback (most recent call last): > File "/home/eltonplima/workspace/web2py/2.0/web2py/gluon/restricted.py", > line 205, in restricted > exec ccode in environment > File > "/home/eltonplima/workspace/web2py/2.0/web2py/applications/sqm/controllers/appadmin.py" > <http://127.0.0.1:8000/admin/default/edit/sqm/controllers/appadmin.py>, line > 432, in <module> > File "/home/eltonplima/workspace/web2py/2.0/web2py/gluon/globals.py", line > 182, in <lambda> > self._caller = lambda f: f() > File > "/home/eltonplima/workspace/web2py/2.0/web2py/applications/sqm/controllers/appadmin.py" > <http://127.0.0.1:8000/admin/default/edit/sqm/controllers/appadmin.py>, line > 126, in insert > form = SQLFORM(db[table], ignore_rw=ignore_rw) > File "/home/eltonplima/workspace/web2py/2.0/web2py/gluon/sqlhtml.py", line > 920, in __init__ > inp = self.widgets.options.widget(field, default) > File "/home/eltonplima/workspace/web2py/2.0/web2py/gluon/sqlhtml.py", line > 224, in widget > options = requires[0].options() > File "/home/eltonplima/workspace/web2py/2.0/web2py/gluon/validators.py", > line 479, in options > self.build_set() > File "/home/eltonplima/workspace/web2py/2.0/web2py/gluon/validators.py", > line 466, in build_set > records = self.dbset(table).select(*fields, **dd) > File "/home/eltonplima/workspace/web2py/2.0/web2py/gluon/dal.py", line > 8416, in select > return adapter.select(self.query,fields,attributes) > File "/home/eltonplima/workspace/web2py/2.0/web2py/gluon/dal.py", line > 4854, in select > self._select(query,fields,attributes) > File "/home/eltonplima/workspace/web2py/2.0/web2py/gluon/dal.py", line > 4802, in _select > raise SyntaxError, 'invalid select attribute: %s' % key > SyntaxError: invalid select attribute: distinct > > > On Tuesday, August 7, 2012 12:01:49 AM UTC-3, Cliff Kachinske wrote: >> >> I have created this problem by adding the unique argument to a table >> column after populating it with data. try removing it from the has_line >> field. >> >> On Monday, August 6, 2012 8:19:36 PM UTC-4, Elton Pereira de Lima wrote: >>> >>> 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? >>> >> --
