mysql> delete from setting where varname = 'adenable';
Query OK, 1 row affected (0.02 sec)
mysql> delete from setting where varname = 'adleftadleft';
Query OK, 0 rows affected (0.00 sec)
I couldn't wait...
[sql]
delete from setting where varname = 'adright';
delete from setting where varname = 'adleft';
delete from setting where varname = 'adtitleleft';
delete from setting where varname = 'adtitleright';
[/sql]
[sql]INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES('adenable', 'adcolumn', '1', '1', 'yesno', 10, 0, 1);
INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES('adleft', 'adcolumn', '1', '1', 'yesno', 20, 0, 1);
INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES('adright', 'adcolumn', '0', '0', 'yesno', 30, 0, 1);
INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES('adtitleleft', 'adcolumn', 'Left Column', 'Left Column', '', 40, 0, 1);
INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES('adtitleright', 'adcolumn', 'Right Column', 'Right Column', '', 50, 0, 1);
[/sql]
Results: it all works (so yea, the new installer file did the trick).
|