[web2py] cpdb.py 'Cannot resolve reference auth_group in auth_permission'

I'm having the following messages when trying to copy a sqlite:// database. EXCEPTION: could not make a copy of the database 'Cannot resolve reference auth_group in auth_permission' When it happens, the only tables created in the database are: - auth_user - sqlite_sequence auth_permission.goup_i

[web2py] Which DB is best suited for many single entry to one table ?

I have a geolocalisation application with 2 tables of interest i.e. db.define_table('device', notnull=True, ...) db.define_table('wp', 'device', type=reference device, notnull=True, ...) The 'device' table may have several hundreds entries, while the 'wp' table holding GPS-coordinates may have t

[web2py] Re: Ticket ID __init__() got an unexpected keyword argument 'default'

Thanks Massimo, In fact this is on a system provided by a ISP, so I don't know how to fix the problem. I will ask the ISP maintainers. Regards, Andre On Monday, October 28, 2013 5:24:25 AM UTC+1, arutti wrote: > > Hello, > > This is a json error which doesn't occur on my

[web2py] DAL in intreactive shell - strange behaviour

Hi, I'm trying to use DAL in web2py interactive shell. The troubles is that DAL doesn' show the already defined tables. I can create new tables perfectly They show up in SQLLite manager (Firefox add-on). After closing/reopening the shell, it's as if the database connexion didn't work correctly.

[web2py] Ticket ID __init__() got an unexpected keyword argument 'default'

Hello, This is a json error which doesn't occur on my dev. system Windows 7, same version of web2py and python2.7 web2py™Version 2.7.4-stable+timestamp.2013.10.14.15.16.29PythonPython 2.6.6: /usr/languages/python/2.6/bin/python (prefix: /usr/languages/python/2.6)Traceback 1. 2. 3. 4. 5. 6. 7.

[web2py] Ticket ID No module named modules

Hello, This error doesn't occur on my dev. system Windows 7, same version of web2py and python2.7 web2py™Version 2.7.4-stable+timestamp.2013.10.14.15.16.29PythonPython 2.6.6: /usr/languages/python/2.6/bin/python (prefix: /usr/languages/python/2.6)Traceback 1. 2. 3. 4. 5. 6. 7. 8. 9. Traceba

[web2py] Re: help needed for a query for one to many relation

Hi Martin, It works well, thanks Best regards, Andre On Sep 30, 2:52 pm, Marin Pranjić wrote: > On Fri, Sep 30, 2011 at 9:10 AM, arutti wrote: > > Hello, > > > I'm trying to make this simple query > > > SELECT a.*, s.* FROM account a, statement s WHERE a.nb = &

[web2py] Re: help needed for a query for one to many relation

After much trial and re-re-..-reading the book, I came to this solution: acc = db.account(nb=2110) # to find the account stats = db((db.statement.debit==acc.id) | (db.statement.credit==acc.id) ).select() # to find the statements Best regards On Sep 30, 9:10 am, arutti wrote: > Hello, >

[web2py] help needed for a query for one to many relation

Hello, I'm trying to make this simple query SELECT a.*, s.* FROM account a, statement s WHERE a.nb = '2110' AND (a.id = s.debit OR a.id = s.credit) with query, set, rows objects the tables are defined as follow: . db.define_table('account', Field('id','id', represent=lambda id