April 21, 2022 in MySql, Tips and Tricks
#1101 error in mysql / phpmyadmin
1101 – BLOB, TEXT, GEOMETRY or JSON column ‘answer’ can’t have a default value Probably your development environment allows the defaults and the production environment doesn’t. You can either upgrade your production system or not use that feature. How to disable strict mode in MySQL 5 (Windows): Edit /my.ini and look for linesql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION” Replace it […]






