search

michiya / django-pyodbc-azure

Django backend for Microsoft SQL Server and Azure SQL Database using pyodbc
https://pypi.python.org/pypi/django-pyodbc-azure
BSD 3-Clause "New" or "Revised" License
321 stars 140 forks source link

COUNT field incorrect or syntax error Django 1.11.20 #198

Open julian-patmos opened 5 years ago

julian-patmos commented 5 years ago

When I run the migrations they fail with the following error message

lib/python3.6/site-packages/sql_server/pyodbc/base.py", line 575, in execute     return self.cursor.execute(sql, params) django.db.utils.Error: ('07002', '[07002] [Microsoft][ODBC Driver 17 for SQL Server]COUNT field incorrect or syntax error (0) (SQLExecDirectW)')

onkar-bagade commented 4 years ago

hey did you find solution to this problem. i am facing some what similar issue when i am trying to return paginated response in Django rest framework