Upgrade help needed for version 1.2.7

[scorpbond]

I tried upgrading AbanteCart 1.2.6 to 1.2.7 manually but upgrade fail. I uploaded all files in code folder through FTP. and edited upgrade.sql file by replacing ac_ to my prefix bpi_   and run sql query by pasting the code in upgrade.sql.  but got error:

Error
SQL query:

ALTER TABLE  `bpi_settings` ADD INDEX  `bpi_settings_idx` USING BTREE(

`group` ASC ,
`key` ASC
);

MySQL said: Documentation

#1061 - Duplicate key name 'bpi_settings_idx'




Please help me to rectify that.

[abolabo]

just remove this query from your sql set and try again

[scorpbond]

just remove this query from your sql set and try again

After restoring the database from backup I tried once again it shows this but in Admin its showing same old version 1.2.6 at the footer:

------------------------------------
ALTER TABLE `bpi_settings`
ADD INDEX `bpi_settings_idx` USING BTREE (`group` ASC, `key` ASC);# 429 rows affected.


INSERT INTO `bpi_block_templates` (`block_id`, `parent_block_id`, `template`, `date_added`) VALUES
(29, 3, 'blocks/account.tpl', now() ),
(29, 6, 'blocks/account.tpl', now() );# 2 rows affected.


UPDATE `bpi_block_templates`
SET `parent_block_id` = 1
WHERE `template` = 'blocks/customer.tpl' AND `block_id`=31 AND `parent_block_id` = 0;# 1 row affected.


UPDATE `bpi_block_templates`
SET `parent_block_id` = 8
WHERE `template` = 'blocks/donate.tpl' AND `block_id`=21 AND `parent_block_id` = 0;# 1 row affected.


UPDATE `bpi_block_templates`
SET `parent_block_id` = 2
WHERE `template` = 'blocks/breadcrumbs.tpl' AND `block_id`=28 AND `parent_block_id` = 0;# 1 row affected.


INSERT INTO `bpi_settings` (`group`, `key`, `value`)
VALUES
('system','config_html_cache',0),
('system','config_image_quality',95);# 2 rows affected.


INSERT INTO `bpi_settings` (`g[...]

----------------

Please suggest me is this the right way to do it or tell me how to remove  this query from my sql set.....My Sql window attached

[abolabo]

I Tried updating manually from version 1.2.6 to version 1.2.7 in a right way by following the instruction but when i check at the footer of Admin area It showing version same older version 1.2.6.

you can just edit file core/version.php.