• 1402/05/22

ProgramingError هنگام اجرای migrate در پابلیش :

سلام استاد 

من برای پابلیش با ویدیو پیش رفتم ولی هنگام اجرای دستور migrate به مشکل خوردم  اگه میشه راهنمایی کنید 

متن ارور :

django.db.utils.ProgrammingError: (1146, "1146 (42S02): Table 'aryanka1_db_pajoheshsara.user_module_user' doesn't exist", '42S02')
  • 1402/05/24
  • ساعت 09:13

سلام دوست من

در پروژه شما برای migration ها مشکلی ایجاد شده

لطفا وارد هر app بشین و migration ها رو به جز فایل init در هر پوشه پاک کنین

مجددا دستور makemigrations رو بزنین

دیتابیس رو از سرور پاک کنین و مجدد ایجاد کنین

دستور migrate رو یک بار دیگه بزنین و تست کنین

اگه مشکل داشت از mysqlclient استفاده کنین که البته نیاز هستش engin مربوط به دیتابیس رو در تنظیمات تغییر بدین

موفق باشین :)


  • 1402/05/24
  • ساعت 12:34

سلام 

روش اول مشکل رو حل نکرد . برای روش دوم وقتی میخوام mysqlclient رو نصب کنم ارور میده . برای استفاده از mysqlclient باید فقط تنظیمات رو تغیر بدیم ؟ یا باید کلا یک دیتابیس دیگه بسازیم ؟ 

ارور : 

((pajoheshsara:3.8)) [aryanka1@forouhar pajoheshsara]$ pip install mysqlclient
Collecting mysqlclient
  Using cached mysqlclient-2.2.0.tar.gz (89 kB)
  Installing build dependencies ... done
  Getting requirements to build wheel ... done
  Installing backend dependencies ... done
  Preparing metadata (pyproject.toml) ... done
