the reserve keyword in firebird works but when use it with another table
relation (reference type) it returns an error
*step to reproduce an error*
*#create database firebird on ubuntu terminal*
isql-fb -user SYSDBA -password password
CREATE DATABASE '/testdb.fdb' user 'SYSDBA' password 'password';
quit;
chmod 777 /testdb.fdb
*create new web2py app (latest version 2.15.4)*
*private/appconfig.ini*
uri = firebird://SYSDBA:password@localhost:3050//testdb.fdb
*models/db.py*
auth.settings.password_field = 'password2'
auth.define_tables(username = False, signature = False, migrate = False)
db.define_table('mytable', Field('myfield', 'reference auth_user') )
when define any table that reference to auth_user table, it return an error
Traceback (most recent call last):
File "/home/site/web2py/gluon/restricted.py", line 219, in restricted
exec(ccode, environment)
File "/home/site/web2py/applications/a/models/db.py"
<https://192.168.1.80/admin/default/edit/a/models/db.py>, line 135, in <module>
db.define_table('mytable', Field('myfield', 'reference auth_user') )
File "/home/site/web2py/gluon/packages/dal/pydal/base.py", line 587, in
define_table
table = self.lazy_define_table(tablename, *fields, **args)
File "/home/site/web2py/gluon/packages/dal/pydal/base.py", line 621, in
lazy_define_table
polymodel=polymodel)
File "/home/site/web2py/gluon/packages/dal/pydal/adapters/base.py", line 797,
in create_table
return self.migrator.create_table(*args, **kwargs)
File "/home/site/web2py/gluon/packages/dal/pydal/migrator.py", line 277, in
create_table
self.adapter.create_sequence_and_triggers(query, table)
File "/home/site/web2py/gluon/packages/dal/pydal/adapters/firebird.py", line
58, in create_sequence_and_triggers
self.execute(query)
File "/home/site/web2py/gluon/packages/dal/pydal/adapters/__init__.py", line
67, in wrap
return f(*args, **kwargs)
File "/home/site/web2py/gluon/packages/dal/pydal/adapters/base.py", line 412,
in execute
rv = self.cursor.execute(command, *args[1:], **kwargs)
ProgrammingError: (-607, 'isc_dsql_execute: \n unsuccessful metadata update\n
Table auth_user not found')
any idea how to fix it?
another things is tested the driver fdb (installed from pip is not work),
work using kinterbasdb python driver from ubuntu repo
thanks and best regards,
stifan
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
