Problem after upgrading from 1.0 Final to 1.2 Final

[target_locked]

Hi there,
I have just upgraded Prestashop 1.0 Final to 1.2 Final
There is only one error during upgrade:
--------------------
Unfortunately, 1 SQL errors have occurred.
View the log....
You have just updated and configured PrestaShop to be your online shop solution. May it be a success!
--------------------
Is that OK for the upgrade?

The shop looks ok but I can not filter by Manufacturer.
It always show "No products for this manufacturer."

I go to back office >> catalog >> manufacturer/products and see that the manufacturer ids are there. It look like the DB is ok after upgrading.

I use default theme, English.

What should I do to make the Manufacturer block work again?

Thanks.

[TropischBruin]

De-install en re-install the Manufacturer module from the BO, maybe that will help.

[target_locked]

Already De-install en re-install but same error.

[TropischBruin]

What if you create a new product and attach it to a manufacturer?

[target_locked]

Same error if I create a new product and attach it to an existing manufacturer or even add new manufacturer.

[TropischBruin]

Is this you production server or shadow?

Maybe you could try again using your backup-db?

[target_locked]

I'm testing on my local host running XAMPP.
Here is what I did:
Install my shop (Ver 1.0 Final) on Localhost, it work well including manufacturer filter.

Now upgrading:
1. Rename current Prestashop folder to old_
2. Create new Prestashop folder
3. Unzip prestashop 1.2 Final setup package to Prestashop folder
4. Copy /img folder from old shop to new one
5. Copy the settings.inc.php file from old shop to new one
6. Launch the Installer by adding /install to your shop’s URL

At update step 4 I see this msg:

Congratulations!
Update is finished.

Unfortunately, 1 SQL errors have occurred.

View the log

/* PHP */ /* PHP:AttributeGroup::cleanDeadCombinations(); */

/* PHP:configuration_double_cleaner(); */

SET NAMES 'utf8'

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

DROP TABLE IF EXISTS ps_search

ALTER TABLE ps_category_lang ADD INDEX category_name (name)

ALTER TABLE ps_order_detail MODIFY COLUMN product_name VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL

ALTER TABLE ps_order_detail ADD deleted TINYINT(3) UNSIGNED NOT NULL DEFAULT 0

ALTER TABLE ps_configuration MODIFY COLUMN name VARCHAR(32) NOT NULL UNIQUE

ALTER TABLE ps_orders ADD invoice_number INTEGER(10) UNSIGNED NOT NULL DEFAULT 0 AFTER total_wrapping

ALTER TABLE ps_orders ADD delivery_number INTEGER(10) UNSIGNED NOT NULL DEFAULT 0 AFTER invoice_number

ALTER TABLE ps_orders ADD invoice_date DATETIME NOT NULL AFTER delivery_number

ALTER TABLE ps_orders ADD delivery_date DATETIME NOT NULL AFTER invoice_date

ALTER TABLE ps_order_detail CHANGE product_price product_price DECIMAL(13, 6) NOT NULL DEFAULT 0.000000

ALTER TABLE ps_order_slip ADD shipping_cost TINYINT UNSIGNED NOT NULL DEFAULT 0 AFTER id_order

ALTER TABLE ps_order_state ADD delivery TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER logable

ALTER TABLE ps_country DROP deleted

ALTER TABLE ps_product ADD customizable BOOL NOT NULL DEFAULT 0 AFTER quantity_discount

ALTER TABLE ps_product ADD uploadable_files TINYINT NOT NULL DEFAULT 0 AFTER customizable

ALTER TABLE ps_product ADD text_fields TINYINT NOT NULL DEFAULT 0 AFTER uploadable_files

ALTER TABLE ps_product_lang CHANGE availability available_now VARCHAR(255) NULL

ALTER TABLE ps_product_lang ADD available_later VARCHAR(255) NULL AFTER available_now

ALTER TABLE ps_access DROP id_access

ALTER TABLE ps_access DROP INDEX access_profile

ALTER TABLE ps_access DROP INDEX access_tab

ALTER TABLE ps_access ADD PRIMARY KEY(id_profile, id_tab)

ALTER TABLE ps_currency ADD blank TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER sign

ALTER TABLE ps_currency ADD decimals TINYINT(1) UNSIGNED NOT NULL DEFAULT 1 AFTER format

ALTER TABLE ps_product_attribute ADD wholesale_price decimal(13,6) NOT NULL DEFAULT 0.000000 AFTER ean13

ALTER TABLE ps_employee ADD last_passwd_gen TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER passwd

ALTER TABLE ps_customer ADD last_passwd_gen TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER passwd

ALTER TABLE ps_customer ADD ip_registration_newsletter VARCHAR(15) NULL DEFAULT NULL AFTER newsletter

