J-BusinessDirectory - Install Errors on JBD 5.7.3

Support Forum

 
 

 

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 11
SQL =
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;
2 replies

Guess this is quickest solution to create a ticket for support there..

The error is generated by the database server. It seems that you are using an older version and the json data type is not supported.
We are going to change the field type to have a compatibility also with the older database servers.

 
 
 

3 Item(s)

Show per page