J-BusinessDirectory - Error installing component...

Support Forum

 
 

 

I try to install the component (J-businessdirectory_4.2.1) in an existing Joomla installation (3.4.1) but next warning shows up:


Warning

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 '' at line 45 SQL=-- -------------------------------------------------------- -- -- Table structure for table `kuw3o_jbusinessdirectory_companies` -- CREATE TABLE IF NOT EXISTS `kuw3o_jbusinessdirectory_companies` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `alias` varchar(100) NOT NULL DEFAULT '', `comercialName` varchar(120) DEFAULT NULL, `short_description` varchar(255) DEFAULT NULL, `description` text, `street_number` varchar(20) DEFAULT NULL, `address` varchar(100) NOT NULL, `city` varchar(60) DEFAULT NULL, `county` varchar(60) DEFAULT NULL, `countryId` int(11) DEFAULT NULL, `website` varchar(100) DEFAULT NULL, `keywords` varchar(100) DEFAULT NULL, `registrationCode` varchar(20) DEFAULT NULL, `phone` varchar(20) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `fax` varchar(20) DEFAULT NULL, `state` tinyint(4) DEFAULT '1', `typeId` int(11) NOT NULL, `logoLocation` varchar(245) DEFAULT NULL, `creationDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `modified` DATETIME DEFAULT NULL , `mainSubcategory` int(11) DEFAULT NULL, `latitude` varchar(45) DEFAULT NULL, `longitude` varchar(45) DEFAULT NULL, `activity_radius` float DEFAULT NULL, `userId` int(11) NOT NULL DEFAULT '0', `averageRating` float NOT NULL DEFAULT '0', `approved` tinyint(1) NOT NULL DEFAULT '0', `viewCount` int(11) NOT NULL DEFAULT '0', `websiteCount` int(11) NOT NULL DEFAULT '0', `contactCount` int(11) NOT NULL DEFAULT '0', `taxCode` varchar(45) DEFAULT NULL, `package_id` int(11) NOT NULL DEFAULT '0', `facebook` varchar(100) DEFAULT NULL, `twitter` varchar(100) DEFAULT NULL, `googlep` varchar(100) DEFAULT NULL, `linkedin` VARCHAR(100) NULL;

2 replies

Hi,

 

Please download the extension again. The error has been fixed.

Thanx, problem solved.

 
 
 

3 Item(s)

Show per page