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 25SQL =
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;