• 1401/07/25

مشکل در migrate هنگام پابلیش پروژه :

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

  • 1401/07/25
  • ساعت 09:22

سلام دوست من

متن ارور مثل اینکه بارگزاری نشده

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


  • 1401/07/25
  • ساعت 09:22

با سلام.

 

لطفاً تصویر یا متن پیام خطای دریافتی را ارسال کنید.


  • 1401/07/25
  • ساعت 11:29

  • 1401/07/25
  • ساعت 11:32
((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')

  • 1401/07/25
  • ساعت 11:39

سلام توی اپ آرتیکلت تو فایل migrations یه فایلی هست 0005 اونو باز کن توی اون یکی از option  های max_length 42000 هست اونو بیار زیر 1000 فکر کنم حل شه


  • 1401/07/25
  • ساعت 11:42
# 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': 'مقالات',
            },
        ),
    ]

 

اصلا همچین چیزی نیست توش


  • 1401/07/25
  • ساعت 11:43

ی سری جدول ساخت از دیتابیس داخل سیستم نگاه کردم به جدول session رسید اینجوری شده


  • 1401/07/25
  • ساعت 15:52

با سلام.

 

اگر در فیلد Slug از کاراکترهای فارسی استفاده کردید، این پست ها را ببینید:

 پست  1 

پست  2

پست 3

پست 4

 


  • 1401/07/25
  • ساعت 18:54

با نصب پکیج گفته شده توی پست 4 و همچین پاک کردن کل مایگرشن های ماژولی که گیر داده بود مشکل حل شد

 

بازم ممنون از پاسخگویی و کمک همه دوستان 


  • 1401/07/25
  • ساعت 19:01

خوشحالم که مشکل برطرف شد. 

موفق باشید.


  • 1401/07/26
  • ساعت 09:30

خوشحالم که مشکلتون برطرف شده دوست من


logo-enamadlogo-samandehi