J-BusinessDirectory - error add companies
Support Forum
C.
error add companies
hi, when add new companies display error: Table 'carlos87_ccc.abc14_jbusinessdirectory_company_activity_city' doesn't exist SQL=SHOW FULL COLUMNS FROM `abc14_jbusinessdirectory_company_activity_city`
2 replies
G.B.
posted: 10 years ago
- total posts 2204
- joined 10 years ago
Hi,
It seems that the upgrade has not been performed corerctly.
You can run the sql's yourself. Replace #_ with your table prefix.
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;
`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;
If you need help please provide us access to your database. (using contact form)
C.
posted: 10 years ago
- total posts 15
- joined 10 years ago
Excelente ya corri el script y funciona sin errores. Muchas gracias. Es un excelente template