Error when trying to install update 6.0.5.1

Hi,

I try to update zhgooglemap component with 6.0.5.1 and result is:

1060 Duplicate column name 'kmllayer' SQL=ALTER TABLE `tudqx_zhgooglemaps_maps` ADD `kmllayer` text NOT NULL;

What's wrong?

Regards,

Stephan

Hi.

I think you used backup-restore utility, because this field was added in version 1.1.6.

And now you have some incorrect data configuration.
It is not easy to fix this problem but you can do that with little tricks. I can explain how you can do that.

Or if you don't have lots of data (placemarks...) - you can uninstall and install component again, but in this case you will lose your maps data (placemarks, maps, paths etc) and have to enter it again.

Hi Dima,

I have already enter my placemarks (70 placemarks).

It's a new configuration started with J3.X and zhGooglemap Component 6.0.5.1 and zhGooglemap plugin 4.2.2.1

I don't know why Joomla ask me to install a new component, it's already the good version.

Is it possible to make an export in phpmyadmin of zhgooglemap data, uninstall zhgooglemap, install zhgooglemap again and import data?

Or can you explain what I need to do to fix the problem.

Regards,

Stephan

Hi.
I don't know for what reason it asks (as I wrote, may be you use rollback in backup utility)

You have 2 ways:
way 1:
1 - export my tables (__zhgooglemaps_), it is 12
2 - uninstall, install
3 - import
4 - fix categories (if it changed)

way 2:
- use little trick
- find file in admin/sql/updates, which do alter table with your error. Do it empty, ie just leave only file without content
- zip component and try to install
- if will get new error - find new file, empty it, zip it and upload
- as result - joomla will know, that files are already installed and will not try to alter my tables

Choose which way more easy for you

Hi Dima,

In extensions I found two components zhgooglemap. One w/o version, one with good version. I think the problem coming from there.

I use way 1 to reinstall and it works now.

Thanks a lot,

Stephan