Jump to content

(Solved)Six different (1062) Duplicate entry when upgrading to 1.3.5.0


Recommended Posts

Hi
I am in the process of upgrading my 1.2.5 to 1.3.5.0 and it have worked very good, even with my black & white theme. But some sql errors has occurred. (down below) Can I fix this in some way? I have read in other treads that this is because I have tried to upgrade my database earlier, but the only upgrade I have made is the security fix that was released when the 1.3.1 version came out.

INSERT INTO `ps_hook` (`name`, `title`, `description`, `position`) VALUES ('createAccountTop', 'Block above the form for create an account', NULL , '1'), ('backOfficeHeader', 'Administration panel header', NULL , '0'), ('backOfficeTop', 'Administration panel top hover the tabs', NULL , '1'), ('backOfficeFooter', 'Administration panel footer', NULL , '1')

(1062) Duplicate entry 'createAccountTop' for key 'hook_name'

************

ALTER TABLE `ps_search_engine` ADD UNIQUE (`server`,`getvar`)

(1062) Duplicate entry 'google-q' for key 'server'

*****************

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) ( SELECT 'MA_LAST_QTIES', '3', NOW(), NOW() FROM `ps_module` WHERE `name` = 'mailalerts' )

(1062) Duplicate entry 'MA_LAST_QTIES' for key 'name'

*****************

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_1_3_2_UPDATE_DATE', NOW(), NOW(), NOW())

(1062) Duplicate entry 'PS_1_3_2_UPDATE_DATE' for key 'name'

********************

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) SELECT 'PS_LOCALE_LANGUAGE', l.`iso_code`, NOW(), NOW() FROM `ps_configuration` c INNER JOIN `ps_lang` l ON (l.`id_lang` = c.`value`) WHERE c.`name` = 'PS_LANG_DEFAULT'

(1062) Duplicate entry 'PS_LOCALE_LANGUAGE' for key 'name'

*******************

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) SELECT 'PS_LOCALE_COUNTRY', co.`iso_code`, NOW(), NOW() FROM `ps_configuration` c INNER JOIN `ps_country` co ON (co.`id_country` = c.`value`) WHERE c.`name` = 'PS_COUNTRY_DEFAULT'

(1062) Duplicate entry 'PS_LOCALE_COUNTRY' for key 'name'






Hopefully someone can help me please
Frida

I looked at my db and all of this is already in there.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...