Support archive

Database Error 1064 when installing Low Variables

ucberkeley 10 May 2013 19:53 problem, pending

I am running the latest version of EE (2.6) and just purchased Low Variables. I am running into myriad errors when I try to install, for example:

A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL, 'variable_order' int(4) unsigned default 0 NOT NULL, 'early_pa' at line 7

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) NOT NULL, 'variable_notes' text NOT NULL, 'variable_type' varchar(50) default 'low_textarea' NOT NULL, 'variable_settings' 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

I have tried to make some basic tweaks such as turning of strict mode in MySQL but once I get past one error I run into another? Is it an incompatibility issue? If so can we get a refund?

Replies

1. Low 10 May 2013 19:59

   It's a bug that occurs on some environments and will be fixed with the next version. to fix, open up upd.low_variables.php and change this
   
   

   'group_notes' text default '' NOT NULL,

   
   
   to this
   
   

   'group_notes' text NOT NULL,

   
   
   ..on lines 80, 82, and 355.

2. ucberkeley 10 May 2013 20:19

   Thanks Low,
   
   I've already made those changes, as well as turned off "strict" mode in MySQL. I am running MySQL 5.6.11 and PHP Version 5.3.15 on my MacBook Pro's localhost.
   
   This is a different syntax error - any clues?
   
   Error Number: 1064
   
   You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL, 'variable_order' int(4) unsigned default 0 NOT NULL, 'early_pa' at line 7
   
   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) NOT NULL, 'variable_notes' text NOT NULL, 'variable_type' varchar(50) default 'low_textarea' NOT NULL, 'variable_settings' 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

3. Low 10 May 2013 20:26

   Looks like you replaced the word 'text' in there, too.
   
   If you send me an email at hi at gotolow dot com, I can send you a patched file.