سلام استاد
من برای پابلیش با ویدیو پیش رفتم ولی هنگام اجرای دستور migrate به مشکل خوردم اگه میشه راهنمایی کنید
متن ارور :
django.db.utils.ProgrammingError: (1146, "1146 (42S02): Table 'aryanka1_db_pajoheshsara.user_module_user' doesn't exist", '42S02')
سلام دوست من
در پروژه شما برای migration ها مشکلی ایجاد شده
لطفا وارد هر app بشین و migration ها رو به جز فایل init در هر پوشه پاک کنین
مجددا دستور makemigrations رو بزنین
دیتابیس رو از سرور پاک کنین و مجدد ایجاد کنین
دستور migrate رو یک بار دیگه بزنین و تست کنین
اگه مشکل داشت از mysqlclient استفاده کنین که البته نیاز هستش engin مربوط به دیتابیس رو در تنظیمات تغییر بدین
موفق باشین :)
سلام
روش اول مشکل رو حل نکرد . برای روش دوم وقتی میخوام 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
برای نصب این پکیج باید از پشتیبانی سرور کمک بگیرین
این پکیج به c++ builder نیاز داره که عملا شما دسترسی نصبش رو ندارین
به پشتیبانی سرور بگین که مشکل رو برطرف کنن
سلام
پشتیبانی پکیج رو برام نصب کرد و 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
مشکل نسخه ی mysql هستش دوست من
به پشتیبانی سرور تیکت بزنین و ازشون بپرسین که نسخه ی mariadb سرور شما چند هستش
شما به نسخه ی 10.3.39 نیاز دارین ( البته حداقل )
موفق باشین :)
سلام
خیلی ممنون از راهنماییتون مشکل حل شد
خواهش میکنم دوست من
موفق باشین :)