Building wheels for collected packages: mysqlclient
  Building wheel for mysqlclient (pyproject.toml) ... error
  ERROR: Command errored out with exit status 1:
   command: /home/aryanka1/virtualenv/pajoheshsara/3.8/bin/python3.8_bin /home/aryanka1/virtualenv/pajoheshsara/3.8/lib/python3.8/site-packages/pip/_vendor/pep517/in_process/_in_process.py build_wheel /tmp/tmpsrejrcyd
       cwd: /tmp/pip-install-ari53gbz/mysqlclient_3b91c2fbbf1e49fd9cbbaf7680c74759
  Complete output (45 lines):
  Trying pkg-config --exists mysqlclient
  Command 'pkg-config --exists mysqlclient' returned non-zero exit status 1.
  Trying pkg-config --exists mariadb
  # Options for building extention module:
    extra_compile_args: ['-I/usr/include/mysql', '-std=c99']
    extra_link_args: ['-pthread', '-lmariadb', '-ldl', '-lm', '-lpthread', '-lssl', '-lcrypto', '-lz']
    define_macros: [('version_info', (2, 2, 0, 'final', 0)), ('__version__', '2.2.0')]
  running bdist_wheel
  running build
  running build_py
  creating build
  creating build/lib.linux-x86_64-cpython-38
  creating build/lib.linux-x86_64-cpython-38/MySQLdb
  copying src/MySQLdb/__init__.py -> build/lib.linux-x86_64-cpython-38/MySQLdb
  copying src/MySQLdb/_exceptions.py -> build/lib.linux-x86_64-cpython-38/MySQLdb
  copying src/MySQLdb/connections.py -> build/lib.linux-x86_64-cpython-38/MySQLdb
  copying src/MySQLdb/converters.py -> build/lib.linux-x86_64-cpython-38/MySQLdb
  copying src/MySQLdb/cursors.py -> build/lib.linux-x86_64-cpython-38/MySQLdb
  copying src/MySQLdb/release.py -> build/lib.linux-x86_64-cpython-38/MySQLdb
  copying src/MySQLdb/times.py -> build/lib.linux-x86_64-cpython-38/MySQLdb
  creating build/lib.linux-x86_64-cpython-38/MySQLdb/constants
  copying src/MySQLdb/constants/CLIENT.py -> build/lib.linux-x86_64-cpython-38/MySQLdb/constants
  copying src/MySQLdb/constants/CR.py -> build/lib.linux-x86_64-cpython-38/MySQLdb/constants
  copying src/MySQLdb/constants/ER.py -> build/lib.linux-x86_64-cpython-38/MySQLdb/constants
  copying src/MySQLdb/constants/FIELD_TYPE.py -> build/lib.linux-x86_64-cpython-38/MySQLdb/constants
  copying src/MySQLdb/constants/FLAG.py -> build/lib.linux-x86_64-cpython-38/MySQLdb/constants
  copying src/MySQLdb/constants/__init__.py -> build/lib.linux-x86_64-cpython-38/MySQLdb/constants
  running egg_info
  writing src/mysqlclient.egg-info/PKG-INFO
  writing dependency_links to src/mysqlclient.egg-info/dependency_links.txt
  writing top-level names to src/mysqlclient.egg-info/top_level.txt
  reading manifest file 'src/mysqlclient.egg-info/SOURCES.txt'
  reading manifest template 'MANIFEST.in'
  adding license file 'LICENSE'
  writing manifest file 'src/mysqlclient.egg-info/SOURCES.txt'
  copying src/MySQLdb/_mysql.c -> build/lib.linux-x86_64-cpython-38/MySQLdb
  running build_ext
  building 'MySQLdb._mysql' extension
  creating build/temp.linux-x86_64-cpython-38
  creating build/temp.linux-x86_64-cpython-38/src
  creating build/temp.linux-x86_64-cpython-38/src/MySQLdb
  gcc -Wno-unused-result -Wsign-compare -DNDEBUG -D_GNU_SOURCE -fPIC -fwrapv -O2 -pthread -Wno-unused-result -Wsign-compare -g -std=c99 -Wextra-Wno-unused-parameter -Wno-missing-field-initializers -Werror=implicit-function-declaration -D_GNU_SOURCE -fPIC -fwrapv -D_GNU_SOURCE -fPIC -fwrapv -O2 -pthread -Wno-unused-result -Wsign-compare -g -std=c99 -Wextra -Wno-unused-parameter -Wno-missing-field-initializers -Werror=implicit-function-declaration -D_GNU_SOURCE -fPIC -fwrapv -O2 -pthread -Wno-unused-result -Wsign-compare -g -std=c99 -Wextra -Wno-unused-parameter -Wno-missing-field-initializers -Werror=implicit-function-declaration -fPIC "-Dversion_info=(2, 2, 0, 'final', 0)" -D__version__=2.2.0 -I/home/aryanka1/virtualenv/pajoheshsara/3.8/include -I/opt/alt/python38/include/python3.8 -c src/MySQLdb/_mysql.c -o build/temp.linux-x86_64-cpython-38/src/MySQLdb/_mysql.o -I/usr/include/mysql -std=c99
  /tmp/pip-build-env-n9fdjxac/overlay/lib/python3.8/site-packages/setuptools/config/pyprojecttoml.py:66: _BetaConfiguration: Support for `[tool.setuptools]` in `pyproject.toml` is still *beta*.
    config = read_configuration(filepath, True, ignore_option_errors, dist)
  error: command '/bin/gcc' failed: Permission denied
  ----------------------------------------
  ERROR: Failed building wheel for mysqlclient
Failed to build mysqlclient
ERROR: Could not build wheels for mysqlclient, which is required to install pyproject.toml-based projects

  • 1402/05/27
  • ساعت 20:10

برای نصب این پکیج باید از پشتیبانی سرور کمک بگیرین

این پکیج به c++ builder نیاز داره که عملا شما دسترسی نصبش رو ندارین

به پشتیبانی سرور بگین که مشکل رو برطرف کنن


  • 1402/05/31
  • ساعت 18:54

سلام 

پشتیبانی پکیج رو برام نصب کرد و mysqlclient نصب شد 

الان یک ارور دیگه برای migrate کردن میده

ارور : 

