Errors updating component 1.7.4, 1.7.5 and 2.5.1

Hi Dima, I am in the process of updating your component and plugin. The plugin updates fine, the component errors out. I tried this on 1.7.4 as well as 2.5.1…

At first I get a table exists error...

JInstaller: :Install: Error SQL DB function failed with error number 1050
Table ‘jos_zhgooglemaps_maptypes’ already exists SQL=CREATE TABLE `jos_zhgooglemaps_maptypes` ( `id` int(11) unsigned NOT NULL auto_increment, `catid` int(11) NOT NULL default ’0′, `title` varchar(250) NOT NULL default ”, `description` text NOT NULL, `published` tinyint(1) NOT NULL default ’0′, `params` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM CHARACTER SET `utf8`;
SQL =
CREATE TABLE `#__zhgooglemaps_maptypes` (
`id` int(11) unsigned NOT NULL auto_increment,
`catid` int(11) NOT NULL default ’0′,
`title` varchar(250) NOT NULL default ”,
`description` text NOT NULL,
`published` tinyint(1) NOT NULL default ’0′,
`params` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM CHARACTER SET `utf8`;

Then I run update again and get this...

JInstaller: :Install: Error SQL DB function failed with error number 1060
Duplicate column name ‘nztopomaps’ SQL=ALTER TABLE `jos_zhgooglemaps_maps` ADD `nztopomaps` tinyint(1) NOT NULL default ’0′;
SQL =
ALTER TABLE `#__zhgooglemaps_maps` ADD `nztopomaps` tinyint(1) NOT NULL default ’0′;
Component Update: SQL error file DB function failed with error number 1060
Duplicate column name ‘nztopomaps’ SQL=ALTER TABLE `jos_zhgooglemaps_maps` ADD `nztopomaps` tinyint(1) NOT NULL default ’0′;
SQL =
ALTER TABLE `#__zhgooglemaps_maps` ADD `nztopomaps` tinyint(1) NOT NULL default ’0′;

This happens on 1.7.4, 1.7.5 and 2.5.1

Any suggestions? I tried the updater function from joomla as well as uploading the latest version.

Right now I'm stuck - I am in the process of updating the site to J2.5.1 from 1.7.4 and your component is the only one that is being stubborn for some reason. I love it btw, so please help!

Hi Peet.
It is very strange.

But lets fix this.
Check if in your table jos_zhgooglemaps_maps exists field nztopomaps. if yes – unzip extension, find in admin/sql/updates file which contain this alter table to add field, and clear text in it. Then zip it again and try to install. The same do with create table…

I note, that when I update by extenstion manager, there is some problems when I select more than one extension at one.

I remember!!!
Purge cache, And try to check updates. I have this "feature". Component is updated, but with messages, and updater think that there is new update is still exists.

Check this too

The update file is 2.6.12... the create table was in 2.8.1

About to zip and try again. BRB.

But first clear cache, and check updates. Do not unzip-change-zip.
May be it's OK