Errors updating component 1.7.4, 1.7.5 and 2.5.1

More
12 years 1 month ago #32 by peet
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!

Please Log in or Create an account to join the conversation.

More
12 years 1 month ago - 12 years 1 month ago #33 by Dima
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…

Don't forget support my developments: post review in JED , donate , help with translation ;)
Last edit: 12 years 1 month ago by Dima.

Please Log in or Create an account to join the conversation.

More
12 years 1 month ago #34 by Dima
I note, that when I update by extenstion manager, there is some problems when I select more than one extension at one.

Don't forget support my developments: post review in JED , donate , help with translation ;)

Please Log in or Create an account to join the conversation.

More
12 years 1 month ago #35 by Dima
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

Don't forget support my developments: post review in JED , donate , help with translation ;)

Please Log in or Create an account to join the conversation.

More
12 years 1 month ago #36 by peet
The update file is 2.6.12... the create table was in 2.8.1

About to zip and try again. BRB.

Please Log in or Create an account to join the conversation.

More
12 years 1 month ago #37 by Dima
But first clear cache, and check updates. Do not unzip-change-zip.
May be it's OK

Don't forget support my developments: post review in JED , donate , help with translation ;)

Please Log in or Create an account to join the conversation.

Time to create page: 0.109 seconds

Donate


Go to top