GoAutoDial and Limesurvey integration problem

[mumin37]

Hello,

I've installed the newest iso available - goautodial-64bit-ce-3.3-final.iso
The problem is creating limesurvey scripts.
I can complete the creation procedure, then when I try to activate script or survey using Save button I get message:

Code: Select all

<some irrelevant html and css code>

<div id="content">
      <h1></h1>
      <p>Error Number: 1146</p><p>Table 'goautodial.lime_surveys' doesn't exist</p><p>SELECT *
FROM (`lime_surveys`)
WHERE `sid` = '41526'</p>   </div>
</body>


then script is being activated, survey isn't. I have to log into limesurvey as admin and activate it manually, then it works. But it is unacceptable for callcenter manager.
Rest of functions like adding questions works good from goadmin.

Can anyone help? It's urgent case.
Thanks in advance.

[mumin37]

Ok, I've solved my problem.

It was stupid and last thing I have thought. I've created empty table in goautodial database.
Here is SQL to do it:

Code: Select all

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;


[gardo]

Thank you for posting your solution.