Errors updating component 1.7.4, 1.7.5 and 2.5.1

More
12 years 1 month ago #38 by peet
Hi - tried it both ways. Purge cache, delete all system cache, system caching off. Update, look for update, try it - same error as before.

Using the modified zip - now I get this error:


JInstaller: :Install: Error SQL DB function failed with error number 1060
Duplicate column name 'gettileurl' SQL=ALTER TABLE `jos_zhgooglemaps_maptypes` ADD `gettileurl` text NOT NULL;
SQL =
ALTER TABLE `#__zhgooglemaps_maptypes` ADD `gettileurl` text NOT NULL;
Component Update: SQL error file DB function failed with error number 1060
Duplicate column name 'gettileurl' SQL=ALTER TABLE `jos_zhgooglemaps_maptypes` ADD `gettileurl` text NOT NULL;
SQL =
ALTER TABLE `#__zhgooglemaps_maptypes` ADD `gettileurl` text NOT NULL;

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

More
12 years 1 month ago #39 by peet
Let me try restore the site to unchanged condition... then I'll try the clear caches and update. BRB again

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

More
12 years 1 month ago #40 by Dima
Do the same.
Find update sql, and clear line there.

It is the first time that, I've updated in demo, test, and 3rd sites, and it is well updated.

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 #41 by Dima
If I understand right, updater do steps:
- check which files sql it have to execute
- do that
- update the others files
- mark update is completed

In your situation, it done 2-3 steps, and alters tables, but thinks that it need to do update. But columns and table is exists.

But for what reason this is appear in your site.

Can you say from what version of component you try to upgrade. I'll try too ;) ;)
But I think it will be 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.

More
12 years 1 month ago #42 by peet
Ok, fresh restore from backup (akeeba backup), went to system, turned off caching, cleared system cache, deleted expired cache, went to extension updates, purged cache, clicked find updates, click on zh googlemaps component, click update, bam - same error with create table.

Going to now try the hunting for code method. Perhaps adding if not exist to the code in the future?

I honestly don't know why these tables and columns are in my installation, I was running on version 2.7.6 with plugin 2.4.6.

The next one, btw is in 2.8.2

Your code:


ALTER TABLE `#__zhgooglemaps_maptypes` ADD `gettileurl` text NOT NULL;
ALTER TABLE `#__zhgooglemaps_maptypes` ADD `tilewidth` int(5) NOT NULL default '256';
ALTER TABLE `#__zhgooglemaps_maptypes` ADD `tileheight` int(5) NOT NULL default '256';
ALTER TABLE `#__zhgooglemaps_maptypes` ADD `ispng` tinyint(1) NOT NULL default '1';
ALTER TABLE `#__zhgooglemaps_maptypes` ADD `minzoom` int(3) NOT NULL default '0';
ALTER TABLE `#__zhgooglemaps_maptypes` ADD `maxzoom` int(3) NOT NULL default '18';


And my db already has:

gettileurl
ispng
minzoom
maxzoom

Am removing those and let's see what happens.

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

More
12 years 1 month ago #43 by peet
Ok, this is likely something tied to my system... I just ran the updated script removing the four above that already existed and only leaving tilewidth and tileheight. Guess what, it crashed out again and reported:


JInstaller: :Install: Error SQL DB function failed with error number 1060
Duplicate column name 'tilewidth' SQL=ALTER TABLE `jos_zhgooglemaps_maptypes` ADD `tilewidth` int(5) NOT NULL default '256';
SQL =


I looked in DB and both tilewidth and tileheight were already in there.

The only thing I can think of that is causing this is Akeeba Backup doing a checkpoint. Let me restore site, turn that off and see how it goes.

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

Time to create page: 0.129 seconds

Donate


Go to top