Jump to content

Mysql Upgrade Errors


Recommended Posts

Upgrading from 1.3.7 to 1.4 final. Four sql commands failed in latest distribution.

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

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

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

INSERT INTO `zeqw_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ( 'zeqw_INVOICE_START_NUMBER', ( SELECT `invoice_number` FROM (SELECT GREATEST(`value`, (SELECT CAST(MAX(`invoice_number`) AS CHAR) FROM `zeqw_orders`)) AS `invoice_number` FROM `zeqw_configuration` WHERE `name` = 'zeqw_INVOICE_NUMBER' ) as tmp), NOW(), NOW() )


Any ideas whether these are ignorable or not? So much select nesting that I can't even tell what the last three are looking for.

Wil

Link to comment
Share on other sites

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