J-BusinessDirectory - Error 1146 with latest update

Hi,

I just updated J-Businessdir to the latest version, version 3.3.1. This remark was added: You can install the new version over the old one. *Please notice that all changes made to css or html code will be overwritten*. The database data will not be changed.

Nevertheless i have the following error when trying to add new companies or change any.

Error: 1146

Table 'beuasdb.beuas_jbusinessdirectory_cities' doesn't exist SQL=SHOW FULL COLUMNS FROM `beuas_jbusinessdirectory_cities`

Somebody any suggestions ?

Best regards,

Andres

Hi,

It seems that something went wrong on updating the version. Can you mention what version was previously installed?

You can run the following sql (please change the table prefix with the one that you have):

CREATE TABLE IF NOT EXISTS `#__jbusinessdirectory_cities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(65) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE `#__jbusinessdirectory_applicationsettings` ADD COLUMN `limit_cities` VARCHAR(1) NOT NULL DEFAULT 0  AFTER `meta_description_facebook` ;