Upgrade from 1.1 to 1.25 with 20 SQL problems

[Dwita]

Hello,

I was trying again to upgrade my shop.
But every-time i did that i get 20 SQL errors.

My question is. Can i ignore these errors?
Because everything seems to work fine.
Only my pictures aren't showing up.

Can someone help me with this?
Otherwise i like to pay if someone can upgrade for me.
Please i need an answer.

Can i do fresh install of 1.25 and connect my database to it?
Do i hold all my customers, selling, pictures and so on?

Thanks.

These are the SQL problems:

SET NAMES 'utf8'


/* ##################################### */ /* STRUCTURE */ /* ##################################### */ DROP TABLE IF EXISTS ps_order_customization_return


ALTER TABLE ps_cart ADD id_guest INT UNSIGNED NULL AFTER id_customer


ALTER TABLE ps_tab ADD `module` varchar(64) NULL AFTER class_name


ALTER TABLE ps_product ADD `indexed` tinyint(1) NOT NULL default '0' AFTER `active`


ALTER TABLE ps_orders DROP INDEX `orders_customer`


ALTER TABLE ps_orders ADD INDEX id_customer (id_customer)


ALTER TABLE ps_orders ADD valid INTEGER(1) UNSIGNED NOT NULL DEFAULT '0' AFTER delivery_date


ALTER TABLE ps_orders ADD INDEX `id_cart` (`id_cart`)


ALTER TABLE ps_customer ADD deleted TINYINT(1) NOT NULL DEFAULT '0' AFTER active


ALTER TABLE ps_employee ADD stats_date_to DATE NULL DEFAULT NULL AFTER last_passwd_gen


ALTER TABLE ps_employee ADD stats_date_from DATE NULL DEFAULT NULL AFTER last_passwd_gen


ALTER TABLE ps_order_state ADD hidden TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER unremovable


ALTER TABLE ps_carrier ADD is_module TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER range_behavior


ALTER TABLE ps_carrier ADD INDEX deleted (`deleted`, `active`)


ALTER TABLE ps_state CHANGE iso_code `iso_code` char(4) NOT NULL


ALTER TABLE ps_order_detail CHANGE product_quantity_cancelled product_quantity_refunded INT(10) UNSIGNED NOT NULL DEFAULT '0'


ALTER TABLE ps_order_detail ADD INDEX product_id (product_id)


ALTER TABLE ps_attribute_lang ADD INDEX id_lang (`id_lang`, `name`)


ALTER TABLE ps_attribute_lang ADD INDEX id_lang_2 (`id_lang`)


ALTER TABLE ps_attribute_lang ADD INDEX id_attribute (`id_attribute`)


ALTER TABLE ps_block_cms ADD PRIMARY KEY (`id_block`, `id_cms`)


ALTER TABLE ps_connections CHANGE `http_referer` `http_referer` VARCHAR(255) DEFAULT NULL


ALTER TABLE ps_connections ADD INDEX `date_add` (`date_add`)


ALTER TABLE ps_customer DROP INDEX `customer_email`


ALTER TABLE ps_customer ADD UNIQUE `customer_email` (`email`)


ALTER TABLE ps_delivery ADD INDEX id_zone (`id_zone`)


ALTER TABLE ps_delivery ADD INDEX id_carrier (`id_carrier`, `id_zone`)


ALTER TABLE ps_discount_category ADD INDEX id_category (`id_category`)


ALTER TABLE ps_feature_product ADD INDEX `id_feature` (`id_feature`)


ALTER TABLE ps_hook_module DROP INDEX `hook_module_index`


ALTER TABLE ps_hook_module ADD PRIMARY KEY (id_module,id_hook)


ALTER TABLE ps_hook_module ADD INDEX id_module (`id_module`)


ALTER TABLE ps_hook_module ADD INDEX id_hook (`id_hook`)


ALTER TABLE ps_module CHANGE `active` `active` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0'


ALTER TABLE ps_page CHANGE `id_object` `id_object` INT UNSIGNED NULL DEFAULT NULL


ALTER TABLE ps_page ADD INDEX `id_page_type` (`id_page_type`)


