Jump to content

1.2 beta 3 install SQL error roadblock


Recommended Posts

No matter what I do, when I attempt to update to the latest beta I get no further than step 3.
I've made numerous attempt following the wiki, the sticky, and a few other well regarded posts.
When I log into my newly updated back office it still reads Version 1.2.0.5 - 0.129s
I am able to do a clean install, and the beta seems to be working perfectly.

This is the error I'm getting:

Congratulations!
Update is finished.

Unfortunately, 4 SQL errors have occurred.

View the log:

_________________________________________________________________________________________

SET NAMES 'utf8'

/* ##################################### */ /* STRUCTURE */ /* ##################################### */ ALTER TABLE `ps_customization` ADD `quantity_refunded` INT NOT NULL DEFAULT '0'

(1060) Duplicate column name 'quantity_refunded'
ALTER TABLE `ps_customization` ADD `quantity_returned` INT NOT NULL DEFAULT '0'

(1060) Duplicate column name 'quantity_returned'
ALTER TABLE `ps_alias` CHANGE `id_alias` `id_alias` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT

ALTER TABLE `ps_attribute_impact` CHANGE `id_attribute_impact` `id_attribute_impact` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT

ALTER TABLE `ps_customization` CHANGE `id_customization` `id_customization` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT

ALTER TABLE `ps_customization_field` CHANGE `id_customization_field` `id_customization_field` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT

ALTER TABLE `ps_subdomain` CHANGE `id_subdomain` `id_subdomain` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT

/* ##################################### */ /* CONTENTS */ /* ##################################### */ INSERT INTO ps_hook (`name`, `title`, `description`, `position`) VALUES ('postUpdateOrderStatus', 'Post update of order status', NULL, 0)

(1062) Duplicate entry 'postUpdateOrderStatus' for key 2
INSERT INTO `ps_search_engine` (`server`,`getvar`) VALUES ('bing.com','q')

INSERT INTO `ps_hook_module` (`id_module`, `id_hook`, `position`) VALUES (19, 9, 1)

(1062) Duplicate entry '19-9' for key 1
/* PHP:decode_content(); */

SET NAMES 'utf8'

/* ##################################### */ /* STRUCTURE */ /* ##################################### */ /* ##################################### */ /* CONTENTS */ /* ##################################### */ /* PHP:decode_content(); */

SET NAMES 'utf8'

/* ##################################### */ /* STRUCTURE */ /* ##################################### */ /* ##################################### */ /* CONTENTS */ /* ##################################### */ UPDATE `ps_order_state_lang` SET `name` = 'Shipped' WHERE `id_order_state` = 4 AND `id_lang` = 1

UPDATE `ps_order_state_lang` SET `template` = 'shipped' WHERE `id_order_state` = 4 AND `template` = 'shipping'

/* PHP:reorderpositions(); */

_____________________________________________________________________

You have just updated and configured PrestaShop to be your online shop solution. May it be a success!
WARNING! For security reasons, you must now delete the 'install' folder located on your hosting server.

Link to comment
Share on other sites

  • 4 weeks later...

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...