error number 1364
Hello
When I tried to klick on one of my variable I got this msg.
EE 2.2.2; LOW var 1.3.7
It is new phenomena, where should I start looking?
Thanks
A Database Error Occurred
Error Number: 1364
Field 'variable_label' doesn't have a default value
INSERT INTO 'exp_low_variables' ('variable_id', 'group_id', 'variable_type') VALUES ('16', '0', 'low_textarea')
Filename: C:\Websites\coachingCoIL\system\codeigniter\system\database\DB_driver.php
Line Number: 330
Replies
Low 8 Sep 2011 06:41
Hi! Is your MySQL running is strict_mode, by any chance? And can you try and switch that off?
Vince Falconi 9 Nov 2012 21:33
I encountered this same issue today. I installed Low Variables, entered my license number, and when I went to acccess the Module settings, I got the same error.
I'm assuming it's an issue with the DB as I didn't have a chance to actually mess anything up.
My database is not running strict_mode, near as I can tell.
Low 9 Nov 2012 21:57
This error message only appears when the DB is running in strict mode; please make absolutely sure this is turned off.
Vince Falconi 14 Nov 2012 19:27
D'oh. Just realized I was looking at the wrong strict mode setting. I was looking at the InnoDB settings by mistake. Feeling dumb, haha.
Thanks!