JInstaller: :Install: Error SQL DB function failed with error number 1064 in Fresh CA 1.6 in Joomla 1.6 install

User Name:Randy McCallum
Date Created:2 years ago
Status:Closed

Project: Community Answers
Release: v1.6.0
Module: Backend

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.

2 years ago 43 years ago

Home

Bug Tracker