Solsken Posted January 11, 2011 Share Posted January 11, 2011 HiI 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 pleaseFridaI looked at my db and all of this is already in there. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now