#29777: ORA-00933: SQL command not properly ended with pagination in a 
ModelViewSet
-------------------------------------+-------------------------------------
     Reporter:  zorky                |                    Owner:  nobody
         Type:  Bug                  |                   Status:  closed
    Component:  Database layer       |                  Version:  2.1
  (models, ORM)                      |
     Severity:  Normal               |               Resolution:  invalid
     Keywords:                       |             Triage Stage:
  orm,oracle,pagination              |  Unreviewed
    Has patch:  0                    |      Needs documentation:  0
  Needs tests:  0                    |  Patch needs improvement:  0
Easy pickings:  0                    |                    UI/UX:  0
-------------------------------------+-------------------------------------

Comment (by zorky):

 Hi,

   Thanks for your response.
   I juste downgraded to '''Django 2.0.6''' (with DRF 3.8.2, django-filters
 2.0) and '''it's working fine with no errors'''.

   Thx

 pip freeze :

 {{{
 # pip freeze
 absl-py==0.5.0
 appdirs==1.4.3
 asn1crypto==0.24.0
 astor==0.7.1
 attrs==18.2.0
 backcall==0.1.0
 behave==1.2.6
 behave-django==1.1.0
 bleach==2.1.4
 cached-property==1.5.1
 cairocffi==0.9.0
 CairoSVG==2.1.3
 certifi==2018.8.24
 cffi==1.11.5
 chardet==3.0.4
 click==6.7
 coreapi==2.3.3
 coreapi-cli==1.0.9
 coreschema==0.0.4
 cryptography==2.3.1
 cssselect2==0.2.1
 cx-Oracle==5.2.1
 Cython==0.28.5
 decorator==4.3.0
 defusedxml==0.5.0
 Django==2.0.6
 django-auth-ldap==1.7.0
 django-cleanup==2.1.0
 django-cors-headers==2.4.0
 django-debug-toolbar==1.10.1
 django-extensions==2.1.2
 django-filter==2.0.0
 django-mail-templated==2.6.5
 django-polymorphic==2.0.3
 django-rest-swagger==2.2.0
 django-treebeard==4.3
 django-xworkflows==0.12.3
 djangorestframework==3.8.2
 djangorestframework-jwt==1.11.0
 easy-thumbnails==2.5
 entrypoints==0.2.3
 et-xmlfile==1.0.1
 factory-boy==2.11.1
 Faker==0.9.1
 gast==0.2.0
 greenlet==0.4.15
 grpcio==1.15.0
 gunicorn==19.9.0
 html5lib==1.0.1
 idna==2.7
 ipykernel==4.9.0
 ipython==6.5.0
 ipython-genutils==0.2.0
 ipywidgets==7.4.2
 isodate==0.6.0
 itypes==1.1.0
 jdcal==1.4
 jedi==0.12.1
 Jinja2==2.10
 jsonschema==2.6.0
 jupyter==1.0.0
 jupyter-client==5.2.3
 jupyter-console==5.2.0
 jupyter-core==4.4.0
 lxml==4.2.5
 Markdown==2.6.11
 MarkupSafe==1.0
 meinheld==0.6.1
 mistune==0.8.3
 nbconvert==5.4.0
 nbformat==4.4.0
 notebook==5.7.0
 numpy==1.15.1
 openapi-codec==1.3.2
 openpyxl==2.5.7
 pandas==0.23.4
 pandocfilters==1.4.2
 parse==1.8.4
 parse-type==0.4.2
 parso==0.3.1
 pdfrw==0.4
 pexpect==4.6.0
 pickleshare==0.7.4
 Pillow==5.2.0
 prometheus-client==0.3.1
 prompt-toolkit==1.0.15
 protobuf==3.6.1
 psycopg2-binary==2.7.5
 ptyprocess==0.6.0
 pyasn1==0.4.4
 pyasn1-modules==0.2.2
 pycparser==2.19
 Pygments==2.2.0
 PyJWT==1.6.4
 pyldap==3.0.0.post1
 Pyphen==0.9.5
 python-dateutil==2.7.3
 python-ldap==3.1.0
 pytz==2018.5
 PyYAML==3.13
 pyzmq==17.1.2
 qtconsole==4.4.1
 raven==6.9.0
 requests==2.19.1
 requests-toolbelt==0.8.0
 Send2Trash==1.5.0
 simplegeneric==0.8.1
 simplejson==3.16.0
 six==1.11.0
 sqlparse==0.2.4
 tensorboard==1.10.0
 tensorflow==1.10.1
 tensorflow-hub==0.1.1
 termcolor==1.1.0
 terminado==0.8.1
 testpath==0.3.1
 text-unidecode==1.2
 tinycss2==0.6.1
 tornado==5.1.1
 traitlets==4.3.2
 Unidecode==1.0.22
 uritemplate==3.0.0
 urllib3==1.23
 wcwidth==0.1.7
 WeasyPrint==0.42.3
 webencodings==0.5.1
 Werkzeug==0.14.1
 widgetsnbextension==3.4.2
 xworkflows==1.0.4
 zeep==3.1.0

 }}}

 Replying to [comment:1 Carlton Gibson]:
 > Hi...
 >
 > > After an upgrade from Django 2.0.6 to Django 2.1.1 and DRF 3.8.2...
 >
 > OK. DRF 3.8.2 supports both Django 2.x and Django 2.1.x. Can you please
 downgrade Django (and keep DRF 3.8.2) and verify it works there?
 > (Then at least the change is presumably in Django, rather than DRF or
 your code.)
 >
 > If so, could you then git bisect to find the change? (See
 [https://docs.djangoproject.com/en/dev/internals/contributing/triaging-
 tickets/#bisecting-a-regression the guide on using bisect].)
 >
 > Ideally we need to reduce this down to an issue that only involves
 Django itself...

-- 
Ticket URL: <https://code.djangoproject.com/ticket/29777#comment:3>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/063.2cbea15df8f3ecedd0aca0f3f128d0e7%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to