GOautodial Open Source Omni-channel Contact Center Suite

Hi Dev. Team,

We have a known bug on limesurvey in GOautodial CE 3.3. Saving or Activating it will prompt an error. Please see the screenshot for your reference. To be able to fix it you need to create lime_surveys table on your GoAutoDial database. Source URL: http://www.vicidial.org/VICIDIALforum/viewtopic.php?f=7&t=33414

Log-in on MySQL console, type

mysql -p

Once logged in, copy/paste the following queries on the MySQL console

use goautodial;

CREATE TABLE IF NOT EXISTS `lime_surveys` (
  `sid` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL,
  `admin` varchar(50) default NULL,
  `active` char(1) NOT NULL default 'N',
  `expires` datetime default NULL,
  `startdate` datetime default NULL,
  `adminemail` varchar(320) default NULL,
  `anonymized` char(1) NOT NULL default 'N',
  `faxto` varchar(20) default NULL,
  `format` char(1) default NULL,
  `savetimings` char(1) default 'N',
  `template` varchar(100) default 'default',
  `language` varchar(50) default NULL,
  `additional_languages` varchar(255) default NULL,
  `datestamp` char(1) default 'N',
  `usecookie` char(1) default 'N',
  `allowregister` char(1) default 'N',
  `allowsave` char(1) default 'Y',
  `autonumber_start` bigint(11) default '0',
  `autoredirect` char(1) default 'N',
  `allowprev` char(1) default 'Y',
  `printanswers` char(1) default 'N',
  `ipaddr` char(1) default 'N',
  `refurl` char(1) default 'N',
  `datecreated` date default NULL,
  `publicstatistics` char(1) default 'N',
  `publicgraphs` char(1) default 'N',
  `listpublic` char(1) default 'N',
  `htmlemail` char(1) default 'N',
  `tokenanswerspersistence` char(1) default 'N',
  `assessments` char(1) default 'N',
  `usecaptcha` char(1) default 'N',
  `usetokens` char(1) default 'N',
  `bounce_email` varchar(320) default NULL,
  `attributedescriptions` text,
  `emailresponseto` text,
  `emailnotificationto` text,
  `tokenlength` tinyint(2) default '15',
  `showxquestions` char(1) character set utf8 collate utf8_unicode_ci NOT NULL default 'Y',
  `showgroupinfo` char(1) default 'B',
  `shownoanswer` char(1) default 'Y',
  `showqnumcode` char(1) default 'X',
  `bouncetime` bigint(20) default NULL,
  `bounceprocessing` varchar(1) default 'N',
  `bounceaccounttype` varchar(4) default NULL,
  `bounceaccounthost` varchar(200) default NULL,
  `bounceaccountpass` varchar(100) default NULL,
  `bounceaccountencryption` varchar(3) default NULL,
  `bounceaccountuser` varchar(200) default NULL,
  `showwelcome` char(1) default 'Y',
  `showprogress` char(1) default 'Y',
  `allowjumps` char(1) default 'N',
  `navigationdelay` tinyint(2) default '0',
  `nokeyboard` char(1) default 'N',
  `alloweditaftercompletion` char(1) default 'N',
  `googleanalyticsstyle` char(1) default NULL,
  `googleanalyticsapikey` varchar(25) default NULL,
  PRIMARY KEY  (`sid`)
) ENGINE=MyISAM;