Jinstaller error – cannot install Community Survey
Jinstaller error - cannot install Community Survey
I am getting the following error when trying to install Community Survey - Any suggestions?
JInstaller: :Install: Error SQL DB function failed with 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 'TYPE=MyISAM CHARACTER SET `utf8`' at line 21 SQL=CREATE TABLE IF NOT EXISTS `nse_survey` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `alias` varchar(255) NOT NULL, `introtext` text, `endtext` text, `created_by` int(11) NOT NULL, `created` datetime NOT NULL, `publish_up` datetime NOT NULL, `publish_down` datetime NOT NULL, `responses` int(11) NOT NULL DEFAULT '0', `private_survey` tinyint(1) DEFAULT '0', `max_responses` int(10) unsigned NOT NULL DEFAULT '0', `anonymous` tinyint(1) unsigned NOT NULL DEFAULT '0', `custom_header` text, `public_permissions` tinyint(1) unsigned NOT NULL DEFAULT '1', `published` tinyint(3) unsigned NOT NULL DEFAULT '1', `survey_key` varchar(32) NOT NULL, `redirect_url` VARCHAR(999) DEFAULT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8`;
SQL =
JInstaller: :Install: Error SQL DB function failed with 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 'TYPE=MyISAM CHARACTER SET `utf8`' at line 21 SQL=CREATE TABLE IF NOT EXISTS `nse_survey` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `alias` varchar(255) NOT NULL, `introtext` text, `endtext` text, `created_by` int(11) NOT NULL, `created` datetime NOT NULL, `publish_up` datetime NOT NULL, `publish_down` datetime NOT NULL, `responses` int(11) NOT NULL DEFAULT '0', `private_survey` tinyint(1) DEFAULT '0', `max_responses` int(10) unsigned NOT NULL DEFAULT '0', `anonymous` tinyint(1) unsigned NOT NULL DEFAULT '0', `custom_header` text, `public_permissions` tinyint(1) unsigned NOT NULL DEFAULT '1', `published` tinyint(3) unsigned NOT NULL DEFAULT '1', `survey_key` varchar(32) NOT NULL, `redirect_url` VARCHAR(999) DEFAULT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8`;
SQL =
Access to viewing replies is restricted.
Showing 2 of 2 replies
You do not have permissions for replying to this topic.