MySQL/ MariaDB strict mode off on local dev server – for example: excel export not working

A Laragonnál STRICT -re lett hagyva a MariaDB.

Run this:
SHOW VARIABLES LIKE ‘sql_mode’;

IF STRICT RUN THIS:
set global sql_mode=’NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION’;

Strict Mode enabled by default, How to disable Strict Mode after upgrade to MySQL or Maria: https://www.multimediaxp.com/post/46/strict-mode-enabled-by-default-how-to-disable-strict-mode-after-upgrade-to-mysql-or-maria-db-101-102

How to turn on/off MySQL strict mode in localhost:
https://stackoverflow.com/questions/40881773/how-to-turn-on-off-mysql-strict-mode-in-localhost-xampp

B logbook : PHP | Javascript | Laravel | CodeIgniter | VueJs | ReactJs | WordPress

Translate »