JInstaller: :Install: Error SQL DB function failed with error number 1064 in Fresh CA 1.6 in Joomla 1.6 install
  • Randy McCallum
  • 3 years ago
  • Closed
  • 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 '', PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8`; CREATE TABLE IF NOT' at line 14 SQL=CREATE TABLE IF NOT EXISTS `jos_answers_responses` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `question_id` int(10) unsigned NOT NULL DEFAULT '0', `description` mediumtext NOT NULL, `created_by` int(10) unsigned NOT NULL, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `thumbup` int(10) unsigned NOT NULL DEFAULT '0', `thumbdown` int(10) unsigned NOT NULL DEFAULT '0', `chosen_best` int(10) unsigned NOT NULL DEFAULT '0', `source` mediumtext, `published` tinyint(3) unsigned NOT NULL DEFAULT '1', `ip_address` varchar(39) NOT NULL DEFAULT '0.0.0.0', `user_name` VARCHAR(64) DEFAULT NULL, `email` VARCHAR(128) DEFAULT NULL', PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8`; CREATE TABLE IF NOT EXISTS `#__answers_users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `questions` int(10) unsigned NOT NULL DEFAULT '0', `answers` int(10) unsigned NOT NULL DEFAULT '0', `accepted` int(10) unsigned NOT NULL DEFAULT '0', `best_answers` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8`; CREATE TABLE IF NOT EXISTS `#__answers_ratings` ( `user_id` int(10) unsigned DEFAULT NULL, `answer_id` int(10) unsigned NOT NULL, `rating` tinyint(3) NOT NULL DEFAULT '0' ) TYPE=MyISAM CHARACTER SET `utf8`; CREATE TABLE IF NOT EXISTS `#__answers_config` ( `config_name` varchar(255) NOT NULL, `config_value` varchar(255) NOT NULL, PRIMARY KEY (`config_name`) ) TYPE=MyISAM CHARACTER SET `utf8`;
    SQL =
    CREATE TABLE IF NOT EXISTS  `#__answers_responses` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `question_id` int(10) unsigned NOT NULL DEFAULT '0',
    `description` mediumtext NOT NULL,
    `created_by` int(10) unsigned NOT NULL,
    `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    `thumbup` int(10) unsigned NOT NULL DEFAULT '0',
    `thumbdown` int(10) unsigned NOT NULL DEFAULT '0',
    `chosen_best` int(10) unsigned NOT NULL DEFAULT '0',
    `source` mediumtext,
    `published` tinyint(3) unsigned NOT NULL DEFAULT '1',
    `ip_address` varchar(39) NOT NULL DEFAULT '0.0.0.0',
    `user_name` VARCHAR(64) DEFAULT NULL,
    `email` VARCHAR(128) DEFAULT NULL',
    PRIMARY KEY (`id`)
    ) TYPE=MyISAM CHARACTER SET `utf8`;

    CREATE TABLE IF NOT EXISTS `#__answers_users` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `questions` int(10) unsigned NOT NULL DEFAULT '0',
    `answers` int(10) unsigned NOT NULL DEFAULT '0',
    `accepted` int(10) unsigned NOT NULL DEFAULT '0',
    `best_answers` int(10) unsigned NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`)
    ) TYPE=MyISAM CHARACTER SET `utf8`;

    CREATE TABLE IF NOT EXISTS `#__answers_ratings` (
    `user_id` int(10) unsigned DEFAULT NULL,
    `answer_id` int(10) unsigned NOT NULL,
    `rating` tinyint(3) NOT NULL DEFAULT '0'
    ) TYPE=MyISAM CHARACTER SET `utf8`;

    CREATE TABLE IF NOT EXISTS `#__answers_config` (
    `config_name` varchar(255) NOT NULL,
    `config_value` varchar(255) NOT NULL,
    PRIMARY KEY (`config_name`)
    ) TYPE=MyISAM CHARACTER SET `utf8`;
  • Component Install: SQL error file 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 '', PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8`; CREATE TABLE IF NOT' at line 14 SQL=CREATE TABLE IF NOT EXISTS `jos_answers_responses` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `question_id` int(10) unsigned NOT NULL DEFAULT '0', `description` mediumtext NOT NULL, `created_by` int(10) unsigned NOT NULL, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `thumbup` int(10) unsigned NOT NULL DEFAULT '0', `thumbdown` int(10) unsigned NOT NULL DEFAULT '0', `chosen_best` int(10) unsigned NOT NULL DEFAULT '0', `source` mediumtext, `published` tinyint(3) unsigned NOT NULL DEFAULT '1', `ip_address` varchar(39) NOT NULL DEFAULT '0.0.0.0', `user_name` VARCHAR(64) DEFAULT NULL, `email` VARCHAR(128) DEFAULT NULL', PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8`; CREATE TABLE IF NOT EXISTS `#__answers_users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `questions` int(10) unsigned NOT NULL DEFAULT '0', `answers` int(10) unsigned NOT NULL DEFAULT '0', `accepted` int(10) unsigned NOT NULL DEFAULT '0', `best_answers` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8`; CREATE TABLE IF NOT EXISTS `#__answers_ratings` ( `user_id` int(10) unsigned DEFAULT NULL, `answer_id` int(10) unsigned NOT NULL, `rating` tinyint(3) NOT NULL DEFAULT '0' ) TYPE=MyISAM CHARACTER SET `utf8`; CREATE TABLE IF NOT EXISTS `#__answers_config` ( `config_name` varchar(255) NOT NULL, `config_value` varchar(255) NOT NULL, PRIMARY KEY (`config_name`) ) TYPE=MyISAM CHARACTER SET `utf8`;
    SQL =
    CREATE TABLE IF NOT EXISTS  `#__answers_responses` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `question_id` int(10) unsigned NOT NULL DEFAULT '0',
    `description` mediumtext NOT NULL,
    `created_by` int(10) unsigned NOT NULL,
    `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    `thumbup` int(10) unsigned NOT NULL DEFAULT '0',
    `thumbdown` int(10) unsigned NOT NULL DEFAULT '0',
    `chosen_best` int(10) unsigned NOT NULL DEFAULT '0',
    `source` mediumtext,
    `published` tinyint(3) unsigned NOT NULL DEFAULT '1',
    `ip_address` varchar(39) NOT NULL DEFAULT '0.0.0.0',
    `user_name` VARCHAR(64) DEFAULT NULL,
    `email` VARCHAR(128) DEFAULT NULL',
    PRIMARY KEY (`id`)
    ) TYPE=MyISAM CHARACTER SET `utf8`;

    CREATE TABLE IF NOT EXISTS `#__answers_users` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `questions` int(10) unsigned NOT NULL DEFAULT '0',
    `answers` int(10) unsigned NOT NULL DEFAULT '0',
    `accepted` int(10) unsigned NOT NULL DEFAULT '0',
    `best_answers` int(10) unsigned NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`)
    ) TYPE=MyISAM CHARACTER SET `utf8`;

    CREATE TABLE IF NOT EXISTS `#__answers_ratings` (
    `user_id` int(10) unsigned DEFAULT NULL,
    `answer_id` int(10) unsigned NOT NULL,
    `rating` tinyint(3) NOT NULL DEFAULT '0'
    ) TYPE=MyISAM CHARACTER SET `utf8`;

    CREATE TABLE IF NOT EXISTS `#__answers_config` (
    `config_name` varchar(255) NOT NULL,
    `config_value` varchar(255) NOT NULL,
    PRIMARY KEY (`config_name`)
    ) TYPE=MyISAM CHARACTER SET `utf8`;
