Entity_quoting and Firebird

33 views
Skip to first unread message

Константин Комков

unread,
Jul 17, 2019, 12:17:34 PM7/17/19
to web...@googlegroups.com
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
PythonPython 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.

Константин Комков

unread,
Jul 18, 2019, 7:20:13 AM7/18/19
to web2py-users
I understand - when web2py created auth tables automatically in welcome app I didn't add entity_quoting=False. 
1212.png
Reply all
Reply to author
Forward
0 new messages