did you alter in any way the auth_user table ? On Thursday, January 21, 2016 at 8:43:07 PM UTC+1, Alessio Varalta wrote: > > Hi I have a database in sqlite..today I try to add new table..very simple > > db.define_table('viewnews', > Field('user_id','reference > auth_user',requires=IS_NOT_EMPTY()), > ) > > but when i insert a row a have this error > > Traceback (most recent call last): > File "/home/www-data/web2py/applications/coop/controllers/appadmin.py", > line 269, in select > *fields, limitby=(start, stop)) > File "/home/www-data/web2py/gluon/packages/dal/pydal/objects.py", line > 2002, in select > return adapter.select(self.query,fields,attributes) > File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/sqlite.py", > line 122, in select > return super(SQLiteAdapter, self).select(query, fields, attributes) > File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", > line 1286, in select > return self._select_aux(sql,fields,attributes) > File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", > line 1243, in _select_aux > self.execute(sql) > File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", > line 1378, in execute > return self.log_execute(*a, **b) > File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", > line 1372, in log_execute > ret = self.cursor.execute(command, *a[1:], **b) > File "/usr/lib/python2.7/sqlite3/dbapi2.py", line 65, in convert_date > return datetime.date(*map(int, val.split("-"))) > TypeError: Required argument 'month' (pos 2) not found > > I don't understand the reason..without this table all work perfec > > >
-- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.