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

