(B-C) Altroot

This was the main issue for me as well but fixed now!, the best methods to see what sql_mode your on and change its is the following: STEP 1: You can check the local and global value of it with: Execute - SELECT @@SQL_MODE, @@GLOBAL.SQL_MODE; if the field are blank then proceed below, however if you see 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' twice you do not this issue with MySQL mode. STEP 2: You can set the SQL_MODE either from the command line (the --sql-mode option) or by setting the sql_mode system variable. Execute - SET sql_mode = 'modes'; SET GLOBAL sql_mode = 'modes'; with - NO_AUTO_CREATE_USER Don't automatically create users with GRANT. NO_ENGINE_SUBSTITUTION If not set, if the available storage engine specified by a CREATE TABLE is not available, a warning is given and the default storage engine is used instead. e.g SET sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' ; SET GLOBAL sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' ; STEP 3: You can check the local and global value of it with: Execute - SELECT @@SQL_MODE, @@GLOBAL.SQL_MODE; I do hope this fixes your issue. the tips above work for MariaBD and MySQL.