ALTER TABLE ps_image_type ADD scenes TINYINT(1) NOT NULL DEFAULT 1

ALTER TABLE ps_image_lang CHANGE legend legend VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL

/* CMS */ CREATE TABLE ps_cms ( id_cms INTEGER UNSIGNED NOT NULL auto_increment, PRIMARY KEY (id_cms) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

CREATE TABLE ps_cms_lang ( id_cms INTEGER UNSIGNED NOT NULL auto_increment, id_lang INTEGER UNSIGNED NOT NULL, meta_title VARCHAR(128) NOT NULL, meta_description VARCHAR(255) DEFAULT NULL, meta_keywords VARCHAR(255) DEFAULT NULL, content longtext NULL, link_rewrite VARCHAR(128) NOT NULL, PRIMARY KEY (id_cms, id_lang) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

CREATE TABLE ps_block_cms ( id_block INTEGER(10) NOT NULL, id_cms INTEGER(10) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8

/* PAYMENT MODULE RESTRICTIONS */ CREATE TABLE `ps_module_country` ( `id_module` INTEGER UNSIGNED NOT NULL, `id_country` INTEGER UNSIGNED NOT NULL, PRIMARY KEY (`id_module`, `id_country`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

CREATE TABLE `ps_module_currency` ( `id_module` INTEGER UNSIGNED NOT NULL, `id_currency` INTEGER NOT NULL, PRIMARY KEY (`id_module`, `id_currency`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

/* ORDER-MESSAGE */ CREATE TABLE ps_order_message ( id_order_message int(10) unsigned NOT NULL auto_increment, date_add datetime NOT NULL, PRIMARY KEY (id_order_message) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

CREATE TABLE ps_order_message_lang ( id_order_message int(10) unsigned NOT NULL, id_lang int(10) unsigned NOT NULL, name varchar(128) NOT NULL, message text NOT NULL, PRIMARY KEY (id_order_message,id_lang) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

/* SUB-DOMAINS */ CREATE TABLE ps_subdomain ( id_subdomain INTEGER(10) NOT NULL AUTO_INCREMENT, name VARCHAR(16) NOT NULL, PRIMARY KEY(id_subdomain) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

CREATE TABLE ps_meta_lang ( id_meta INTEGER UNSIGNED NOT NULL, id_lang INTEGER UNSIGNED NOT NULL, title VARCHAR(255) NULL, description VARCHAR(255) NULL, keywords VARCHAR(255) NULL, PRIMARY KEY (id_meta, id_lang) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
....

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.

* My Front Office

I would like to know if that is a real error or only a warning message?

By the way if I ignore this msg the new shop looks ok (the productlist, price display ok) but the manufacturer filter not work.
Any one experienced this?

[TropischBruin]

Unfortunately, 1 SQL errors have occurred.

View the log

Which part of the update failed?

[target_locked]

That error message appear at final step 4.
From the error log I don't know what exactly the error is.

Update:
This error also happen on Fresh install of Presta 1.0 Final (with sample products) then upgrade to 1.2 Final (all use default theme, default English language).
Can I believe that this is really a bug?

[target_locked]

I want to post this issue to the "bug report" but it say:

The following errors were encountered
You are not authorized to perform this action

What should I do now?

[weaselbringer]

I had this same problem and now when I check out it mentions all these same tables after you authorize payment, so it makes an error...

adam

i.e. I cannot complete checkout i gives an error about quanity in stock to an old table in sql?

[target_locked]

Update:
The manufacturer block work halfly if I continue to upgrade from 1.2.0.8 to 1.2.1.0 (could not upgrade directly from 1.0.0.8 to 1.2.1.0, hang at step 3)

The upgraded 1.2.1.0 work, however it has new bug:
For manufacturer that has no products, it will return error:(see below)
This bug also happen on fresh install of 1.2.1.0, a French guy also found this bug:
http://www.prestashop.com/forums/viewthread/25142/

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-10,10' at line 16
       SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, i.`id_image`, il.`legend`, m.`name` AS manufacturer_name, tl.`name` AS tax_name, t.`rate`
       FROM `ps_product` p
       LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1)
       LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1)
       LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
       LEFT JOIN `ps_tax` t ON t.`id_tax` = p.`id_tax`
       LEFT JOIN `ps_tax_lang` tl ON (t.`id_tax` = tl.`id_tax` AND tl.`id_lang` = 1)
       LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer`
       LEFT JOIN `ps_category_product` cp ON (cp.`id_product` = p.`id_product`)
       INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)

       WHERE p.`id_manufacturer` = 3 AND p.`active` = 1
       AND ( ctg.`id_group` = 1)
       GROUP BY p.`id_product`
       ORDER BY `name` DESC 
       LIMIT -10,10

[Oz]

I am having this same problem, apparently if there are no products under such manufacturer, same sql error is thrown.

Any potential fix?

Thanks