Re: Unable to create the django_migrations table (ORA-00907: missing right parenthesis)

Hi.

Django 2.2 supports Oracle 12.1+. Oracle 11g support was dropped with Django 2.0. If you want to use Oracle 11g (which is out of support anyway from Oracle) you either need to downgrade to Django 1.11 and cx_Oracle 6.4.1

I really suggest you to update at least latest Oracle 12.2 which is still supported by Oracle.

la 27. huhtik. 2019 klo 22.56 tossouwisdom <tossouwisdom@gmail.com> kirjoitti:

Django 2.2.2

Cx_oracle 7.2

base Oracle 11g

When I run the django migrate commande, i have error django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create the django_migrations table (ORA-00907: missing right parenthesis)

  Operations to perform:    Apply all migrations: admin, auth, contenttypes, sessions  Running migrations:  Traceback (most recent call last):    File "C:\Python37-32\lib\site-packages\django\db\backends\utils.py", line 82, in _execute      return self.cursor.execute(sql)    File "C:\Python37-32\lib\site-packages\django\db\backends\oracle\base.py", line 510, in execute      return self.cursor.execute(query, self._param_generator(params))  cx_Oracle.DatabaseError: ORA-00907: missing right parenthesis    The above exception was the direct cause of the following exception:    Traceback (most recent call last):    File "C:\Python37-32\lib\site-packages\django\db\migrations\recorder.py", line 67, in ensure_schema      editor.create_model(self.Migration)    File "C:\Python37-32\lib\site-packages\django\db\backends\base\schema.py", line 307, in create_model      self.execute(sql, params or None)    File "C:\Python37-32\lib\site-packages\django\db\backends\base\schema.py", line 137, in execute      cursor.execute(sql, params)    File "C:\Python37-32\lib\site-packages\django\db\backends\utils.py", line 99, in execute      return super().execute(sql, params)    File "C:\Python37-32\lib\site-packages\django\db\backends\utils.py", line 67, in execute      return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)    File "C:\Python37-32\lib\site-packages\django\db\backends\utils.py", line 76, in _execute_with_wrappers      return executor(sql, params, many, context)    File "C:\Python37-32\lib\site-packages\django\db\backends\utils.py", line 84, in _execute      return self.cursor.execute(sql, params)    File "C:\Python37-32\lib\site-packages\django\db\utils.py", line 89, in __exit__      raise dj_exc_value.with_traceback(traceback) from exc_value    File "C:\Python37-32\lib\site-packages\django\db\backends\utils.py", line 82, in _execute      return self.cursor.execute(sql)    File "C:\Python37-32\lib\site-packages\django\db\backends\oracle\base.py", line 510, in execute      return self.cursor.execute(query, self._param_generator(params))  django.db.utils.DatabaseError: ORA-00907: missing right parenthesis    During handling of the above exception, another exception occurred:    Traceback (most recent call last):    File "manage.py", line 21, in <module>      main()    File "manage.py", line 17, in main      execute_from_command_line(sys.argv)    File "C:\Python37-32\lib\site-packages\django\core\management\__init__.py", line 381, in execute_from_command_line      utility.execute()    File "C:\Python37-32\lib\site-packages\django\core\management\__init__.py", line 375, in execute      self.fetch_command(subcommand).run_from_argv(self.argv)    File "C:\Python37-32\lib\site-packages\django\core\management\base.py", line 323, in run_from_argv      self.execute(*args, **cmd_options)    File "C:\Python37-32\lib\site-packages\django\core\management\base.py", line 364, in execute      output = self.handle(*args, **options)    File "C:\Python37-32\lib\site-packages\django\core\management\base.py", line 83, in wrapped      res = handle_func(*args, **kwargs)    File "C:\Python37-32\lib\site-packages\django\core\management\commands\migrate.py", line 234, in handle      fake_initial=fake_initial,    File "C:\Python37-32\lib\site-packages\django\db\migrations\executor.py", line 91, in migrate      self.recorder.ensure_schema()    File "C:\Python37-32\lib\site-packages\django\db\migrations\recorder.py", line 69, in ensure_schema      raise MigrationSchemaMissing("Unable to create the django_migrations table (%s)" % exc)  django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create the django_migrations table (ORA-00907: missing right parenthesis)

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/dac2cda6-2543-4664-aea5-025473ecc3e5%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAHn91oe5OqEGg86Z2bTyVjkr1UwqWAX7DrqbjZE11NJ5qKHULg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.