Error SQL You have an error in your SQL syntax; MariaDB server

svnron
svnron
  • svnron
  • 3 months ago
Hello,
I am having installation problems with Community Answers.  CoreJoomla API installed correctly. I have disabled strict mode in mysql server but still get the ERROR below.
 
JInstaller: :Install: Error SQL You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci' at line 25
Extension Install: SQL error processing query: DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci' at line 25
SQL =
CREATE TABLE IF NOT EXISTS  `#__answers_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `signature` TEXT NULL DEFAULT NULL,
  `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',
  `question_likes` int(10) NOT NULL DEFAULT '0',
  `question_dislikes` int(10) NOT NULL DEFAULT '0',
  `answer_likes` int(10) NOT NULL DEFAULT '0',
  `answer_dislikes` int(10) NOT NULL DEFAULT '0',
  `questions_liked` int(10) NOT NULL DEFAULT '0',
  `questions_disliked` int(10) NOT NULL DEFAULT '0',
  `answers_liked` int(10) NOT NULL DEFAULT '0',
  `answers_disliked` int(10) NOT NULL DEFAULT '0',
  `karma` int(10) unsigned NOT NULL DEFAULT '0',
  `last_visit` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `current_visit` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `session_data` text NOT NULL,
  `subid` varchar(12) DEFAULT NULL,
  `current_access_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_access_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `idx_answers_users_karma` (`karma`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;

Access to viewing replies is restricted.
Showing 2 of 2 replies
You do not have permissions for replying to this topic.
Loading...
Confirm delete? This action is irreversible and the data will be deleted permanently. Do you want to continue? Confirm Add New Delete Unpublish Cancel Import Uninstall The selected item successfully deleted.
Shondalai