Low Variables won't install
Low,
I just went to install Low Variables on a new site I'm developing and received the error below. I don't know if this is an EE 2.5.5 issue because I've see a couple similar installation issues with other add-ons but the devs were able to resolve the issue with a quick patch.
A Database Error Occurred
Error Number: 1101
BLOB/TEXT column 'variable_notes' can't have a default value
CREATE TABLE IF NOT EXISTS 'exp_low_variables' ( 'variable_id' int(6) unsigned NOT NULL, 'group_id' int(6) unsigned default 0 NOT NULL, 'variable_label' varchar(100) default '' NOT NULL, 'variable_notes' text default '' NOT NULL, 'variable_type' varchar(50) default 'low_textarea' NOT NULL, 'variable_settings' text default '' NOT NULL, 'variable_order' int(4) unsigned default 0 NOT NULL, 'early_parsing' char(1) default 'n' NOT NULL, 'is_hidden' char(1) default 'n' NOT NULL, 'save_as_file' char(1) default 'n' NOT NULL, 'edit_date' int(10) unsigned default 0 NOT NULL, PRIMARY KEY ('variable_id'), KEY ('group_id') ) CHARACTER SET utf8 COLLATE utf8_general_ci
Filename: third_party/low_variables/upd.low_variables.php
Line Number: 92
Replies
Low 11 Apr 2013 14:20
Looks like a MySQL Strict problem, more like.
What happens if you open up upd.low_variables.php, look up line #80, and change that from
to this:
Stuart McCoy 11 Apr 2013 14:38
Same error.
Low 11 Apr 2013 14:43
Wut?! And it doesn't even say it has a default value. That can't be right.
Can you turn off MySQL Strict mode, by any chance?
Either that, or I'll need SuperAdmin and FTP access to debug myself. You can send those login credentials to hi at gotolow dot com.
Low 11 Apr 2013 14:47
Wait, try and change this as well. Same file, line #355. From this:
to this:
Stuart McCoy 11 Apr 2013 14:59
I had to change lines 80, 82, and 355. 'variable_notes', 'variable_settings', and 'group_notes' all complained when it tried to set a text default value of ''. Problem with strict mode and MySQL or something else? Either way, it appears to have installed and is up and running.
Low 11 Apr 2013 15:06
Ah good. I'll make a note of it. Definitely Strict Mode related.
Stuart McCoy 11 Apr 2013 15:18
I did look on the MySQL settings in WorkBench and under the Inno options strict mode was not checked. my.cnf was empty so this has never been set as far as I can tell.
Low 11 Apr 2013 15:31
Hmm. Well, you're the first one to report this, so it doesn't happen often. Must be an environmental issue. Anyway, I'll make a note of it and make changes for a future version.
MrGlasspoole 4 May 2013 10:12
I had the same problem and needed to make the same changes