ALTER TABLE ps_page ADD INDEX `id_object` (`id_object`)


ALTER TABLE ps_page_type ADD INDEX `name` (`name`)


ALTER TABLE ps_page_type CHANGE `name` `name` VARCHAR(255) NOT NULL


ALTER TABLE ps_product_attribute ADD INDEX reference (reference)


ALTER TABLE ps_product_attribute ADD INDEX supplier_reference (supplier_reference)


ALTER TABLE ps_product_lang ADD INDEX id_product (id_product)


ALTER TABLE ps_product_lang ADD INDEX id_lang (id_lang)


ALTER TABLE ps_product_lang ADD INDEX `name` (`name`)


ALTER TABLE ps_product_lang ADD FULLTEXT KEY ftsname (`name`)


ALTER TABLE ps_cart_discount ADD INDEX `id_discount` (`id_discount`)


ALTER TABLE ps_discount_category ADD PRIMARY KEY (id_category,id_discount)


ALTER TABLE ps_image_lang ADD INDEX id_image (id_image)


ALTER TABLE ps_range_price CHANGE `delimiter1` `delimiter1` DECIMAL(13, 6) NOT NULL


ALTER TABLE ps_range_price CHANGE `delimiter2` `delimiter2` DECIMAL(13, 6) NOT NULL


ALTER TABLE ps_range_price CHANGE `id_carrier` `id_carrier` INT(10) UNSIGNED NOT NULL


ALTER TABLE ps_range_price DROP INDEX `range_price_unique`


ALTER TABLE ps_range_price ADD UNIQUE KEY `id_carrier` (`id_carrier`,`delimiter1`,`delimiter2`)


ALTER TABLE ps_range_weight CHANGE `delimiter1` `delimiter1` DECIMAL(13, 6) NOT NULL


ALTER TABLE ps_range_weight CHANGE `delimiter2` `delimiter2` DECIMAL(13, 6) NOT NULL


ALTER TABLE ps_range_weight CHANGE `id_carrier` `id_carrier` INT(10) UNSIGNED NOT NULL


ALTER TABLE ps_range_weight DROP INDEX `range_weight_unique`


ALTER TABLE ps_range_weight ADD UNIQUE KEY `id_carrier` (`id_carrier`,`delimiter1`,`delimiter2`)


ALTER TABLE ps_scene_products ADD PRIMARY KEY (`id_scene`, `id_product`, `x_axis`, `y_axis`)


ALTER TABLE ps_product_lang DROP INDEX fts


ALTER TABLE ps_product_lang DROP INDEX ftsname


/* KEY management */ ALTER TABLE ps_attribute_lang DROP INDEX `id_lang_2`


ALTER TABLE ps_attribute_lang DROP INDEX `id_attribute`


ALTER TABLE ps_attribute_lang DROP INDEX `attribute_lang_index`, ADD PRIMARY KEY (`id_attribute`, `id_lang`)


ALTER TABLE ps_carrier_zone DROP INDEX `carrier_zone_index`, ADD PRIMARY KEY (`id_carrier`, `id_zone`)


ALTER TABLE ps_discount_category CHANGE `id_discount` `id_discount` int(11) NOT NULL AFTER `id_category`


ALTER TABLE ps_discount_category DROP INDEX `id_category`


ALTER TABLE ps_feature_product DROP INDEX `id_feature`


ALTER TABLE ps_hook_module DROP INDEX `id_module`


ALTER TABLE ps_image_lang DROP INDEX `id_image`


ALTER TABLE ps_product_lang DROP

[roberta]

With me also is this happening, I would like to know how to solve.
Hug.

[Milano2]

I have the same problem. Any idea?

[Dwita]

Nobody seems to know, and i think the Presta-team doesn't know either.
But i donut blame them. they aren't God.
I am building a new site with zen-cart. The forum is different and i have over 60 free templates i can modify myself.
I learned much from Presta-shop about some coding, but i am tired off the questions without answers. So i give it up.
I think you have to wait for there next release. 1.3

[shoulders]

zen-cart suks. wait until you discover overide folders, now there is a stupid idea.

[Scotty501]

At least there answers there!