سلام استاد وقت بخیر من در زمان migrate زدن پروژه به این مشکل بر خوردم تمام اقدامات هم دقیقا مو به مو فیلم پیش رفتم میشه برسی کنید مشکل از کجاست
سلام دوست من
متن ارور مثل اینکه بارگزاری نشده
لطفا متن اروری که باهاش مواجه میشین رو ارسال کنین تا بتونم کمکتون کنم
با سلام.
لطفاً تصویر یا متن پیام خطای دریافتی را ارسال کنید.
((abyaransanat/project:3.8)) [abyarans@hamed abyaransanat_project]$ python manage.py migrate
System check identified some issues:
WARNINGS:
?: (mysql.W002) MySQL Strict Mode is not set for database connection 'default'
HINT: MySQL's Strict Mode fixes many data integrity problems in MySQL, such as data truncation upon insertion, by escalating warnings into errors. It is strongly recommended you activate it. See: https://docs.djangoproject.com/en/4.0/ref/databases/#mysql-sql-mode
article_modules.Article.slug: (mysql.W003) MySQL may not allow unique CharFields to have a max_length > 255.
HINT: See: https://docs.djangoproject.com/en/4.0/ref/databases/#mysql-character-fields
product_module.Product.description: (fields.W162) MySQL does not support a database index on longtext columns.
HINT: An index won't be created. Silence this warning if you don't care about it.
Operations to perform:
Apply all migrations: account_modules, admin, article_modules, auth, contact_module, contenttypes, order_module, product_module, sessions, site_module, thumbnail
Running migrations:
Applying article_modules.0005_article...Traceback (most recent call last):
File "/home/abyarans/virtualenv/abyaransanat_project/3.8/lib64/python3.8/site-packages/mysql/connector/connection_cext.py", line 535, in cmd_query
self._cmysql.query(query,
_mysql_connector.MySQLInterfaceError: Specified key was too long; max key length is 1000 bytes
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/abyarans/virtualenv/abyaransanat_project/3.8/lib/python3.8/site-packages/django/db/backends/utils.py", line 87, in _execute
return self.cursor.execute(sql)
File "/home/abyarans/virtualenv/abyaransanat_project/3.8/lib64/python3.8/site-packages/mysql/connector/django/base.py", line 149, in execute
return self.cursor.execute(query, new_args)
File "/home/abyarans/virtualenv/abyaransanat_project/3.8/lib64/python3.8/site-packages/mysql/connector/cursor_cext.py", line 269, in execute
result = self._cnx.cmd_query(stmt, raw=self._raw,
File "/home/abyarans/virtualenv/abyaransanat_project/3.8/lib64/python3.8/site-packages/mysql/connector/connection_cext.py", line 540, in cmd_query
raise errors.get_mysql_exception(exc.errno, msg=exc.msg,
mysql.connector.errors.ProgrammingError: 1071 (42000): Specified key was too long; max key length is 1000 bytes
The above exception was the direct cause of the following exception:
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/abyarans/virtualenv/abyaransanat_project/3.8/lib/python3.8/site-packages/django/core/management/__init__.py", line 446, in execute_from_command_line
utility.execute()
File "/home/abyarans/virtualenv/abyaransanat_project/3.8/lib/python3.8/site-packages/django/core/management/__init__.py", line 440, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/home/abyarans/virtualenv/abyaransanat_project/3.8/lib/python3.8/site-packages/django/core/management/base.py", line 414, in run_from_argv
self.execute(*args, **cmd_options)
File "/home/abyarans/virtualenv/abyaransanat_project/3.8/lib/python3.8/site-packages/django/core/management/base.py", line 460, in execute
output = self.handle(*args, **options)
File "/home/abyarans/virtualenv/abyaransanat_project/3.8/lib/python3.8/site-packages/django/core/management/base.py", line 98, in wrapped
res = handle_func(*args, **kwargs)
File "/home/abyarans/virtualenv/abyaransanat_project/3.8/lib/python3.8/site-packages/django/core/management/commands/migrate.py", line 290, in handle
post_migrate_state = executor.migrate(
File "/home/abyarans/virtualenv/abyaransanat_project/3.8/lib/python3.8/site-packages/django/db/migrations/executor.py", line 131, in migrate
state = self._migrate_all_forwards(
File "/home/abyarans/virtualenv/abyaransanat_project/3.8/lib/python3.8/site-packages/django/db/migrations/executor.py", line 163, in _migrate_all_forwards
state = self.apply_migration(
File "/home/abyarans/virtualenv/abyaransanat_project/3.8/lib/python3.8/site-packages/django/db/migrations/executor.py", line 248, in apply_migration
state = migration.apply(state, schema_editor)
File "/home/abyarans/virtualenv/abyaransanat_project/3.8/lib/python3.8/site-packages/django/db/migrations/migration.py", line 131, in apply
operation.database_forwards(
File "/home/abyarans/virtualenv/abyaransanat_project/3.8/lib/python3.8/site-packages/django/db/migrations/operations/models.py", line 93, in database_forwards
schema_editor.create_model(model)
File "/home/abyarans/virtualenv/abyaransanat_project/3.8/lib/python3.8/site-packages/django/db/backends/base/schema.py", line 432, in create_model
self.execute(sql, params or None)
File "/home/abyarans/virtualenv/abyaransanat_project/3.8/lib/python3.8/site-packages/django/db/backends/base/schema.py", line 192, in execute
cursor.execute(sql, params)
File "/home/abyarans/virtualenv/abyaransanat_project/3.8/lib/python3.8/site-packages/django/db/backends/utils.py", line 103, in execute
return super().execute(sql, params)
File "/home/abyarans/virtualenv/abyaransanat_project/3.8/lib/python3.8/site-packages/django/db/backends/utils.py", line 67, in execute
return self._execute_with_wrappers(
File "/home/abyarans/virtualenv/abyaransanat_project/3.8/lib/python3.8/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/home/abyarans/virtualenv/abyaransanat_project/3.8/lib/python3.8/site-packages/django/db/backends/utils.py", line 89, in _execute
return self.cursor.execute(sql, params)
File "/home/abyarans/virtualenv/abyaransanat_project/3.8/lib/python3.8/site-packages/django/db/utils.py", line 91, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/home/abyarans/virtualenv/abyaransanat_project/3.8/lib/python3.8/site-packages/django/db/backends/utils.py", line 87, in _execute
return self.cursor.execute(sql)
File "/home/abyarans/virtualenv/abyaransanat_project/3.8/lib64/python3.8/site-packages/mysql/connector/django/base.py", line 149, in execute
return self.cursor.execute(query, new_args)
File "/home/abyarans/virtualenv/abyaransanat_project/3.8/lib64/python3.8/site-packages/mysql/connector/cursor_cext.py", line 269, in execute
result = self._cnx.cmd_query(stmt, raw=self._raw,
File "/home/abyarans/virtualenv/abyaransanat_project/3.8/lib64/python3.8/site-packages/mysql/connector/connection_cext.py", line 540, in cmd_query
raise errors.get_mysql_exception(exc.errno, msg=exc.msg,
django.db.utils.ProgrammingError: (1071, '1071 (42000): Specified key was too long; max key length is 1000 bytes', '42000')
سلام توی اپ آرتیکلت تو فایل migrations یه فایلی هست 0005 اونو باز کن توی اون یکی از option های max_length 42000 هست اونو بیار زیر 1000 فکر کنم حل شه
# Generated by Django 4.0.5 on 2022-07-18 11:14
from django.db import migrations, models
class Migration(migrations.Migration):
dependencies = [
('article_modules', '0004_articlecategories_is_parent'),
]
operations = [
migrations.CreateModel(
name='Article',
fields=[
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(max_length=300, verbose_name='عنوان مقاله')),
('slug', models.SlugField(allow_unicode=True, max_length=400, unique=True, verbose_name='عنوان در URL')),
('image', models.ImageField(upload_to='images/articles', verbose_name='تصویر مقاله')),
('short_description', models.TextField(verbose_name='توضیحات کوتاه')),
('text', models.TextField(verbose_name='متن مقاله')),
('is_active', models.BooleanField(default=True, verbose_name='فعال / غیرفعال')),
('createDate', models.DateTimeField(auto_now=True, verbose_name='تاریخ ایجاد مقاله')),
('updateDate', models.DateTimeField(auto_now_add=True, verbose_name='آخرین بروزرسانی')),
('selected_categories', models.ManyToManyField(to='article_modules.articlecategories', verbose_name='دسته بندی ها')),
],
options={
'verbose_name': 'مقاله',
'verbose_name_plural': 'مقالات',
},
),
]
اصلا همچین چیزی نیست توش
ی سری جدول ساخت از دیتابیس داخل سیستم نگاه کردم به جدول session رسید اینجوری شده
با نصب پکیج گفته شده توی پست 4 و همچین پاک کردن کل مایگرشن های ماژولی که گیر داده بود مشکل حل شد
بازم ممنون از پاسخگویی و کمک همه دوستان
خوشحالم که مشکل برطرف شد.
موفق باشید.
خوشحالم که مشکلتون برطرف شده دوست من