Mysql import table error : Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535.

If you are facing this error while importing data in mysql, you need to edit the Engine type of your mysql table.

Error : Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535.

 Solution :

ALTER TABLE sheet4_5 ENGINE=MYISAM;

Django Migration Error - Error : duplicate key value violates unique constraint "auth_permission _pkey"DETAIL: Key (id)=(xxx) already exists.

Python Django Error :

Error : duplicate key value violates unique constraint "auth_permission _pkey"DETAIL: Key (id)=(xxx) already exists.

Solution :

python manage.py sqlsequencereset auth | python manage.py dbshell

Python Error while creating virtualenv 'ImportError: No module named importlib_metadata'

Python Errors while creating virtualenv

ImportError: No module named importlib_metadata

or

AssertionError: importlib-metadata>=0.12; python_version < "3.8" .dist-info directory not found

or

NameError: name 'ModuleNotFoundError' is not defined

Solution :

You need to upgrade pip.

pip install --upgrade --user pip

Once the pip is upgraded, you should not get the error. If you are using pip3 then use pip3 instead of pip in the command.

You can see the solution in the following video.