Skip to main content

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

641 Views
0 Replies
2 min read
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;

0 Replies

No Replies Yet

Topic Author

S

svnron

@svnron

Topic Stats

Created Tuesday, 13 July 2021 15:10
Last Updated Tuesday, 13 July 2021 15:10
Replies 0
Views 641
Likes 0

Share This Topic