hi. i'm trying to update joomsef 4.2.2 to 4.2.5. I've tried the automatic updater and the manual updater and with both i get the following error:

JInstaller: :Install: Error SQL DB function failed with error number 1060
Duplicate column name 'host' SQL=ALTER TABLE `jos_sefurls` ADD COLUMN `host` varchar(255) NOT NULL DEFAULT '';
SQL =

ALTER TABLE `#__sefurls` ADD COLUMN `host` varchar(255) NOT NULL DEFAULT '';

Component Update: SQL error file DB function failed with error number 1060
Duplicate column name 'host' SQL=ALTER TABLE `jos_sefurls` ADD COLUMN `host` varchar(255) NOT NULL DEFAULT '';
SQL =

ALTER TABLE `#__sefurls` ADD COLUMN `host` varchar(255) NOT NULL DEFAULT '';

Error updating component.

i've been keen on buying this component, but everytime i try to update, there is always an issue. can't remember the countless times i've lost all my urls and have had to spend hours trying to get them back and fix them.

please any assistance would be greatly appreciated. love the component, but i really find it buggy.

Hi,
It seems that for some reason correct database schema version is not stored in your database. You'll need some database manager (like phpMyAdmin) to fix this. Of course, make a backup of your website and database before doing this.

1. Use phpMyAdmin (or similar tool) and open the #_extensions table in your database (where # is your database prefix).
2. Find the line where name is com_sef and write down the extension_id for it.
3. Open the #_schemas table.
4. Modify or create if it's not present a record with extension_id set to the extension_id previously found, and set version_id to 4.2.1 (not 4.2.2, as this is not the component version but its database schema version).

After this modification update should work correctly.

hi thanks for the reply. i ended up doing it another way. i was updating a site that was on Joomla 1.7. So I ended up leaving Joomsef for last.
Once the site was updated to 2.5, I used the update tool in joomla to try and update joomsef. I got a message saying that it is an invalid component and it disappeared from the components dropdown menu.
After a brief panic I checked in the extensions manager and saw that joomsef is still installed. So then I merely tried installing it again through Joomla's extension manager and, boom, it worked.
Joomsef working again and updated to latest version and, thank the joomla gods, i did not lose my urls or config again!