Error updating

Hi there.. trying to update through Joomla Extension Mgr.. getting the following error:

JInstaller: :Install: Error SQL DB function failed with error number 1060
Duplicate column name 'css2load' SQL=ALTER TABLE `xi5ay_zhgooglemaps_maps` ADD `css2load` text NOT NULL;

Any ideas?

Thanks, GG

Hi.

I think you use backup utility (for example akeeba backup), and rollback and try to upgrade component.

If yes - you have to do some steps manual.

In result - you need to have the table structure as in install.sql script.

In your case - the table was altered, and when you try to rollback - you rollback files, but not database. You have database tables structures is freshed.
Check, if you have this columns - set empty file (do not delete it, only empty). In this case joomla updater will proceed it and mark it done, and the other my update will be proceeded.

In the other words, when you have completed database structures, but the update tries it do again by the upgrade script - simple empty this file.

I mean, that you should to empty sql updates file, zip archive and try again.

Hmmm.. no, I'm not using a backup utility. I found the column CSS2load.. there is no entry?

OK. Then I didn't understand what it is appeared. Go to phpAdmin and delete (drop) it. In this case your updater create it again. But it is only for your risk!

What exactly am I dropping? The entire maps table?

Thank you!

Only this database columns