How can I resolve errors encountered during migration from SQLite to MySQL in Django? [closed]

(venv) PS E:\Easyalgo project\django-tailwind-blog> python manage.py migrate
System check identified some issues:

WARNINGS:
?: (ckeditor.W001) django-ckeditor bundles CKEditor 4.22.1 which isn't supported anmyore and which does have unfixed security issues, see for example https://ckeditor.com/cke4/release/CKEditor-4.24.0-LTS . You should consider strongly switching to a different editor (maybe CKEditor 5 respectively django-ckeditor-5 after checking whether the CKEditor 5 license terms work for you) or switch to the non-free CKEditor 4 LTS package. See https://ckeditor.com/ckeditor-4-support/ for more on this. (Note! This notice has been added by the django-ckeditor developers and we are not affiliated with CKSource and were not involved in the licensing change, so please refrain from complaining to us. Thanks.)
?: (urls.W002) Your URL pattern '/post' has a route beginning with a '/'. Remove this slash as it is unnecessary. If this pattern is targeted in an include(), ensure the include() pattern has a trailing '/'.
Operations to perform:
  Apply all migrations: Adv_css, DBMS, admin, auth, blogs, contenttypes, cp_sheet, cs_subject, home, htmlapp, mini_sheet, networking, patterns, prepration_sheet, programming, sessions, stl
Running migrations:
  Applying home.0003_blog_remark...Traceback (most recent call last):
  File "E:\Easyalgo project\django-tailwind-blog\venv\Lib\site-packages\django\db\backends\utils.py", line 105, in _execute
    return self.cursor.execute(sql, params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "E:\Easyalgo project\django-tailwind-blog\venv\Lib\site-packages\django\db\backends\mysql\base.py", line 76, in execute
    return self.cursor.execute(query, args)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "E:\Easyalgo project\django-tailwind-blog\venv\Lib\site-packages\MySQLdb\cursors.py", line 179, in execute
    res = self._query(mogrified_query)
          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "E:\Easyalgo project\django-tailwind-blog\venv\Lib\site-packages\MySQLdb\cursors.py", line 330, in _query
    db.query(q)
File "E:\Easyalgo project\django-tailwind-blog\venv\Lib\site-packages\MySQLdb\connections.py", line 261, in query
    _mysql.connection.query(self, query)
MySQLdb.OperationalError: (1170, "BLOB/TEXT column 'remark' used in key specification without a key length")

Back to Top