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.
Quote from: abolabo on May 14, 2016, 12:08:19 PM
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
Quote from: scorpbond on May 15, 2016, 02:16:00 AM
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.