After i upgraded to 2.15.3 I got serious problems with Oracle. First of
all: new lowercase tables were created. Then I read that this is due to the
new "entity_quoting" option. Nevertheles I decided to degrade my project to
basic auth tables (nothing more!).
I dropped everything on Oracle side via sqlplus. After first request I got
this error. Migration is active to create tables, "app_auth_user" is
created and then error. No *.table files in databases folder. Fighting
several hours with this (so basic!) issue.
I am getting crazy because of that :(
Note: I changed oracle.py at line 70, because "all parameters were not
converted" error
Can anyone help?
Environment: python 2.7.12, oracle 12.2, cx_Oracle 6.0.1, web2py 2.15.3,
Ubuntu 16.04 LTS
Traceback (most recent call last):
File "/home/zpomianowski/web2py/gluon/restricted.py", line 219, in restricted
exec(ccode, environment)
File "/home/zpomianowski/web2py/applications/eparagon/models/db.py"
<http://127.0.0.1:8000/admin/default/edit/eparagon/models/db.py>, line 59, in
<module>
auth.define_tables(username=False, signature=False)
File "/home/zpomianowski/web2py/gluon/tools.py", line 2216, in define_tables
super(Auth, self).define_tables(username, signature, migrate,
fake_migrate)._table_signature_list
File "/home/zpomianowski/web2py/gluon/authapi.py", line 350, in define_tables
format='%(first_name)s %(last_name)s (%(id)s)'))
File "/home/zpomianowski/web2py/gluon/packages/dal/pydal/base.py", line 587,
in define_table
table = self.lazy_define_table(tablename, *fields, **args)
File "/home/zpomianowski/web2py/gluon/packages/dal/pydal/base.py", line 621,
in lazy_define_table
polymodel=polymodel)
File "/home/zpomianowski/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 797, in create_table
return self.migrator.create_table(*args, **kwargs)
File "/home/zpomianowski/web2py/gluon/packages/dal/pydal/migrator.py", line
277, in create_table
self.adapter.create_sequence_and_triggers(query, table)
File "/home/zpomianowski/web2py/gluon/packages/dal/pydal/adapters/oracle.py",
line 68, in create_sequence_and_triggers
self.execute(query)
File
"/home/zpomianowski/web2py/gluon/packages/dal/pydal/adapters/__init__.py", line
67, in wrap
return f(*args, **kwargs)
File "/home/zpomianowski/web2py/gluon/packages/dal/pydal/adapters/oracle.py",
line 52, in execute
rv = self.cursor.execute(command, *args[1:], **kwargs)
DatabaseError: ORA-00955: name is already used by an existing object
--
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.
