Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

raise FullResultSet django.core.exceptions.FullResultSet with sql server database #360

Open
MagloireKITIO opened this issue Oct 2, 2024 · 0 comments

Comments

@MagloireKITIO
Copy link

Hello, I have This error when i want to make migration on sql server database

python manage.py makemigrations
(0.140) QUERY = "SELECT CAST(SERVERPROPERTY('ProductVersion') AS varchar)" - PARAMS = (); args=None; alias=default
(0.125) QUERY = 'SELECT SYSDATETIME()' - PARAMS = (); args=None; alias=default
(0.140) QUERY = "SELECT CAST(SERVERPROPERTY('ProductVersion') AS varchar)" - PARAMS = (); args=None; alias=default
(0.141) QUERY = 'SELECT SYSDATETIME()' - PARAMS = (); args=None; alias=default
(0.125) QUERY = 'SET NOCOUNT OFF; UPDATE [biometric_biometricdevices] SET [is_live] = %s' - PARAMS = (0,); args=(False,); alias=default
(0.172) QUERY = 'SELECT TABLE_NAME, TABLE_TYPE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = SCHEMA_NAME()' - PARAMS = (); args=None; alias=default
Traceback (most recent call last):
File "C:\Users\stage.dsi.pmo\Documents\Projet Dev\Activa Hr\activahr\manage.py", line 22, in
main()
File "C:\Users\stage.dsi.pmo\Documents\Projet Dev\Activa Hr\activahr\manage.py", line 18, in main
execute_from_command_line(sys.argv)
File "C:\Users\stage.dsi.pmo\Documents\Projet Dev\Activa Hr\activahr.venv\Lib\site-packages\django\core\management_init_.py", line 442, in execute_from_command_line
utility.execute()
File "C:\Users\stage.dsi.pmo\Documents\Projet Dev\Activa Hr\activahr.venv\Lib\site-packages\django\core\management_init_.py", line 436, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "C:\Users\stage.dsi.pmo\Documents\Projet Dev\Activa Hr\activahr.venv\Lib\site-packages\django\core\management\base.py", line 412, in run_from_argv
self.execute(*args, **cmd_options)
File "C:\Users\stage.dsi.pmo\Documents\Projet Dev\Activa Hr\activahr.venv\Lib\site-packages\django\core\management\base.py", line 458, in execute
output = self.handle(*args, **options)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\stage.dsi.pmo\Documents\Projet Dev\Activa Hr\activahr.venv\Lib\site-packages\django\core\management\base.py", line 106, in wrapper
res = handle_func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\stage.dsi.pmo\Documents\Projet Dev\Activa Hr\activahr.venv\Lib\site-packages\django\core\management\commands\makemigrations.py", line 158, in handle
loader.check_consistent_history(connection)
File "C:\Users\stage.dsi.pmo\Documents\Projet Dev\Activa Hr\activahr.venv\Lib\site-packages\django\db\migrations\loader.py", line 313, in check_consistent_history
applied = recorder.applied_migrations()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\stage.dsi.pmo\Documents\Projet Dev\Activa Hr\activahr.venv\Lib\site-packages\django\db\migrations\recorder.py", line 82, in applied_migrations
return {
^
File "C:\Users\stage.dsi.pmo\Documents\Projet Dev\Activa Hr\activahr.venv\Lib\site-packages\django\db\models\query.py", line 398, in iter
self._fetch_all()
File "C:\Users\stage.dsi.pmo\Documents\Projet Dev\Activa Hr\activahr.venv\Lib\site-packages\django\db\models\query.py", line 1881, in _fetch_all
self._result_cache = list(self._iterable_class(self))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\stage.dsi.pmo\Documents\Projet Dev\Activa Hr\activahr.venv\Lib\site-packages\django\db\models\query.py", line 91, in iter
results = compiler.execute_sql(
^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\stage.dsi.pmo\Documents\Projet Dev\Activa Hr\activahr.venv\Lib\site-packages\django\db\models\sql\compiler.py", line 1549, in execute_sql sql, params = self.as_sql()
^^^^^^^^^^^^^
File "C:\Users\stage.dsi.pmo\Documents\Projet Dev\Activa Hr\activahr.venv\Lib\site-packages\sql_server\pyodbc\compiler.py", line 189, in as_sql
where, w_params = self.compile(self.where) if self.where is not None else ("", [])
^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\stage.dsi.pmo\Documents\Projet Dev\Activa Hr\activahr.venv\Lib\site-packages\sql_server\pyodbc\compiler.py", line 358, in compile
return super().compile(node, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\stage.dsi.pmo\Documents\Projet Dev\Activa Hr\activahr.venv\Lib\site-packages\django\db\models\sql\compiler.py", line 546, in compile
sql, params = node.as_sql(self, self.connection)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\stage.dsi.pmo\Documents\Projet Dev\Activa Hr\activahr.venv\Lib\site-packages\django\db\models\sql\where.py", line 174, in as_sql
raise FullResultSet
django.core.exceptions.FullResultSet

@MagloireKITIO MagloireKITIO changed the title raise FullResultSet django.core.exceptions.FullResultSet raise FullResultSet django.core.exceptions.FullResultSet with sql server database Oct 2, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant