SQL error after update prestashop 1.3.3.0 to 1.4.1.0

[Caps, Coils and Speakers]

When I did a update from 1.3.3.0 to 1.4.1.0 I got the message:

4 SQL errors.

This is the part of the log:

UPDATE `ps_configuration` SET `value` = IF((SELECT value FROM (SELECT `value` FROM `ps_configuration` WHERE `name` = 'PS_CONDITIONS_CMS_ID')tmp), 1, 0) WHERE `name` = 'PS_CONDITIONS'

(1093) You can't specify target table 'ps_configuration' for update in FROM clause
INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_CIPHER_ALGORITHM', 0, NOW(), NOW())

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

The shop also did not function properely, in the front office the CATEGORY tab shows no category and after clicking redirects to the original site (have the shop running on a test site)

In the backend the appearance tab is gone

Anyone a idea what is going wrong?

Did the update several times, still having the same error

[JoopS]

I got the same problem here....only I got 6 SQL errors!
When searching in Google for this error it gives some info about reading and writing at the same time??? This is not possible??? I've got no clue how to solve this one.
Hope somebody at this forum can help us out.

Greetz,
Joop

[Caps, Coils and Speakers]

Update of the SQL error list, had not the complete list posted

-------------------------------------------------------------------------------------------------------------------------
UPDATE `ps_configuration` SET `value` = IF((SELECT value FROM (SELECT `value` FROM `ps_configuration` WHERE `name` = 'PS_CONDITIONS_CMS_ID')tmp), 1, 0) WHERE `name` = 'PS_CONDITIONS'

(1093) You can't specify target table 'ps_configuration' for update in FROM clause

------------------------------------------------------------------------------------------------------------------------

UPDATE `ps_tab` SET `position` = `position` + 1 WHERE `id_parent` = (SELECT * FROM (SELECT `id_parent` FROM `ps_tab` WHERE `class_name` = 'AdminTaxes') tmp) AND `position` > (SELECT * FROM (SELECT `position` FROM `ps_tab` WHERE `class_name` = 'AdminTaxes') tmp2)

(1093) You can't specify target table 'ps_tab' for update in FROM clause

------------------------------------------------------------------------------------------------------------------------

UPDATE `ps_tab` SET `position` = (SELECT * FROM (SELECT `position` FROM `ps_tab` WHERE `class_name` = 'AdminTaxes') tmp) + 1 WHERE `class_name` = 'AdminTaxRulesGroup'

(1093) You can't specify target table 'ps_tab' for update in FROM clause

------------------------------------------------------------------------------------------------------------------------

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ( 'ps_INVOICE_START_NUMBER', ( SELECT `invoice_number` FROM (SELECT GREATEST(`value`, (SELECT CAST(MAX(`invoice_number`) AS CHAR) FROM `ps_orders`)) AS `invoice_number` FROM `ps_configuration` WHERE `name` = 'ps_INVOICE_NUMBER' ) as tmp), NOW(), NOW() )

(1093) You can't specify target table 'ps_configuration' for update in FROM clause

------------------------------------------------------------------------------------------------------------------------

A fresh install of presta 1.4 works like a charm, just can't update from 1.3.3 to 1.4.1, also tried with a change of the database engine into InnoDB instead if MyISAM wich gave the same errors.

Rudy

[Caps, Coils and Speakers]

Problem solved!

After updating to MySQL 5 everything worked like a charm. Have to work on my template to get
it working with 1.4, when this is done my new shop is going live!

Thanks for your great help prestashop team.