J-BusinessDirectory - Add company fails + update general settings doesn't work

1. I can't update general settings. VAT, days and Terms just return to empty when I try toupdate them.

2. I can't add companies, I get the following error:

0 SQL=SHOW FULL COLUMNS FROM `laser_jbusinessdirectory_company_locations`

I started with company_activity_city missing, but followed the advice given in the thread http://www.cmsjunkie.com/forum/error-add-companies, which solved the initial issue, just to  see another table missing.

I assume it's the same issue resulting in search errors in front end, or...?

Best regards

Hi,

For some reasons it seems that the update has not runned all sql's. Please replace the table prefix and run the followings sql's on your database. If you need help please provide us joomla admin access.(use contact form)

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` ;

Hi,

Thanks for quick reply. The provided queries seems to have done the trick, everything seems to work as it's supposed to - now I have something to play with, thanks