Originally Posted by xcooling [B][SIZE="6"]SQL fix to enable 2 decimal zeros (1.00) and not 4 decimal zeros (1.0000) SQL: Code: ALTER TABLE `zen_products` CHANGE `products_price` `products_price` DECIMAL( 15, 2 ) NOT NULL DEFAULT '0.00'; ALTER TABLE `zen_products` CHANGE `products_price_sorter` `products_price_sorter` DECIMAL( 15, 2 ) NOT NULL DEFAULT '0.00' Please note that this is not related to quick updates, and these changes may have undesired effects on other parts of the Zen Cart script!
ALTER TABLE `zen_products` CHANGE `products_price` `products_price` DECIMAL( 15, 2 ) NOT NULL DEFAULT '0.00'; ALTER TABLE `zen_products` CHANGE `products_price_sorter` `products_price_sorter` DECIMAL( 15, 2 ) NOT NULL DEFAULT '0.00'
Last edited by paulm; 12 Nov 2009 at 05:57 PM.
Forum Rules
Bookmarks