1
Installing Liaise
## Table structure for table `liaise_forms`#CREATE TABLE `liaise_forms` ( `form_id` smallint(5) NOT NULL auto_increment, `form_send_method` char(1) NOT NULL default 'e', `form_send_to_group` smallint(3) NOT NULL default '0', `form_order` smallint(3) NOT NULL default '0', `form_delimiter` char(1) NOT NULL default 's', `form_title` varchar(255) NOT NULL default '', `form_submit_text` varchar(50) NOT NULL default '', `form_desc` text NOT NULL, `form_intro` text NOT NULL, `form_whereto` varchar(255) NOT NULL default '', PRIMARY KEY (`form_id`), KEY `form_order` (`form_order`)) TYPE=MyISAM;## Dumping data for table `liaise_forms`#INSERT INTO `liaise_forms` VALUES (1, 'e', 0, 1, 'b', 'Send feedback', 'Submit', 'Tell us about your comments for this site.', 'Contact us by filling out this form.', '');## Table structure for table `liaise_formelements`#CREATE TABLE `liaise_formelements` ( `ele_id` smallint(5) unsigned NOT NULL auto_increment, `form_id` smallint(5) NOT NULL default '0', `ele_type` varchar(10) NOT NULL default '', `ele_caption` varchar(255) NOT NULL default '', `ele_order` smallint(2) NOT NULL default '0', `ele_req` tinyint(1) NOT NULL default '1', `ele_value` text NOT NULL, `ele_display` tinyint(1) NOT NULL default '1', PRIMARY KEY (`ele_id`), KEY `ele_display` (`ele_display`), KEY `ele_order` (`ele_order`)) TYPE=MyISAM;## Dumping data for table `liaise_formelements`#INSERT INTO `liaise_formelements` VALUES (1, 1, 'checkbox', 'What are your hobbies?', 11, 1, 'a:7:{s:13:"I\'m a dreary.";i:1;s:35:"Searching adult contents on the net";i:0;s:66:"Arguing with people about those stupid things on discussion boards";i:0;s:33:"Searching software serial numbers";i:0;s:6:"Speech";i:0;s:34:"Making weapons of mass destruction";i:0;s:10:"{OTHER|30}";i:0;}', 1);INSERT INTO `liaise_formelements` VALUES (2, 1, 'text', 'Your name', 0, 1, 'a:3:{i:0;i:30;i:1;i:255;i:2;s:7:"{UNAME}";}', 1);INSERT INTO `liaise_formelements` VALUES (3, 1, 'text', 'Email', 1, 1, 'a:3:{i:0;i:30;i:1;i:255;i:2;s:7:"{EMAIL}";}', 1);INSERT INTO `liaise_formelements` VALUES (4, 1, 'text', 'Website', 3, 0, 'a:3:{i:0;i:30;i:1;i:255;i:2;s:7:"http://";}', 1);INSERT INTO `liaise_formelements` VALUES (5, 1, 'text', 'Company', 4, 0, 'a:3:{i:0;i:30;i:1;i:255;i:2;s:0:"";}', 1);INSERT INTO `liaise_formelements` VALUES (6, 1, 'text', 'Location', 5, 0, 'a:3:{i:0;i:30;i:1;i:255;i:2;s:0:"";}', 1);INSERT INTO `liaise_formelements` VALUES (7, 1, 'textarea', 'Comments', 6, 1, 'a:3:{i:0;s:0:"";i:1;i:5;i:2;i:35;}', 1);INSERT INTO `liaise_formelements` VALUES (8, 1, 'select', 'How are you today?', 7, 0, 'a:3:{i:0;i:1;i:1;i:0;i:2;a:6:{s:6:"Great!";i:0;s:9:"I\'m fine.";i:1;s:6:"So so.";i:0;s:8:"No good.";i:0;s:9:"I\'m sick.";i:0;s:5:"What?";i:0;}}', 1);INSERT INTO `liaise_formelements` VALUES (9, 1, 'text', 'Your credit card number', 14, 0, 'a:3:{i:0;i:30;i:1;i:255;i:2;s:15:"Are you crazy!?";}', 1);INSERT INTO `liaise_formelements` VALUES (10, 1, 'radio', 'How old are you?', 9, 0, 'a:8:{s:3:"0-9";i:0;s:5:"10-19";i:0;s:5:"20-29";i:0;s:5:"30-39";i:0;s:5:"40-49";i:0;s:5:"50-59";i:0;s:3:"60+";i:0;s:27:"It\'s none of your business.";i:1;}', 1);INSERT INTO `liaise_formelements` VALUES (11, 1, 'checkbox', 'foo', 13, 0, 'a:1:{s:3:"bar";i:0;}', 0);INSERT INTO `liaise_formelements` VALUES (12, 1, 'select', 'Why did you buy a computer?', 8, 1, 'a:3:{i:0;i:10;i:1;i:1;i:2;a:6:{s:25:"My room is too big for me";i:1;s:25:"I don\'t have a girlfriend";i:0;s:18:"My wife is a biddy";i:0;s:17:"I like spam mails";i:0;s:29:"That makes me look more smart";i:0;s:13:"I just forgot";i:0;}}', 1);INSERT INTO `liaise_formelements` VALUES (13, 1, 'radio', 'Gender', 2, 0, 'a:3:{s:4:"Male";i:0;s:6:"Female";i:0;s:15:"I won\'t tell ya";i:1;}', 1);INSERT INTO `liaise_formelements` VALUES (14, 1, 'yn', 'Do you believe your government?', 12, 0, 'a:2:{s:4:"_YES";i:1;s:3:"_NO";i:0;}', 1);INSERT INTO `liaise_formelements` VALUES (15, 1, 'html', '', 10, 0, 'a:3:{i:0;s:316:"I have no idea what should be placed here. Maybe a chapter from the holy bible? Click here if you have too much time to waste, or get a free PlayStation 2 if you are boring.";i:1;i:10;i:2;i:50;}', 1) is not a valid SQL!
Unable to install liaise. Error(s):
-----------------------------------------------
also when i was using 1.22 every time i saved a form after it was created EI crashed art from tghat its all be great
Thanks
Cobra
