I created empty firebird database. Then I included it in welcome app. Web2py created auth tables. Then I registered in welcome app. I want to use this database in my app, but if I include it like:
db = DAL(configuration.get('db.uri'),pool_size=1,migrate_enabled=False,entity_quoting=False,check_reserved=['all'])
I heve error:
<class 'fdb.fbcore.DatabaseError'> ('Error while preparing SQL statement:\n- SQLCODE: -204\n- Dynamic SQL Error\n- SQL error code = -204\n- Table unknown\n- AUTH_USER\n- At line 1, column 233', -204, 335544569)
Версия
| web2py™ | Version 2.18.5-stable+timestamp.2019.04.08.04.22.03 |
|---|
| Python | Python 3.7.3: C:\Program Files (x86)\Python37-32\python.exe (prefix: C:\Program Files (x86)\Python37-32)
|
|---|
If I do like that (without entity_quoting):
db = DAL(configuration.get('db.uri'),pool_size=1,migrate_enabled=False,check_reserved=['all'])
I can login.
Why?
I have one more database some tables was created by web2py some tables was created by me and if I use entity_quoting=False web2py see my tables but I can't login if I don't use it web2py don't see my tables but I can login.