Steps to reproduce

STEP 1:

I set up the new MYSQL Database and then did the Joomla 1.6 final install and the site works fine.

STEP 2:

I installed the plg_jquery_v1.6.0b1 plugin without any issues

STEP 3:

I then installed the com_communityanswers_v1.6.0 and I get the above error message. I then deleted the Joomla 1.6 installation, and set everything up again, and did the same thing and I get the same error message as above:

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 '', PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8`; CREATE TABLE IF NOT' at line 14 SQL=CREATE TABLE IF NOT EXISTS `jos_answers_responses` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `question_id` int(10) unsigned NOT NULL DEFAULT '0', `description` mediumtext NOT NULL, `created_by` int(10) unsigned NOT NULL, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `thumbup` int(10) unsigned NOT NULL DEFAULT '0', `thumbdown` int(10) unsigned NOT NULL DEFAULT '0', `chosen_best` int(10) unsigned NOT NULL DEFAULT '0', `source` mediumtext, `published` tinyint(3) unsigned NOT NULL DEFAULT '1', `ip_address` varchar(39) NOT NULL DEFAULT '0.0.0.0', `user_name` VARCHAR(64) DEFAULT NULL, `email` VARCHAR(128) DEFAULT NULL', PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8`; CREATE TABLE IF NOT EXISTS `#__answers_users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `questions` int(10) unsigned NOT NULL DEFAULT '0', `answers` int(10) unsigned NOT NULL DEFAULT '0', `accepted` int(10) unsigned NOT NULL DEFAULT '0', `best_answers` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8`; CREATE TABLE IF NOT EXISTS `#__answers_ratings` ( `user_id` int(10) unsigned DEFAULT NULL, `answer_id` int(10) unsigned NOT NULL, `rating` tinyint(3) NOT NULL DEFAULT '0' ) TYPE=MyISAM CHARACTER SET `utf8`; CREATE TABLE IF NOT EXISTS `#__answers_config` ( `config_name` varchar(255) NOT NULL, `config_value` varchar(255) NOT NULL, PRIMARY KEY (`config_name`) ) TYPE=MyISAM CHARACTER SET `utf8`;
SQL =

 

Discussions
  • This is fixed with v1.6.0 updated.
    3 years ago 44 years ago

Are you sure you want to perform this operation?
...
1 Yes No Error! Confirm? /bug-tracker/publish_discussion/0.html /bug-tracker/unpublish_discussion/0.html 100076 Error! ... Please wait...
Powered by Bug Tracker