((django/pajoheshsara:3.8)) [aryanka1@forouhar django_pajoheshsara]$ python manage.py migrate
Traceback (most recent call last):  File "manage.py", line 22, in <module>
    main()
  File "manage.py", line 18, in main
    execute_from_command_line(sys.argv)
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/core/management/__init__.py", line 442, in execute_from_command_line
    utility.execute()  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/core/management/__init__.py", line 436, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/core/management/base.py", line 412, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/core/management/base.py", line 458, in execute    output = self.handle(*args, **options)
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/core/management/base.py", line 106, in wrapper
    res = handle_func(*args, **kwargs)
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/core/management/commands/migrate.py", line 100, inhandle
    self.check(databases=[database])
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/core/management/base.py", line 485, in check
    all_issues = checks.run_checks(
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/core/checks/registry.py", line 88, in run_checks
    new_errors = check(app_configs=app_configs, databases=databases)
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/core/checks/model_checks.py", line 36, in check_all_models
    errors.extend(model.check(**kwargs))
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/db/models/base.py", line 1558, in check
    *cls._check_indexes(databases),
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/db/models/base.py", line 2002, in _check_indexes
    connection.features.supports_expression_indexes
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/utils/functional.py", line 57, in __get__
    res = instance.__dict__[self.name] = self.func(instance)
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/db/backends/mysql/features.py", line 317, in supports_expression_indexes
    not self.connection.mysql_is_mariadb
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/utils/functional.py", line 57, in __get__
    res = instance.__dict__[self.name] = self.func(instance)
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/db/backends/mysql/base.py", line 439, in mysql_is_mariadb
    return "mariadb" in self.mysql_server_info.lower()
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/utils/functional.py", line 57, in __get__
    res = instance.__dict__[self.name] = self.func(instance)
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/db/backends/mysql/base.py", line 425, in mysql_server_info
    return self.mysql_server_data["version"]
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/utils/functional.py", line 57, in __get__
    res = instance.__dict__[self.name] = self.func(instance)
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/db/backends/mysql/base.py", line 399, in mysql_server_data
    with self.temporary_connection() as cursor:
  File "/opt/alt/python38/lib64/python3.8/contextlib.py", line 113, in __enter__
    return next(self.gen)
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/db/backends/base/base.py", line 705, in temporary_connection
    with self.cursor() as cursor:
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/utils/asyncio.py", line 26, in inner
    return func(*args, **kwargs)
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/db/backends/base/base.py", line 330, in cursor
    return self._cursor()
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/db/backends/base/base.py", line 306, in _cursor
    self.ensure_connection()
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/utils/asyncio.py", line 26, in inner
    return func(*args, **kwargs)
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection
    self.connect()
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/utils/asyncio.py", line 26, in inner
    return func(*args, **kwargs)
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/db/backends/base/base.py", line 272, in connect
    self.init_connection_state()
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/db/backends/mysql/base.py", line 257, in init_connection_state
    super().init_connection_state()
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/db/backends/base/base.py", line 239, in init_connection_state
    self.check_database_version_supported()
  File "/home/aryanka1/virtualenv/django_pajoheshsara/3.8/lib/python3.8/site-packages/django/db/backends/base/base.py", line 214, in check_database_version_supported
    raise NotSupportedError(
django.db.utils.NotSupportedError: MariaDB 10.4 or later is required (found 10.3.39).

من از این لینک استفاده کردم ولی به نتیجه ای نرسیدم 

https://stackoverflow.com/questions/74233986/how-to-solve-django-db-utils-notsupportederror-in-django

همه ی مراحلش رو انجام دادم ولی من پوشه ی date رو نمیتونم پیدا کنم توی پوشه ای که اکسترکت کردم 

و توی فایل me این خط وجود نداره : innodb_additional_mem_pool_size = 2M

 


  • 1402/06/03
  • ساعت 20:53

مشکل نسخه ی mysql هستش دوست من

به پشتیبانی سرور تیکت بزنین و ازشون بپرسین که نسخه ی mariadb سرور شما چند هستش

شما به نسخه ی 10.3.39 نیاز دارین ( البته حداقل )

موفق باشین :)


  • 1402/06/05
  • ساعت 11:32

سلام 

خیلی ممنون از راهنماییتون مشکل حل شد 


  • 1402/06/08
  • ساعت 00:21

خواهش میکنم دوست من

موفق باشین :)


logo-enamadlogo-samandehi