Sunday, November 22, 2020

Re: Problem with Postgresql-11.9 ??

Hey David, how are you? Please I need help.

I have been battling with installing psycopg2 on my virtual environment to i can do migration, but I have not been able to do so because whenever i tried make migrations, I receive this

Traceback (most recent call last):
  File "C:\Users\lenovo\Envs\easynet\lib\site-packages\django\db\backends\postgresql\base.py", line 25, in <module>
    import psycopg2 as Database
  File "C:\Users\lenovo\Envs\easynet\lib\site-packages\psycopg2\__init__.py", line 51, in <module>
    from psycopg2._psycopg import (                     # noqa
ModuleNotFoundError: No module named 'psycopg2._psycopg'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\lenovo\miv\ryc\manage.py", line 22, in <module>
    main()
  File "C:\Users\lenovo\miv\ryc\manage.py", line 18, in main
    execute_from_command_line(sys.argv)
  File "C:\Users\lenovo\Envs\easynet\lib\site-packages\django\core\management\__init__.py", line 401, in execute_from_command_line
    utility.execute()
  File "C:\Users\lenovo\Envs\easynet\lib\site-packages\django\core\management\__init__.py", line 377, in execute
    django.setup()
  File "C:\Users\lenovo\Envs\easynet\lib\site-packages\django\__init__.py", line 24, in setup
    apps.populate(settings.INSTALLED_APPS)
  File "C:\Users\lenovo\Envs\easynet\lib\site-packages\django\apps\registry.py", line 114, in populate
    app_config.import_models()
  File "C:\Users\lenovo\Envs\easynet\lib\site-packages\django\apps\config.py", line 211, in import_models
    self.models_module = import_module(models_module_name)
  File "c:\users\lenovo\appdata\local\programs\python\python39\lib\importlib\__init__.py", line 127, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "<frozen importlib._bootstrap>", line 1030, in _gcd_import
  File "<frozen importlib._bootstrap>", line 1007, in _find_and_load

  File "<frozen importlib._bootstrap>", line 986, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 680, in _load_unlocked
  File "<frozen importlib._bootstrap_external>", line 790, in exec_module
  File "<frozen importlib._bootstrap>", line 228, in _call_with_frames_removed
  File "C:\Users\lenovo\miv\ryc\food\models.py", line 3, in <module>
    class Menu(models.Model):
  File "C:\Users\lenovo\Envs\easynet\lib\site-packages\django\db\models\base.py", line 122, in __new__
    new_class.add_to_class('_meta', Options(meta, app_label))
  File "C:\Users\lenovo\Envs\easynet\lib\site-packages\django\db\models\base.py", line 326, in add_to_class
    value.contribute_to_class(cls, name)
  File "C:\Users\lenovo\Envs\easynet\lib\site-packages\django\db\models\options.py", line 206, in contribute_to_class
    self.db_table = truncate_name(self.db_table, connection.ops.max_name_length())
  File "C:\Users\lenovo\Envs\easynet\lib\site-packages\django\db\__init__.py", line 28, in __getattr__
    return getattr(connections[DEFAULT_DB_ALIAS], item)
  File "C:\Users\lenovo\Envs\easynet\lib\site-packages\django\db\utils.py", line 214, in __getitem__
    backend = load_backend(db['ENGINE'])
  File "C:\Users\lenovo\Envs\easynet\lib\site-packages\django\db\utils.py", line 111, in load_backend
    return import_module('%s.base' % backend_name)
  File "c:\users\lenovo\appdata\local\programs\python\python39\lib\importlib\__init__.py", line 127, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "<frozen importlib._bootstrap>", line 1030, in _gcd_import
  File "<frozen importlib._bootstrap>", line 1007, in _find_and_load
  File "<frozen importlib._bootstrap>", line 986, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 680, in _load_unlocked
  File "<frozen importlib._bootstrap_external>", line 790, in exec_module
  File "<frozen importlib._bootstrap>", line 228, in _call_with_frames_removed
  File "C:\Users\lenovo\Envs\easynet\lib\site-packages\django\db\backends\postgresql\base.py", line 29, in <module>
    raise ImproperlyConfigured("Error loading psycopg2 module: %s" % e)

django.core.exceptions.ImproperlyConfigured: Error loading psycopg2 module: No module named 'psycopg2._psycopg'

On Saturday, October 17, 2020 at 5:40:05 AM UTC+1 David Nugent wrote:
Apologies, I must have bumped send accidentally.

To complete the sentence, unless fields have null=True then referencing unsaved records here will fail because there is no id in the dependent records to provide a reference. By default there is a constraint that the reference is not null.

But rather than add null=True to fields, you probably need to ensure those model instances are saved and populated with a valid record before saving your InputTypeMap record.

It would have little to do with the database, any version. That would be the last place I'd go looking for such an issue.

Regards, David

On 17 Oct 2020, at 15:13, David Nugent <dav...@uniquode.io> wrote:

In __your__ code, most certainly.  :-)

You didn't say what 'training', 'input_type' and 'gender' are. It is in one or more of those where the problem exists.

Do these referenced save module instances? If they are not yet saved then it will trigger this error for fields where 



On 13 Oct 2020, at 08:49, Joakim Hove <joaki...@gmail.com> wrote:

Thank you for answering. Just to be sure: you agree that the behavior I describe looks like a bug somewhere?

--
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 view this discussion on the web visit https://groups.google.com/d/msgid/django-users/2958ca44-c62f-446e-84ae-c77ad0164a1dn%40googlegroups.com.

No comments:

Post a Comment