hi,
when add new companies display error: Table '...._jbusinessdirectory_company_activity_city' doesn't exist SQL=SHOW FULL COLUMNS FROM `...._jbusinessdirectory_company_activity_city`
the same problems in :
Table .._jbusinessdirectory_reports' doesn't exist SQL=SHOW FULL COLUMNS FROM `trkfx_jbusinessdirectory_reports
Thank for your help
Hi,
It seems that update sql's have not been runned.
Can you please run the following sql's on database. (you have to replace the prefix with the one that you have). If you need help please let us know.
CREATE TABLE `#__jbusinessdirectory_company_activity_city` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`company_id` int(11) DEFAULT NULL,
`city_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `IND_UNQ` (`company_id`,`city_id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
ALTER TABLE `#__jbusinessdirectory_companies` ADD COLUMN `websiteCount` INT NOT NULL DEFAULT 0 ;
CREATE TABLE `#__jbusinessdirectory_reports` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(145) DEFAULT NULL,
`description` text,
`selected_params` text,
`custom_params` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
ALTER TABLE `#__jbusinessdirectory_applicationsettings` ADD COLUMN `claim_business` TINYINT(1) NULL DEFAULT 1;
CREATE TABLE `#__jbusinessdirectory_company_locations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`company_id` int(11) DEFAULT NULL,
`street_number` varchar(20) DEFAULT NULL,
`address` varchar(100) NOT NULL,
`city` varchar(60) DEFAULT NULL,
`county` varchar(60) DEFAULT NULL,
`postalCode` varchar(45) DEFAULT NULL,
`countryId` int(11) DEFAULT NULL,
`latitude` varchar(45) DEFAULT NULL,
`longitude` varchar(45) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
ALTER TABLE `#__jbusinessdirectory_categories` ADD COLUMN `markerLocation` VARCHAR(250) NULL AFTER `imageLocation` ;
ALTER TABLE `#__jbusinessdirectory_companies` ADD COLUMN `modified` DATETIME NULL AFTER `creationDate` ;
ALTER TABLE `#__jbusinessdirectory_applicationsettings` ADD COLUMN `terms_conditions` BLOB NULL AFTER `claim_business` ;
ALTER TABLE `#__jbusinessdirectory_applicationsettings` ADD COLUMN `vat` TINYINT NULL DEFAULT 0 AFTER `terms_conditions` ;
ALTER TABLE `#__jbusinessdirectory_applicationsettings` ADD COLUMN `expiration_day_notice` TINYINT(2) NULL AFTER `vat` ;
ALTER TABLE `#__jbusinessdirectory_orders` ADD COLUMN `expiration_email_date` DATETIME NULL AFTER `currency` ;
ALTER TABLE `#__jbusinessdirectory_applicationsettings` ADD COLUMN `show_cat_description` TINYINT(1) NULL DEFAULT 1 ;
ALTER TABLE `#__jbusinessdirectory_company_locations` ADD COLUMN `name` VARCHAR(75) NULL AFTER `id` ;