Installing JBD 5.7.3 on Joomla 3.10.9 PHP 7.4.29 DB 5.6.41-84.1
When trying to install I get the error below.
Warning
JInstaller: :Install: Error SQL 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 'json DEFAULT NULL, `capacity` int(11) DEFAULT NULL, `organizer` varchar(100)' at line 11
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 MySQL server version for the right syntax to use near 'json DEFAULT NULL, `capacity` int(11) DEFAULT NULL, `organizer` varchar(100)' at line 11SQL =
CREATE TABLE `#__jbusinessdirectory_trips` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`alias` varchar(100) DEFAULT NULL,
`description` text,
`start_date` date DEFAULT NULL,
`end_date` date DEFAULT NULL,
`start_time` time DEFAULT NULL,
`end_time` time DEFAULT NULL,
`frequency` int(11) NOT NULL DEFAULT '0',
`recurring_info` json DEFAULT NULL,
`capacity` int(11) DEFAULT NULL,
`organizer` varchar(100) DEFAULT NULL,
`phone` varchar(45) DEFAULT NULL,
`email` varchar(45) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `idx_name` (`name`),
KEY `idx_alias` (`alias`),
KEY `idx_frequency` (`frequency`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;