same problem here. I also changed line 70 as stated below but still I get the error " not all arguments converted during string formatting"
line 70, in create_sequence_and_triggers Only the table auth_users is created but no sequence (I cloned the current git master brunch) How can I get web2py work with Oracle (12c) best regards Sven Am Donnerstag, 24. August 2017 01:57:14 UTC+2 schrieb Zbigniew Pomianowski: > > 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.
