A-Z Hosting Posted April 7, 2011 Share Posted April 7, 2011 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now